I have updated cnext_drug_exposure and cnext_device_exposure. In cnext_drug_exposure, I had to append the Tx table's 3 letter abbreviation to SOURCE_PK, DRUG_EXPOSURE_ID, and VISIT_DETAIL_ID to make each field unique and avoid dups.
In cnext_device_exposure, I only appended the Tx table's 3 letter abbreviation to VISIT_DETAIL_ID. SOURCE_PK and DRUG_EXPOSURE_ID are unique without the prefix.
isangil
commented
2 years ago
I have updated cnext_drug_exposure and cnext_device_exposure. In cnext_drug_exposure, I had to append the Tx table's 3 letter abbreviation to SOURCE_PK, DRUG_EXPOSURE_ID, and VISIT_DETAIL_ID to make each field unique and avoid dups. In cnext_device_exposure, I only appended the Tx table's 3 letter abbreviation to VISIT_DETAIL_ID. SOURCE_PK and DRUG_EXPOSURE_ID are unique without the prefix.