Table: Data_Allergies Allergy_ID Number (Long) 4 Consult_ID Number (Long) 4 ClaDesc Text 50 ClaCode Number (Integer) 2 Drug Text 75 Generic Text 255 Reaction Text 255 Type Number (Byte) 1 Definate Yes/No 1 Generic_Specific_Reaction Yes/No 1 Ozcode Number (Long) 4 Deleted Yes/No 1 Table: Data_Consult_Summary ConsultSummary_ID Number (Long) 4 Consult_ID Number (Long) 4 Summary Text 255 Table: Data_Ethnicity Ethnicity_ID Number (Long) 4 Consult_iD Number (Long) 4 Country_ID Number (Integer) 2 Language_ID Number (Integer) 2 Occupation_ID Number (Long) 4 Aboriginal Yes/No 1 Torres_strait_islander Yes/No 1 Retired Yes/No 1 Deleted Yes/No 1 Table: Data_FH_Conditions Page: 4 Condition_ID Number (Long) 4 Member_iD Number (Long) 4 Consult_ID Number (Long) 4 Condition Text 50 Ozcode Number (Long) 4 Age_of_onset Text 3 Cause_of_death Yes/No 1 Comment Text 50 Deleted Yes/No 1 Table: Data_Fh_FMembers Page: 5 Member_ID Number (Long) 4 Consult_ID Number (Long) 4 Name Text 50 Date_of_birth Text 10 Relationship_ID Number (Byte) 1 Age_of_Death Text 3 Deleted Yes/No 1 Table: Data_Fh_Links Page: 6 Link_ID Number (Long) 4 Member_iD Number (Long) 4 Patient_ID Number (Long) 4 Consult_ID Number (Long) 4 Deleted Yes/No 1 Table: Data_Immunisations Page: 7 record_Id Number (Long) 4 consult_ID Number (Long) 4 Date_given Text 10 Vaccine_ID Number (Integer) 2 Schedule_ID Number (Integer) 2 Serial_No Text 20 Reaction Text 25 Deleted Yes/No 1 Table: Data_Links_Table_ProgressNotes Page: 8 Table_iD Number (Long) 4 Record_ID Number (Long) 4 ProgressNote_ID Number (Long) 4 Deleted Yes/No 1 Table: Data_Measurements Page: 9 Measurement_ID Number (Long) 4 Consult_Id Number (Long) 4 Type_ID Number (Long) 4 Measurement Number (Single) 4 Date_noted Date/Time 8 Comment Text 50 Deleted Yes/No 1 Table: Data_PastHistory Page: 10 PastHistory_ID Number (Long) 4 Consult_ID Number (Long) 4 Review_ID Number (Long) 4 Age_Onset Number (Integer) 2 Age_onset_Units Number (Byte) 1 Description_ID Number (Long) 4 Description Text 50 Notes Text 50 Side_of_Body Number (Byte) 1 Ozcode Number (Long) 4 Date Text 10 Active Yes/No 1 Operation Yes/No 1 Cause_of_death Yes/No 1 Confidential Yes/No 1 Significant Yes/No 1 Deleted Yes/No 1 Table: Data_ProgressNotes Page: 11 Progress_note_ID Number (Long) 4 Consult_ID Number (Long) 4 Segment_ID Number (Double) 8 Problem_ID Number (Double) 8 Problem_Text Text 50 Task_Description Text 50 Heading_ID Number (Double) 8 Display_Order Number (Integer) 2 Text Text 255 Table_ID Number (Long) 4 Record_Id Number (Long) 4 Deleted Yes/No 1 Table: Data_Recall_Reviews Page: 12 Review_ID Number (Long) 4 Consult_ID Number (Long) 4 Doctor_ID Text 8 Method_ID Number (Byte) 1 Length_ID Number (Byte) 1 Type_ID Number (Byte) 1 Description_ID Number (Long) 4 Description Text 50 Interval Number (Integer) 2 Unit_ID Number (Integer) 2 End Number (Integer) 2 Last_Date Date/Time 8 Trigger_recall Yes/No 1 Trigger_period Number (Byte) 1 Trigger_Method Number (Byte) 1 Memo Text 50 Dealt_With Yes/No 1 Overdue Yes/No 1 Deleted Yes/No 1 Table: Data_RecreationalDrugs Page: 13 Habit_ID Number (Long) 4 Consult_ID Number (Long) 4 Drug_ID Number (Integer) 2 qualifier Text 50 Deleted Yes/No 1 Table: Data_Referrals Page: 14 Referral_ID Number (Long) 4 Consult_ID Number (Long) 4 Tag Text 20 File_Name Text 75 Deleted Yes/No 1 Table: Data_Requests_Forms Page: 15 Form_ID Number (Long) 4 Consult_ID Number (Long) 4 Type_ID Number (Long) 4 Notes_ID Number (Long) 4 ClinicalNotes_ID Number (Long) 4 Deleted Yes/No 1 Requests_Summary Memo - Organisation_ID Number (Long) 4 Table: Data_Requests_FormsNotes Page: 16 ID Number (Long) 4 Notes Text 255 Table: Data_Requests_FormsRequests Page: 17 Record_ID Number (Long) 4 Form_ID Number (Long) 4 Request_ID Number (Long) 4 Provider_ID Number (Long) 4 Lateralisation_ID Number (Byte) 1 Deleted Yes/No 1 Table: Data_ScratchPad Page: 18 ScratchPad_ID Number (Long) 4 Consult_ID Number (Long) 4 Description Memo - Deleted Yes/No 1 Table: data_script_AIA Page: 19 Authority_ID Number (Long) 4 Indication Memo - valid Yes/No 1 Table: Data_Script_Display_Indications Page: 20 Indication Memo - Table: Data_Script_Instruction_Habits Page: 21 Instruction_ID Number (Long) 4 Drug Text 100 Doctor_ID Text 2 Formulation Text 60 Weighting Number (Long) 4 Table: Data_Script_Instructions Page: 22 Instruction_ID Number (Long) 4 Instruction Text 60 Unit_time Text 1 AM Text 5 Lunch Text 5 PM Text 5 Bed Text 5 PRN Number (Byte) 1 Table: Data_Script_Item_Dates Page: 23 ScriptDate_ID Number (Long) 4 Start_Date Date/Time 8 Last_Date Date/Time 8 Consult_Last_Prescribed Number (Long) 4 Deleted Yes/No 1 Table: Data_Script_Items Page: 24 ScriptItem_ID Number (Long) 4 Consult_ID Number (Long) 4 Rx_ID Number (Long) 4 Instruction_ID Number (Long) 4 PrescribedFor_ID Number (Long) 4 ScriptDate_ID Number (Long) 4 Authority_ID Number (Long) 4 Print_Status Text 4 Suppress_Reason Text 1 Repeats Number (Integer) 2 Quantity Number (Integer) 2 Incr_Quantity_via_Auth Yes/No 1 S8 Yes/No 1 Current_Medication Yes/No 1 Deleted Yes/No 1 Table: Data_Script_Prescribed_For Page: 25 PrescribedFor_ID Number (Long) 4 Prescribed_For Text 50 Ozcode Number (Long) 4 Table: Data_Script_Prescribed_for_Habits Page: 26 PrescribedFor_ID Number (Long) 4 Drug Text 100 Doctor_ID Text 2 weighting Number (Long) 4 Table: Data_Script_RxDetails Page: 27 Rx_ID Number (Long) 4 Drug Text 100 Generic Text 255 Active Text 50 Active_units Text 20 per_volume Text 20 per_vol_units Text 20 unit_volume Text 20 unit_vol_units Text 20 Formulation Text 60 ClassCodes Text 50 Section Number (Integer) 2 SubSection Text 1 Valid Yes/No 1 Weighting Number (Long) 4 Table: Data_SocialHistory Page: 28 SocialHistory_ID Number (Long) 4 Consult_ID Number (Long) 4 Description Memo - Deleted Yes/No 1