Main Synergetic views

Views have been created by the Synergetic development team to make querying the database an easier process. These views are either from the:

Main Synergetic database, as outlined below.
Finance database. See Main Finance views.

View name	Description	Base tables used
vAbsenceEventsHistory	Use this view to list a history of changes to absence events.	AbsenceEvents AttendancesHistory AbsenceEvents AbsenceEvents Deleted tAttendances AttendanceMaster Community ConfigUsers
vAwards	Use this field to view all current and past student award information.	StudentAwards Community Addresses PastStudentAwards FileSemesters luAchievementType luAward luAwardClassification
vCommunicationsCurrent	Use this view to list current communications, with the name and address details of the recipients. Automatically excludes deceased people.	Community Communications Current Addresses Communications Community luAddressRegion luNotifyMethod
vCommunicationsPast	Use this view to list past communications, with the name and address details of the recipients. Automatically excludes deceased people.	Community Communications Communications Community Addresses luAddressRegion luNotifyMethod
vCommunityAddresses	Use this view to query on community members. This view includes all fields from the Community and Addresses tables. It has spouse and occupation details as well.	Community Addresses luOccupation luCountry
vCommunityAddresses Constit	Use this view to query on community members and their constituencies. This view includes all fields from the Community, Addresses and Constituency tables. Spouse and occupation details can be extracted as well. A community record will be duplicated for every constituency that they have. You would normally do a record selection on ConstitCode to only get one record per person.	Community Constituencies Addresses luConstituency luCountry luOccupation
vCommunitySkills	Use this view to list community members and the skills they have.	Community CommunitySkills Addresses Staff luDepartment luOccupation luSkill luSkillLevel
vDonors	Use this view to list donor information such as foundations, addresses and phone numbers.	Donors Addresses Community
vDonorPledges	Use this view to list donor pledges and the amount received against each pledge, with: name and address details of the donor appeal and fund details.	DonorPledges Community Addresses luAppeal luFund
vDonorPledgesReceipts	Use this view to list donor pledges and detailed receipt information for each pledge with: name and address details of the donor appeal and fund details.	DonorPledges Community Addresses DonorReceipts luAppeal luFund
vDonorProspectAddress	Use this view for donor prospect name and address details, as well as: fund and appeal information that they are prospected for staff and volunteer name information, which comes from extra joins to the Community table. Automatically excludes deceased prospects.	DonorProspects Community Addresses luAppeal luDonorProspect Inclination
vDonorProspectHistory Address	Use this view for donor prospect history (activities) with: prospect name and address details appeal information that they are prospected for. Automatically excludes deceased prospects.	DonorProspects Community Addresses DonorProspect History luAppeal luDonorProspect ActivityStatus
vDonorReceipts	Use this view for detailed receipt information with: name and address details of the donor appeal and fund information.	DonorReceipts Community Addresses luAppeal luFund
vEnquiryContactAddress	Use this view to list: enquiry contacts their name and address details the students that they are associated with. If the person is a member of the community, the information comes from the actual Community table, otherwise it comes off the enquiry tables. Automatically excludes deceased people.	EnquiryStudent Contacts EnquiryStudents Community Addresses luBoarder luCampus luEnquirySource luHouse luSubSchool luYearLevel luYearLevelGroup
vEnquiryFutureStudents	Use this view to list future student and enquiry information such as: personal information campus year level form house.	EnquiryStudents Community FutureStudents luCampus luEnquirySource luForm luFuturePriority luHouse luPreviousSchool luTutor luYearLevel
vEvents	Use this view for information on events and their locations, without any attendee details.	Events luLocation
vEventsCurrent	Use this view for information on current events and their locations, with attendee name and address details. Automatically excludes deceased attendees.	CommunityEvents Current Addresses Community Events luLocation
vEventsPast	Use this view for information on past events and their locations, with attendee name and address details.	CommunityEvents Addresses Community Events luLocation
vFutureContactAddress	Use this view for future student names and entry information, along with: contact name and address details for each of the student's contacts spouse information for each contact. Automatically excludes: deceased future students and contacts term contacts (contact type = SCT).	FutureStudents Addresses Community CommunityLegal FutureStudent Contacts Relationships luBoarder luCampus luContact luCountry luFutureStatus luIndustry luOccupation luOccupationPosition luRelationship luYearLevel
vFutureStudents	Use this view for future student names and entry information, if you do not want any contact or relationship information. Automatically excludes cancelled or deceased future students.	FutureStudents Community CommunityLegal StudentStatic luBoarder luFuturePriority luFutureStatus luHouse luParish luPreviousSchool luRelationship luReligion luYearLevel
vFutureStudentsAll	Use this view for future student names and entry information, if you do not want any contact or relationship information. Includes cancelled future students, automatically excludes deceased future students.	FutureStudents Community CommunityLegal StudentStatic luBoarder luFuturePriority luFutureStatus luHouse luParish luPreviousSchool luRelationship luReligion luYearLevel
vFutureContactsRelationOnly	Use this view to obtain: future student names address and occupation information for each relation their relationship with the future student. Automatically excludes term contacts (Type = SCT).	FutureStudents FutureStudent Contacts Addresses ConfigUsers Community CommunityLegal Relationships StudentStatic luContact luCountry luLanguage luNationality luOccupation luParish luRelationship luReligion
vFutureMedDetailsPrim Contact	Use this view to obtain future student medical information as well as: primary contact (SC1 contact) information for emergency contacts their relationship to the future student. Retrieves information as detailed in the vFutureContactAddress view, covered earlier.	vFutureContact Address FutureStudents FutureStudent MedicalDetails Addresses Community CommunityLegal StudentStatic luAsthmaCategory luCountry luHouse luImmunisationFormStatus luLanguage luMedicalPrivate InsuranceFund luNationality luParish luPreviousSchool luRelationship luReligion luYearLevel
vNZMoE_eAR_School Details	Use this view for the school number and name based on campus, using the configuration for the New Zealand Ministry of Education (NZMoE) electronic attendance register (eAR). If the configuration details are not available, the following details are retrieved: The school name from the configuration file maintenance using the System \| Install \| Name key. The school number from the School table.	Config School luCampus
vNZMoE_StudentData Changes	Use this view for data changes by student and year level. This is required for New Zealand Ministry of Education (NZMoE) electronic attendance register (eAR) audit requirements.	SystemDataChanges Community FileSemesters StudentYears
vPastStudentAddress	Use this view for past student names and their: address schooling information occupation information.	PastStudents Community CommunityLegal Addresses luBoarder luBranch luCampus luHouse luLeavingDestination luOccupation luYearLevel
vStaff	Use this view for personal staff details. This view contains detailed name and address information. Automatically excludes deceased staff members.	Staff Addresses Community luCampus luStaffCategory luWorkWithChildren CheckStatus luYearLevel
vStaffTimetableFull	Use this view for staff timetable details. This view does not contain detailed name and address information. Automatically excludes deceased staff members.	Staff Community SubjectClasses Timetable TimetableDefinition luCampus luTimetableGroup luYearLevel
vStudentAbsences	Use this view for absentee information with student name details. Note: This view has been superseded by vStudentAbsenceEvents.	Absences Community ConfigUsers Students StudentSemester luAbsencePeriod luAbsenceReason luAbsenceType luBoarder luYearLevel
vStudentAbsenceEvents	Use this view for all absence events that have not been superseded. Includes student details.	AbsenceEvents AttendanceMaster tAttendances Community StudentYears Students luAbsenceEventType luAbsenceReason luAbsenceType luAbsencePeriod luBoarder luCampus luForm luHouse luStudentStatus luTutor luYearLevel
vStudentAbsenceEvents Attendances	Use this view for attendance information. Includes attendances and nonattendances. This view is based on vStudentAbsenceEvents.	vStudentAbsence Events tAttendances Community luAbsenceType luAbsenceReason AttendanceMaster SubjectClasses pvTimetableDefinition
vStudentClasses	Use this view to list students and the classes they are taking. Also includes: relevant information about the staff member who teaches the classes information about house captains and Head of Campus. Automatically excludes students who: have left the class or school prior to the current date are on leave of absence are deceased. Note: This view is based on vStudentClassesAll where the class stop date is blank or set to a future date.	Students StudentClasses StudentSemester StudentYears SubjectClasses Addresses Community CommunityLegal ConfigUsers FileSemesters LearningAreas StudentStatic SubjectAssessments SubjectClassStaff Staff luBoarder luHouse luCampus luStudentClassStatus luStudentStatus luYearLevel
vStudentClassesAll	Use this view to list students and the classes they are taking. Also includes: relevant information about the staff member who teaches the classes information about house captains and Head of Campus. Automatically excludes students who: are deceased have left your organisation are on a leave of absence.	Students StudentClasses StudentYears SubjectClasses Addresses Community CommunityLegal ConfigUsers FileSemesters LearningAreas Staff StudentStatic SubjectAssessments SubjectClassStaff luBoarder luCampus luHouse luStudentClassStatus luStudentStatus luYearLevel
vStudentContact Address	Use this view for student names and schooling information, along with: contact name and address details for primary and alternative contacts spouse information for each contact. Automatically excludes: term contacts (SCT) deceased students deceased contacts.	Students Addresses Community CommunityLegal ConfigUsers Relationships StudentContacts StudentSemester StudentStatic luBoarder luCampus luContact luCountry luForm luHouse luLanguage luNationality luOccupation luOccupationPosition luParish luRelationship luReligion luStudentStatus luYearLevel
vStudentContact AllAddress	Use this view for student names and schooling information, along with contact name and address details for all contacts, including term contacts. Automatically excludes deceased: students contacts.	Students Addresses Community CommunityLegal ConfigUsers Relationships StudentContacts StudentSemester StudentStatic luCampus luContact luCountry luForm luStudentStatus luYearLevel
vStudentContacts ParentsDebtor	Use this view to obtain student names and schooling details, along with name and address details for the student's: debtor mother father. Excludes students who: have left your organisation are deceased.	Students Addresses Community CommunityLegal ConfigUsers Relationships StudentContacts StudentSemester StudentStatic luBoarder luCampus luContact luForm luIndustry luOccupation luOccupationPosition luPreviousSchool luRelationship luStudentStatus luYearLevel
vStudentContacts RelationOnly	Use this view to obtain: student names address and occupation information for each relation their relationship with the student. Automatically excludes term contacts (SCT).	Students StudentContacts Addresses Community CommunityLegal ConfigUsers FileSemesters Relationships StudentStatic StudentYears luCampus luContact luCountry luForm luLanguage luNationality luOccupation luParish luRelationship luReligion
vStudentCourses	Use this view to obtain information on courses that a student is doing. Includes basic name information.	Students StudentCourses Courses Community StudentYears luBoarder luCampus luStudentCourse Status luYearLevel
vStudentForms Absences	Use this view to obtain a list of absent students by form.	luForm StudentSemester Absences Community ConfigUsers luAbsenceType luYearLevel
vStudentMedDetails PrimContact	Use this view to obtain student medical information as well as: primary contact information for emergency contacts their relationship to the student. Retrieves information as detailed in the vStudentContactAddress view, covered earlier.	vStudentContact Address Students StudentMedical Details Addresses Community CommunityLegal StudentStatic luAsthmaCategory luImmunisationFormStatus luMedicalPrivate InsuranceFund luPreviousSchool luRelationship
vStudentMedical Details	Use this view to obtain: all student medical information information from current students and community functions. One record is output per student. Does not include medical incidents.	StudentYears Students StudentStatic StudentMedical Details Addesses Community CommunityLegal luAsthmaCategory luBoarder luCampus luCountry luForm luHouse luImmunisationFormStatus luLanguage luMedicalPrivateInsuranceFund luNationality luParish luPreviousSchool luRelationship luReligion
vStudentParents MCEETYA	Use this view to extract MCEECDYA (Australian Ministerial Council of Education, Early Childhood Development and Youth Affairs) parent details, including: Occupation Group Home Language Highest Qualification Level Highest Secondary Level.	pvStudentParents vCommunity Addresses luLanguage luQualification Level luOccupation Position Config
vStudentRelations	Use this view to show students and all of their relations. Excludes students who are deceased. Also, see vStudentRelationsAll.	Students StudentSemester Relationships pvCommunity Addresses luOccupation luRelationship luStudentStatus luCampus luForm luBoarder luYearLevel CommunityLegal StudentStatic
vStudentRelationsAll	Use this view to show students and all of their relations. Includes all records, including deceased students. Also see vStudentRelations.	Students StudentSemester Relationships pvCommunity Addresses luOccupation luRelationship luStudentStatus luCampus luForm luBoarder luYearLevel CommunityLegal StudentStatic
vStudentReportsNo Results	Use this view to show which: students have not had results entered for them which staff members are responsible for entering the results.	StudentClasses StudentSemester Community ConfigUsers LearningAreas Staff StudentAssessment Comments StudentAssessment Results Students StudentStatic StudentYears SubjectAssessments SubjectAssessment Areas SubjectClass DefaultPrintFlags SubjectClasses SubjectClassStaff luReportResultType luYearLevel
vStudentReportsSemester	Use this view to obtain the overall results of students, comments and staff information. This view does not contain detailed results. To get detailed results, refer to vStudentReportsSemesterResults, covered below.	StudentSemester Students Community ConfigUsers LearningAreas StudentAssessment Results Staff StudentClasses StudentStatic SubjectAssessment Areas SubjectClasses SubjectClassStaff SubjectAssessments StudentAssessment Comments StudentYears luBoarder luBoardStudiesSubjects luBoardStudiesType luForm luHouse luReportResultClassification luTutor luYearLevel
vStudentReportsSemester Results	Use this view to obtain detailed student results. It does not include overall results or comments. To get overall results and comments, refer to the vStudentReportsSemester view, covered earlier.	StudentClasses SubjectClasses SubjectAssessment Areas StudentAssessment Results SubjectAssessments LearningAreas SubjectClassDefaultPrintFlags luReportResultType luReportResultTypeMaskExtended luReportResultGroup luReportResultClassification StudentAssessmentComments Students StudentSemester luCampus luForm luHouse luYearLevel luBoarder Community SubjectClassStaff Staff ConfigUsers SubjectAssessmentTargets StudentStatic luSubjectClassType
vStudents	Use this view for student schooling and name details. The view does not include: contact details relationship information. Automatically excludes deceased students and students with a status that has a SynergyMeaning of: LEFT - have left your organisation LOA - are on leave of absence. The view was designed for fast, simple queries. Also, see: vStudentsAll vStudentAndLOA, covered below.	Students StudentSemester Community CommunityLegal Config ConfigUsers FileSemesters luStudentStatus luCampus luHouse luYearLevel luForm luTutor luBoarder luParish luReligion luPreviousSchool luCountry luLanguage luLeavingDestination luNationality luRelationship
vStudentsAll	Use this view for student schooling and name details. This view: contains the same information as vStudents includes all students, regardless of their status. This view was created for more detailed queries but runs slower than the vStudents view.	Students StudentSemester Community CommunityLegal Config ConfigUsers FileSemesters luStudentStatus luCampus luHouse luYearLevel luForm luTutor luBoarder luParish luReligion luPreviousSchool luCountry luLanguage luLeavingDestination luNationality luRelationship
vStudentsAndLOA	Use this view for student schooling and name details. This view: does not include contact or relationship information includes a lot more information than the vStudents view, covered earlier includes all current students and those on leave of absence but excludes students who have left your organisation. This view was created for more detailed queries but runs slower than the vStudents view. Also, see the vStudentAll view, covered earlier.	Students StudentSemester Community CommunityLegal Config ConfigUsers FileSemesters luStudentStatus luCampus luHouse luYearLevel luForm luTutor luBoarder luParish luReligion luPreviousSchool luCountry luLanguage luLeavingDestination luNationality luRelationship
vStudentSubjectClass	Use this view to obtain a list of classes that a student is doing, along with the staff member who is teaching that class. Automatically excludes: deceased students classes with a stop date prior to today's date.	Students StudentSemester StudentClasses Community SubjectClasses SubjectClassStaff Staff luBoarder StudentStatic ConfigUsers luYearLevel
vStudentTimetableFull	Use this view to obtain timetable details for students, including: rooms days periods the staff members teaching the classes. Automatically excludes: deceased students classes with a stop date prior to today's date.	StudentSemester Students Community luYearLevel luTimetableGroup luHouse luCampus luForm StudentClasses Timetable Staff TimetableDefinition luBoarder SubjectClasses ConfigUsers StudentStatic luBoarder SubjectClasses ConfigUsers TimetableDefinition
vStudentTutorsAbsences	Use this view to obtain a list of student absences by tutor.	luTutor StudentSemester Absences Community luAbsenceType luAbsencePeriod ConfigUsers luYearLevel

Last modified: 11/09/2014 4:20:07 PM