Previous icon

Next icon

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

vAbsenceEventsHistory

Use this view to list a history of changes to absence events.

  • AbsenceEvents
    AttendancesHistory
  • AbsenceEvents
  • AbsenceEvents
    Deleted
  • tAttendances
  • AttendanceMaster
  • Community
  • ConfigUsers

vAwards

Use this field to view all current and past student award information.

  • StudentAwards
  • Community
  • Addresses
  • PastStudentAwards
  • FileSemesters
  • luAchievementType
  • luAward
  • luAwardClassification

vCommunicationsCurrent

Use this view to list current communications, with the name and address details of the recipients.

Automatically excludes deceased people.

  • Community
    Communications
    Current
  • Addresses
  • Communications
  • Community
  • luAddressRegion
  • luNotifyMethod

vCommunicationsPast

Use this view to list past communications, with the name and address details of the recipients.

Automatically excludes deceased people.

  • Community
    Communications
  • Communications
  • Community
  • Addresses
  • luAddressRegion
  • luNotifyMethod

vCommunityAddresses

Use this view to query on community members.

This view includes all fields from the Community and Addresses tables. It has spouse and occupation details as well.

  • Community
  • Addresses
  • luOccupation
  • luCountry

vCommunityAddresses
Constit

Use this view to query on community members and their constituencies.

This view includes all fields from the Community, Addresses and Constituency tables. Spouse and occupation details can be extracted as well. A community record will be duplicated for every constituency that they have. You would normally do a record selection on ConstitCode to only get one record per person.

  • Community
  • Constituencies
  • Addresses
  • luConstituency
  • luCountry
  • luOccupation

vCommunitySkills

Use this view to list community members and the skills they have.

  • Community
  • CommunitySkills
  • Addresses
  • Staff
  • luDepartment
  • luOccupation
  • luSkill
  • luSkillLevel

vDonors

Use this view to list donor information such as foundations, addresses and phone numbers.

  • Donors
  • Addresses
  • Community

vDonorPledges

Use this view to list donor pledges and the amount received against each pledge, with:

  • name and address details of the donor
  • appeal and fund details.
  • DonorPledges
  • Community
  • Addresses
  • luAppeal
  • luFund

vDonorPledgesReceipts

Use this view to list donor pledges and detailed receipt information for each pledge with:

  • name and address details of the donor
  • appeal and fund details.
  • DonorPledges
  • Community
  • Addresses
  • DonorReceipts
  • luAppeal
  • luFund

vDonorProspectAddress

Use this view for donor prospect name and address details, as well as:

  • fund and appeal information that they are prospected for
  • staff and volunteer name information, which comes from extra joins to the Community table.

Automatically excludes deceased prospects.

  • DonorProspects
  • Community
  • Addresses
  • luAppeal
  • luDonorProspect
    Inclination

vDonorProspectHistory
Address

Use this view for donor prospect history (activities) with:

  • prospect name and address details
  • appeal information that they are prospected for.

Automatically excludes deceased prospects.

  • DonorProspects
  • Community
  • Addresses
  • DonorProspect
    History
  • luAppeal
  • luDonorProspect
    ActivityStatus

vDonorReceipts

Use this view for detailed receipt information with:

  • name and address details of the donor
  • appeal and fund information.
  • DonorReceipts
  • Community
  • Addresses
  • luAppeal
  • luFund

vEnquiryContactAddress

Use this view to list:

  • enquiry contacts
  • their name and address details
  • the students that they are associated with.

If the person is a member of the community, the information comes from the actual Community table, otherwise it comes off the enquiry tables.

Automatically excludes deceased people.

  • EnquiryStudent
    Contacts
  • EnquiryStudents
  • Community
  • Addresses
  • luBoarder
  • luCampus
  • luEnquirySource
  • luHouse
  • luSubSchool
  • luYearLevel
  • luYearLevelGroup

vEnquiryFutureStudents

Use this view to list future student and enquiry information such as:

  • personal information
  • campus
  • year level
  • form
  • house.
  • EnquiryStudents
  • Community
  • FutureStudents
  • luCampus
  • luEnquirySource
  • luForm
  • luFuturePriority
  • luHouse
  • luPreviousSchool
  • luTutor
  • luYearLevel

vEvents

