vFutureStudentsAll


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FutureID int 4 null
FutureName varchar 51 null
FutureNameInternal varchar 100 null
FutureNameExternal varchar 100 null
FutureLegalFullName varchar 150 null
FutureSurname varchar 30 null
FutureTitle varchar 30 null
FutureInitials varchar 15 null
FutureSuffix varchar 20 null
FuturePreferred varchar 20 null
FuturePreferredFormal varchar 20 null
FutureGiven1 varchar 20 null
FutureGiven2 varchar 50 null
FutureOccupEmail varchar 100 null
FutureBirthDate datetime 16,3 √ null
FutureGender varchar 15 null
FutureMobilePhone varchar 15 null
FutureDefaultMobilePhone varchar 15 null
FutureEmail varchar 100 null
ReligionCode varchar 5 null
ReligionDescription varchar 40 √ null
FutureEnquiryDate datetime 16,3 √ null
FutureApplicationDate datetime 16,3 √ null
FutureEnrolDate datetime 16,3 √ null
FutureEnrolYear int 4 √ null
FutureEnrolMonth int 4 √ null
FutureCampus varchar 3 null
FutureBoarder varchar 3 null
FutureBoarderType varchar 30 √ null
FutureBoardingHouse varchar 15 null
FutureYearLevel smallint 2 √ null
FutureSuppEnrolDate1 datetime 16,3 √ null
FutureSuppCampus1 varchar 3 null
FutureSuppYearLevel1 smallint 2 √ null
FutureSuppEnrolDate2 datetime 16,3 √ null
FutureSuppCampus2 varchar 3 null
FutureSuppYearLevel2 smallint 2 √ null
FutureStatus varchar 3 null
FutureStatusChangeDate datetime 16,3 √ null
FutureStatusChangeDescription varchar 30 null
FutureStatusDescription varchar 30 √ null
FutureStatusSynergyMeaning varchar 30 √ null
FuturePriority varchar 3 null
FuturePriorityDescription varchar 30 √ null
FutureHouse varchar 5 null
FutureHouseDescription varchar 30 √ null
FutureHeadOfHouse varchar 100 √ null
FutureHouseCaptain varchar 100 √ null
FutureForm varchar 15 null
FutureTutor varchar 15 null
CourseClassificationCode varchar 8 null
FutureEnquirySource varchar 10 null
FutureEnquirySourceComment varchar 50 null
FuturePreviousSchoolCode varchar 15 null
FuturePreviousSchoolDescription varchar 100 √ null
FuturePreviousSchoolRSBNumber varchar 30 √ null
FutureStudentParishCode varchar 5 null
FutureStudentParishDescript varchar 50 √ null
FutureMedicalAlert varchar 2000 √ null
FutureExternalStudentFlag bit 1 null
FutureEnglishSecondFlag bit 1 null
FutureDisabilityFlag bit 1 null
FutureFullFeeFlag bit 1 null
FutureTuitionVariationType varchar 3 null
FutureTuitionNoSibFlag bit 1 null
FuturePhotoSubmittedFlag bit 1 null
FutureBirthCertificateFlag bit 1 null
FutureNonResidentFlag bit 1 null
FutureIBFlag bit 1 null
FutureIntendsTertiaryFlag bit 1 null
FutureImmunisedFlag bit 1 null
FutureCrecheFlag bit 1 null
FutureBeforeSchoolCareFlag bit 1 null
FutureAfterSchoolCareFlag bit 1 null
FutureVisaType varchar 5 null
FutureVisaExpiryDate datetime 16,3 √ null
FutureVisaNumber varchar 20 null
FutureVisaIssuedDate datetime 16,3 √ null
FuturePassportCountryCode varchar 5 null
FuturePassportExpiryDate datetime 16,3 √ null
FuturePassportNo varchar 15 null
FutureComment varchar 2147483647 √ null
FutureCommentWarningFlag bit 1 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
FutureNaturalisationDate datetime 16,3 √ null
FutureMedicalAlertFlag bit 1 null
FutureSpecialBillingType varchar 5 null
FutureStudyAtHomeFlag bit 1 null
FutureTSIFlag bit 1 null
FutureSpecialNeedsFlag bit 1 null
FutureESLProficiencyLevel varchar 15 null
FutureESLListeningLevelCode varchar 15 √ null
FutureESLSpeakingLevelCode varchar 15 √ null
FutureESLReadingLevelCode varchar 15 √ null
FutureESLWritingLevelCode varchar 15 √ null
FutureDoctorName varchar 80 null
FutureDoctorPhone varchar 15 null
FutureDoctorPhoneAlt varchar 15 null
FutureDoctorAddress varchar 200 null
FutureDoctorSpecialisation varchar 50 null
FutureDoctor2Name varchar 80 null
FutureDoctor2Phone varchar 15 null
FutureDoctorPhone2Alt varchar 15 null
FutureDoctor2Address varchar 200 null
FutureDoctor2Specialisation varchar 50 null
FutureDentistName varchar 80 null
FutureDentistPhone varchar 15 null
FutureDentistPhoneAlt varchar 15 null
FutureDentistAddress varchar 200 null
FutureEmergencyName varchar 80 null
FutureEmergencyAddress varchar 200 null
FutureEmergencyPhone varchar 15 null
FutureEmergencyPhoneAlt varchar 15 null
FutureEmergencyRelat varchar 5 null
FutureEmergencyRelatDescription varchar 30 √ null
FutureEmergency2Name varchar 80 null
FutureEmergency2Address varchar 200 null
FutureEmergency2Phone varchar 15 null
FutureEmergency2PhoneAlt varchar 15 null
FutureEmergency2Relat varchar 5 null
FutureEmergency2RelatDescription varchar 30 √ null
FutureEmergency3Name varchar 80 null
FutureEmergency3Address varchar 200 null
FutureEmergency3Phone varchar 15 null
FutureEmergency3PhoneAlt varchar 15 null
FutureEmergency3Relat varchar 5 null
FutureEmergency3RelatDescription varchar 30 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
MCEETYAFormReceivedDate datetime 16,3 √ null
FutureNationalityCode varchar 5 null
FutureNationality2Code varchar 5 null
FutureSubSchool varchar 15 √ null
IdamGuid uniqueidentifier 16 √ null
LearningPathway varchar 30 null
GenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views