Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FutureStudentID | int | 4 | null |
|
|
|||
| FutureContactType | varchar | 3 | null |
|
|
|||
| FutureNameInternal | varchar | 100 | null |
|
|
|||
| FutureNameExternal | varchar | 100 | null |
|
|
|||
| FutureLegalFullName | varchar | 150 | null |
|
|
|||
| FuturePreferredFormal | varchar | 20 | null |
|
|
|||
| FutureGiven1 | varchar | 20 | null |
|
|
|||
| FutureGiven2 | varchar | 50 | null |
|
|
|||
| FutureSurname | varchar | 30 | null |
|
|
|||
| FutureBirthDate | datetime | 16,3 | √ | null |
|
|
||
| Gender | varchar | 15 | null |
|
|
|||
| EnquiryDate | datetime | 16,3 | √ | null |
|
|
||
| ApplicationDate | datetime | 16,3 | √ | null |
|
|
||
| EnrolDate | datetime | 16,3 | √ | null |
|
|
||
| Status | varchar | 3 | null |
|
|
|||
| StatusChangeDate | datetime | 16,3 | √ | null |
|
|
||
| StatusChangeDescription | varchar | 30 | null |
|
|
|||
| Priority | varchar | 3 | null |
|
|
|||
| Campus | varchar | 3 | null |
|
|
|||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| House | varchar | 5 | null |
|
|
|||
| Form | varchar | 15 | null |
|
|
|||
| Tutor | varchar | 15 | null |
|
|
|||
| FullFeeFlag | bit | 1 | null |
|
|
|||
| TuitionVariationType | varchar | 3 | null |
|
|
|||
| Boarder | varchar | 3 | null |
|
|
|||
| BoardingHouse | varchar | 15 | 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 |
|
|
|||
| FutureSpecialBillingType | varchar | 5 | null |
|
|
|||
| FutureBarcode | varchar | 20 | null |
|
|
|||
| FutureAustudyFlag | bit | 1 | null |
|
|
|||
| FutureStudyAtHomeFlag | bit | 1 | null |
|
|
|||
| FutureIndigenousFlag | bit | 1 | null |
|
|
|||
| FutureTSIFlag | bit | 1 | null |
|
|
|||
| FutureNaturalisationDate | datetime | 16,3 | √ | null |
|
|
||
| FutureMedicalAlertFlag | bit | 1 | null |
|
|
|||
| FutureSpecialNeedsFlag | bit | 1 | null |
|
|
|||
| FutureIntendsTertiaryFlag | bit | 1 | null |
|
|
|||
| LegalPhotoWebFlag | bit | 1 | √ | null |
|
|
||
| LegalPhotoPromFlag | bit | 1 | √ | null |
|
|
||
| LegalPhotoPublicationFlag | bit | 1 | √ | null |
|
|
||
| FutureContactMailName | varchar | 100 | null |
|
|
|||
| FutureContactMailSalutation | varchar | 100 | null |
|
|
|||
| FutureContactAddressComma | varchar | 200 | √ | null |
|
|
||
| FutureContactAddressFull | varchar | 200 | √ | null |
|
|
||
| FutureContactSuburb | varchar | 40 | null |
|
|
|||
| FutureContactState | varchar | 5 | null |
|
|
|||
| FutureContactPostCode | varchar | 5 | null |
|
|
|||
| FutureContactCoutryCode | varchar | 5 | null |
|
|
|||
| FutureContactAddressDPID | varchar | 8 | null |
|
|
|||
| FutureContactAddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| FutureContactAddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| FutureContactAddressPAFVersion | varchar | 10 | null |
|
|
|||
| FutureContactID | int | 4 | null |
|
|
|||
| FutureContactSpouseID | int | 4 | null |
|
|
|||
| FutureContactNormalMailFlag | bit | 1 | null |
|
|
|||
| FutureContactReportsFlag | bit | 1 | null |
|
|
|||
| FutureContactParentFlag | bit | 1 | null |
|
|
|||
| FutureContactLivesWithFlag | bit | 1 | null |
|
|
|||
| SubSchool | varchar | 15 | √ | null |
|
|
Table contained 0 rows