Views have been created by the Synergetic development team to make querying the database an easier process. These views are either from the:
View name |
Description |
Base tables used |
---|---|---|
vAbility |
Use this view to list community members and the skills they have. |
|
vAbsenceEventsHistory |
Use this view to list a history of changes to absence events. |
|
vAwards |
Use this field to view all current and past student award information. |
|
vCommunicationsCurrent |
Use this view to list current communications, with the name and address details of the recipients. Automatically excludes deceased people. |
|
vCommunicationsPast |
Use this view to list past communications, with the name and address details of the recipients. Automatically excludes deceased people. |
|
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. |
|
vCommunityAddresses |
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. |
|
vCommunitySkills |
Use this view to list community members and the skills they have. |
|
vDonors |
Use this view to list donor information such as foundations, addresses and phone numbers. |
|
vDonorPledges |
Use this view to list donor pledges and the amount received against each pledge, with:
|
|
vDonorPledgesReceipts |
Use this view to list donor pledges and detailed receipt information for each pledge with:
|
|
vDonorProspectAddress |
Use this view for donor prospect name and address details, as well as:
Automatically excludes deceased prospects. |
|
vDonorProspectHistory |
Use this view for donor prospect history (activities) with:
Automatically excludes deceased prospects. |
|
vDonorReceipts |
Use this view for detailed receipt information with:
|
|
vEnquiryContactAddress |
Use this view to list:
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. |
|
vEnquiryFutureStudents |
Use this view to list future student and enquiry information such as:
|
|
vEvents |
Use this view for information on events and their locations, without any attendee details. |
|
vEventsCurrent |
Use this view for information on current events and their locations, with attendee name and address details. Automatically excludes deceased attendees. |
|
vEventsPast |
Use this view for information on past events and their locations, with attendee name and address details. |
|
vFutureContactAddress |
Use this view for future student names and entry information, along with:
Automatically excludes:
|
|
vFutureContactsRelationOnly |
Use this view to obtain:
Automatically excludes term contacts (Type = SCT). |
|
vFutureMedical |
Use this view to obtain future student medical information as well as:
Retrieves information as detailed in the vFutureContactAddress view, covered earlier. |
|
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. |
|
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. |
|
vFutureStudentAbility |
Use this view to list future students and their abilities. |
|
vFutureStudent |
Use this view to list future students and their allergies. |
|
vFutureStudent |
Use this view to list future students and their medical conditions. |
|
vFutureStudent |
Use this view to list future students and their medical consents. |
|
vFutureStudent |
Use this view to obtain future student medical information. |
|
vFutureStudent |
Use this view to list future students and their immunisations. |
|
vFutureStudentMedical |
Use this view to list future students and their medications. |
|
vFutureStudent |
Use this view to list future students and their medical symptoms. |
|
vMedicalAllergy |
Use this view to list community members and their allergies. |
|
vMedicalCondition |
Use this view to list community members and their medical conditions. |
|
vMedicalConsent |
Use this view to list community members and their medical consents. |
|
vMedicalImmunisation |
Use this view to list community members and their immunisations. |
|
vMedicalIncidentsAll |
Use this view to list community members and their medical incidents. |
|
vMedicalSymptomAll |
Use this view to list community members and their medical symptoms. |
|
vMedicalSymptom |
Use this view to list community members and their medical symptoms for active records only. |
|
vMedicalMedication |
Use this view to list community members and their medications. |
|
vNZMoE_eAR_School |
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:
|
|
vNZMoE_StudentData |
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. |
|
vPastStudentAddress |
Use this view for past student names and their:
|
|
vStaff |
Use this view for personal staff details. This view contains detailed name and address information. Automatically excludes deceased staff members. |
|
vStaffAbility |
Use this view to list staff members and their abilities. |
|
vStaffMedicalAllergy |
Use this view to list staff members and their allergies. |
|
vStaffMedicalCondition |
Use this view to list staff members and their medical conditions. |
|
vStaffMedicalConsents |
Use this view to list staff members and their medical consents. |
|
vStaffMedicalHealthcare |
Use this view to obtain staff medical information |
|
vStaffMedical |
Use this view to list staff members and their immunisations. |
|
vStaffMedicalMedication |
Use this view to list staff members and their medications. |
|
vStaffMedicalSymptom |
Use this view to list staff members and their medical symptoms. |
|
vStaffTimetableFull |
Use this view for staff timetable details. This view does not contain detailed name and address information. Automatically excludes deceased staff members. |
|
vStudentAbility |
Use this view to list future, current and past students and their abilities. |
|
vStudentAbsences |
Use this view for absentee information with student name details. Note: This view has been superseded by vStudentAbsenceEvents. |
|
vStudentAbsenceEvents |
Use this view for all absence events that have not been superseded. Includes student details. |
|
vStudentAbsenceEvents |
Use this view for attendance information. Includes attendances and nonattendances. This view is based on vStudentAbsenceEvents. |
|
vStudentClasses |
Use this view to list students and the classes they are taking. Also includes:
Automatically excludes students who:
|
|
vStudentClassesAll |
Use this view to list students and the classes they are taking. Also includes:
Automatically excludes students who:
|
|
vStudentContact |
Use this view for student names and schooling information, along with:
Automatically excludes:
|
|
vStudentContact |
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:
|
|
vStudentContacts |
Use this view to obtain student names and schooling details, along with name and address details for the student's:
Excludes students who:
|
|
vStudentContacts |
Use this view to obtain:
Automatically excludes term contacts (SCT). |
|
vStudentCourses |
Use this view to obtain information on courses that a student is doing. Includes basic name information. |
|
vStudentForms |
Use this view to obtain a list of absent students by form. |
|
vStudentMedical |
Use this view to list future, current and past students and their allergies. |
|
vStudentMedical |
Use this view to list future, current and past students and their medical conditions. |
|
vStudentMedical |
Use this view to list future, current and past students and their medical consents. |
|
vStudentMedical |
Use this view to obtain:
One record is output per student. Does not include medical incidents |
|
vStudentMedical |
Use this view to obtain student medical information as well as:
|
|
vStudentMedical |
Use this view to obtain student medical information as well as:
Retrieves information as detailed in the vStudentContactAddress view, covered earlier. |
|
vStudentMedical |
Use this view to list future, current and past students and their immunisations. |
|
vStudentMedical |
Use this view to list future, current and past students and their immunisations. |
|
vStudentMedical |
Use this view to list future, current and past students and their medications. |
|
vStudentMedical |
Use this view to list future, current and past students and their medical symptoms. |
|
vStudentParents |
Use this view to extract MCEECDYA (Australian Ministerial Council of Education, Early Childhood Development and Youth Affairs) parent details, including:
|
|
vStudentRelations |
Use this view to show students and all of their relations. Excludes students who are deceased. Also, see vStudentRelationsAll. |
|
vStudentRelationsAll |
Use this view to show students and all of their relations. Includes all records, including deceased students. Also see vStudentRelations. |
|
vStudentReportsNo |
Use this view to show which:
|
|
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. |
|
vStudentReportsSemester |
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. |
|
vStudents |
Use this view for student schooling and name details. The view does not include:
Automatically excludes deceased students and students with a status that has a SynergyMeaning of:
The view was designed for fast, simple queries. Also, see:
|
|
vStudentsAll |
Use this view for student schooling and name details. This view:
This view was created for more detailed queries but runs slower than the vStudents view. |
|
vStudentsAndLOA |
Use this view for student schooling and name details. This view:
This view was created for more detailed queries but runs slower than the vStudents view. Also, see the vStudentAll view, covered earlier. |
|
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:
|
|
vStudentTimetableFull |
Use this view to obtain timetable details for students, including:
Automatically excludes:
|
|
vStudentTutorsAbsences |
Use this view to obtain a list of student absences by tutor. |
|
non printable note at the end of a topic, with a tableLast modified: 30/06/2016 12:21:03 PM
See Also |
© 2016 Synergetic Management Systems. Published 16 September 2016.