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 |
| |
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 |
| |
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 |
| |
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 |
| |
vCommunityConfirmationStatus |
| - refMyDetailsConfirmationFlagName
- Community
- MyDetailsConfirmation
- Students
- FutureStudents
|
vCommunityConstit |
| |
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 |
| |
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. | |
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. | |
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 |
| |
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 |
| - 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 |
| |
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 |
| - 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 |
| |
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 | 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 |
| |
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.
| |
vNZMoE_eAR_StudentAttendanceFirstLast |
| - tAttendances
- AttendanceMaster
|
vNZMoE_Ethnicity |
| |
vNZMoE_Footer |
| |
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 |
| |
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 |
| - 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 |
| |
vPotentiality |
| - Addresses
- Community
- PastStudents
- luCountry
- luIndustry
- luNationality
- luOccupation
- luOccupationPosition
|
vPTInterviews |
|
|
vReceiptsOnline |
| - OnlinePaymentMerchants
- ReceiptsOnline
- SynDatabases
- vCommunityAddresses
|
vReceiptsFooter |
| |
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. | |
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. | |
vStaffMedicalCondition | Use this view to list staff members and their medical conditions. | |
vStaffMedicalConsent | Use this view to list staff members and their medical consents. | |
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. | |
vStaffMedicalSymptom | Use this view to list staff members and their medical symptoms. | |
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. | |
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
- 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: 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, formerly MCEETYA) 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 |
| |
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 |
| |
vTasks |
| - Community
- Tasks
- TaskTemplates
|
vTaskTemplates |
| |
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
|