vFutureStudentAppContactAddr


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ApplicationSeq int 4 null
ApplicationEnrolDate datetime 16,3 √ null
ApplicationEnrolYear int 4 √ null
ApplicationEnrolMonth int 4 √ null
ApplicationID int 4 null
ApplicationCampus varchar 3 null
ApplicationYearLevel smallint 2 null
ApplicationStatus varchar 3 null
ApplicationBoarder varchar 3 null
ApplicationReviewFlag bit 1 null
ApplicationComment varchar 255 null
ApplicationStatusChangeDate datetime 16,3 √ null
ApplicationYearStatusRanking int 4 √ null
ApplicationDate datetime 16,3 √ null
ApplicationCategory varchar 15 null
ApplicationCategoryDescription varchar 100 √ null
ID int 4 null
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
FuturePublishToAssociatedFlag bit 1 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
FutureBoardingHouse varchar 15 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
FutureIntendsTertiaryFlag bit 1 null
FutureContactID int 4 √ null
FutureContactPrimaryOnlyFlag bit 1 √ null
FutureContactNormalMailFlag bit 1 √ null
FutureContactReportsFlag bit 1 √ null
FutureContactParentFlag bit 1 √ null
FutureContactLivesWithFlag 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
FutureContactPublishToAssociatedFlag bit 1 √ 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
FutureContactSpousePublishToAssociatedFlag bit 1 √ 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
ContactRelationship varchar 5 √ null
ContactRelationshipDescription varchar 30 √ null
ContactSpouseRelationship varchar 5 √ null
ContactSpouseRelationshipDescription varchar 30 √ null
ApplicationSubSchool varchar 15 √ null
FutureSubSchool varchar 15 √ null
LearningPathway varchar 30 null
FutureGenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views