| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| Seq |
int identity |
4 |
|
√ |
null |
|
|
|
| ID |
int |
4 |
|
|
((0)) |
|
|
|
| CreatedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| CreatedBy |
varchar |
50 |
√ |
|
('') |
|
|
|
| ModifiedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ModifiedBy |
varchar |
50 |
√ |
|
('') |
|
|
|
| Operator |
varchar |
30 |
|
|
('') |
|
|
|
| StudiesCode |
varchar |
15 |
|
|
('') |
|
|
|
| TertiaryRegistrationCode |
varchar |
15 |
|
|
('') |
|
|
|
| TimeTableCode |
varchar |
15 |
|
|
('') |
|
|
|
| AltCode |
varchar |
15 |
|
|
('') |
|
|
|
| DebtorID |
int |
4 |
|
|
((0)) |
|
|
|
| DebtorIDSeq |
smallint |
2 |
|
|
((0)) |
|
|
|
| N16StuCode |
varchar |
50 |
|
|
('') |
|
|
|
| N16ParCode |
varchar |
50 |
|
|
('') |
|
|
|
| N16DebCode |
varchar |
50 |
|
|
('') |
|
|
|
| AgeYearsJan |
smallint |
2 |
|
|
((0)) |
|
|
|
| AgeMonthsJan |
smallint |
2 |
|
|
((0)) |
|
|
|
| FamilyPosition |
smallint |
2 |
|
|
((0)) |
|
|
|
| EldestFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| YoungestFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| EntryDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| EntryCampus |
varchar |
3 |
|
|
('') |
|
|
|
| EntryYearLevel |
smallint |
2 |
√ |
|
null |
|
|
|
| EnquirySource |
varchar |
10 |
|
|
('') |
|
|
|
|
varchar |
50 |
|
|
('') |
|
|
|
| PreviousSchool |
varchar |
15 |
|
|
('') |
|
|
|
| MedicalAlert |
varchar |
2000 |
√ |
|
('') |
|
|
|
| ExternalStudentFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| EnglishSecondFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| DisabilityFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| FullFeeFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| TuitionVariationType |
varchar |
3 |
|
|
('') |
|
|
|
| TuitionNoSibFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| DoctorName |
varchar |
80 |
|
|
('') |
|
|
|
| DoctorPhone |
varchar |
15 |
|
|
('') |
|
|
|
| DoctorPhoneAlt |
varchar |
15 |
|
|
('') |
|
|
|
| DoctorAddress |
varchar |
200 |
|
|
('') |
|
|
|
| DoctorSpecialisation |
varchar |
50 |
|
|
('') |
|
|
|
| Doctor2Name |
varchar |
80 |
|
|
('') |
|
|
|
| Doctor2Phone |
varchar |
15 |
|
|
('') |
|
|
|
| Doctor2PhoneAlt |
varchar |
15 |
|
|
('') |
|
|
|
| Doctor2Address |
varchar |
200 |
|
|
('') |
|
|
|
| Doctor2Specialisation |
varchar |
50 |
|
|
('') |
|
|
|
| DentistName |
varchar |
80 |
|
|
('') |
|
|
|
| DentistPhone |
varchar |
15 |
|
|
('') |
|
|
|
| DentistPhoneAlt |
varchar |
15 |
|
|
('') |
|
|
|
| DentistAddress |
varchar |
200 |
|
|
('') |
|
|
|
| EmergencyName |
varchar |
80 |
|
|
('') |
|
|
|
| EmergencyAddress |
varchar |
200 |
|
|
('') |
|
|
|
| EmergencyPhone |
varchar |
15 |
|
|
('') |
|
|
|
| EmergencyPhoneAlt |
varchar |
15 |
|
|
('') |
|
|
|
| EmergencyRelat |
varchar |
5 |
√ |
|
('') |
|
|
|
| Emergency2Name |
varchar |
80 |
|
|
('') |
|
|
|
| Emergency2Address |
varchar |
200 |
|
|
('') |
|
|
|
| Emergency2Phone |
varchar |
15 |
|
|
('') |
|
|
|
| Emergency2PhoneAlt |
varchar |
15 |
|
|
('') |
|
|
|
| Emergency2Relat |
varchar |
5 |
√ |
|
('') |
|
|
|
| LastLessonRcvdDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| BirthCertificateFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| NonResidentFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| CrecheFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| BeforeSchoolCareFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| AfterSchoolCareFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| VisaType |
varchar |
5 |
|
|
('') |
|
|
|
| VisaExpiryDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| PassportNo |
varchar |
15 |
|
|
('') |
|
|
|
|
varchar |
2147483647 |
√ |
|
null |
|
|
|
|
bit |
1 |
|
|
((0)) |
|
|
|
| BaptismFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| BaptismDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ReconciliationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| ReconciliationDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| CommunionFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| CommunionDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ConfirmationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| ConfirmationDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| AustudyFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| IndigenousFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| NaturalisationDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| DebtorPrimaryOnlyFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| StudentBillingFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| AllowAutoTuitionFlag |
bit |
1 |
|
|
((1)) |
|
|
|
| AllowAutoChargesFlag |
bit |
1 |
|
|
((1)) |
|
|
|
| VisaNumber |
varchar |
20 |
|
|
('') |
|
|
|
| PassportCountryCode |
varchar |
5 |
|
|
('') |
|
|
|
| PassportExpiryDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ApplicationDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| Emergency3Name |
varchar |
80 |
|
|
('') |
|
|
|
| Emergency3Address |
varchar |
200 |
|
|
('') |
|
|
|
| Emergency3Phone |
varchar |
15 |
|
|
('') |
|
|
|
| Emergency3PhoneAlt |
varchar |
15 |
|
|
('') |
|
|
|
| Emergency3Relat |
varchar |
5 |
|
|
('') |
|
|
|
| MedicalAlertFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| SpecialNeedsFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| SpecialBillingType |
varchar |
5 |
|
|
('') |
|
|
|
| StudyAtHomeFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| TSIFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| ESLProficiencyLevel |
varchar |
15 |
|
|
('') |
|
|
|
|
varchar |
2147483647 |
√ |
|
null |
|
|
|
| EnquiryDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| IntendsTertiaryFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| PassportIssuedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| VisaIssuedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| EmergencyID |
int |
4 |
|
|
((0)) |
|
|
|
| Emergency2ID |
int |
4 |
|
|
((0)) |
|
|
|
| Emergency3ID |
int |
4 |
|
|
((0)) |
|
|
|
| SystemProcessNumber |
int |
4 |
√ |
|
null |
|
|
|
| LastRequestedDetailsDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| TransactionGUID |
uniqueidentifier |
16 |
√ |
|
null |
|
|
|
| TransactionMode |
char |
1 |
√ |
|
null |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| PK_Seq |
Primary key |
Asc |
Seq |
| AK_StudentsHistory_ID |
Performance |
Asc |
ID |
| AK_TransactionGUID |
Performance |
Asc |
TransactionGUID |