| Seq |
int identity |
4 |
|
√ |
null |
|
|
|
| ID |
int |
4 |
|
|
((0)) |
|
|
|
| IntegrationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| SaleDailyCreditLimit |
money |
21,4 |
|
|
((0)) |
|
|
|
| NewArrivalsProgramFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| PriorOvernightCampsFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| StudentTypeCode |
varchar |
15 |
|
|
('') |
|
|
|
| ResourceLevelCode |
varchar |
15 |
|
|
('') |
|
|
|
| SchoolZoneCode |
varchar |
15 |
|
|
('') |
|
|
|
| SystemProcessNumber |
int |
4 |
√ |
|
null |
|
|
|
| InitialSchoolingDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ModifiedDate |
datetime |
16,3 |
|
|
(getdate()) |
|
|
|
| ModifiedBy |
varchar |
50 |
√ |
|
null |
|
|
|
| FinanceAssistTypeCode |
varchar |
15 |
√ |
|
null |
|
|
|
| BenefitNumber |
varchar |
20 |
√ |
|
null |
|
|
|
| PaymentAmount |
money |
21,4 |
√ |
|
null |
|
|
|
| CandidateCount |
smallint |
2 |
√ |
|
null |
|
|
|
| ApplicationID |
varchar |
20 |
√ |
|
null |
|
|
|
| WithdrawnFlag |
bit |
1 |
√ |
|
null |
|
|
|
| TertiaryReleaseFlag |
bit |
1 |
√ |
|
null |
|
|
|
| ExportAddressOverrideFlag |
bit |
1 |
√ |
|
null |
|
|
|
| ExportAddress1 |
varchar |
40 |
√ |
|
null |
|
|
|
| ExportAddress2 |
varchar |
40 |
√ |
|
null |
|
|
|
| ExportAddress3 |
varchar |
40 |
√ |
|
null |
|
|
|
| ExportSuburb |
varchar |
40 |
√ |
|
null |
|
|
|
| ExportState |
varchar |
5 |
√ |
|
null |
|
|
|
| ExportCountryCode |
varchar |
5 |
√ |
|
null |
|
|
|
| ExportPostcode |
varchar |
15 |
√ |
|
null |
|
|
|
| EMAFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| UserFlag1 |
bit |
1 |
|
|
((0)) |
|
|
|
| UserFlag2 |
bit |
1 |
|
|
((0)) |
|
|
|
| UserFlag3 |
bit |
1 |
|
|
((0)) |
|
|
|
| UserFlag4 |
bit |
1 |
|
|
((0)) |
|
|
|
| UserFlag5 |
bit |
1 |
|
|
((0)) |
|
|
|
| MCEETYAFormReceivedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| TuitionWeeks |
int |
4 |
|
|
((0)) |
|
|
|
| TertiaryAchievedFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| ExchangeScheme |
varchar |
15 |
|
|
('') |
|
|
|
| ESLListeningLevelCode |
varchar |
15 |
√ |
|
null |
|
|
|
| ESLSpeakingLevelCode |
varchar |
15 |
√ |
|
null |
|
|
|
| ESLReadingLevelCode |
varchar |
15 |
√ |
|
null |
|
|
|
| ESLWritingLevelCode |
varchar |
15 |
√ |
|
null |
|
|
|
| AssistanceApproval |
varchar |
1 |
√ |
|
null |
|
|
|
|
bit |
1 |
√ |
|
null |
|
|
|
| PublishExamAnswerFlag |
bit |
1 |
√ |
|
null |
|
|
|
| PublishCareerInformationFlag |
bit |
1 |
√ |
|
null |
|
|
|
| PublishAwardsFlag |
bit |
1 |
√ |
|
null |
|
|
|
| IntendedQualificationCode |
varchar |
30 |
√ |
|
null |
|
|
|
| EligibilityCode |
varchar |
15 |
|
|
('') |
|
|
|
| VerificationDocumentCode |
varchar |
15 |
|
|
('') |
|
|
|
| SerialNumber |
varchar |
20 |
|
|
('') |
|
|
|
| IntendedTertiaryCourseCode |
varchar |
15 |
√ |
|
null |
|
|
|
| StudiesCodeURL |
varchar |
255 |
|
|
('') |
|
|
|
| GovernmentStudentNumber |
varchar |
15 |
|
|
('') |
|
|
|
| WaiverEndDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| AcademyFlag |
varchar |
1 |
√ |
|
('') |
|
|
|
| VerificationDocumentExpiryDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| OverrideEntryDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| SecondaryTertiaryProgramme |
varchar |
15 |
√ |
|
('') |
|
|
|
|
decimal |
8,2 |
√ |
|
null |
|
|
|
| YouthServicesSubmitContactDetailsFlag |
bit |
1 |
|
|
((1)) |
|
|
|
| EarlyLearningCode |
varchar |
15 |
|
|
('') |
|
|
|
| VocationalEducationCode |
varchar |
15 |
|
|
('') |
|
|
|
| IncludeInRollReturnFlag |
bit |
1 |
|
|
((1)) |
|
|
|
| STARFundedCourseDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| FundingApplicationFlag |
bit |
1 |
|
|
((0)) |
|
|
|