     treatment_function_code             varchar(12),
     discharge_status                    varchar(20) COMMENT 'Snomed coded',
     discharge_destination               varchar(20),
+    discharge_destination_site_id       varchar(20),
     conclusion_date                     datetime,
     departure_date                      datetime,
     mh_classifications                  mediumtext   COMMENT 'code~start datetime~end datetime in upto 10 | delimetered groups',

    treatment_function_code             varchar(12),
    discharge_status                    varchar(20) COMMENT 'Snomed coded',
    discharge_destination               varchar(20),
    conclusion_date                     datetime,
    departure_date                      datetime,
    mh_classifications                  mediumtext   COMMENT 'code~start datetime~end datetime in upto 10 | delimetered groups',

    patient_pathway_identifier          varchar(20)  COMMENT 'links to the EpisodeId from the tail file if present',
    department_type                     varchar(20),
    ambulance_incident_number           varchar(50),
    treatment_organisation_code         varchar(12)  COMMENT 'emergency care organisation ods code',
    attendance_identifier               varchar(20),
    arrival_mode                        varchar(20),
    attendance_category                 varchar(12),
