isaric_resstud_surv_table - isaric4c/wiki GitHub Wiki

[1] Database Table Field Name	[2] Field Data Type	[3] Variable Availability Date Range	[4] Field Length or Format	[5] Range of Values	[6] Completeness	[7] Constraints	[8] Representation of Missing Data	[9] Field Description	[10] Field Group	[11] Notes
STUDY_ID	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ACUITY	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ACUITY_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ARRIVAL_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ARRIVAL_MODE	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ARRIVAL_MODE_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ARRIVAL_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ASSESSMENT_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ASSESSMENT_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ATTENDANCE_CATEGORY	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ATTENDANCE_SOURCE	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ATTENDANCE_SOURCE_ORGANISATION	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ATTENDANCE_SOURCE_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CHIEF_COMPLAINT	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CHIEF_COMPLAINT_EXTENDED_CODE	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CHIEF_COMPLAINT_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CONCLUSION_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CONCLUSION_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CONVEYING_AMBULANCE_TRUST	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DECIDED_TO_ADMIT_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DECIDED_TO_ADMIT_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DEPARTURE_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DEPARTURE_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_DESTINATION	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_DESTINATION_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_FOLLOW_UP	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_FOLLOW_UP_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_INFORMATION_GIVEN	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_INFORMATION_GIVEN_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_STATUS	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_STATUS_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_STATUS	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_STATUS_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_TYPE	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_TYPE_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_INTENT	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_INTENT_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_MECHANISM	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_MECHANISM_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_1	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_10	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_11	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_12	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_2	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_3	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_4	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_5	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_6	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_7	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_8	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_DATE_9	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_1	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_10	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_11	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_12	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_2	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_3	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_4	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_5	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_6	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_7	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_8	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_TIME_9	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PERIOD_END_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PERIOD_LENGTH	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PERIOD_START_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PLACE_OF_INJURY	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PLACE_OF_INJURY_VALID_APPROVED	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEEN_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEEN_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_1	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_10	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_11	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_12	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_2	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_3	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_4	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_5	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_6	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_7	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_8	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_DATE_9	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_FUNCTION_CODE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_1	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_10	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_11	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_12	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_2	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_3	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_4	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_5	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_6	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_7	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_8	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_TIME_9	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_1	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_10	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_11	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_12	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_2	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_3	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_4	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_5	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_6	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_7	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_8	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_9	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]