vStudentContactAllAddress


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
ID int 4 null
StudentName varchar 51 √ null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentSurname varchar 30 √ null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
StudentGiven1 varchar 20 √ null
StudentGiven2 varchar 50 √ null
StudentGender varchar 15 √ null
StudentBirthDate datetime 16,3 √ null
StudentBarcode varchar 20 √ null
StudentStudiesCode varchar 15 null
StudentGovernmentStudentNumber varchar 15 √ null
StudentTimetableCode varchar 15 null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
StudentLeavingDestination varchar 15 √ null
StudentReturningDate datetime 16,3 √ null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
StudentFamilyPosition smallint 2 √ null
StudentStatus varchar 3 √ null
StudentStatusNextYear varchar 3 √ null
StudentCampus varchar 3 √ null
StudentYearLevel smallint 2 √ null
StudentOverrideNextYearLevel smallint 2 √ null
StudentOverrideNextStudentCampus varchar 3 √ null
StudentOverrideNextBoarder varchar 3 √ null
StudentYearLevelSort smallint 2 √ null
StudentHouse varchar 5 √ null
StudentHouseDescription varchar 30 null
StudentHouseHeadOfHouse varchar 100 null
StudentHouseCaptain varchar 100 null
StudentForm varchar 15 √ null
StudentFormDescription varchar 30 null
StudentFormStaffName varchar 100 null
StudentTutor varchar 15 √ null
StudentTutorDescription varchar 30 null
StudentTutorName varchar 100 null
StudentBoarder varchar 3 √ null
StudentBoardingHouse varchar 15 √ null
CurrentSemesterOnlyFlag int 4 null
StudentStatusDescription varchar 30 √ null
StudentStatusNextYearDesc varchar 30 √ null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentStudyAtHomeFlag bit 1 null
StudentTSIFlag bit 1 null
StudentIndigenousFlag bit 1 null
StudentIntendsTertiaryFlag bit 1 null
StudentContactDescription varchar 30 √ null
StudentContactType varchar 3 √ null
StudentContactLivesWithFlag bit 1 √ null
StudentContactPrimaryOnlyFlag bit 1 √ null
StudentContactNormalMailFlag bit 1 √ null
StudentContactReportsFlag bit 1 √ null
StudentContactParentFlag bit 1 √ null
StudentContactID int 4 √ null
StudentContactMailName varchar 100 √ null
StudentContactMailSalutation varchar 100 √ null
StudentContactTitle varchar 30 √ null
StudentContactNameInternal varchar 100 √ null
StudentContactNameExternal varchar 100 √ null
StudentContactLegalFullName varchar 150 √ null
StudentContactSurname varchar 30 √ null
StudentContactPreferred varchar 20 √ null
StudentContactPreferredFormal varchar 20 √ null
StudentContactGiven1 varchar 20 √ null
StudentContactGiven2 varchar 50 √ null
StudentContactOccupPhone varchar 15 √ null
StudentContactOccupFax varchar 15 √ null
StudentContactOccupEmail varchar 100 √ null
StudentContactOccupCompany varchar 50 √ null
StudentContactOccupDesc varchar 50 √ null
StudentContactOccupCode varchar 15 √ null
StudentContactOccupType varchar 120 null
StudentContactEmail varchar 100 √ null
StudentContactDefaultEmail varchar 100 √ null
StudentContactMobilePhone varchar 15 √ null
StudentContactDefaultMobilePhone varchar 15 √ null
StudentContactOccupMobilePhone varchar 15 √ null
StudentContactSpouseID int 4 √ null
StudentContactSpouseTitle varchar 30 √ null
StudentContactSpouseNameInternal varchar 100 √ null
StudentContactSpouseNameExternal varchar 100 √ null
StudentContactSpouseLegalFullName varchar 150 √ null
StudentContactSpouseSurname varchar 30 √ null
StudentContactSpousePreferred varchar 20 √ null
StudentContactSpousePreferredFormal varchar 20 √ null
StudentContactSpouseGiven1 varchar 20 √ null
StudentContactSpouseGiven2 varchar 50 √ null
StudentContactSpouseOccupPhone varchar 15 √ null
StudentContactSpouseOccupFax varchar 15 √ null
StudentContactSpouseOccupEmail varchar 100 √ null
StudentContactSpouseOccupCompany varchar 50 √ null
StudentContactSpouseOccupDesc varchar 50 √ null
StudentContactSpouseOccupCode varchar 15 √ null
StudentContactSpouseOccupType varchar 120 null
StudentContactSpouseEmail varchar 100 √ null
StudentContactSpouseDefaultEmail varchar 100 √ null
StudentContactSpouseMobilePhone varchar 15 √ null
StudentContactSpouseDefaultMobilePhone varchar 15 √ null
StudentContactSpouseOccupMobilePhone varchar 15 √ null
StudentContactHomePhone varchar 15 √ null
StudentContactHomePhoneAlt varchar 15 √ null
StudentContactHomeFax varchar 15 √ null
StudentContactSilentPhoneFlag bit 1 √ null
StudentContactPhoneActual varchar 15 √ null
ValidAddressFlag bit 1 √ null
StudentContactAddressComma varchar 200 √ null
StudentContactAddressFull varchar 200 √ null
StudentContactAddress1 varchar 40 √ null
StudentContactAddress2 varchar 40 √ null
StudentContactAddress3 varchar 40 √ null
StudentContactState varchar 5 √ null
StudentContactCountryCode varchar 5 √ null
StudentContactCountryDesc varchar 40 √ null
StudentContactPostCode varchar 5 √ null
StudentContactSuburb varchar 40 √ null
StudentContactAddressDPID varchar 8 √ null
StudentContactAddressDPIDBarcode varchar 60 √ null
StudentContactAddressSortPlanNumber varchar 3 √ null
StudentContactAddressPAFVersion varchar 10 √ null
StudentContactHomeAddressComma varchar 200 √ null
StudentContactHomeAddressFull varchar 200 √ null
StudentContactHomeState varchar 5 √ null
StudentContactHomeCountryCode varchar 5 √ null
StudentContactHomePostCode varchar 5 √ null
StudentContactHomeSuburb varchar 40 √ null
StudentContactHomeAddress1 varchar 40 √ null
StudentContactHomeAddress2 varchar 40 √ null
StudentContactHomeAddress3 varchar 40 √ null
StudentContactHomeAddressDPID varchar 8 √ null
StudentContactHomeAddressDPIDBarcode varchar 60 √ null
StudentContactHomeAddressSortPlanNumber varchar 3 √ null
StudentContactHomeAddressPAFVersion varchar 10 √ null
StudentPhotoWebFlag bit 1 √ null
StudentPhotoPromFlag bit 1 √ null
StudentPhotoPublicationFlag bit 1 √ null
StudentContactInitials varchar 15 √ null
StudentContactSpouseInitials varchar 15 √ null
StudentParentsSeparatedFlag bit 1 √ null
StudentEntryDate datetime 16,3 √ null
StudentContactRelation varchar 100 √ null
StudentContactSpouseRelation varchar 100 √ null
StudentSubSchool varchar 15 √ null
StudentMobilePhone varchar 15 √ null
StudentEmail varchar 100 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views