vxeIDCStudents


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

View Definition


Possibly Referenced Tables/Views