vStudentContactsParentsDebtor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
StudentID int 4 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
StudentPublishToAssociatedFlag bit 1 √ null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
Status varchar 3 √ null
StatusDescription varchar 30 √ null
StatusNextYear varchar 3 √ null
StatusNextYearDescription varchar 30 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
StudentLeavingDestination varchar 15 √ null
StudentReturningDate datetime 16,3 √ null
StudentCampus varchar 3 √ null
StudentEntryDate datetime 16,3 √ null
StudentEntryCampus varchar 3 null
StudentEntryYearLevel smallint 2 √ 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
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
BoardingHouse varchar 15 √ null
BoarderType varchar 30 √ null
StudiesCode varchar 15 null
GovernmentStudentNumber varchar 15 √ null
TimetableCode varchar 15 null
AlternateCode varchar 15 null
StudentFamilyPosition smallint 2 √ null
CurrentSemesterOnlyFlag int 4 null
StudentApplicationDate datetime 16,3 √ null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentStudyAtHomeFlag bit 1 null
StudentFullFeeFlag bit 1 null
StudentTSIFlag bit 1 null
StudentIndigenousFlag bit 1 null
StudentIntendsTertiaryFlag bit 1 null
EmergencyName varchar 80 null
EmergencyAddress varchar 200 null
EmergencyPhone varchar 15 null
EmergencyPhoneAlt varchar 15 null
EmergencyRelat varchar 5 √ null
EmergencyRelatDescription varchar 30 √ null
Emergency2Name varchar 80 null
Emergency2Address varchar 200 null
Emergency2Phone varchar 15 null
Emergency2PhoneAlt varchar 15 null
Emergency2Relat varchar 5 √ null
Emergency2RelatDescription varchar 30 √ null
Emergency3Name varchar 80 null
Emergency3Address varchar 200 null
Emergency3Phone varchar 15 null
Emergency3PhoneAlt varchar 15 null
Emergency3Relat varchar 5 null
Emergency3RelatDescription varchar 30 √ null
PreviousSchool varchar 15 null
PreviousSchoolDescription varchar 100 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
StudentContactID int 4 √ null
StudentContactLivesWithFlag bit 1 √ 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
StudentContactSilentHomeAddressFlag bit 1 √ null
StudentContactHomeAddressDPID varchar 8 √ null
StudentContactHomeAddressDPIDBarcode varchar 60 √ null
StudentContactHomeAddressSortPlanNumber varchar 3 √ null
StudentContactHomeAddressPAFVersion varchar 10 √ null
StudentContactHomePhoneActual varchar 15 √ null
StudentContactHomePhone varchar 15 √ null
StudentContactHomePhoneAlt varchar 15 √ null
StudentContactHomeEmail varchar 100 √ null
StudentContactSuburb varchar 40 √ null
StudentContactState varchar 5 √ null
StudentContactCountryCode varchar 5 √ null
StudentContactPostCode varchar 5 √ null
StudentContactValidAddress bit 1 √ null
StudentContactNormalMailFlag bit 1 √ null
StudentContactReportsFlag bit 1 √ null
StudentContactParentFlag bit 1 √ null
StudentContactOccupCode varchar 15 √ null
StudentContactOccupCodeDesc varchar 120 √ null
StudentContactOccupDesc varchar 50 √ null
StudentContactOccupCompany varchar 50 √ null
StudentContactOccupSuburb varchar 40 √ null
StudentContactOccupState varchar 5 √ null
StudentContactOccupCountryCode varchar 5 √ null
StudentContactOccupPostCode varchar 5 √ null
StudentContactOccupAddressFull varchar 200 √ null
StudentContactOccupAddressComma varchar 200 √ null
StudentContactOccupAddressDPID varchar 8 √ null
StudentContactOccupAddressDPIDBarcode varchar 60 √ null
StudentContactOccupAddressSortPlanNumber varchar 3 √ null
StudentContactOccupAddressPAFVersion varchar 10 √ null
StudentContactOccupFax varchar 15 √ null
StudentContactOccupMobilePhone varchar 15 √ null
StudentContactSilentOccupMobilePhoneFlag bit 1 √ null
StudentContactOccupEmail varchar 100 √ null
StudentContactPublishToAssociatedFlag bit 1 √ null
StudentContactOccupIndustryCode varchar 8 √ null
StudentContactOccupIndustryDesc varchar 100 √ null
StudentContactOccupPositionCode varchar 8 √ null
StudentContactOccupPositionDescription varchar 120 √ null
StudentContactSpouseOccupCode varchar 15 √ null
StudentContactSpouseOccupCodeDesc varchar 120 √ null
StudentContactSpouseOccupDesc varchar 50 √ null
StudentContactSpouseOccupCompany varchar 50 √ null
StudentContactSpouseOccupSuburb varchar 40 √ null
StudentContactSpouseOccupState varchar 5 √ null
StudentContactSpouseOccupCountryCode varchar 5 √ null
StudentContactSpouseOccupPostCode varchar 5 √ null
StudentContactSpouseOccupAddressFull varchar 200 √ null
StudentContactSpouseOccupAddressComma varchar 200 √ null
StudentContactSpouseOccupAddressDPID varchar 8 √ null
StudentContactSpouseOccupAddressDPIDBarcode varchar 60 √ null
StudentContactSpouseOccupAddressSortPlanNumber varchar 3 √ null
StudentContactSpouseOccupAddressPAFVersion varchar 10 √ null
StudentContactSpouseOccupFax varchar 15 √ null
StudentContactSpouseOccupMobilePhone varchar 15 √ null
StudentContactSpouseOccupMobilePhoneFlag bit 1 √ null
StudentContactSpouseOccupEmail varchar 100 √ null
StudentContactSpouseOccupPhone varchar 15 √ null
StudentContactSpousePublishToAssociatedFlag bit 1 √ null
StudentContactSpouseOccupIndustryCode varchar 8 √ null
StudentContactSpouseOccupIndustryDesc varchar 100 √ null
StudentContactSpouseOccupPositionCode varchar 8 √ null
StudentContactSpouseOccupPositionDescription varchar 120 √ null
StudentContactHomePhoneSilentFlag bit 1 √ null
StudentContactMobilePhone varchar 15 √ null
StudentContactDefaultMobilePhone varchar 15 √ null
StudentContactSilentMobilePhoneFlag bit 1 √ null
StudentContactOccupPhone varchar 15 √ null
StudentContactHomeFax varchar 15 √ null
StudentContactTitle varchar 30 √ null
StudentContactInitials varchar 15 √ null
StudentContactSurname varchar 30 √ null
StudentContactPreferred varchar 20 √ null
StudentContactGiven1 varchar 20 √ null
StudentContactGiven2 varchar 50 √ null
StudentContactSpouseTitle varchar 30 √ null
StudentContactSpouseInitials varchar 15 √ null
StudentContactSpouseSurname varchar 30 √ null
StudentContactSpousePreferred varchar 20 √ null
StudentContactSpouseGiven1 varchar 20 √ null
StudentContactSpouseGiven2 varchar 50 √ null
StudentContactSpouseMobilePhone varchar 15 √ null
StudentContactSpouseDefaultMobilePhone varchar 15 √ null
StudentContactSpouseSilentMobilePhoneFlag bit 1 √ null
AlternateID int 4 √ null
StudentAltContactLivesWithFlag bit 1 √ null
AlternateSpouseID int 4 √ null
StudentAltContactHomeEmail varchar 100 √ null
StudentAltContactHomePhone varchar 15 √ null
StudentAltContactHomePhoneActual varchar 15 √ null
StudentAltContactHomePhoneAlt varchar 15 √ null
StudentAltContactHomePhoneSilentFlag bit 1 √ null
StudentAltOccupCode varchar 15 √ null
StudentAltOccupCodeDesc varchar 120 √ null
StudentAltOccupDesc varchar 50 √ null
StudentAltOccupCompany varchar 50 √ null
StudentAltOccupPhone varchar 15 √ null
StudentAltOccupMobilePhone varchar 15 √ null
StudentAltSilentOccupMobilePhoneFlag bit 1 √ null
StudentAltOccupFax varchar 15 √ null
StudentAltOccupEmail varchar 100 √ null
StudentAltOccupSuburb varchar 40 √ null
StudentAltOccupState varchar 5 √ null
StudentAltOccupCountryCode varchar 5 √ null
StudentAltOccupPostCode varchar 5 √ null
StudentAltOccupAddressFull varchar 200 √ null
StudentAltOccupAddressComma varchar 200 √ null
StudentAltOccupAddressDPID varchar 8 √ null
StudentAltOccupAddressDPIDBarcode varchar 60 √ null
StudentAltOccupAddressSortPlanNumber varchar 3 √ null
StudentAltOccupAddressPAFVersion varchar 10 √ null
StudentAltOccupIndustryCode varchar 8 √ null
StudentAltOccupIndustryDesc varchar 100 √ null
StudentAltOccupPositionCode varchar 8 √ null
StudentAltOccupPositionDescription varchar 120 √ null
StudentAltPublishToAssociatedFlag bit 1 √ null
StudentAltSpouseOccupCode varchar 15 √ null
StudentAltSpouseOccupCodeDesc varchar 120 √ null
StudentAltSpouseOccupDesc varchar 50 √ null
StudentAltSpouseOccupCompany varchar 50 √ null
StudentAltSpouseOccupPhone varchar 15 √ null
StudentAltSpouseOccupMobilePhone varchar 15 √ null
StudentAltSpouseSilentOccupMobilePhoneFlag bit 1 √ null
StudentAltSpouseOccupFax varchar 15 √ null
StudentAltSpouseOccupEmail varchar 100 √ null
StudentAltSpouseOccupSuburb varchar 40 √ null
StudentAltSpouseOccupState varchar 5 √ null
StudentAltSpouseOccupCountryCode varchar 5 √ null
StudentAltSpouseOccupPostCode varchar 5 √ null
StudentAltSpouseOccupAddressFull varchar 200 √ null
StudentAltSpouseOccupAddressComma varchar 200 √ null
StudentAltSpouseOccupAddressDPID varchar 8 √ null
StudentAltSpouseOccupAddressDPIDBarcode varchar 60 √ null
StudentAltSpouseOccupAddressSortPlanNumber varchar 3 √ null
StudentAltSpouseOccupAddressPAFVersion varchar 10 √ null
StudentAltContactSpouseMobilePhone varchar 15 √ null
StudentAltContactSpouseDefaultMobilePhone varchar 15 √ null
StudentAltContactSpouseSilentMobilePhoneFlag bit 1 √ null
StudentAltSpouseOccupIndustryCode varchar 8 √ null
StudentAltSpouseOccupIndustryDesc varchar 100 √ null
StudentAltSpouseOccupPositionCode varchar 8 √ null
StudentAltSpouseOccupPositionDescription varchar 120 √ null
StudentAltSpousePublishToAssociatedFlag bit 1 √ null
StudentAltContactHomeFax varchar 15 √ null
StudentAltContactMobilePhone varchar 15 √ null
StudentAltContactDefaultMobilePhone varchar 15 √ null
StudentAltContactOccupPhone varchar 15 √ null
StudentAltContactMailName varchar 100 √ null
StudentAltContactMailSalutation varchar 100 √ null
StudentAltContactAddressComma varchar 200 √ null
StudentAltContactAddressFull varchar 200 √ null
StudentAltContactAddressDPID varchar 8 √ null
StudentAltContactAddressDPIDBarcode varchar 60 √ null
StudentAltContactAddressSortPlanNumber varchar 3 √ null
StudentAltContactAddressPAFVersion varchar 10 √ null
StudentAltContactHomeAddressComma varchar 200 √ null
StudentAltContactHomeAddressFull varchar 200 √ null
StudentAltContactHomeAddressDPID varchar 8 √ null
StudentAltContactHomeAddressDPIDBarcode varchar 60 √ null
StudentAltContactHomeAddressSortPlanNumber varchar 3 √ null
StudentAltContactHomeAddressPAFVersion varchar 10 √ null
StudentAltContactTitle varchar 30 √ null
StudentAltContactInitials varchar 15 √ null
StudentAltContactSurname varchar 30 √ null
StudentAltContactPreferred varchar 20 √ null
StudentAltContactGiven1 varchar 20 √ null
StudentAltContactGiven2 varchar 50 √ null
StudentAltSpouseTitle varchar 30 √ null
StudentAltSpouseInitials varchar 15 √ null
StudentAltSpouseSurname varchar 30 √ null
StudentAltSpousePreferred varchar 20 √ null
StudentAltSpouseGiven1 varchar 20 √ null
StudentAltSpouseGiven2 varchar 50 √ null
FatherID int 4 √ null
FatherSpouseID int 4 √ null
FatherTitle varchar 30 √ null
FatherInitials varchar 15 √ null
FatherSurname varchar 30 √ null
FatherPreferred varchar 20 √ null
FatherGiven1 varchar 20 √ null
FatherGiven2 varchar 50 √ null
FatherHomeEmail varchar 100 √ null
FatherHomePhone varchar 15 √ null
FatherAddressComma varchar 200 √ null
FatherAddressFull varchar 200 √ null
FatherValidAddressFlag bit 1 √ null
FatherOccupCode varchar 15 √ null
FatherOccupCodeDesc varchar 120 √ null
FatherOccupDesc varchar 50 √ null
FatherOccupCompany varchar 50 √ null
FatherOccupSuburb varchar 40 √ null
FatherOccupState varchar 5 √ null
FatherOccupCountryCode varchar 5 √ null
FatherOccupPostCode varchar 5 √ null
FatherOccupAddressFull varchar 200 √ null
FatherOccupAddressComma varchar 200 √ null
FatherOccupAddressDPID varchar 8 √ null
FatherOccupAddressDPIDBarcode varchar 60 √ null
FatherOccupAddressSortPlanNumber varchar 3 √ null
FatherOccupAddressPAFVersion varchar 10 √ null
FatherOccupIndustryCode varchar 8 √ null
FatherOccupIndustryDesc varchar 100 √ null
FatherOccupPositionCode varchar 8 √ null
FatherOccupPositionDescription varchar 120 √ null
FatherOccupPhone varchar 15 √ null
FatherOccupFax varchar 15 √ null
FatherOccupEmail varchar 100 √ null
FatherMobilePhone varchar 15 √ null
FatherDefaultMobilePhone varchar 15 √ null
FatherOccupMobilePhone varchar 15 √ null
FatherPublishToAssociatedFlag bit 1 √ null
MotherID int 4 √ null
MotherSpouseID int 4 √ null
MotherTitle varchar 30 √ null
MotherSurname varchar 30 √ null
MotherPreferred varchar 20 √ null
MotherGiven1 varchar 20 √ null
MotherGiven2 varchar 50 √ null
MotherHomeEmail varchar 100 √ null
MotherHomePhone varchar 15 √ null
MotherEmail varchar 100 √ null
MotherAddressComma varchar 200 √ null
MotherAddressFull varchar 200 √ null
MotherValidAddressFlag bit 1 √ null
MotherOccupCode varchar 15 √ null
MotherOccupCodeDesc varchar 120 √ null
MotherOccupDesc varchar 50 √ null
MotherOccupCompany varchar 50 √ null
MotherOccupSuburb varchar 40 √ null
MotherOccupState varchar 5 √ null
MotherOccupCountryCode varchar 5 √ null
MotherOccupPostCode varchar 5 √ null
MotherOccupAddressFull varchar 200 √ null
MotherOccupAddressComma varchar 200 √ null
MotherOccupAddressDPID varchar 8 √ null
MotherOccupAddressDPIDBarcode varchar 60 √ null
MotherOccupAddressSortPlanNumber varchar 3 √ null
MotherOccupAddressPAFVersion varchar 10 √ null
MotherOccupIndustryCode varchar 8 √ null
MotherOccupIndustryDesc varchar 100 √ null
MotherOccupPositionCode varchar 8 √ null
MotherOccupPositionDescription varchar 120 √ null
MotherOccupPhone varchar 15 √ null
MotherOccupFax varchar 15 √ null
MotherOccupEmail varchar 100 √ null
MotherMobilePhone varchar 15 √ null
MotherDefaultMobilePhone varchar 15 √ null
MotherOccupMobilePhone varchar 15 √ null
MotherPublishToAssociatedFlag bit 1 √ null
DebtorID int 4 √ null
DebtorMailName varchar 100 √ null
DebtorAddressComma varchar 200 √ null
DebtorAddressFull varchar 200 √ null
DebtorHomePhone varchar 15 √ null
DebtorOccupPhone varchar 15 √ null
DebtorOccupCode varchar 15 √ null
DebtorOccupCodeDesc varchar 120 √ null
DebtorOccupDesc varchar 50 √ null
DebtorOccupCompany varchar 50 √ null
DebtorOccupSuburb varchar 40 √ null
DebtorOccupState varchar 5 √ null
DebtorOccupCountryCode varchar 5 √ null
DebtorOccupPostCode varchar 5 √ null
DebtorOccupAddressFull varchar 200 √ null
DebtorOccupAddressComma varchar 200 √ null
DebtorOccupAddressDPID varchar 8 √ null
DebtorOccupAddressDPIDBarcode varchar 60 √ null
DebtorOccupAddressSortPlanNumber varchar 3 √ null
DebtorOccupAddressPAFVersion varchar 10 √ null
DebtorOccupIndustryCode varchar 8 √ null
DebtorOccupIndustryDesc varchar 100 √ null
DebtorOccupPositionCode varchar 8 √ null
DebtorOccupPositionDescription varchar 120 √ null
DebtorPublishToAssociatedFlag bit 1 √ null
TermID int 4 √ null
TermSpouseID int 4 √ null
TermPreferred varchar 20 √ null
TermMailName varchar 100 √ null
TermAddressComma varchar 200 √ null
TermAddressFull varchar 200 √ null
TermPostcode varchar 5 √ null
TermHomePhone varchar 15 √ null
TermMobilePhone varchar 15 √ null
TermDefaultMobilePhone varchar 15 √ null
TermOccupPhone varchar 15 √ null
TermHomePhoneSilentFlag bit 1 √ null
StudentTermContactOccupCode varchar 15 √ null
StudentTermContactOccupCodeDesc varchar 120 √ null
StudentTermContactOccupDesc varchar 50 √ null
StudentTermContactOccupCompany varchar 50 √ null
StudentTermContactOccupSuburb varchar 40 √ null
StudentTermContactOccupState varchar 5 √ null
StudentTermContactOccupCountryCode varchar 5 √ null
StudentTermContactOccupPostCode varchar 5 √ null
StudentTermContactOccupAddressFull varchar 200 √ null
StudentTermContactOccupAddressComma varchar 200 √ null
StudentTermOccupAddressDPID varchar 8 √ null
StudentTermOccupAddressDPIDBarcode varchar 60 √ null
StudentTermOccupAddressSortPlanNumber varchar 3 √ null
StudentTermOccupAddressPAFVersion varchar 10 √ null
StudentTermContactOccupIndustryCode varchar 8 √ null
StudentTermContactOccupIndustryDesc varchar 100 √ null
StudentTermContactOccupPositionCode varchar 8 √ null
StudentTermContactOccupPositionDescription varchar 120 √ null
StudentTermContactPublishToAssociatedFlag bit 1 √ null
StudentTermSpouseOccupCode varchar 15 √ null
StudentTermSpouseOccupCodeDesc varchar 120 √ null
StudentTermSpouseOccupDesc varchar 50 √ null
StudentTermSpouseOccupCompany varchar 50 √ null
StudentTermSpouseOccupSuburb varchar 40 √ null
StudentTermSpouseOccupState varchar 5 √ null
StudentTermSpouseOccupCountryCode varchar 5 √ null
StudentTermSpouseOccupPostCode varchar 5 √ null
StudentTermSpouseOccupAddressFull varchar 200 √ null
StudentTermSpouseOccupAddressComma varchar 200 √ null
StudentTermSpouseOccupAddressDPID varchar 8 √ null
StudentTermSpouseOccupAddressDPIDBarcode varchar 60 √ null
StudentTermSpouseOccupAddressSortPlanNumber varchar 3 √ null
StudentTermSpouseOccupAddressPAFVersion varchar 10 √ null
StudentTermSpouseOccupIndustryCode varchar 8 √ null
StudentTermSpouseOccupIndustryDesc varchar 100 √ null
StudentTermSpousePublishToAssociatedFlag bit 1 √ null
StudentTermSpouseOccupPositionCode varchar 8 √ null
StudentTermSpouseOccupPositionDescription varchar 120 √ null
StudentSubSchool varchar 15 √ null
StudentContactRelationship varchar 5 √ null
StudentContactSpouseRelationship varchar 5 √ null
StudentAltContactRelationship varchar 5 √ null
StudentAltContactSpouseRelationship varchar 5 √ null
StudentContactDefaultEmail varchar 201 √ null
StudentContactSpouseDefaultEmail varchar 201 √ null
StudentAltContactDefaultEmail varchar 201 √ null
StudentAltContactSpouseDefault varchar 201 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views