Use this view for information on events and their locations, without any attendee details.

  • Events
  • luLocation

vEventsCurrent

Use this view for information on current events and their locations, with attendee name and address details.

Automatically excludes deceased attendees.

  • CommunityEvents
    Current
  • Addresses
  • Community
  • Events
  • luLocation

vEventsPast

Use this view for information on past events and their locations, with attendee name and address details.

  • CommunityEvents
  • Addresses
  • Community
  • Events
  • luLocation

vFutureContactAddress

Use this view for future student names and entry information, along with:

  • contact name and address details for each of the student's contacts
  • spouse information for each contact.

Automatically excludes:

  • deceased future students and contacts
  • term contacts (contact type = SCT).
  • FutureStudents
  • Addresses
  • Community
  • CommunityLegal
  • FutureStudent
    Contacts
  • Relationships
  • luBoarder
  • luCampus
  • luContact
  • luCountry
  • luFutureStatus
  • luIndustry
  • luOccupation
  • luOccupationPosition
  • luRelationship
  • luYearLevel

vFutureContactsRelationOnly

Use this view to obtain:

  • future student names
  • address and occupation information for each relation
  • their relationship with the future student.

Automatically excludes term contacts (Type = SCT).

  • FutureStudents
  • FutureStudent
    Contacts
  • Addresses
  • ConfigUsers
  • Community
  • CommunityLegal
  • Relationships
  • StudentStatic
  • luContact
  • luCountry
  • luLanguage
  • luNationality
  • luOccupation
  • luParish
  • luRelationship
  • luReligion

vFutureMedical
HealthcarePrimContact

Use this view to obtain future student medical information as well as:

  • primary contact (SC1 contact) information for emergency contacts
  • their relationship to the future student.

Retrieves information as detailed in the vFutureContactAddress view, covered earlier.

  • vFutureContact
    Address
  • FutureStudents
  • FutureStudent
    MedicalDetails
  • Addresses
  • Community
  • CommunityLegal
  • StudentStatic
  • luAsthmaCategory
  • luCountry
  • luHouse
  • luImmunisationForm
    Status
  • luLanguage
  • luMedicalPrivate
    InsuranceFund
  • 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
  • Community
  • CommunityLegal
  • StudentStatic
  • luBoarder
  • luFuturePriority
  • luFutureStatus
  • luHouse
  • luParish
  • luPreviousSchool
  • luRelationship
  • luReligion
  • luYearLevel

vFutureStudentsAll

Use this view for future student names and entry information, if you do not want any contact or relationship information.

Includes cancelled future students, automatically excludes deceased future students.

  • FutureStudents
  • Community
  • CommunityLegal
  • StudentStatic
  • luBoarder
  • luFuturePriority
  • luFutureStatus
  • luHouse
  • luParish
  • luPreviousSchool
  • luRelationship
  • luReligion
  • luYearLevel

vFutureStudentAbility

Use this view to list future students and their abilities.

  • FutureStudents
  • vAbility

vFutureStudent
MedicalAllergy

Use this view to list future students and their allergies.

  • vFutureStudent
  • MedicalAllergies

vFutureStudent
MedicalCondition

Use this view to list future students and their medical conditions.

  • FutureStudents
  • vMedicalCondition

vFutureStudent
MedicalConsent

Use this view to list future students and their medical consents.

  • FutureStudents
  • vMedicalConsent

vFutureStudent
MedicalHealthcare

Use this view to obtain future student medical information.

  • Addresses
  • Community
  • CommunityLegal
  • FutureStudent
    Contacts
  • FutureStudents
  • luDisabilityLevel
  • luMedicalPrivate
    InsuranceFund
  • luYearLevel
  • MedicalDetails
  • StudentStatic

vFutureStudent
MedicalImmunisation

Use this view to list future students and their immunisations.

  • FutureStudents
  • vMedical
    Immunisation

vFutureStudentMedical
Medication

Use this view to list future students and their medications.

  • FutureStudents
  • vMedicalMedication

vFutureStudent
MedicalSymptom

Use this view to list future students and their medical symptoms.

  • vFutureStudent
  • MedicalSymptom

vMedicalAllergy

Use this view to list community members and their allergies.

  • vMedicalAllergyAll

vMedicalCondition

