vFutureTransportContactAddress


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
FutureFullFeeFlag bit 1 null
FutureTuitionVariationType varchar 3 null
FutureAllowAutoTuitionFlag bit 1 null
FutureAllowAutoChargesFlag 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
FutureYearLevelDescription varchar 30 √ null
FutureYearLevelSort smallint 2 √ null
FutureCampusSort int 4 √ null
FutureCampusDescription varchar 30 √ 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
FutureIndigenousFlag bit 1 null
FutureTSIFlag bit 1 null
FutureStudyAtHomeFlag bit 1 null
FutureAustudyFlag bit 1 null
FutureMedicalAlertFlag bit 1 null
FutureSpecialNeedsFlag bit 1 null
FutureIntendsTertiaryFlag 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
FutureContactType varchar 3 √ null
FutureContactDescription varchar 30 √ 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
FutureContactMailName varchar 100 √ null
FutureContactMailSalutation varchar 100 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
TransportAMPM varchar 5 null
TransportSeq smallint 2 null
TransportCode varchar 15 null
TransportCodeDescription varchar 50 √ null
TransportDescription varchar 255 null
FutureTransportFeeCode varchar 15 √ null
TransportTravelFactor decimal 11,8 null
TransportTravelMondayFlag bit 1 null
TransportTravelTuesdayFlag bit 1 null
TransportTravelWednesdayFlag bit 1 null
TransportTravelThursdayFlag bit 1 null
TransportTravelFridayFlag bit 1 null
TransportTravelSaturdayFlag bit 1 null
TransportTravelSundayFlag bit 1 null
FutureTransportTravelDistance decimal 8,2 null
TransportOverrideTravelDistanceFlag bit 1 null
TransportStopCode varchar 30 null
TransportStopDescription varchar 100 √ null
TransportStopSortOrder smallint 2 √ null
TransportStopTravelDistance decimal 8,2 √ null
FutureTravelAllowanceFlag bit 1 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
FutureContactOccupDescription varchar 120 √ null
FutureContactOccupIndustryCode varchar 8 √ null
FutureContactOccupIndustryDescription varchar 100 √ null
FutureContactOccupPositionCode varchar 8 √ null
FutureContactOccupPositionDescription varchar 120 √ null
FutureContactOccupDescExtra varchar 50 √ null
FutureContactOccupDescIncludeAddressFlag bit 1 √ 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
FutureContactOccupAddressFull varchar 200 √ 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
FutureContactSilentPhoneFlag bit 1 √ 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
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
FutureContactSpouseSilentPhoneFlag bit 1 √ null
FutureContactSpouseOccupCode varchar 15 √ null
FutureContactSpouseOccupDescription varchar 120 √ null
FutureContactSpouseOccupIndustryCode varchar 8 √ null
FutureContactSpouseOccupIndustryDescription varchar 100 √ null
FutureContactSpouseOccupPositionCode varchar 8 √ null
FutureContactSpouseOccupPositionDescription varchar 120 √ null
FutureContactSpouseOccupDescExtra varchar 50 √ null
FutureContactSpouseOccupDescIncludeAddressFlag bit 1 √ 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
FutureContactSpouseOccupAddressFull varchar 200 √ null
ValidAddressFlag bit 1 √ null
ContactRelationship varchar 5 √ null
ContactRelationshipDescription varchar 30 √ null
ContactSpouseRelationship varchar 5 √ null
ContactSpouseRelationshipDescription varchar 30 √ null
TransportCapacity int 4 √ null
TransportActiveFlag bit 1 √ null
FutureSubSchool varchar 15 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views