Removed Treatment table query - replaced with DxStg table query. Removed Transplant table query - replaced with Hospital table query. Changed all select statements to pull SOURCE_PK, PROCEDURE_OCCURRENCE_ID, and VISIT_DETAIL_ID from the queried treatment table. Concatenated the treatment table's 3 letter code plus a dash to the treatment table's UK for each of these fields.
Removed Treatment table query - replaced with DxStg table query. Removed Transplant table query - replaced with Hospital table query. Changed all select statements to pull SOURCE_PK, PROCEDURE_OCCURRENCE_ID, and VISIT_DETAIL_ID from the queried treatment table. Concatenated the treatment table's 3 letter code plus a dash to the treatment table's UK for each of these fields.