vFutureStudentSiblingsAtSchool


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FutureName varchar 51 null
FutureNameInternal varchar 100 null
FutureNameExternal varchar 100 null
FutureLegalFullName varchar 150 null
FutureSurname varchar 30 null
FuturePreferred varchar 20 null
FuturePreferredFormal varchar 20 null
FutureGiven1 varchar 20 null
FutureGiven2 varchar 50 null
FutureTitle varchar 30 null
FutureGender varchar 15 null
FutureBirthDate datetime 16,3 √ null
StudentBarCode varchar 20 null
FutureSiblingID int 4 √ null
FutureSiblingName varchar 51 √ null
FutureSiblingNameInternal varchar 100 √ null
FutureSiblingNameExternal varchar 100 √ null
FutureSiblingLegalFullName varchar 150 √ null
FutureSiblingSurname varchar 30 √ null
FutureSiblingPreferred varchar 20 √ null
FutureSiblingPreferredFormal varchar 20 √ null
FutureSiblingGiven1 varchar 20 √ null
FutureSiblingGiven2 varchar 50 √ null
FutureSiblingTitle varchar 30 √ null
FutureSiblingGender varchar 15 √ null
FutureSiblingBirthDate datetime 16,3 √ null
SiblingType varchar 30 √ null
FutureStudentid int 4 null
FutureEnquiryDate datetime 16,3 √ null
FutureApplicationDate datetime 16,3 √ null
FutureEnrolDate datetime 16,3 √ null
FutureEnrolYear int 4 √ null
FutureEnrolMonth int 4 √ null
FutureStatus varchar 3 null
FutureStatusDescription varchar 30 √ null
FutureStatusChangeDate datetime 16,3 √ null
FutureStatusChangeDescription varchar 30 null
FuturePriority varchar 3 null
FutureCampus varchar 3 null
FutureYearLevel smallint 2 √ null
FutureHouse varchar 5 null
FutureForm varchar 15 null
FutureTutor varchar 15 null
FuturePosition smallint 2 null
FutureBoarder varchar 3 null
FutureBoarderType varchar 30 √ null
FuturePreviousSchool varchar 15 null
FutureExternalStudentFlag bit 1 null
FutureFullFeeFlag bit 1 null
FutureIBFlag bit 1 null
FutureSuppEnrolDate1 datetime 16,3 √ null
FutureSuppEnrolYear1 int 4 √ null
FutureSuppEnrolMonth1 int 4 √ null
FutureSuppCampus1 varchar 3 null
FutureSuppYearLevel1 smallint 2 √ null
FutureSuppEnrolDate2 datetime 16,3 √ null
FutureSuppEnrolYear2 int 4 √ null
FutureSuppEnrolMonth2 int 4 √ null
FutureSuppCampus2 varchar 3 null
FutureSuppYearLevel2 smallint 2 √ null
FutureBaptismFlag bit 1 null
FutureBaptismDate datetime 16,3 √ null
FutureReconciliationFlag bit 1 null
FutureReconciliationDate datetime 16,3 √ null
FutureCommunionFlag bit 1 null
FutureCommunionDate datetime 16,3 √ null
FutureConfirmationFlag bit 1 null
FutureConfirmationDate datetime 16,3 √ null
FutureAllowAutoChargesFlag bit 1 null
FutureAllowAutoTuitionFlag bit 1 null
FutureAustudyFlag bit 1 null
FutureBarcode varchar 20 null
FutureIndigenousFlag bit 1 null
FutureMedicalAlertFlag bit 1 null
FutureSpecialNeedsFlag bit 1 null
FutureStudyAtHomeFlag bit 1 null
FutureTSIFlag bit 1 null
FutureContactID int 4 null
FutureContactPrimaryOnlyFlag bit 1 null
FutureContactNormalMailFlag bit 1 null
FutureContactReportsFlag bit 1 null
FutureContactParentFlag bit 1 null
FutureContactType varchar 3 null
FutureContactMailName varchar 100 √ null
FutureContactMailSalutation varchar 100 √ null
FutureContactDescription varchar 30 √ null
FutureContactTitle varchar 30 √ null
FutureContactNameInternal varchar 100 √ null
FutureContactNameExternal varchar 100 √ null
FutureContactLegalFullName varchar 150 √ null
FutureContactGiven1 varchar 20 √ null
FutureContactGiven2 varchar 50 √ null
FutureContactSurname varchar 30 √ null
FutureContactPreferred varchar 20 √ null
FutureContactPreferredFormal varchar 20 √ null
FutureContactOccupCode varchar 15 √ null
FutureContactOccupCompany varchar 50 √ null
FutureContactOccupPhone varchar 15 √ null
FutureContactOccupFax varchar 15 √ null
FutureContactOccupEmail varchar 100 √ null
FutureContactEmail varchar 100 √ null
FutureContactMobilePhone varchar 15 √ null
FutureContactDefaultMobilePhone varchar 15 √ null
FutureContactOccupMobilePhone varchar 15 √ null
FutureContactOccupDescription varchar 120 √ null
FutureContactAddressComma varchar 200 √ null
FutureContactAddressFull varchar 200 √ null
FutureContactSuburb varchar 40 √ null
FutureContactState varchar 5 √ null
FutureContactCountryCode varchar 5 √ null
FutureContactPostCode varchar 5 √ null
FutureContactAddressDPID varchar 8 √ null
FutureContactAddressDPIDBarcode varchar 60 √ null
FutureContactAddressSortPlanNumber varchar 3 √ null
FutureContactAddressPAFVersion varchar 10 √ null
FutureContactHomeAddressComma varchar 200 √ null
FutureContactHomeAddressFull varchar 200 √ null
FutureContactHomeSuburb varchar 40 √ null
FutureContactHomeState varchar 5 √ null
FutureContactHomeCountryCode varchar 5 √ null
FutureContactHomePostCode varchar 5 √ null
FutureContactHomeAddressDPID varchar 8 √ null
FutureContactHomeAddressDPIDBarcode varchar 60 √ null
FutureContactHomeAddressSortPlanNumber varchar 3 √ null
FutureContactHomeAddressPAFVersion varchar 10 √ null
FutureContactHomePhone varchar 15 √ null
FutureContactHomePhoneAlt varchar 15 √ null
FutureContactHomeFax varchar 15 √ null
ValidAddressFlag bit 1 √ null
FutureContactSpouseID int 4 √ null
FutureContactSpouseTitle varchar 30 √ null
FutureContactSpouseNameInternal varchar 100 √ null
FutureContactSpouseNameExternal varchar 100 √ null
FutureContactSpouseLegalFullName varchar 150 √ null
FutureContactSpouseGiven1 varchar 20 √ null
FutureContactSpouseGiven2 varchar 50 √ null
FutureContactSpouseSurname varchar 30 √ null
FutureContactSpousePreferred varchar 20 √ null
FutureContactSpousePreferredFormal varchar 20 √ null
FutureContactSpouseOccupCompany varchar 50 √ null
FutureContactSpouseOccupPhone varchar 15 √ null
FutureContactSpouseOccupFax varchar 15 √ null
FutureContactSpouseOccupEmail varchar 100 √ null
FutureContactSpouseEmail varchar 100 √ null
FutureContactSpouseMobilePhone varchar 15 √ null
FutureContactSpouseDefaultMobilePhone varchar 15 √ null
FutureContactSpouseOccupMobilePhone varchar 15 √ null
FutureContactSpouseOccupCode varchar 15 √ null
FutureContactSpouseOccupDescription varchar 120 √ null
FutureContactSpouseAddressFull varchar 200 √ null
FutureContactSpouseAddressComma varchar 200 √ null
FutureContactSpouseHomeAddressFull varchar 200 √ null
FutureContactSpouseHomeAddressComma varchar 200 √ null
FutureContactSpouseSuburb varchar 40 √ null
FutureContactSpouseState varchar 5 √ null
FutureContactSpouseCountryCode varchar 5 √ null
FutureContactSpousePostCode varchar 5 √ null
FutureContactSpouseAddressDPID varchar 8 √ null
FutureContactSpouseAddressDPIDBarcode varchar 60 √ null
FutureContactSpouseAddressSortPlanNumber varchar 3 √ null
FutureContactSpouseAddressPAFVersion varchar 10 √ null
FutureContactSpouseHomeSuburb varchar 40 √ null
FutureContactSpouseHomeState varchar 5 √ null
FutureContactSpouseHomeCountryCode varchar 5 √ null
FutureContactSpouseHomePostCode varchar 5 √ null
FutureContactSpouseHomeAddressDPID varchar 8 √ null
FutureContactSpouseHomeAddressDPIDBarcode varchar 60 √ null
FutureContactSpouseHomeAddressSortPlanNumber varchar 3 √ null
FutureContactSpouseHomeAddressPAFVersion varchar 10 √ null
FutureContactSpouseHomePhone varchar 15 √ null
FutureContactSpouseHomePhoneAlt varchar 15 √ null
FutureContactSpouseHomeFax varchar 15 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
FutureSiblingRelationship varchar 30 √ null
FutureSubSchool varchar 15 √ null
LearningPathway varchar 30 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views