Use this view to list community members and their medical conditions.

  • vMedicalConditionAll

vMedicalConsent

Use this view to list community members and their medical consents.

  • Community
  • Consent
  • luConsentType

vMedicalImmunisation

Use this view to list community members and their immunisations.

  • Community
  • luMedical
    ImmunisationType
  • luMedicalVaccine
    Brand
  • MedicalImmunisation

vMedicalIncidentsAll

Use this view to list community members and their medical incidents.

  • Community
  • luMedicalIncident
    Type
  • PastStudents
  • Staff
  • Students
  • StudentYears
  • vMedicalIncidents

vMedicalSymptomAll

Use this view to list community members and their medical symptoms.

  • Community
  • luMedicalSymptomType
  • MedicalSymptom

vMedicalSymptom

Use this view to list community members and their medical symptoms for active records only.

  • vMedicalSymptomAll

vMedicalMedication

Use this view to list community members and their medications.

  • MedicalCondition
    Medication
  • vMedicalCondition
  • vMedicalMedication
    All

vNZMoE_eAR_School
Details

Use this view for the school number and name based on campus, using the configuration for the New Zealand Ministry of Education (NZMoE) electronic attendance register (eAR).

If the configuration details are not available, the following details are retrieved:

  • The school name from the configuration file maintenance using the System | Install | Name key.
  • The school number from the School table.
  • Config
  • School
  • luCampus

vNZMoE_StudentData
Changes

Use this view for data changes by student and year level.

This is required for New Zealand Ministry of Education (NZMoE) electronic attendance register (eAR) audit requirements.

  • SystemDataChanges
  • Community
  • FileSemesters
  • StudentYears

vPastStudentAddress

Use this view for past student names and their:

  • address
  • schooling information
  • occupation information.
  • PastStudents
  • Community
  • CommunityLegal
  • Addresses
  • luBoarder
  • luBranch
  • luCampus
  • luHouse
  • luLeavingDestination
  • luOccupation
  • luYearLevel

vStaff

Use this view for personal staff details. This view contains detailed name and address information.

Automatically excludes deceased staff members.

  • Staff
  • Addresses
  • Community
  • luCampus
  • luStaffCategory
  • luWorkWithChildren
    CheckStatus
  • luYearLevel

vStaffAbility

Use this view to list staff members and their abilities.

  • Staff
  • vAbility

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

vStaffMedicalConsents

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

vStaffMedical
Immunisation

Use this view to list staff members and their immunisations.

  • Staff
  • vMedical
    Immunisation

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

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

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
  • StudentYears
  • Students
  • luAbsenceEventType
  • luAbsenceReason
  • luAbsenceType
  • luAbsencePeriod
  • luBoarder
  • luCampus
  • luForm
  • luHouse
  • luStudentStatus
  • luTutor
  • luYearLevel

vStudentAbsenceEvents
Attendances

Use this view for attendance information.

Includes attendances and nonattendances.

This view is based on vStudentAbsenceEvents.

  • vStudentAbsence
    Events
  • tAttendances
  • Community
  • luAbsenceType
  • luAbsenceReason
  • AttendanceMaster
  • SubjectClasses
  • pvTimetableDefinition

vStudentClasses

Use this view to list students and the classes they are taking. Also includes:

  • relevant information about the staff member who teaches the classes
  • information about house captains and Head of Campus.

Automatically excludes students who:

  • have left the class or school prior to the current date
  • are on leave of absence
  • are deceased.

    Note: This view is based on vStudentClassesAll where the class stop date is blank or set to a future date.

  • Students
  • StudentClasses
  • StudentSemester
  • StudentYears
  • SubjectClasses
  • Addresses
  • Community
  • CommunityLegal
  • ConfigUsers
  • FileSemesters
  • LearningAreas
  • StudentStatic
  • SubjectAssessments
  • SubjectClassStaff
  • Staff
  • luBoarder
  • luHouse
  • luCampus
  • luStudentClassStatus
  • luStudentStatus
  • luYearLevel

vStudentClassesAll

Use this view to list students and the classes they are taking. Also includes:

  • relevant information about the staff member who teaches the classes
  • information about house captains and Head of Campus.

