ECDS_main_table - isaric4c/wiki GitHub Wiki

[1] Database Table Field Name	[2] Field Data Type	[3] Field Length or Format	[4] Range of Values	[5] Constraints	[6] Representation of Missing Data	[7] Field Description	[8] Sensitive Field	[9] Identifiable Field	[10] Field_Group	[11] Notes
STUDY_ID	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ACUITY	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ACUITY_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ARRIVAL_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ARRIVAL_MODE	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ARRIVAL_MODE_VALID_APPROVED	REAL	[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	REAL	[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	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CHIEF_COMPLAINT	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CHIEF_COMPLAINT_EXTENDED_CODE	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CHIEF_COMPLAINT_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_9	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMORBIDITIES_VALID_APPROVED_9	REAL	[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	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_CODE_9	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_QUALIFIER_9	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DIAGNOSIS_VALID_APPROVED_9	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_DESTINATION	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_DESTINATION_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_FOLLOW_UP	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_FOLLOW_UP_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_INFORMATION_GIVEN	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_INFORMATION_GIVEN_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_STATUS	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHARGE_STATUS_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DRUG_ALCOHOL_CODE_VALID_APPROVED_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_STATUS	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_STATUS_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_TYPE	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_ACTIVITY_TYPE_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_INTENT	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_INTENT_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_MECHANISM	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_MECHANISM_VALID_APPROVED	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INJURY_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATION_CODE_9	REAL	[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	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INVESTIGATIONS_VALID_APPROVED_9	REAL	[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	REAL	[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	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PLACE_OF_INJURY_VALID_APPROVED	REAL	[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	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SEQUENCE_NUMBER_9	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_1	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENT_CODE_9	REAL	[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	REAL	[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	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_10	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_11	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_12	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_2	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_3	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_4	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_5	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_6	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_7	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_8	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TREATMENTS_VALID_APPROVED_9	REAL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
EPCC_DATE_RECEIVED	DATE	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
EPCC_DATE_INSERTED	TIMESTAMP	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]