vFutureStudentApplicationsAll


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
ApplicationSeq int 4 null
ApplicationEnrolDate datetime 16,3 √ null
ApplicationEnrolYear int 4 √ null
ApplicationEnrolMonth 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
FutureName varchar 100 √ null
FutureNameInternal varchar 100 √ null
FutureNameExternal varchar 150 √ 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
FutureOccupEmail varchar 100 √ null
FutureBirthDate datetime 16,3 √ null
FutureGender varchar 15 √ null
FutureMobilePhone varchar 15 √ null
FutureDefaultMobilePhone varchar 15 √ null
FutureOccupMobilePhone varchar 15 √ null
FutureEmail varchar 100 √ null
FutureEnquiryDate datetime 16,3 √ null
FutureApplicationDate datetime 16,3 √ null
FutureEnrolDate datetime 16,3 √ null
FutureEnrolYear int 4 √ null
FutureEnrolMonth int 4 √ null
FutureBoarder varchar 3 null
FutureBoarderType varchar 30 √ null
FutureBoardingHouse varchar 15 null
FutureCampus varchar 3 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
FutureStatusRankingGroup varchar 3 √ null
FuturePriority varchar 3 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
FuturePreviousSchool varchar 15 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
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
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
FutureDoctor2Name varchar 80 null
FutureDoctor2Phone varchar 15 null
FutureDoctorPhone2Alt varchar 15 null
FutureDoctor2Address varchar 200 null
FutureDentistName varchar 80 null
FutureDentistPhone 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
FutureEmergency2Name varchar 80 null
FutureEmergency2Address varchar 200 null
FutureEmergency2Phone varchar 15 null
FutureEmergency2PhoneAlt varchar 15 null
FutureEmergency2Relat varchar 5 null
FutureEmergency3Name varchar 80 null
FutureEmergency3Address varchar 200 null
FutureEmergency3Phone varchar 15 null
FutureEmergency3PhoneAlt varchar 15 null
FutureEmergency3Relat varchar 5 null
LegalPhotoWebFlag int 4 √ null
LegalPhotoPromFlag int 4 √ null
LegalPhotoPublicationFlag int 4 √ null
DeceasedDate datetime 16,3 √ null
DeceasedFlag bit 1 √ null
ConfigUseMainAppDateFlag bit 1 √ null
ConfigAppStatusIsMasterFlag bit 1 √ null
FutureNationalityCode varchar 5 √ null
FutureNationality2Code varchar 5 √ 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