Page Comparison

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
vAbility	Use this view to list community members and the skills they have.	Ability Community luAbilityType luAbilitySkillLevel
vAbilityDefault		Community luAbilityType luAbilitySkillLevel vAbility
vAbsenceEventsDailyCalc		AbsenceEventsDailyCalc Community vAbsenceEventsDailyCalcIncluded luAbsencePeriod
vAbsenceEventsDailyCalcErrors		AbsenceEvents luAbsenceType luAbsencePeriod
vAbsenceEventsDailyCalcIncluded		AbsenceEvents luAbsenceType luAbsencePeriod
vAbsenceEventsDailyCalcSummary		AbsenceEventsDailyCalc Community
vAbsenceEventsHistory	Use this view to list a history of changes to absence events.	AbsenceEventsAttendancesHistory AbsenceEvents AbsenceEventsDeleted tAttendances AttendanceMaster Community ConfigUsers
vActionMessage		ActionMessage pvActionMessageType pvActionMessageImage luSchool Tasks luTaskStatus Config
vActionMessageSubscriber		ActionMessageSubscriber vActionMessage
vActionMessageSubscriptionInfo		ActionMessageSubscription ActionMessageType
vActionMessageType		ActionMessageType
vActionUserSubscriptionPreferences		ActionMessageSubscription ActionUserSubscriptionPreferences ActionMessageType SynDatabases
vActivities		tActivities luActivity luActvityStatus Community pvEnquiryStudents Students FutureStudents PastStudents pvEnquiryStudentContacts StudentContacts FutureStudentContacts PastStudentContacts Addresses
vAddressesBad	Used to return addresses that were not successfully matched during the bulk validation process.	AddressesBad Community Addresses EnquiryStudentContacts
vAttendances		Attendances luAbsenceType luAbsenceReason Community Staff StudentSemester ConfigUsers luYearLevel
vAttendancesUserFlagHeadings		Config
vAttendancesWithAbsences		Attendances luAbsenceType luAbsenceReason Community Staff StudentSemester Students AbsencesEvents luAbsenceEventType luAbsencePeriod ConfigUsers SubjectClasses luBoarder luYearLevel
vAwards	Use this field to view all current and past student award information.	StudentAwards Community Addresses PastStudentAwards FileSemesters luAchievementType luAward luAwardClassification
vCocurricularResults		StaffSchedule luStaffScheduleType SubjectClasses luLocation SubjectClassStaff FileSemesters Staff
vCocurricularScheduledAppointments		StaffScheduleStudentClasses SubjectClasses vStudents StaffSchedule Staff luStaffScheduleType Community
vColour		luColour
vCommunicationsCurrent	Use this view to list current communications, with the name and address details of the recipients. Automatically excludes deceased people.	CommunityCommunicationsCurrent Addresses Communications CommunityCommunications Community Config luAddressRegion luCountry luNotifyMethod vCommunicationsCurrentNoNotify
vCommunicationsCurrentAndPast		CommunityCommunicationsCurrent Communications Config CommunityCommunications
vCommunicationsCurrentNoNotify		CommunityCommunicationMethods luNotifyMethod
vCommunicationsPast	Use this view to list past communications, with the name and address details of the recipients. Automatically excludes deceased people.	CommunityCommunications 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
vCommunityAddressesArchive		AddressesArchive CommunityArchive CommunityArchiveDates AddressArchiveDates
vCommunityAddressesConstit	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
vCommunityAddressesPortions		vCommunityAddresses
vCommunityConfirmationStatus		refMyDetailsConfirmationFlagName Community MyDetailsConfirmation Students FutureStudents
vCommunityConstit		Constituencies
vCommunityKeys		Keys CommunityKeys Community luOccupation Addresses Staff luDepartment
vCommunityMainConstitsDonors		Constituencies DonorPledges DonorReceipts Community Addresses PastStudents
vCommunityQualifications		pvCommunity CommunityQualifications luQualification luQualificationLevel luOccupation Addresses Staff luDepartment
vCommunitySkills	Use this view to list community members and the skills they have.	Community CommunitySkills Addresses Staff luDepartment luOccupation luSkill luSkillLevel
vCommunityVehicles		pvCommunity CommunityVehicles luOccupation Addresses Staff luDepartment luVehicleParkingSpace luVehicleClass
vConfigGroupResourcesAll		Config pvConfigGroupSecurity refModule luDocumentClassification luConfigGroup ConfigGroupDocumentClassifications pvConfigGroupConstituencies ActionMessageType SynDatabases ActionMessageSubscription
vConfigGroupSecurityAndDocumentClassifications		ConfigUsers ConfigUserGroups Community ConfigGroupSecurity ConfigGroupDocumentClassifications
vConfigUserResourcesAll		ConfigUsers Community ConfigUserGroups ConfigGroupResourcesAll ActionMessageType vActionUserSubscriptionPreferences
vConstituenciesExtraDetails		Constituencies ConfigUser PastStudents FutureStudents StudentYears
vCRptSchedulerLog		ConfigReportSchedule Community refModule ConfigResources
vDailyMaintenanceLog		DailyMaintenanceLog DailyMaintenanceLogDatabase
vDocuments		pvDocumentReferences tDocuments pvDocumentClassificationsUser
vDonors	Use this view to list donor information such as foundations, addresses and phone numbers.	Donors Addresses Community Constituencies DonorReceipts
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 luDonorProspectInclination
vDonorProspectHistoryAddress	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 DonorProspectHistory luAppeal luDonorProspectActivityStatus
vDonorProspectLastActivity		DonorProspects DonorProspectHistory Community Addresses luDonorProspectInclination luDonorProspectActivityStatus luDonorProspectActivity
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
vDonorRecentReceipts		DonorReceipts
vDonorRecentReceiptsCommunityAddresses		CommunityAddresses DonorRecentReceipts Donors
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.	EnquiryStudentContacts EnquiryStudents Community Addresses luBoarder luCampus luEnquirySource luHouse luSubSchool luYearLevel luYearLevelGroup
vEnquiryFutureCurrentLink		vEnquiryStudents FutureStudents Community luYearLevel EnquiryStudentsArchive luReligion Students luFutureStatus StudentYears FutureStudentsArchive
vEnquiryFutureStudents	Use this view to list future student and enquiry information such as: personal information campus year level form house.	vEnquiryStudents Community FutureStudents luCampus luEnquirySource luForm luFuturePriority luHouse luPreviousSchool luTutor luYearLevel luReligion
vEnquiryStudents		EnquiryStudents luCampus luYearLevel luHouse luForm luTutor luPreviousSchool luEnquirySource luFuturePriority Community luReligion
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.	CommunityEventsCurrent Addresses Community Events luLocation
vEventsCurrentAndPast	Used to retrieve event description with status and ID of the person attending.	CommunityEvents Events luCommunityCurrEventStatus CommunityEventsCurrent Config
vEventsCurrentAttendeeAndGuests		CommunityEventsCurrent Community Events luLocation Addresses CommunityEventsCurrentGuests pvEvents
vEventsCurrentEachAttendee		CommunityEventsCurrent pvCommunity pvEvents luLocation Addresses EventGeneralConsent EventAbility
vEventsPast	Use this view for information on past events and their locations, with attendee name and address details.	CommunityEvents Addresses pvCommunity pvEvents luLocation
vEventsStudentAttendees		EventAppointment StaffSchedule StaffScheduleStudentClasses Community Events luStaffScheduleType EventGroup EventSubGroup luEventGroupType
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 pvCommunity CommunityLegal FutureStudentContacts Relationships luBoarder luCampus luContact luCountry luFutureStatus luIndustry luOccupation luOccupationPosition luRelationship luYearLevel
vFutureContactAddressWithTerm		FutureStudents pvCommunity FutureStudentContacts luBoarder Addresses luContact luFutureStatus luOccupation luIndustry luOccupationPosition CommunityLegal Relationships luRelationship luCampus luYearLevel
vFutureContactsAndRelations		Relationships StudentContacts pvCommunity FutureStudents FutureStudentContacts Community ContactsAndRelations_cte RecipientUse_cte StudentStatic luBoarder luBoardingHouse luForm luHouse luFutureStatus luFuturePriority luCampus luTutor luYearLevel Students
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 FutureStudentContacts Addresses ConfigUsers Community CommunityLegal Relationships StudentStatic luContact luCountry luLanguage luNationality luOccupation luParish luRelationship luReligion
vFutureContactsSplitFamilies		FutureStudents FutureStudentContacts Community Addresses CommunityLegal luYearLevel
vFutureMedicalHealthcarePrimContact	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.	vFutureContactAddress FutureStudents Addresses pvCommunity CommunityLegal MedicalDetails StudentStatic luDisabilityLevel luCountry luHouse luImmunisationFormStatus luLanguage luMedicalPrivateInsuranceFund luNationality luParish luPreviousSchool luRelationship luReligion 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 pvCommunity 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 pvCommunity CommunityLegal StudentStatic luBoarder luFuturePriority luFutureStatus luHouse luParish luPreviousSchool luRelationship luReligion luYearLevel
vFutureStudentAbility	Use this view to list future students and their abilities.	FutureStudents vAbility
vFutureStudentActivities		tActivities Addresses Community EnquiryStudentContacts EnquiryStudents FutureStudentContacts FutureStudents StudentContacts Students luActivity luActivityStatus luBoarder
vFutureStudentAppContactAddress		Addresses CommunityLegal FutureStudentApplications FutureStudentContacts FutureStudents pvCommunity Relationships luBoarder luContact luFutureApplicationCategory luFutureStatus luOccupation luRelationships luYearLevel
vFutureStudentApplications		CommunityLegal FutureStudentApplications FutureStudents pvCommunity StudentStatic luFutureApplicationCategory luFutureStatus luBoarder luHouse luYearLevel
vFutureStudentApplicationsAll		CommunityArchive CommunityLegal config FutureStudentApplicationsArchv FutureStudentApplications FutureStudentsArchive FutureStudents pvCommunity StudentStatic luFutureStatus luHouse luBoarder luFutureApplicationCategory luYearLevel
vFutureStudentMedicalAllergy	Use this view to list future students and their allergies.	vFutureStudent MedicalAllergies
vFutureStudentMedicalCondition	Use this view to list future students and their medical conditions.	FutureStudents vMedicalCondition
vFutureStudentMedicalConsent	Use this view to list future students and their medical consents.	FutureStudents vMedicalConsent
vFutureStudentMedicalHealthcare	Use this view to obtain future student medical information.	Addresses Community CommunityLegal FutureStudentContacts FutureStudents luDisabilityLevel luMedicalPrivateInsuranceFund luYearLevel MedicalDetails StudentStatic
vFutureStudentMedicalImmunisation	Use this view to list future students and their immunisations.	FutureStudents vMedicalImmunisation
vFutureStudentMedicalMedication	Use this view to list future students and their medications.	FutureStudents vMedicalMedication
vFutureStudentMedicalSymptom	Use this view to list future students and their medical symptoms.	vFutureStudent MedicalSymptom
vFutureStudentPastSiblingsAtSchool	Used to list future students and their current, past and future student siblings.	Addresses CommunityLegal FutureStudents FutureStudentContacts PastStudentContacts pvCommunity Relationships StudentContacts luBoarder luContact luFutureStatus luOccupation luRelationship luYearLevel
vFutureStudentSiblingsAtSchool	Used to list future students and their current student siblings.	Addresses CommunityLegal FutureStudents FutureStudentContacts pvCommunity Relationships StudentContacts luBoarder luContact luFutureStatus luOccupation luRelationship luYearLevel
vFutureStudentTransport	Used to list future students and details about how they are transported to your organisation.	Addresses CommunityLegal Community ConfigUsers FutureStudents FutureStudenTransport StudentStatic luBoarder luCampus luFuturePriority luFutureStatus luHouse luParish luPreviousSchool luRelationship luReligion luTransport luTransportStops luYearLevel
vFutureStudentTransportContactAddress		Addresses CommunityLegal FutureStudentContacts FutureStudents FutureStudentTransport pvCommunity Relationships luBoarder luCampus luContact luFutureStatus luIndustry luTransport luTransportStops luOccupation luOccupationPosition luRelationship luYearLevel
vIdamConstituency		luConstituency
vIndividualPlans	Used to list individual learning plans for current students.	Community IndividualPlans vPhotos vStudents luIndividualPlanArea luIndividualPlanType luIndividualPlanStatus
vMedicalAbilityDefaultsStudent		Ability Students luAbilityType
vMedicalAbilityStaff		Ability Staff luAbilityType
vMedicalAbilityStudent		Ability Students luAbilityType
vMedicalAdditionalAsthmaDetails		MedicalAdditionalAsthmasDetails luAsthmaCategory
vMedicalAllAbilityStudent		Ability Students luAbilityType
vMedicalAllAllergyStudent		MedicalAllergy MedicalAttributesVisibility Students luMedicalAllergyType luMedicalConditionSeverity
vMedicalAllCondiitonStudent		Community MedicalCondition MedicalSummaryConfidentialConditionDisplayText Students luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalAllConsentStudent		Community Consent Students luConsentType
vMedicalAllergy	Use this view to list community members and their allergies.	vMedicalAllergyAll
vMedicalAllergyAll		Community MedicalAllergy MedicalAttributesVisibility MedicalSummaryShowAttributes_cte luMedicalAllergyType luMedicalConditionSeverity
vMedicalAllergyDefault		Community SeverityString_cte luMedicalConditionSeverity luMedicalAllergyType
vMedicalAllergyDefaultsStudent		Community vMedicalAllergy SeverityString_cte luMedicalAllergyType luMedicalConditionSeverity
vMedicalAllergyPlusDefault		Community vMedicalAllergy SeverityString_cte luMedicalAllergyType luMedicalConditionSeverity
vMedicalAllergyStaff		MedicalAllergy Staff MedicalSummaryShowAttributes_cte luMedicalAllergyType luMedicalAttributesVisibility luMedicalConditionSeverity
vMedicalAllergyStaffVisibility		vMedicalAllergyAll
vMedicalAllergyStudent		MedicalAllergy MedicalAttributesVisibilty MedicalSummaryShowAttributes_cte Students luMedicalAllergyType luMedicalConditionSeverity
vMedicalAllImmunisationStudent		MedicalDetails MedicalImmunisation Students luImmunisationFormStatus luMedicalImmunisationType luMedicalVaccineBrand
vMedicalCondAdditionalAsthmaDetailsStaff		Community MedicalAdditionalAsthmaDetails MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Staff luAsthmaCategory luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalCondAdditionalAsthmaDetailsStudent		Community MedicalAdditionalAsthmaDetails MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Students luAsthmaCategory luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalCondAllergyStaff		Community MedicalAllergy MedicalConditionAllergy MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Staff luMedicalAllergyType luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalCondAllergyStudent		Community MedicalAllergy MedicalConditionAllergy MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Students luMedicalAllergyType luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalCondEquipmentStaff		Community MedicalCondition MedicalEquipment MedicalSummaryConfidentialConditionDisplayText_cte Staff luMedicalEquipment luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalCondEquipmentStudent		Community MedicalCondition MedicalEquipment MedicalSummaryConfidentialConditionDisplayText_cte Students luMedicalEquipment luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalCondition	Use this view to list community members and their medical conditions.	vMedicalConditionAll
vMedicalConditionAll		Community MedicalAdditionalAsthmaDetails MedicalCondition luAsthmaCategory luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility
vMedicalConditionAllergyStaffVisibility		MedicalConditionAllergy vMedicalAllergyAll vMedicalConditionAll
vMedicalConditionDefaultsStudent		Community MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Students luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility
vMedicalConditionEquipment		MedicalCondition MedicalEquipment luMedicalConditionSeverity luMedicalConditionType luMedicalEquipment
vMedicalConditionMedicationStaffVisibility		MedicalConditionMedication vMedicalMedicationAll vMedicalConditionAll
vMedicalConditionStaff		Community MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Staff luMedicalConditionSeverity luMedicalConditionType luMedicalConditionVisibility
vMedicalConditionStaffVisibility		vMedicalConditionAll
vMedicalConditionSTFContact		Addresses Community CommunityLegal Relationships Staff StaffReportContactDetailsShowCourtOrderSection_cte luCourtOrderType luRelationship
vMedicalConditionSTUContact		Addresses Community CommunityLegal Relationships Students vStudentContactAddress luCourtOrderType
vMedicalConditionStudent		Community MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Students luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility
vMedicalCondMedicationStaff		Community MedicalConditionMedication MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Medication Staff luMedication luMedicationAdministration luMedicationType luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility
vMedicalCondMedicationStudent		Community MedicalConditionMedication MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte Medication Students luMedication luMedicationAdministration luMedicationType luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility
vMedicalCondRiskStaff		Community MedicalCondition MedicalRisk MedicalSummaryConfidentialConditionDisplayText_cte Staff luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility
vMedicalCondRiskStudent		Community MedicalCondition MedicalRisk MedicalSummaryConfidentialConditionDisplayText_cte Students luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility
vMedicalCondSymptomStaff		Community MedicalCondition MedicalSymptom MedicalSummaryConfidentialConditionDisplayText_cte Staff luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility luMedicalSymptomType
vMedicalCondSymptomStudent		Community MedicalCondition MedicalSymptom MedicalSummaryConfidentialConditionDisplayText_cte Stduents luMedicalConditionType luMedicalConditionSeverity luMedicalConditionVisibility luMedicalSymptomType
vMedicalCondTestStaff		Community MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte MedicalTest Staff luMedicalConditionSeverity luMedicalConditionType luMedicalTestType luMedicalConditionVisibility
vMedicalCondTestStudent		Community MedicalCondition MedicalSummaryConfidentialConditionDisplayText_cte MedicalTest Students luMedicalConditionSeverity luMedicalConditionType luMedicalTestType luMedicalConditionVisibility
vMedicalConsent	Use this view to list community members and their medical consents.	Community Consent luConsentType
vMedicalConsentDefault		Community vMedicalConsent luConsentType
vMedicalConsentDefaultsStudent		Community Consent Students luConsentType
vMedicalConsentStaff		Community Consent Staff luConsentType
vMedicalConsentStudent		Community Consent Students luConsentType
vMedicalConsentHealthcareStaff		MedicalDetails Staff luDisabilityLevel luMedicalPrivateInsuranceFund luRelationship
vMedicalConsentHealthcareStudent		MedicalDetails Students luDisabilityLevel luMedicalPrivateInsuranceFund luRelationship
vMedicalImmunisation	Use this view to list community members and their immunisations.	Community luMedicalImmunisationType luMedicalVaccineBrand MedicalImmunisation
vMedicalImmunisationDefault		Community vMedicalImmunisation luMedicalImmunisationType
vMedicalImmunisationDefaultsStudent		MedicalDetails MedicalImmunisation Students luImmunisationFormStatus luMedicalImmunisationType luMedicalVaccineBrand
vMedicalImmunisationStaff		MedicalDetails MedicalImmunisation Staff luImmunisationFormStatus luMedicalImmunisationType luMedicalVaccineBrand
vMedicalImmunisationStudent		MedicalDetails MedicalImmunisation Students luImmunisationFormStatus luMedicalImmunisationType luMedicalVaccineBrand
vMedicalIncidents		tMedicalIncidents RestrictedActivities luInjuryActionTaken luInjuryReferral luInjuryScale luMedicalIncidentType
vMedicalIncidentsAll	Use this view to list community members and their medical incidents.	Community luMedicalIncidentType PastStudents Staff Students StudentYears vMedicalIncidents
vMedicalMedication	Use this view to list community members and their medications.	MedicalConditionMedication vMedicalCondition vMedicalMedicationAll
vMedicalMedicationAll		MedicalConditionMedication vMedicalCondition vMedicalMedicationAll
vMedicalMedicationDefault		Community MedicalConditionMedication vMedicalCondition vMedicalMedication luMedication luMedicationAdministration luMedicationType
vMedicalMedicationPlusDefault		Community MedicalConditionMedication vMedicalCondition vMedicalMedication luMedication luMedicationAdministration luMedicationType
vMedicalMedicationStaff		Medication Staff luMedication luMedicalAdministration luMedicationType
vMedicalMedicationStudent		Medication Students luMedication luMedicalAdministration luMedicationType
vMedicalOperators		Community ConfigUsers vMedicalIncidents
vMedicalSymptom	Use this view to list community members and their medical symptoms for active records only.	vMedicalSymptomAll
vMedicalSymptomAll	Use this view to list community members and their medical symptoms.	Community luMedicalSymptomType MedicalSymptom
vMedicalSymptomStaffVisibility		vMedicalSymptomAll vMedicalConditionAll
vMsgUAbsenceEvents		AbsenceEvents ConfigUsers StudentYears luAbsenceEventType luAbsencePeriod luAbsenceType
vMyDetailsConfirmedStatus		MyDetailsConfirmation pvCommunity
vNZMOE		Community PastStudentYears pvxeNZMOE pvxeNZMOERollReturnControl refExternalSystemSchoolAttainment refExternalSystemSchool refExternalSystemEthnicGroup School StudentYears xeNZMOE
VNZMOE_CountDates		cte_Dates cte_List
vNZMoE_eAR_SchoolDetails	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_eAR_StudentAttendanceFirstLast		tAttendances AttendanceMaster
vNZMoE_Ethnicity		Community luEthnicGroup
vNZMoE_Footer		Config School
vNZMoE_StudentAttendanceRegister		vAttendancesWithAbsences luYearLevel
vNZMoE_StudentDataChanges	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
vNZMoE_Students		Community Students StudentStatic StudentYears luCountry luExchangeScheme luForm luStudentEligibility luTutor luYearLevel
vNZMoE_StudentsByIndigenousGroup		Community Students StudentYears luCampus luForm luHouse luIndigenousGroup
vNZMoE_StudentsSnapshot		CommunityArchive StudentsHistory StudentStaticHistory StudentYearsHistory vNZMOE vNZMOE_CountDates luForm luTutor luYearLevel
vObjectAccommodation		Objects ObjectAccommodation ObjectTypes
vObjectLoans		Community ObjectBookings ObjectLoans ObjectTypes pvObjects pvStudentNames
vObjectsAll		Config Objects ObjectAccommodation
vOldCollegiansBranchBoundariesbyPostCode		Addresses Community PastStudents vCommunityConstit
vOMNILinkluTransport		luTransport
vOMNILinkStudentAddresses		Addresses Community Config FileSemesters FutureStudents PastStudents Students StudentYears luCountry luStudentStatus
vOMNILinkStudentTransport		FileSemesters FutureStudents PastStudents Students StudentYears Transport luTransport luTransportStops vOMNILinkStudentAddresses
vOnlineApplication		OnlineImportApplications OnlineImportContacts OnlineImportStudents OnlineImportStudentsSchoolPreferences
vOnlineEnquiry		OnlineImportApplications OnlineImportContacts OnlineImportStudents
vOnlineImportApplicationsStatusSummary		OnlineImportApplications OnlineImportStudents luOnlineApplicationStatus luOnlineApplicationStudentStatus
vOnlineImportContacts		OnlineimportContacts luRelationship
vPastoralCare		Community PastoralCare Students vPastoralCareActions vPastoralCareContacts vPastoralCareComments luPastoralCareCategory luPastoralCareType
vPastoralCareActions		Community PastoralCare PastoralCareActions Students luPastoralCareAction luPastoralCareActionType luPastoralCareCategory luPastoralCareType
vPastoralCareComments		Community PastoralCare PastoralCareComments Students luPastoralCareCategory luPastoralCareType
vPastoralCareContacts		Community PastoralCare PastoralCareContacts Students luPastoralCareCategory luPastoralCareType
vPastoralCareContactType		luPastoralCareContactType
vPastoralCarePivotContacts		PastoralCare PastoralCareContacts luPastoralCareContactType
vPastoralCareStaffRole		FileSemester StudentClasses Tutor luForm luHouse luYearLevel
vPastoralCareStatistics		PastoralCareActions PastoralCareContacts pvPastoralCare vStudents
vPastoralCareStudentContacts		Community FileSemesters StudentYears StudentClasses StudentContacts SubjectClassStaff SubjectClasses vStudentRelations luForm luHouse luPastoralCareContactType luTutor luYearLevel
vPastoralCareTabPermission		ConfigGroupSecurity ConfigResources ConfigUserGroups
vPastStudentAbsenceEvents		AbsenceEvents AttendanceMaster tAttendances AbsenceEvents Community PastStudentYears PastStudents luAbsenceEventType luAbsencePeriod luAbsenceReason luAbsenceType luBoarder luCampus luHouse luForm luStudentStatus luTutor luYearLevel
vPastStudentAbsenceEventsAffectedPeriods		FileSemesters pvTimetableDefinition vPastStudentAbsenceEvents luYearLevel
vPastStudentAbsenceEventsAttendancesAffectedPeriods		tAttendances AttendanceMaster ClassCode Community pvTimetableDefinition SubjectClasses vPastStudenAbsenceEventsAffectedPeriods luAbsenceReason luAbsenceType
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
vPastStudentAssessAreaResults		AssessmentCode ClassCode LearningAreas PastStudentClasses SubjectAssessmentAreas SubjectAssessments SubjectClasses
vPastStudentClasses		vPastStudentClassesAll
vPastStudentClassesAll		Addresses Community CommunityLegal ConfigUsers FileSemesters LearningAreas PastStudentsOriginal PastStudentClasses PastStudentSemester Staff SubjectAssessments SubjectClasses SubjectClassStaff luBoarder luCampus luHouse luStudentStatus luYearLevel
vPastStudentReportsSemester		ClassCode Community PastStudentClasses PastStudents PastStudentSemester PastStudentYears SubjectClasses luBoarder luBoardStudiesSubjects luBoardStudiesType luForm luHouse luTutor luYearLevel
vPastStudentReportsSemesterResults		Community ConfigUsers LearningAreas PastStudentAssessmentComments PastStudentAssessmentResults PastStudentClasses PastStudents PastStudentSemester Staff SubjectAssessmentAreas SubjectAssessments SubjectAssessmentTargets SubjectClasses SubjectClassStaff SubjectClassDefaultPrintFlags StudentStatic luBoarder luCampus luForm luHouse luReportResultClassification luReportResultGroup luReportResultType luReportResultTypeMaskExpanded luSubjectClassType luTutor luYearLevel
vPhotos		photos
vPotentiality		Addresses Community PastStudents luCountry luIndustry luNationality luOccupation luOccupationPosition
vPTInterviews
vReceiptsOnline		OnlinePaymentMerchants ReceiptsOnline SynDatabases vCommunityAddresses
vReceiptsFooter		Config
vResourcesAll		ActionMessageType ConfigResources luConstituency luDocumentClassification
vRoomTimetableFull		vTimetableRooms PeriodNumber pvTimetableDefinition Staff SubjectClasses Timetable TimetableGroup luTimetableGroup luYearLevel
vScholarshipApplicationsPrimC		Addresses Community EnquiryStudents EnquiryStudentContacts FutureStudentContacts FutureStudents FutureStudentScholarships StudentContacts Students luScholarship luScholarshipStatus
vSchoolDetails		School luDocumentClassification
VSNStatus		FileSemesters StudentStatic StudentYears VSNBatchStudents VSNBatches
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 luWorkWithChildrenCheckStatus luYearLevel
vStaffAbility	Use this view to list staff members and their abilities.	Staff vAbility
vStaffAbsences		Community StaffAbsences Staff luAbsenceReason luAbsenceType luCampus luDepartment luStaffCategory
vStaffAppraisals		Addresses pvCommunity StaffAppraisals Staff luDepartment
vStaffConfidentialComments		Addresses pvCommunity StaffComments Staff luDepartment
vStaffExternalDetails		StaffExternalDetails StaffExternalDetailsDefinitions
vStaffJobPositionHierarchy		JobPositions Staff StaffJobPositions
vStaffJobPositions		Addresses JobPositions pvCommunity Staff StaffJobPositions luDepartment luJobPositionCategory
vStaffLearningAreas		Addresses pvCommunity LearningAreas Staff StaffLearningAreas luDepartment luLearningAreaLevel luYearLevel
vStaffMedicalAllergy	Use this view to list staff members and their allergies.	Staff vMedicalAllergy
vStaffMedicalCondition	Use this view to list staff members and their medical conditions.	Staff vMedicalCondition
vStaffMedicalConsent	Use this view to list staff members and their medical consents.	Staff vMedicalConsent
vStaffMedicalHealthcare	Use this view to obtain staff medical information	Addresses luCampus luDisabilityLevel luStaffCategory luYearLevel MedicalDetails pvCommunity Staff
vStaffMedicalImmunisation	Use this view to list staff members and their immunisations.	Staff vMedicalImmunisation
vStaffMedicalMedication	Use this view to list staff members and their medications.	Staff vMedicalMedication
vStaffMedicalSymptom	Use this view to list staff members and their medical symptoms.	Staff vMedicalSymptom
vStaffPersonalCommentBank		Community Staff StaffAssessmentComments luYearLevel
vStaffPersonalDevelopment		Addresses pvCommunity LearningAreas Staff StaffTraining luDepartment luStaffTrainingCategory luTrainingProvider luYearLevel
vStaffScheduleAttendances		ClassCode StaffSchedule StaffScheduleStudentClasses SubjectClasses vStaff vStudentsAll
vStaffScheduleFull		ClassCode Community Staff StaffSchedule StaffScheduleStudentClasses StudentClasses StudentYears SubjectClasses luTeam 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
vStuContactLabels		vStudentContactAllAddress
vStudentAbility	Use this view to list future, current and past students and their abilities.	StudentYears vAbility
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 StudentStatic StudentYears Students luAbsenceEventType luAbsenceReason luAbsenceType luAbsencePeriod luBoarder luCampus luForm luHouse luStudentStatus luTutor luYearLevel
vStudentAbsenceEventsAffectedPeriods		FileSemesters pvTimetableDefinition vStudentAbsenceEvents luYearLevel
vStudentAbsenceEventsAttendances	Use this view for attendance information. Includes attendances and nonattendances. This view is based on vStudentAbsenceEvents.	vStudentAbsenceEvents tAttendances Community luAbsenceType luAbsenceReason AttendanceMaster SubjectClasses pvTimetableDefinition
vStudentAbsenceEventsAttendancesAffectedPeriods		vStudentAbsenceEventsAffectedPeriods tAttendances AttendanceMaster ClassCode Community pvTimetableDefinition SubjectClasses luAbsenceReason luAbsenceType
vStudentAbsenceEventsFileSemesters		AbsenceEvents FileSemesters luAbsenceEventType luAbsenceType
vStudentAbsenceEventsUnexplained		AbsenceEvents tAttendances AttendanceMaster Community vCommunityAddresses vStudentContactLivesWith luAbsenceType
vStudentAbsences		Absences Community ConfigUsers Students StudentSemester luAbsenceReason luAbsencePeriod luAbsenceType luBoarder luYearLevel
vStudentAlerts		IndividualPlans vStudentsAll MedicalCondition luMedicalConditionType
vStudentAssesmentResultsAusVELS		Community FileSemesters StudentStatic StudentYears StudentAssessmentResultsVELS pvSubjectAssessmentVELS pvStudentAssessmentResultsVELS luYearLevel
vStudentAssessmentResultsAusVELSClasses		Community FileSemesters LearningAreas StudentStatic StudentYears SubjectAssessments SubjectAssessmentDomainSummarise StudentAssessmentResultsVELS StudentClasses pvSubjectAssessmentVELS pvSubjectClasses luYearLevel
vStudentAssessmentResultsCurriculum		Community Config CurriculumAllLevels FileSemesters StudentAssessmentResultsCurriculum StudentStatic StudentYears luYearLevel
vStudentAssessmentResultsCurriculumClasses		AssessmentCode Community Config CurriculumAllLevels FileSemesters LearningAreas StudentAssessmentResultsCurriculum StudentClasses StudentStatic StudentYears SubjectAssessments SubjectAssessmentDomainSummarise SubjectClasses luYearLevel
vStudentAssessmentResultsSummary		Config StudentAssessmentAreas StudentAssessmentComments StudentAssessmentResults StudentClasses SubjectClasses luReportResultGroup luReportResultType
vStudentAssessmentResultsVELS		Community FileSemesters StudentAssessmentResultsVELS SubjectAssessmentVELS StudentYears luYearLevel
vStudentAssessmentResultsVELSClasses		Community FileSemesters StudentAssessmentResultsVELS StudentClasses SubjectAssessmentVELS SubjectAssessments SubjectAssessmentDomainSummarise SubjectClasses StudentYears luYearLevel
vStudentBillingDetailsNZQA		Community FileSemesters StudentNCEAExternalStandards StudentNCEAInternalStandards StudentStatic StudentYears wkStudentBillingDetailsNZQA luStudentType
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 luPTIRequestStatus luStudentClassStatus luStudentStatus luYearLevel
vStudentClassesContacts		Addresses pvCommunity CommunityLegal ConfigUsers Staff StudentClasses StudentAssessmentResults StudentContacts Students StudentStatic StudentYears SubjectAssessmentAreas SubjectClasses SubjectClassStaff luBoarder luPTIRequestStatus luYearLevel
vStudentClassesContactsAll		Addresses pvCommunity CommunityLegal ConfigUsers Staff StudentClasses StudentAssessmentResults StudentContacts Students StudentStatic StudentYears SubjectAssessmentAreas SubjectClasses SubjectClassStaff luBoarder luPTIRequestStatus luYearLevel
vStudentClassesInColumns		Config StudentClasses StudentSemester SubjectClasses luFileType
vStudentClassesWithGaps		Sequence StudentClasses StudentSemester
vStudentCocurricularSubjectClass		Community FileSemesters MedicalCondition tMedicalIncidents RestrictedActivities Staff StudentClasses SubjectClasses SubjectClassStaff vStudentsAll luAgeGroup luFileType luLearningAreaPosition luMedicalConditionSeverity luMedicalConditionVisibility luSubejctClassCategory
vStudentContactAddress	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
vStudentContactAllAddress	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 luContact luCountry luForm luHouse luOccupation luStudentStatus luTutor luYearLevel
vStudentContactsAndRelations		Community Relationships StudentContacts Students StudentStatic StudentYears luBoarder luBoardingHouse luCampus luForm luHouse luStudentStatus luTutor luYearLevel
vStudentContactsCurrentFuturePastCombined		FutureStudentContacts PastStudentContacts PastStudents StudentContacts Students vCommunityAddresses vStudentCurrentPastFutureCombined luYearLevel
vStudentContactLivesWith		Community FutureStudentContacts FutureStudents PastStudentContacts PastStudents StudentContacts Students
vStudentContactsParentsDebtor	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
vStudentContactsRelationOnly	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
vStudentContactsSplitFamilies		Addresses Community CommunityLegal ConfigUsers StudentContacts Students StudentStatic StudentYears luYearLevel
vStudentCountByFamily		ConfigUsers StudentContacts StudentYears
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 luStudentCourseStatus luYearLevel
vStudentCurrentPastReportsSemesterResults		Community ConfigUsers LearningAreas PastStudentAssessmentComments PastStudentAssessmentResults PastStudentClasses PastStudentSemester PastStudentsOriginal Staff StudentAssessmentComments StudentAssessmentResults StudentClasses Students StudentSemester StudentStatic SubjectAssessmentAreas SubjectAssessments SubjectAssessmentTargets SubjectClassDefaultPrintFlags SubjectClasses SubjectClassStaff luBoarder luCampus luForm luHouse luReportResultClassification luReportResultGroup luReportResultType luReportResultTypeMaskExpanded luSubjectClassType luTutor luYearLevel
vStudentDataMCEETYA		Addresses Community StudentParents Students StudentYears luCampus luCountry luLanguage luOccupationPosition luQualificationLevel luYearLevel
vStudentDetailsPrimContact		Addresses Community CommunityLegal MedicalDetails StudentContactAddress Students StudentStatic luDisabilityLevel luMedicalPrivateInsuranceFund luPreviousSchool luRelationship luYearLevel
vStudentDisabilityAdjustment		Community DisabilityAdjustment StudentYears luDisabilityAdjustmentLevel luDisabilityCategory luYearLevel
vStudentEmailRecipients		Community Relationship StandardMergeList StudentContacts Students
vStudentExternalStudies		StudentLanguages StudentSchools vStudentsAll luLanguage luSchool
vStudentExternalTestResults		ExternalTest StudentExternalTestResults StudentExternalTests luExternalTestArea luExternalTestLevel luExternalTestResultGroup luExternalTestStandard luExternalTestType luReportResultType luReportResultTypeMaskExpanded
vStudentFamilySiblingCount		Addresses ConfigUsers pvCommunity StudentContacts Students StudentSemester StudentStatic StudentYears luBoarder luCampus luContact luCountry luForm luOccupation luParish luReligion luStudentStatus luYearLevel
vStudentFormsAbsences	Use this view to obtain a list of absent students by form.	luForm StudentSemester Absences Community ConfigUsers luAbsenceType luYearLevel
vStudentMedAlertAndClasses		Addresses Community CommunityLegal ConfigUsers FileSemesters LearningAreas Staff StudentClasses Students StudentStatic StudentYears SubjectAssessments SubjectClasses SubjectClassStaff luBoarder luCampus luForm luHouse luPTIRequestStatus luStudentClassStatus luStudentStatus luTutor luYearLevel
vStudentMedHealthcarePrimContact	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.	vStudentContactAddress Students Addresses Community CommunityLegal MedicalDetails StudentStatic luDisabilityLevel luImmunisationFormStatus luMedicalPrivateInsuranceFund luPreviousSchool luRelationship luYearLevel
vStudentMedicalAllergy	Use this view to list future, current and past students and their allergies.	StudentYears vMedicalAllergy
vStudentMedicalCondition	Use this view to list future, current and past students and their medical conditions.	StudentYears vMedicalCondition
vStudentMedicalConsent	Use this view to list future, current and past students and their medical consents.	StudentYears vMedicalConsent
vStudentMedicalHealthcare	Use this view to obtain: all student healthcare information information from current students and community functions. One record is output per student. Does not include medical incidents	Addresses Community CommunityLegal luBoarder luCampus luCountry luDisabilityLevel luForm luHouse luImmunisationFormStatus luLanguage luMedicalPrivateInsuranceFund luNationality luParish luPreviousSchool luRelationship luReligion luYearLevel MedicalDetails pvCommunity Students StudentStatic StudentYears
vStudentMedicalHealthcareAllContacts	Use this view to obtain student medical information as well as: contact information for all contacts their relationships to the student.	Addresses Community CommunityLegal luBoarder luCampus luCountry luDisabilityLevel luForm luHouse luLanguage luImmunisationFormStatus luMedicalPrivateInsuranceFund luNationality luParish luPreviousSchool luRelationship luReligion luYearLevel MedicalDetails pvCommunity Students StudentStatic StudentYears
vStudentMedicalImmunisation	Use this view to list future, current and past students and their immunisations.	StudentYears vMedicalImmunisation
vStudentMedicalIncidents	Use this view to list future, current and past students and their immunisations.	Addresses CommunityLegal ConfigUsers fnGetLoginName luBoarder luCampus luContact luCountry luForm luLanguage luOccupation luParish luReligion luStudentStatus luYearLevel pvCommunity StudentContacts Students StudentSemester StudentStatic vMedicalIncidents
vStudentMedicalMedication	Use this view to list future, current and past students and their medications.	StudentYears vMedicalMedication
vStudentMedicalSymptom	Use this view to list future, current and past students and their medical symptoms.	StudentYears vMedicalSymptom
vStudentNCEAInternalStandards		StudentClasses StudentYears SubjectAssessmentAreas SubjectAssessmentLinks SubjectAssessmentNCEAStandards SubjectAssessmentResults SubjectAssessments SubjectClasses SubjectClassesNCEAStandards luReportResultClassification luReportResultType luSubjectAssessmentContext luSubjectAssessmentProvider luYearLevelExternalLink
vStudentNCEAStandards		pvStudentNCEAExternalStandards pvStudentNCEAInternalStandards
vStudentParentsMCEETYA	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 vCommunityAddresses luLanguage luQualificationLevel luOccupationPosition Config
vStudentParentsSFO		vStudentParentsMCEETYA Students StudentYears luStudentStatus
vStudentParentsSFODetailed		FileSemesters pvStudentParents Students StudentYears vStudentDataMCEETYA luStudentStatus
vStudentPTInterviews		Community Staff StudentClasses SubjectClassStaff vPTInterviews vStudentsAll
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
vStudentReportsDataMissing		Community ConfigUsers Staff StudentAssessmentComments StudentAssessmentResults StudentClasses StudentSemester StudentYears SubjectAssessmentAreas SubjectAssessments SubjectClasses SubjectClassStaff luReportResultType luYearLevel
vStudentReportsNoResults	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 Staff StudentAssessmentComments StudentAssessmentResults StudentYears SubjectAssessments SubjectAssessmentAreas SubjectClasses SubjectClassStaff 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 StudentAssessmentResults Staff StudentClasses StudentStatic SubjectAssessmentAreas SubjectClasses SubjectClassStaff SubjectAssessments StudentAssessmentComments StudentYears luBoarder luBoardStudiesSubjects luBoardStudiesType luForm luHouse luReportResultClassification luTutor luYearLevel
vStudentReportsSemesterExtraAO		Community ConfigUsers LearningAreas StudentAssessmentComments StudentAssessmentResults StudentClasses StudentSemester Students StudentStatic SubjectAssessments SubjectAssessmentAreas SubjectClasses LearningAreas luForm luHouse luReportResultClassification luTutor luYearLevel
vStudentReportsSemesterResults	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 SubjectAssessmentAreas StudentAssessmentResults SubjectAssessments LearningAreas SubjectClassDefaultPrintFlags luReportResultType luReportResultTypeMaskExtended luReportResultGroup luReportResultClassification StudentAssessmentComments Students StudentSemester luCampus luForm luHouse luTutor luYearLevel luBoarder Community SubjectClassStaff Staff ConfigUsers SubjectAssessmentTargets StudentStatic luSubjectClassType
vStudentReportsSemesterResultsNCEA		SubjectAssessmentLinks SubjectAssessmentNCEAStandards vStudentReportsSemesterResults
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 StudentStatic 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
vStudentScholarships		Addresses Community ConfigUsers StudentContacts Students StudentScholarships StudentSemester StudentStatic luScholarship luScholarshipStatus luStudentStatus luYearLevel
vStudentScholarshipsAll		Community ConfigUsers Students StudentScholarships StudentStatic StudentYears luPreviousSchool luScholarship luScholarshipStatus luStudentStatus luYearLevel
vStudentCurrentPastFutureCombined		Community FileSemester FutureStudents PastStudents PastStudentsOriginal PastStudentYears Students StudentYears luCampus luFutureStatus luLeavingDestination luPreviousSchool luStudentStatus luYearLevel
vStudentSiblings		Community ConfigUsers FutureStudentContacts StudentContacts Students StudentYears vCommunityAddresses vFutureContactAddress vStudentContactAddress luFutureStatus luYearLevel
vStudentSiblings_crosstab		vStudentSiblings
vStudentSiblingsAtSchool		Addresses ConfigUsers pvCommunity Relationships StudentContacts StudentSemester Students StudentStatic luRelationship luYearLevel
vStudentSiblingsCurrent		Community StudentContacts Students StudentYears vCommunityAddresses vStudentContactAddress
vStudentSiblingsCurrent_crosstab		Community vStudentSiblingsCurrent
vStudentSiblingYoungest		Community ConfigUsers StudentContacts StudentSemester Students StudentStatic StudentYears luSubSchool luYearLevel
vStudentSiblingYoungestByCampus		Community ConfigUsers FileSemesters StudentContacts Students StudentStatic StudentYears luYearLevel
vStudentSiblingYoungestBySubSchool		Community ConfigUsers FileSemesters StudentContacts Students StudentStatic StudentYears luYearLevel
vStudentSMSRecipients		pvCommunity pvStandardMergeList Relationships StudentContacts Students
vStudentStatusErrors		Community Students StudentSemester luBoarder luCampus luStudentStatus luYearLevel
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
vStudentSubjectClassAll		Students StudentSemester StudentClasses Community SubjectClasses SubjectClassStaff Staff luBoarder StudentStatic ConfigUsers luYearLevel
vStudentTimetableClasses		Sequence Staff StudentClasses Timetable luTimetableGroup
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
vStudentTimetableFullAll		StudentSemester Students Community luYearLevel luTimetableGroup luHouse luCampus luForm StudentClasses Timetable Staff TimetableDefinition SubjectClasses ConfigUsers StudentStatic luBoarder SubjectClasses
vStudentTimetablePeriods		StudentSemester Students Community luYearLevel luTimetableGroup luHouse luCampus luForm StudentClasses Timetable Staff TimetableDefinition SubjectClasses ConfigUsers StudentStatic luBoarder SubjectClasses
vStudentTransport		Students StudentStatic StudentTransport StudentYears luBoarder luCampus luTransport luTransportStops luYearLevel
vStudentTutorsAbsences	Use this view to obtain a list of student absences by tutor.	luTutor StudentSemester Absences Community luAbsenceType luAbsencePeriod ConfigUsers luYearLevel
vStudentYearsAll		Community PastStudents PastStudentYears Students StudentYears luYearLevel
vSubjectAssessmentClassStaff		AssessmentCode Community ConfigUsers Staff SubjectAssessments SubjectClasses SubjectClassStaff
vSubjectAssessmentOverallSeq		SubjectAssessmentAreas SubjectAssessments
vSubjectClassesStaff		Community ConfigUsers Staff SubjectAssessments SubjectClasses SubjectClassStaff
vSubjectClassResultGroups		Community ConfigUsers Staff SubjectAssessments SubjectClasses SubjectClassStaff
vSubscribersObjectsOrdered		SubscribersObjects SubscribersObjectsRelation
vSystemAccessLog		AccessLog Community ConfigUsers vCommunityConstit WebItem
vSystemReportUsage		Community ConfigResources ConfigUsers MessageLog
vTagsOwn		Community Tags
vTasks		Community Tasks TaskTemplates
vTaskTemplates		Tasks TaskTemplates
vTimetableMaster		ConfigUsers FileType pvTimetableDefinition Staff Timetable
vTimetableRooms		FileSemesters Staff Timetable
vTimetableSubstitutes		Community pvSubjectClasses pvTimetableDefinition Staff TimetableSubstitutes
vWorkExperience		Addresses ConfigUsers PastStudents pvCommunity Students StudentYears WorkExperience luBoarder luOccupation

...

Versions Compared

Old Version 5

New Version 6

Key