Automatically excludes students who:

  • are deceased
  • have left your organisation
  • are on a leave of absence.
  • Students
  • StudentClasses
  • StudentYears
  • SubjectClasses
  • Addresses
  • Community
  • CommunityLegal
  • ConfigUsers
  • FileSemesters
  • LearningAreas
  • Staff
  • StudentStatic
  • SubjectAssessments
  • SubjectClassStaff
  • luBoarder
  • luCampus
  • luHouse
  • luStudentClassStatus
  • luStudentStatus
  • luYearLevel

vStudentContact
Address

Use this view for student names and schooling information, along with:

  • contact name and address details for primary and alternative contacts
  • spouse information for each contact.

Automatically excludes:

  • term contacts (SCT)
  • deceased students
  • deceased contacts.
  • Students
  • Addresses
  • Community
  • CommunityLegal
  • ConfigUsers
  • Relationships
  • StudentContacts
  • StudentSemester
  • StudentStatic
  • luBoarder
  • luCampus
  • luContact
  • luCountry
  • luForm
  • luHouse
  • luLanguage
  • luNationality
  • luOccupation
  • luOccupationPosition
  • luParish
  • luRelationship
  • luReligion
  • luStudentStatus
  • luYearLevel

vStudentContact
AllAddress

Use this view for student names and schooling information, along with contact name and address details for all contacts, including term contacts.

Automatically excludes deceased:

  • students
  • contacts.
  • Students
  • Addresses
  • Community
  • CommunityLegal
  • ConfigUsers
  • Relationships
  • StudentContacts
  • StudentSemester
  • StudentStatic
  • luCampus
  • luContact
  • luCountry
  • luForm
  • luStudentStatus
  • luYearLevel

vStudentContacts
ParentsDebtor

Use this view to obtain student names and schooling details, along with name and address details for the student's:

  • debtor
  • mother
  • father.

Excludes students who:

  • have left your organisation
  • are deceased.
  • Students
  • Addresses
  • Community
  • CommunityLegal
  • ConfigUsers
  • Relationships
  • StudentContacts
  • StudentSemester
  • StudentStatic
  • luBoarder
  • luCampus
  • luContact
  • luForm
  • luIndustry
  • luOccupation
  • luOccupationPosition
  • luPreviousSchool
  • luRelationship
  • luStudentStatus
  • luYearLevel

vStudentContacts
RelationOnly

Use this view to obtain:

  • student names
  • address and occupation information for each relation
  • their relationship with the student.

Automatically excludes term contacts (SCT).

  • Students
  • StudentContacts
  • Addresses
  • Community
  • CommunityLegal
  • ConfigUsers
  • FileSemesters
  • Relationships
  • StudentStatic
  • StudentYears
  • luCampus
  • luContact
  • luCountry
  • luForm
  • luLanguage
  • luNationality
  • luOccupation
  • luParish
  • luRelationship
  • luReligion

vStudentCourses

Use this view to obtain information on courses that a student is doing. Includes basic name information.

  • Students
  • StudentCourses
  • Courses
  • Community
  • StudentYears
  • luBoarder
  • luCampus
  • luStudentCourse
    Status
  • luYearLevel

vStudentForms
Absences

Use this view to obtain a list of absent students by form.

  • luForm
  • StudentSemester
  • Absences
  • Community
  • ConfigUsers
  • luAbsenceType
  • luYearLevel

vStudentMedical
Allergy

Use this view to list future, current and past students and their allergies.

  • StudentYears
  • vMedicalAllergy

vStudentMedical
Condition

Use this view to list future, current and past students and their medical conditions.

  • StudentYears
  • vMedicalCondition

vStudentMedical
Consent

Use this view to list future, current and past students and their medical consents.

  • StudentYears
  • vMedicalConsent

vStudentMedical
Healthcare

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
  • luImmunisationForm
    Status
  • luLanguage
  • luMedicalPrivate
    InsuranceFund
  • luNationality
  • luParish
  • luPreviousSchool
  • luRelationship
  • luReligion
  • luYearLevel
  • MedicalDetails
  • pvCommunity
  • Students
  • StudentStatic
  • StudentYears

vStudentMedical
HealthcareAllContacts

