Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
Record_sta | int | 4 | null |
|
|
|||
Remote_Fax | varchar | 15 | √ | null |
|
|
||
Remote_Cmp | varchar | 15 | null |
|
|
|||
ReservedSystemProcessNumber | int | 4 | null |
|
|
|||
ID | int | 4 | null |
|
|
|||
Title | varchar | 30 | null |
|
|
|||
Sname | varchar | 30 | null |
|
|
|||
Given1 | varchar | 20 | null |
|
|
|||
Pref | varchar | 20 | null |
|
|
|||
Given2 | varchar | 50 | null |
|
|
|||
Gender | varchar | 15 | null |
|
|
|||
BirthDt | varchar | 10 | √ | null |
|
|
||
Relig | varchar | 40 | null |
|
|
|||
Parish | varchar | 30 | null |
|
|
|||
Nat | varchar | 40 | null |
|
|
|||
Nat2 | varchar | 40 | null |
|
|
|||
CtryBirth | varchar | 40 | √ | null |
|
|
||
HmLang | varchar | 30 | null |
|
|
|||
NatDt | varchar | 10 | √ | null |
|
|
||
ExtStu | varchar | 1 | null |
|
|
|||
BirthCert | varchar | 1 | null |
|
|
|||
Indig | varchar | 1 | null |
|
|
|||
Allowance | varchar | 1 | null |
|
|
|||
ESL | varchar | 1 | null |
|
|
|||
NonRes | varchar | 1 | null |
|
|
|||
TSI | varchar | 1 | null |
|
|
|||
IB | varchar | 1 | null |
|
|
|||
SN | varchar | 1 | null |
|
|
|||
Disab | varchar | 1 | null |
|
|
|||
VisaType | varchar | 30 | null |
|
|
|||
VisaExpDt | varchar | 10 | √ | null |
|
|
||
VisaNo | varchar | 20 | null |
|
|
|||
PassCtry | varchar | 40 | null |
|
|
|||
PassExpiryDt | varchar | 10 | √ | null |
|
|
||
PassNo | varchar | 15 | null |
|
|
|||
Bap | varchar | 1 | null |
|
|
|||
BapDt | varchar | 50 | √ | null |
|
|
||
Recon | varchar | 1 | null |
|
|
|||
ReconDt | varchar | 10 | √ | null |
|
|
||
Comm | varchar | 1 | null |
|
|
|||
CommDt | varchar | 50 | √ | null |
|
|
||
Conf | varchar | 1 | null |
|
|
|||
ConfDt | varchar | 10 | √ | null |
|
|
||
YearLevel | varchar | 2 | null |
|
|
|||
Form | varchar | 15 | null |
|
|
|||
House | varchar | 30 | null |
|
|
|||
LockBook | varchar | 15 | null |
|
|
|||
LockOther | varchar | 15 | null |
|
|
|||
TransAM | varchar | 15 | null |
|
|
|||
TransAMBus | varchar | 10 | null |
|
|
|||
TransAMDesc | varchar | 50 | null |
|
|
|||
TransPM | varchar | 15 | null |
|
|
|||
TransPMBus | varchar | 10 | null |
|
|
|||
TransPMDesc | varchar | 50 | null |
|
|
|||
MailTo | varchar | 1 | null |
|
|
|||
ReportsTo | varchar | 1 | null |
|
|
|||
DoctorName | varchar | 80 | null |
|
|
|||
DoctorPh | varchar | 15 | null |
|
|
|||
DoctorPhAlt | varchar | 15 | null |
|
|
|||
DoctorAdd | varchar | 200 | null |
|
|
|||
Doctor2Name | varchar | 80 | null |
|
|
|||
Doctor2Ph | varchar | 15 | null |
|
|
|||
Doctor2PhAlt | varchar | 15 | null |
|
|
|||
Doctor2Add | varchar | 200 | null |
|
|
|||
DentistName | varchar | 80 | null |
|
|
|||
DentistPh | varchar | 15 | null |
|
|
|||
DentistPhAlt | varchar | 15 | null |
|
|
|||
DentistAdd | varchar | 200 | null |
|
|
|||
EmerName | varchar | 80 | null |
|
|
|||
EmerAdd | varchar | 200 | null |
|
|
|||
EmerPh | varchar | 15 | null |
|
|
|||
EmerPhAlt | varchar | 15 | null |
|
|
|||
EmerRelat | varchar | 30 | null |
|
|
|||
Emer2Name | varchar | 80 | null |
|
|
|||
Emer2Add | varchar | 200 | null |
|
|
|||
Emer2Ph | varchar | 15 | null |
|
|
|||
Emer2PhAlt | varchar | 15 | null |
|
|
|||
Emer2Relat | varchar | 30 | null |
|
|
|||
Emer3Name | varchar | 80 | null |
|
|
|||
Emer3Add | varchar | 200 | null |
|
|
|||
Emer3Ph | varchar | 15 | null |
|
|
|||
Emer3PhAlt | varchar | 15 | null |
|
|
|||
Emer3Relat | varchar | 30 | null |
|
|
|||
MedicalCons | varchar | 1 | null |
|
|
|||
AmbCons | varchar | 1 | null |
|
|
|||
SwimOK | varchar | 1 | null |
|
|
|||
OperationCons | varchar | 1 | null |
|
|
|||
SportCons | varchar | 1 | null |
|
|
|||
Swim50Metres | varchar | 3 | null |
|
|
|||
AnaestheticCons | varchar | 1 | null |
|
|
|||
ParacetamolCons | varchar | 1 | null |
|
|
|||
BloodCons | varchar | 1 | null |
|
|
|||
BloodGroup | varchar | 3 | null |
|
|
|||
ConsRefusalComment | varchar | 2147483647 | √ | null |
|
|
||
PrivateIns | varchar | 1 | null |
|
|
|||
PrivateInsFund | varchar | 40 | null |
|
|
|||
PrivateInsNo | varchar | 30 | null |
|
|
|||
Amb | varchar | 1 | null |
|
|
|||
AmbNo | varchar | 12 | null |
|
|
|||
MedCaNo | varchar | 12 | null |
|
|
|||
MedCaLineNo | varchar | 1 | null |
|
|
|||
MedCaExpiryDt | varchar | 10 | √ | null |
|
|
||
ImmForm | varchar | 1 | null |
|
|
|||
ImmFormDt | varchar | 10 | √ | null |
|
|
||
DTPImm | varchar | 1 | null |
|
|
|||
DTPImmDt | varchar | 10 | √ | null |
|
|
||
ADTImm | varchar | 1 | null |
|
|
|||
ADTImmDt | varchar | 10 | √ | null |
|
|
||
DipImm | varchar | 1 | null |
|
|
|||
DipImmDt | varchar | 10 | √ | null |
|
|
||
TetImm | varchar | 1 | null |
|
|
|||
TetImmDt | varchar | 10 | √ | null |
|
|
||
WhpImm | varchar | 1 | null |
|
|
|||
WhpImmDt | varchar | 10 | √ | null |
|
|
||
MMRImm | varchar | 1 | null |
|
|
|||
MMRImmDt | varchar | 10 | √ | null |
|
|
||
MeasImm | varchar | 1 | null |
|
|
|||
MeasImmDt | varchar | 10 | √ | null |
|
|
||
MmpImm | varchar | 1 | null |
|
|
|||
MmpImmDt | varchar | 10 | √ | null |
|
|
||
RubImm | varchar | 1 | null |
|
|
|||
RubImmDt | varchar | 10 | √ | null |
|
|
||
HepAImm | varchar | 1 | null |
|
|
|||
HepAImmDt | varchar | 10 | √ | null |
|
|
||
HepBImm | varchar | 1 | null |
|
|
|||
HepBImmDt | varchar | 10 | √ | null |
|
|
||
HIBImm | varchar | 1 | null |
|
|
|||
HIBImmDt | varchar | 10 | √ | null |
|
|
||
InfImm | varchar | 1 | null |
|
|
|||
InfImmDt | varchar | 10 | √ | null |
|
|
||
PolioImm | varchar | 1 | null |
|
|
|||
PolioImmDt | varchar | 10 | √ | null |
|
|
||
MeninCImm | varchar | 1 | null |
|
|
|||
MeninCImmDt | varchar | 10 | √ | null |
|
|
||
CPoxImm | varchar | 1 | null |
|
|
|||
CPoxImmDt | varchar | 10 | √ | null |
|
|
||
TBImm | varchar | 1 | null |
|
|
|||
TBImmDt | varchar | 10 | √ | null |
|
|
||
ChoImm | varchar | 1 | null |
|
|
|||
ChoImmDt | varchar | 10 | √ | null |
|
|
||
TypImm | varchar | 1 | null |
|
|
|||
TypImmDt | varchar | 10 | √ | null |
|
|
||
SwineFlu | bit | 1 | null |
|
|
|||
SwineFluDt | datetime | 16,3 | √ | null |
|
|
||
MeningococcalB | bit | 1 | null |
|
|
|||
MeningococcalBDt | datetime | 16,3 | √ | null |
|
|
||
GlandChronicDet | varchar | 2147483647 | √ | null |
|
|
||
DiabDet | varchar | 2147483647 | √ | null |
|
|
||
EpistaxisDet | varchar | 2147483647 | √ | null |
|
|
||
EczemaDet | varchar | 2147483647 | √ | null |
|
|
||
PeriodPainDet | varchar | 2147483647 | √ | null |
|
|
||
TravelSickDet | varchar | 2147483647 | √ | null |
|
|
||
HearTestDt | varchar | 10 | √ | null |
|
|
||
HearAid | varchar | 1 | null |
|
|
|||
HearTestResult | varchar | 2147483647 | √ | null |
|
|
||
EyeTestDt | varchar | 10 | √ | null |
|
|
||
EyeGlasses | varchar | 1 | null |
|
|
|||
EyeContactLenses | varchar | 1 | null |
|
|
|||
EyeTestResult | varchar | 2147483647 | √ | null |
|
|
||
SpeechTestDt | varchar | 10 | √ | null |
|
|
||
SpeechTestResult | varchar | 2147483647 | √ | null |
|
|
||
FamilyBackground | varchar | 2147483647 | √ | null |
|
|
||
EmotProblems | varchar | 2147483647 | √ | null |
|
|
||
ReligReq | varchar | 2147483647 | √ | null |
|
|
||
Diet | varchar | 2147483647 | √ | null |
|
|
||
Disabilities | varchar | 2147483647 | √ | null |
|
|
||
Misc | varchar | 2147483647 | √ | null |
|
|
||
Asthma | varchar | 1 | null |
|
|
|||
AsthmaCat | varchar | 5 | null |
|
|
|||
AsthmaHospDt | varchar | 10 | √ | null |
|
|
||
AsthmaTrig | varchar | 2147483647 | √ | null |
|
|
||
AsthmaPrevMed | varchar | 2147483647 | √ | null |
|
|
||
AsthmaRelMed | varchar | 2147483647 | √ | null |
|
|
||
AsthmaNormPF | smallint | 2 | null |
|
|
|||
AsthmaLowPF | smallint | 2 | √ | null |
|
|
||
AsthmaDoctorPF | smallint | 2 | √ | null |
|
|
||
AsthmaAction | varchar | 2147483647 | √ | null |
|
|
||
AsthmaUsualSympt | varchar | 2147483647 | √ | null |
|
|
||
AsthmaWorseSympt | varchar | 2147483647 | √ | null |
|
|
||
Allergies | varchar | 2147483647 | √ | null |
|
|
||
Medications | varchar | 2147483647 | √ | null |
|
|
||
HeadInjDet | varchar | 2147483647 | √ | null |
|
|
||
EpilepsyDet | varchar | 2147483647 | √ | null |
|
|
||
MigraineDet | varchar | 2147483647 | √ | null |
|
|
||
Fractures | varchar | 2147483647 | √ | null |
|
|
||
Joints | varchar | 2147483647 | √ | null |
|
|
||
Arthritis | varchar | 2147483647 | √ | null |
|
|
||
SurglHist | varchar | 2147483647 | √ | null |
|
|
||
MedicalHist | varchar | 2147483647 | √ | null |
|
|
||
PhotoPub | varchar | 1 | null |
|
|
|||
StudyAtHm | varchar | 1 | null |
|
|
|||
C1ID_P | varchar | 7 | null |
|
|
|||
C1Sname_P | varchar | 30 | null |
|
|
|||
C1Title_P | varchar | 30 | null |
|
|
|||
C1Given1P | varchar | 20 | null |
|
|
|||
C1Given2P | varchar | 50 | null |
|
|
|||
C1Pref_P | varchar | 20 | null |
|
|
|||
C1Gender_P | varchar | 15 | null |
|
|
|||
C1Relat_P | varchar | 30 | null |
|
|
|||
C1MobilePh_P | varchar | 15 | null |
|
|
|||
C1Email_P | varchar | 100 | null |
|
|
|||
C1Occ_P | varchar | 40 | null |
|
|
|||
C1OccDesc_P | varchar | 50 | null |
|
|
|||
C1OccIndustry_P | varchar | 30 | null |
|
|
|||
C1OccPosition_P | varchar | 50 | null |
|
|
|||
C1OccCompany_P | varchar | 50 | null |
|
|
|||
C1OccAdd1P | varchar | 40 | null |
|
|
|||
C1OccAdd2P | varchar | 40 | null |
|
|
|||
C1OccSuburb_P | varchar | 40 | null |
|
|
|||
C1OccState_P | varchar | 5 | null |
|
|
|||
C1OccPcode_P | varchar | 5 | null |
|
|
|||
C1OccCtry_P | varchar | 40 | null |
|
|
|||
C1OccPh_P | varchar | 15 | null |
|
|
|||
C1OccMobilePh_P | varchar | 15 | null |
|
|
|||
C1OccFax_P | varchar | 15 | null |
|
|
|||
C1OccEmail_P | varchar | 100 | null |
|
|
|||
C1DefaultEmailCode_P | varchar | 1 | null |
|
|
|||
C1BirthDt_P | varchar | 10 | null |
|
|
|||
C1Relig_P | varchar | 30 | null |
|
|
|||
C1Parish_P | varchar | 30 | null |
|
|
|||
C1Nat_P | varchar | 40 | null |
|
|
|||
C1Nat2P | varchar | 40 | null |
|
|
|||
C1CtryBirth_P | varchar | 30 | null |
|
|
|||
C1HmLang_P | varchar | 30 | null |
|
|
|||
C1SnamePrev_P | varchar | 30 | null |
|
|
|||
C1ID_S | varchar | 10 | null |
|
|
|||
C1Sname_S | varchar | 30 | null |
|
|
|||
C1Title_S | varchar | 30 | null |
|
|
|||
C1Given1S | varchar | 20 | null |
|
|
|||
C1Given2S | varchar | 50 | null |
|
|
|||
C1Pref_S | varchar | 20 | null |
|
|
|||
C1Gender_S | varchar | 15 | null |
|
|
|||
C1Relat_S | varchar | 30 | null |
|
|
|||
C1MobilePh_S | varchar | 15 | null |
|
|
|||
C1Email_S | varchar | 100 | null |
|
|
|||
C1Occ_S | varchar | 50 | null |
|
|
|||
C1OccDesc_S | varchar | 50 | null |
|
|
|||
C1OccIndustry_S | varchar | 30 | null |
|
|
|||
C1OccPosition_S | varchar | 50 | null |
|
|
|||
C1OccCompany_S | varchar | 50 | null |
|
|
|||
C1OccAdd1S | varchar | 40 | null |
|
|
|||
C1OccAdd2S | varchar | 40 | null |
|
|
|||
C1OccSuburb_S | varchar | 40 | null |
|
|
|||
C1OccState_S | varchar | 5 | null |
|
|
|||
C1OccPcode_S | varchar | 5 | null |
|
|
|||
C1OccCtry_S | varchar | 40 | null |
|
|
|||
C1OccPh_S | varchar | 15 | null |
|
|
|||
C1OccMobilePh_S | varchar | 15 | null |
|
|
|||
C1OccFax_S | varchar | 15 | null |
|
|
|||
C1OccEmail_S | varchar | 100 | null |
|
|
|||
C1DefaultEmailCode_S | varchar | 1 | null |
|
|
|||
C1BirthDt_S | varchar | 10 | null |
|
|
|||
C1Relig_S | varchar | 30 | null |
|
|
|||
C1Parish_S | varchar | 30 | null |
|
|
|||
C1Nat_S | varchar | 40 | null |
|
|
|||
C1Nat2S | varchar | 40 | null |
|
|
|||
C1CtryBirth_S | varchar | 30 | null |
|
|
|||
C1HmLang_S | varchar | 30 | null |
|
|
|||
C1SnamePrev_S | varchar | 30 | null |
|
|
|||
C1HmAdd1 | varchar | 40 | null |
|
|
|||
C1HmAdd2 | varchar | 40 | null |
|
|
|||
C1HmAdd3 | varchar | 40 | null |
|
|
|||
C1HmSuburb | varchar | 40 | null |
|
|
|||
C1HmState | varchar | 5 | null |
|
|
|||
C1HmPcode | varchar | 5 | null |
|
|
|||
C1HmCtry | varchar | 30 | null |
|
|
|||
C1Add1 | varchar | 40 | null |
|
|
|||
C1Add2 | varchar | 40 | null |
|
|
|||
C1Add3 | varchar | 40 | null |
|
|
|||
C1Suburb | varchar | 40 | null |
|
|
|||
C1State | varchar | 5 | null |
|
|
|||
C1Pcode | varchar | 5 | null |
|
|
|||
C1Ctry | varchar | 30 | null |
|
|
|||
C1PhActual | varchar | 15 | null |
|
|
|||
C1PhAlt | varchar | 15 | null |
|
|
|||
C1Fax | varchar | 15 | null |
|
|
|||
C1SilentPh | varchar | 1 | null |
|
|
|||
C1LivesWith | varchar | 1 | null |
|
|
|||
C1Parent | varchar | 1 | null |
|
|
|||
C1PrimOnly | varchar | 1 | null |
|
|
|||
C1Mail | varchar | 1 | null |
|
|
|||
C1Reports | varchar | 1 | null |
|
|
|||
C1Mag | varchar | 1 | null |
|
|
|||
C1Relat | varchar | 30 | null |
|
|
|||
C2ID_P | varchar | 7 | null |
|
|
|||
C2Sname_P | varchar | 30 | null |
|
|
|||
C2Title_P | varchar | 30 | null |
|
|
|||
C2Given1P | varchar | 20 | null |
|
|
|||
C2Given2P | varchar | 50 | null |
|
|
|||
C2Pref_P | varchar | 20 | null |
|
|
|||
C2Gender_P | varchar | 15 | null |
|
|
|||
C2Relat_P | varchar | 30 | null |
|
|
|||
C2MobilePh_P | varchar | 15 | null |
|
|
|||
C2Email_P | varchar | 100 | null |
|
|
|||
C2Occ_P | varchar | 40 | null |
|
|
|||
C2OccDesc_P | varchar | 50 | null |
|
|
|||
C2OccIndustry_P | varchar | 30 | null |
|
|
|||
C2OccPosition_P | varchar | 50 | null |
|
|
|||
C2OccCompany_P | varchar | 50 | null |
|
|
|||
C2OccAdd1P | varchar | 40 | null |
|
|
|||
C2OccAdd2P | varchar | 40 | null |
|
|
|||
C2OccSuburb_P | varchar | 40 | null |
|
|
|||
C2OccState_P | varchar | 5 | null |
|
|
|||
C2OccPcode_P | varchar | 5 | null |
|
|
|||
C2OccCtry_P | varchar | 40 | null |
|
|
|||
C2OccPh_P | varchar | 15 | null |
|
|
|||
C2OccMobilePh_P | varchar | 15 | null |
|
|
|||
C2OccFax_P | varchar | 15 | null |
|
|
|||
C2OccEmail_P | varchar | 100 | null |
|
|
|||
C2DefaultEmailCode_P | varchar | 1 | null |
|
|
|||
C2BirthDt_P | varchar | 10 | null |
|
|
|||
C2Relig_P | varchar | 30 | null |
|
|
|||
C2Parish_P | varchar | 30 | null |
|
|
|||
C2Nat_P | varchar | 40 | null |
|
|
|||
C2Nat2P | varchar | 40 | null |
|
|
|||
C2CtryBirth_P | varchar | 30 | null |
|
|
|||
C2HmLang_P | varchar | 30 | null |
|
|
|||
C2SnamePrev_P | varchar | 30 | null |
|
|
|||
C2ID_S | varchar | 10 | null |
|
|
|||
C2Sname_S | varchar | 30 | null |
|
|
|||
C2Title_S | varchar | 30 | null |
|
|
|||
C2Given1S | varchar | 20 | null |
|
|
|||
C2Given2S | varchar | 50 | null |
|
|
|||
C2Pref_S | varchar | 20 | null |
|
|
|||
C2Gender_S | varchar | 15 | null |
|
|
|||
C2Relat_S | varchar | 30 | null |
|
|
|||
C2MobilePh_S | varchar | 15 | null |
|
|
|||
C2Email_S | varchar | 100 | null |
|
|
|||
C2Occ_S | varchar | 50 | null |
|
|
|||
C2OccDesc_S | varchar | 50 | null |
|
|
|||
C2OccIndustry_S | varchar | 30 | null |
|
|
|||
C2OccPosition_S | varchar | 50 | null |
|
|
|||
C2OccCompany_S | varchar | 50 | null |
|
|
|||
C2OccAdd1S | varchar | 40 | null |
|
|
|||
C2OccAdd2S | varchar | 40 | null |
|
|
|||
C2OccSuburb_S | varchar | 40 | null |
|
|
|||
C2OccState_S | varchar | 5 | null |
|
|
|||
C2OccPcode_S | varchar | 5 | null |
|
|
|||
C2OccCtry_S | varchar | 40 | null |
|
|
|||
C2OccPh_S | varchar | 15 | null |
|
|
|||
C2OccMobilePh_S | varchar | 15 | null |
|
|
|||
C2OccFax_S | varchar | 15 | null |
|
|
|||
C2OccEmail_S | varchar | 100 | null |
|
|
|||
C2DefaultEmailCode_S | varchar | 1 | null |
|
|
|||
C2BirthDt_S | varchar | 10 | null |
|
|
|||
C2Relig_S | varchar | 30 | null |
|
|
|||
C2Parish_S | varchar | 30 | null |
|
|
|||
C2Nat_S | varchar | 40 | null |
|
|
|||
C2Nat2S | varchar | 40 | null |
|
|
|||
C2CtryBirth_S | varchar | 30 | null |
|
|
|||
C2HmLang_S | varchar | 30 | null |
|
|
|||
C2SnamePrev_S | varchar | 30 | null |
|
|
|||
C2HmAdd1 | varchar | 40 | null |
|
|
|||
C2HmAdd2 | varchar | 40 | null |
|
|
|||
C2HmAdd3 | varchar | 40 | null |
|
|
|||
C2HmSuburb | varchar | 40 | null |
|
|
|||
C2HmState | varchar | 5 | null |
|
|
|||
C2HmPcode | varchar | 5 | null |
|
|
|||
C2HmCtry | varchar | 30 | null |
|
|
|||
C2Add1 | varchar | 40 | null |
|
|
|||
C2Add2 | varchar | 40 | null |
|
|
|||
C2Add3 | varchar | 40 | null |
|
|
|||
C2Suburb | varchar | 40 | null |
|
|
|||
C2State | varchar | 5 | null |
|
|
|||
C2Pcode | varchar | 5 | null |
|
|
|||
C2Ctry | varchar | 30 | null |
|
|
|||
C2PhActual | varchar | 15 | null |
|
|
|||
C2PhAlt | varchar | 15 | null |
|
|
|||
C2Fax | varchar | 15 | null |
|
|
|||
C2SilentPh | varchar | 1 | null |
|
|
|||
C2LivesWith | varchar | 1 | null |
|
|
|||
C2Parent | varchar | 1 | null |
|
|
|||
C2PrimOnly | varchar | 1 | null |
|
|
|||
C2Mail | varchar | 1 | null |
|
|
|||
C2Reports | varchar | 1 | null |
|
|
|||
C2Mag | varchar | 1 | null |
|
|
|||
C2Relat | varchar | 30 | null |
|
|
|||
Sname2 | varchar | 30 | null |
|
|
|||
Preferred2 | varchar | 20 | null |
|
|
|||
Form2 | varchar | 15 | null |
|
|
|||
SpeechImpairment | bit | 1 | null |
|
|
Table contained 0 rows