Main Synergetic views

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


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
vAddressesBadUsed 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
vEventsCurrentAndPastUsed 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
vFutureStudentPastSiblingsAtSchoolUsed 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
vFutureStudentSiblingsAtSchoolUsed to list future students and their current student siblings.
  • Addresses
  • CommunityLegal
  • FutureStudents
  • FutureStudentContacts
  • pvCommunity
  • Relationships
  • StudentContacts
  • luBoarder
  • luContact
  • luFutureStatus
  • luOccupation
  • luRelationship
  • luYearLevel
vFutureStudentTransportUsed 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
vIndividualPlansUsed 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
vMedicalMedicationUse 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
vMedicalSymptomAllUse 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, 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
  • 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