Use this view to obtain student medical information as well as:

  • contact information for all contacts
  • their relationships to the student.
  • Community
  • CommunityLegal
  • luImmunisationForm
    Status
  • luMedicalPrivate
    InsuranceFund
  • luPreviousSchool
  • luRelationship
  • luYearLevel
  • MedicalDetails
  • pvCommunity
  • Students
  • StudentStatic
  • vStudentContact
    Address

vStudentMedical
HealthcarePrimContact

Use this view to obtain student medical information as well as:

  • primary contact information for emergency contacts
  • their relationship to the student.

Retrieves information as detailed in the vStudentContactAddress view, covered earlier.

  • vStudentContact
    Address
  • Students
  • StudentMedical
    Details
  • Addresses
  • Community
  • CommunityLegal
  • StudentStatic
  • luAsthmaCategory
  • luImmunisationForm
    Status
  • luMedicalPrivate
    InsuranceFund
  • luPreviousSchool
  • luRelationship

vStudentMedical
Immunisation

Use this view to list future, current and past students and their immunisations.

  • StudentYears
  • vMedical
    Immunisation

vStudentMedical
Incidents

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

vStudentMedical
Medication

Use this view to list future, current and past students and their medications.

  • StudentYears
  • vMedicalMedication

vStudentMedical
Symptom

Use this view to list future, current and past students and their medical symptoms.

  • StudentYears
  • vMedicalSymptom

vStudentParents
MCEETYA

Use this view to extract MCEECDYA (Australian Ministerial Council of Education, Early Childhood Development and Youth Affairs) parent details, including:

  • Occupation Group
  • Home Language
  • Highest Qualification Level
  • Highest Secondary Level.
  • pvStudentParents
  • vCommunity
    Addresses
  • luLanguage
  • luQualification
    Level
  • luOccupation
    Position
  • Config

vStudentRelations

Use this view to show students and all of their relations.

Excludes students who are deceased.

Also, see vStudentRelationsAll.

  • Students
  • StudentSemester
  • Relationships
  • pvCommunity
  • Addresses
  • luOccupation
  • luRelationship
  • luStudentStatus
  • luCampus
  • luForm
  • luBoarder
  • luYearLevel
  • CommunityLegal
  • StudentStatic

vStudentRelationsAll

Use this view to show students and all of their relations.

Includes all records, including deceased students.

Also see vStudentRelations.

  • Students
  • StudentSemester
  • Relationships
  • pvCommunity
  • Addresses
  • luOccupation
  • luRelationship
  • luStudentStatus
  • luCampus
  • luForm
  • luBoarder
  • luYearLevel
  • CommunityLegal
  • StudentStatic

vStudentReportsNo
Results

Use this view to show which:

  • students have not had results entered for them
  • which staff members are responsible for entering the results.
  • StudentClasses
  • StudentSemester
  • Community
  • ConfigUsers
  • LearningAreas
  • Staff
  • StudentAssessment
    Comments
  • StudentAssessment
    Results
  • Students
  • StudentStatic
  • StudentYears
  • SubjectAssessments
  • SubjectAssessment
    Areas
  • SubjectClass
    DefaultPrintFlags
  • SubjectClasses
  • SubjectClassStaff
  • luReportResultType
  • luYearLevel

vStudentReportsSemester

Use this view to obtain the overall results of students, comments and staff information.

This view does not contain detailed results. To get detailed results, refer to vStudentReportsSemesterResults, covered below.

  • StudentSemester
  • Students
  • Community
  • ConfigUsers
  • LearningAreas
  • StudentAssessment
    Results
  • Staff
  • StudentClasses
  • StudentStatic
  • SubjectAssessment
    Areas
  • SubjectClasses
  • SubjectClassStaff
  • SubjectAssessments
  • StudentAssessment
    Comments
  • StudentYears
  • luBoarder
  • luBoardStudies
    Subjects
  • luBoardStudiesType
  • luForm
  • luHouse
  • luReportResult
    Classification
  • luTutor
  • luYearLevel

vStudentReportsSemester
Results

Use this view to obtain detailed student results.

