pvvStudents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
StudentNameInternal varchar 100 null
StudentNameExternal varchar 100 null
StudentLegalFullName varchar 150 null
StudentSurname varchar 30 null
StudentTitle varchar 30 null
StudentInitials varchar 15 null
StudentSuffix varchar 20 null
StudentPreferred varchar 20 null
StudentPreferredFormal varchar 20 null
StudentGiven1 varchar 20 null
StudentGiven2 varchar 50 null
StudentOccupEmail varchar 100 null
StudentBirthDate datetime 16,3 √ null
StudentGender varchar 15 null
StudentMobilePhone varchar 15 null
StudentDefaultMobilePhone varchar 15 null
StudentOccupMobilePhone varchar 15 null
StudentEmail varchar 100 null
StudentEducation varchar 255 null
StudentQualifications varchar 255 null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
StudentActiveFlag bit 1 √ null
StudentStatus varchar 3 √ null
StudentStatusDescription varchar 30 √ null
StudentStatusSynergyMeaning varchar 30 √ null
StudentStatusNextYear varchar 3 √ null
StudentCampus varchar 3 √ null
StudentCampusDescription varchar 30 √ null
StudentCampusSort int 4 √ null
StudentCampusRSBNumber varchar 30 √ null
StudentYearLevel smallint 2 √ null
SchoolingYearOffset smallint 2 √ null
FundingYearLevel int 4 √ null
StudentTypeCode varchar 15 √ null
SecondaryTertiaryProgramme varchar 15 √ null
StudentOverrideNextYearLevel smallint 2 √ null
StudentOverrideNextStudentCampus varchar 3 √ null
StudentOverrideNextBoarder varchar 3 √ null
StudentYearLevelSort smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
StudentYearLevelCoordinator varchar 30 √ null
StudentYearLevelTimeTableGroup varchar 5 √ null
StudentYearLevelIncludeInCensusFlag bit 1 √ null
StudentHouse varchar 5 √ null
StudentHouseDescription varchar 30 √ null
StudentHeadOfHouse varchar 100 √ null
StudentHouseCaptain varchar 100 √ null
StudentForm varchar 15 √ null
StudentFormDescription varchar 30 √ null
StudentFormHomeRoom varchar 15 √ null
StudentFormStaffName varchar 100 √ null
StudentTutor varchar 15 √ null
StudentTutorDescription varchar 30 √ null
StudentTutorHomeRoom varchar 15 √ null
StudentTutorName varchar 100 √ null
StudentBoarder varchar 3 √ null
StudentBoarderSynergyMeaning varchar 30 √ null
StudentBoarderType varchar 30 √ null
StudentBoardingHouse varchar 15 √ null
StudentLockerBook varchar 15 √ null
StudentLockerOther varchar 15 √ null
StudentStudiesCode varchar 15 null
StudentGovernmentStudentNumber varchar 15 √ null
StudentEarlyLearningCode varchar 15 √ null
VocationalEducationCode varchar 15 √ null
StudentTertiaryCode varchar 15 null
StudentTimeTableCode varchar 15 null
StudentEntryDate datetime 16,3 √ null
StudentEntryCampus varchar 3 null
StudentEntryYearLevel smallint 2 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
StudentLeavingDestination varchar 15 √ null
StudentReturningDate datetime 16,3 √ null
StudentEnquirySource varchar 10 null
StudentEnquirySourceComment varchar 50 null
StudentPreviousSchool varchar 15 null
StudentTuitionVariationType varchar 3 null
StudentDoctorName varchar 80 null
StudentDoctorPhone varchar 15 null
StudentDoctorPhoneAlt varchar 15 null
StudentDoctorAddress varchar 200 null
StudentDoctorSpecialisation varchar 50 null
StudentDoctor2Name varchar 80 null
StudentDoctor2Phone varchar 15 null
StudentDoctor2PhoneAlt varchar 15 null
StudentDoctor2Address varchar 200 null
StudentDoctor2Specialisation varchar 50 null
StudentDentistName varchar 80 null
StudentDentistPhone varchar 15 null
StudentDentistPhoneAlt varchar 15 null
StudentDentistAddress varchar 200 null
StudentEmergencyName varchar 80 null
StudentEmergencyAddress varchar 200 null
StudentEmergencyPhone varchar 15 null
StudentEmergencyPhoneAlt varchar 15 null
StudentEmergencyRelat varchar 5 √ null
StudentEmergency2Name varchar 80 null
StudentEmergency2Address varchar 200 null
StudentEmergency2Phone varchar 15 null
StudentEmergency2PhoneAlt varchar 15 null
StudentEmergency2Relat varchar 5 √ null
StudentEmergency3Name varchar 80 null
StudentEmergency3Address varchar 200 null
StudentEmergency3Phone varchar 15 null
StudentEmergency3PhoneAlt varchar 15 null
StudentEmergency3Relat varchar 5 null
StudentLastLessonRcvdDate datetime 16,3 √ null
StudentsVisaType varchar 5 null
StudentVisaIssuedDate datetime 16,3 √ null
StudentsVisaExpiryDate datetime 16,3 √ null
StudentVisaNumber varchar 20 null
StudentPassportCountryCode varchar 5 null
StudentPassportIssuedDate datetime 16,3 √ null
StudentPassportExpiryDate datetime 16,3 √ null
StudentsPassportNo varchar 15 null
StudentsComment varchar 2147483647 √ null
ExternalStudentFlag bit 1 null
EnglishSecondFlag bit 1 null
DisabilityFlag bit 1 null
IntegrationFlag bit 1 √ null
FullFeeFlag bit 1 null
EMAFlag bit 1 √ null
IntendsTertiaryFlag bit 1 null
CurrentSemesterOnlyFlag int 4 null
StudentFamilyPosition smallint 2 √ null
StudentParishCode varchar 5 √ null
StudentParishDescription varchar 50 √ null
StudentReligionCode varchar 5 √ null
StudentReligionDescription varchar 40 √ null
StudentPreviousSchoolCode varchar 15 null
StudentPreviousSchoolDescription varchar 100 √ null
StudentPreviousSchoolRSBNumber varchar 30 √ null
StudentPreviousSchoolSuburb varchar 40 √ null
IndigenousFlag bit 1 null
StudentIBFlag bit 1 √ null
StudentApplicationDate datetime 16,3 √ null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentStudyAtHomeFlag bit 1 null
StudentTSIFlag bit 1 null
StudentESLProficiencyLevel varchar 15 null
StudentESLListeningLevelCode varchar 15 √ null
StudentESLSpeakingLevelCode varchar 15 √ null
StudentESLReadingLevelCode varchar 15 √ null
StudentESLWritingLevelCode varchar 15 √ null
LegalParentsSeparatedFlag bit 1 √ null
LegalParentsSeparatedReason varchar 200 √ null
LegalCourtOrderType varchar 15 √ null
LegalCourtOrderDate datetime 16,3 √ null
LegalCourtOrderDetails varchar 2147483647 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
LegalPrivacyPolicyAgreedFlag bit 1 √ null
StudentBarcode varchar 20 null
StudentMedicalAlert varchar 2000 √ null
StudentSchoolFTE decimal 7,2 √ null
StudentInitialSchoolingYear int 4 √ null
StudentInitialSchoolingDate datetime 16,3 √ null
StudentNonResidentFlag bit 1 null
DirectoryIncludeFlag bit 1 null
DirectoryProvideFlag bit 1 null
AddressID int 4 null
StudentBirthCertificateOnFileFlag bit 1 null
StudentCountryOfBirthCode varchar 5 √ null
StudentCountryOfBirthCodeRaw varchar 5 null
StudentCountryOfBirthDescription varchar 40 √ null
StudentHomeLanguageCode varchar 5 null
StudentHomeLanguageDescription varchar 100 √ null
ActualSemester smallint 2 null
StudentAltCode varchar 15 null
ImportantCommentsFlag bit 1 null
StudentLeavingDestinationDesc varchar 100 √ null
ID int 4 null
DebtorID int 4 null
MCEETYAFormReceivedDate datetime 16,3 √ null
StudentNationalityCode varchar 5 null
StudentNationalityDescription varchar 30 √ null
StudentNationality2Code varchar 5 null
StudentNationality2Description varchar 30 √ null
StudentIntendedTertiaryCourseCode varchar 15 √ null
StudentSubSchool varchar 15 √ null
AustudyFlag bit 1 null
StudentEmergencyRelatDesc varchar 30 √ null
StudentEmergency2RelatDesc varchar 30 √ null
StudentEmergency3RelatDesc varchar 30 √ null
StudentNetworkLogin varchar 100 null
AllowAutoTuitionFlag bit 1 null
SpecialBillingType varchar 5 null
TuitionNoSibFlag bit 1 null
LearningPathway varchar 30 √ null
GenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views