     procedure_seq_nbr    int COMMENT 'from PROCEDURE_SEQ_NBR',
     lookup_person_id     int COMMENT 'pre-looked up via ENCNTR_ID',
     lookup_mrn           varchar(10) COMMENT 'looked up via ENCNTR_ID',
-    lookup_nhs_number    varchar(10) COMMENT 'patient NHS number, looked up via ENCNTR_ID',
-    lookup_date_of_birth datetime COMMENT 'patient NHS number, looked up via ENCNTR_ID',
     audit_json           mediumtext null comment 'Used for Audit Purposes',
     CONSTRAINT pk_PROCE PRIMARY KEY (exchange_id, procedure_id)
 );
+
+-- index to make it easier to find last checksum for a record
+CREATE INDEX ix_procedure_PROCE_checksum_helper on procedure_PROCE (procedure_id, dt_received);
+
 
 create table procedure_PROCE_latest
 (

    CONSTRAINT pk_SURCC PRIMARY KEY (exchange_id, surgical_case_id)
);

create table procedure_SURCC_latest
(
    exchange_id         char(36)   NOT NULL COMMENT 'links to audit.exchange table (but on a different server)',

    audit_json                   mediumtext  null comment 'Used for Audit Purposes',
    CONSTRAINT pk_procedure_cds_tail PRIMARY KEY (exchange_id, cds_unique_identifier, sus_record_type)
);

-- index to make it easier to find last checksum for a record
CREATE INDEX ix_procedure_cds_tail_checksum_helper on procedure_cds_tail (cds_unique_identifier, sus_record_type, dt_received);

create table procedure_cds_tail_latest
(