It does not include overall results or comments. To get overall results and comments, refer to the vStudentReportsSemester view, covered earlier.

  • StudentClasses
  • SubjectClasses
  • SubjectAssessment
    Areas
  • StudentAssessment
    Results
  • SubjectAssessments
  • LearningAreas
  • SubjectClassDefault
    PrintFlags
  • luReportResultType
  • luReportResultType
    MaskExtended
  • luReportResultGroup
  • luReportResult
    Classification
  • StudentAssessment
    Comments
  • Students
  • StudentSemester
  • luCampus
  • luForm
  • luHouse
  • luYearLevel
  • luBoarder
  • Community
  • SubjectClassStaff
  • Staff
  • ConfigUsers
  • SubjectAssessment
    Targets
  • StudentStatic
  • luSubjectClassType

vStudents

Use this view for student schooling and name details. The view does not include:

  • contact details
  • relationship information.

Automatically excludes deceased students and students with a status that has a SynergyMeaning of:

  • LEFT - have left your organisation
  • LOA - are on leave of absence.

The view was designed for fast, simple queries. Also, see:

  • vStudentsAll
  • vStudentAndLOA, covered below.
  • Students
  • StudentSemester
  • Community
  • CommunityLegal
  • Config
  • ConfigUsers
  • FileSemesters
  • luStudentStatus
  • luCampus
  • luHouse
  • luYearLevel
  • luForm
  • luTutor
  • luBoarder
  • luParish
  • luReligion
  • luPreviousSchool
  • luCountry
  • luLanguage
  • luLeavingDestination
  • luNationality
  • luRelationship

vStudentsAll

Use this view for student schooling and name details. This view:

  • contains the same information as vStudents
  • includes all students, regardless of their status.

This view was created for more detailed queries but runs slower than the vStudents view.

  • Students
  • StudentSemester
  • Community
  • CommunityLegal
  • Config
  • ConfigUsers
  • FileSemesters
  • luStudentStatus
  • luCampus
  • luHouse
  • luYearLevel
  • luForm
  • luTutor
  • luBoarder
  • luParish
  • luReligion
  • luPreviousSchool
  • luCountry
  • luLanguage
  • luLeavingDestination
  • luNationality
  • luRelationship

vStudentsAndLOA

Use this view for student schooling and name details. This view:

  • does not include contact or relationship information
  • includes a lot more information than the vStudents view, covered earlier
  • includes all current students and those on leave of absence but excludes students who have left your organisation.

This view was created for more detailed queries but runs slower than the vStudents view.

Also, see the vStudentAll view, covered earlier.

  • Students
  • StudentSemester
  • Community
  • CommunityLegal
  • Config
  • ConfigUsers
  • FileSemesters
  • luStudentStatus
  • luCampus
  • luHouse
  • luYearLevel
  • luForm
  • luTutor
  • luBoarder
  • luParish
  • luReligion
  • luPreviousSchool
  • luCountry
  • luLanguage
  • luLeavingDestination
  • luNationality
  • luRelationship

vStudentSubjectClass

Use this view to obtain a list of classes that a student is doing, along with the staff member who is teaching that class.

Automatically excludes:

  • deceased students
  • classes with a stop date prior to today's date.
  • Students
  • StudentSemester
  • StudentClasses
  • Community
  • SubjectClasses
  • SubjectClassStaff
  • Staff
  • luBoarder
  • StudentStatic
  • ConfigUsers
  • luYearLevel

vStudentTimetableFull

Use this view to obtain timetable details for students, including:

  • rooms
  • days
  • periods
  • the staff members teaching the classes.

Automatically excludes:

  • deceased students
  • classes with a stop date prior to today's date.
  • StudentSemester
  • Students
  • Community
  • luYearLevel
  • luTimetableGroup
  • luHouse
  • luCampus
  • luForm
  • StudentClasses
  • Timetable
  • Staff
  • TimetableDefinition
  • luBoarder
  • SubjectClasses
  • ConfigUsers
  • StudentStatic
  • luBoarder
  • SubjectClasses
  • ConfigUsers
  • TimetableDefinition

vStudentTutorsAbsences

Use this view to obtain a list of student absences by tutor.

  • luTutor
  • StudentSemester
  • Absences
  • Community
  • luAbsenceType
  • luAbsencePeriod
  • ConfigUsers
  • luYearLevel

non printable note at the end of a topic, with a tableLast modified: 28/04/2017 11:26:40 AM

See Also

Synergetic views

Main Finance views

© 2017 Synergetic Management Systems. Published 20 July 2017.

Top of page