pvvStudentContactAddress


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
StudentContactType varchar 3 √ null
StudentContactDescription varchar 30 √ null
StudentContactLivesWithFlag bit 1 √ null
StudentContactPrimaryOnlyFlag bit 1 √ null
StudentContactNormalMailFlag bit 1 √ null
StudentContactValidAddress bit 1 √ null
StudentContactReportsFlag bit 1 √ null
StudentContactParentFlag bit 1 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
StudentLeavingDestination varchar 15 √ null
Status varchar 3 √ null
StatusDescription varchar 30 √ null
StatusNextYear varchar 3 √ null
StatusNextYearDescription varchar 30 √ null
StudentCampus varchar 3 √ null
StudentEntryDate datetime 16,3 √ null
StudentEntryCampus varchar 3 null
StudentEntryYearLevel smallint 2 √ null
StudentReturningDate datetime 16,3 √ null
StudentCampusDescription varchar 30 √ null
YearLevel smallint 2 √ null
StudentOverrideNextYearLevel smallint 2 √ null
StudentOverrideNextStudentCampus varchar 3 √ null
StudentOverrideNextBoarder varchar 3 √ null
YearLevelSort smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
House varchar 5 √ null
Form varchar 15 √ null
StudentFormDescription varchar 30 √ null
StudentFormHomeroom varchar 15 √ null
StudentFormHomeroomTeacher varchar 100 √ null
Tutor varchar 15 √ null
Boarder varchar 3 √ null
BoarderSynergyMeaning varchar 30 √ null
BoarderType varchar 30 √ null
BoardingHouse varchar 15 √ null
DebtorID int 4 null
FullFeeFlag bit 1 null
StudentTuitionNoSibFlag bit 1 null
EnglishSecondFlag bit 1 null
StudentApplicationDate datetime 16,3 √ null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentStudyAtHomeFlag bit 1 null
StudentTSIFlag bit 1 null
StudentIndigenousFlag bit 1 null
StudentEMAFlag bit 1 √ null
StudentESLProficiencyLevel varchar 15 null
StudentESLListeningLevelCode varchar 15 √ null
StudentESLSpeakingLevelCode varchar 15 √ null
StudentESLReadingLevelCode varchar 15 √ null
StudentESLWritingLevelCode varchar 15 √ null
StudentIntendsTertiaryFlag bit 1 null
NameInternal varchar 100 √ null
NameExternal varchar 100 √ null
LegalFullName varchar 150 √ null
Surname varchar 30 √ null
Preferred varchar 20 √ null
PreferredFormal varchar 20 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
StudentName varchar 51 √ null
StudentBirthDate datetime 16,3 √ null
StudentGender varchar 15 √ null
StudentReligionCode varchar 5 √ null
StudentMobilePhone varchar 15 √ null
StudentReligionDescription varchar 40 √ null
StudentParishCode varchar 5 √ null
StudentParishDescription varchar 50 √ null
StudentContactID int 4 √ null
StudentContactSpouseID int 4 √ null
StudentContactMailName varchar 100 √ null
StudentContactMailSalutation varchar 100 √ null
StudentContactAddressComma varchar 200 √ null
StudentContactAddressFull varchar 200 √ 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
StudentContactHomeAddressSameFlag bit 1 √ null
StudentContactHomeAddressDPID varchar 8 √ null
StudentContactHomeAddressDPIDBarcode varchar 60 √ null
StudentContactHomeAddressSortPlanNumber varchar 3 √ null
StudentContactHomeAddressPAFVersion varchar 10 √ null
AddressModifiedDate datetime 16,3 √ null
StudentContactEmail varchar 100 √ null
StudentContactMobilePhone varchar 15 √ null
StudentContactDefaultMobilePhone varchar 15 √ null
StudentContactState varchar 5 √ null
StudentContactSuburb varchar 40 √ null
StudentContactCountryCode varchar 5 √ null
StudentContactCountryDesc varchar 40 √ null
StudentContactPostCode varchar 5 √ null
StudentContactHomeState varchar 5 √ null
StudentContactHomeSuburb varchar 40 √ null
StudentContactHomeCountryCode varchar 5 √ null
StudentContactHomeCountryDesc varchar 40 √ null
StudentContactHomePostCode varchar 5 √ null
StudentContactMailFlag bit 1 √ null
StudentContactRaffleFlag bit 1 √ null
StudentContactDeceasedFlag bit 1 √ 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
StudentContactOccupCompany varchar 50 √ null
StudentContactOccupType varchar 50 √ null
StudentContactOccupDescription varchar 120 √ null
StudentContactOccupCode varchar 15 √ null
StudentContactOccupPhone varchar 15 √ null
StudentContactOccupFax varchar 15 √ null
StudentContactDefaultEmailCode varchar 1 √ null
StudentContactDefaultEmail varchar 201 √ null
StudentContactOccupEmail varchar 100 √ null
StudentContactOccupMobilePhone varchar 15 √ 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
StudentContactSpouseOccupCompany varchar 50 √ null
StudentContactSpouseOccupType varchar 50 √ null
StudentContactSpouseOccupDescription varchar 120 √ null
StudentContactSpouseOccupPhone varchar 15 √ null
StudentContactSpouseOccupFax varchar 15 √ null
StudentContactSpouseOccupEmail varchar 100 √ null
StudentContactSpouseEmail varchar 100 √ null
StudentContactSpouseDefaultEmailCode varchar 1 √ null
StudentContactSpouseDefaultEmail varchar 201 √ 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
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
BarCode varchar 20 √ null
StudiesCode varchar 15 null
TimetableCode varchar 15 null
ValidAddressFlag bit 1 √ null
CurrentSemesterOnlyFlag int 4 null
StudentFamilyPosition smallint 2 √ null
StudentCountryOfBirthCode varchar 5 √ null
StudentCountryOfBirthDescription varchar 40 √ null
StudentHomeLanguageCode varchar 5 √ null
StudentHomeLanguageDescription varchar 100 √ null
StudentNationalityCode varchar 5 √ null
StudentNationalityDescription varchar 30 √ null
StudentContactCountryOfBirthCode varchar 5 √ null
StudentContactCountryOfBirthDescription varchar 40 √ null
StudentContactHomeLanguageCode varchar 5 √ null
StudentContactHomeLanguageDescription varchar 100 √ null
StudentContactSpouseCountryOfBirthCode varchar 5 √ null
StudentContactSpouseCountryOfBirthDescription varchar 40 √ null
StudentContactSpouseHomeLanguageCode varchar 5 √ null
StudentContactSpouseHomeLanguageDescription varchar 100 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
SiblingCount int 4 √ null
StudentDirectoryIncludeFlag bit 1 √ null
StudentDirectoryProvideFlag bit 1 √ null
StudentContactDirectoryIncludeFlag bit 1 √ null
StudentContactDirectoryProvideFlag bit 1 √ null
StudentContactSpouseDirectoryIncludeFlag bit 1 √ null
StudentContactSpouseDirectoryProvideFlag bit 1 √ null
StudentPublishToAssociatedFlag bit 1 √ null
StudentContactPublishToAssociatedFlag bit 1 √ null
StudentContactSpousePublishToAssociatedFlag bit 1 √ null
StudentContactPhoneActual varchar 15 √ null
StudentHouseDescription varchar 30 √ null
StudentContactInitials varchar 15 √ null
StudentContactSpouseInitials varchar 15 √ null
StudentAddressID int 4 √ null
StudentEmail varchar 100 √ null
StudentContactAddressID int 4 √ null
StudentSubSchool varchar 15 √ null
StudentContactRelationship varchar 5 √ null
StudentContactRelationshipDesc varchar 30 √ null
StudentContactSpouseRelationship varchar 5 √ null
StudentContactSpouseRelationshipDesc varchar 30 √ null
StudentContactGiven1 varchar 20 √ null
StudentContactOccupPositionCode varchar 8 √ null
StudentContactOccupPositionDescription varchar 120 √ null
StudentContactSilentPhoneFlag bit 1 √ null
StudentContactSpouseGiven1 varchar 20 √ null
StudentContactSpousePositionCode varchar 8 √ null
StudentContactSpouseOccupPositionDescription varchar 120 √ null
StudentContactSpouseOccupCode varchar 15 √ null
StudentGenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views