     spell_start_time               time         COMMENT 'start time of hospital spell: HHSSMM',
     episode_number                 varchar(2),
     episode_start_site_code        varchar(12)  COMMENT 'location at start of episode',
+    episode_start_ward_code        varchar(12)  COMMENT 'ward at start of episode',
     episode_start_date             date         COMMENT 'episode start date: CCYYMMDD',
     episode_start_time             time         COMMENT 'episode start time: HHSSMM',
     episode_end_site_code          varchar(12)  COMMENT 'location at end of episode',
+    episode_end_ward_code          varchar(12)  COMMENT 'ward at end of episode',
     episode_end_date               date         COMMENT 'episode end date: CCYYMMDD',
     episode_end_time               time         COMMENT 'episode end time: HHSSMM',
     discharge_date                 date         COMMENT 'date of discharge: CCYYMMDD',

    date_of_birth         date COMMENT 'from PersonBirthDate',
    consultant_code       varchar(20) NOT NULL COMMENT 'GMC number of consultant, from AEStaffMemberCode',

    attendance_number               varchar(12),
    arrival_mode_code               char(1)      COMMENT 'LKP_CDS_AEA_ARRIVAL_MODE',
    attendance_category_code        char(1)      COMMENT 'LKP_AEA_ATTEND_CAT',

    date_of_birth                   date COMMENT 'from PersonBirthDate',
    consultant_code                 varchar(20) NOT NULL COMMENT 'GMC number of consultant, from ConsultantCode',

    patient_pathway_identifier      varchar(20)  COMMENT 'links to the EpisodeId from the tail file if present',
    appt_attendance_identifier      varchar(12),
    appt_attended_code              char(1)     COMMENT 'Attended or DNA code: LKP_CDS_ATTENDED',
    appt_outcome_code               char(1)     COMMENT 'LKP_CDS_ATTENDANCE_OUTCOME',
