V1 sact_drug_detail
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | MERGED_DRUG_DETAIL_ID | — | — | 10247372 10247495 10247511 10247572 10247576 +5 more | — |
| 2 | MERGED_CYCLE_ID | — | — | 10000125 10000170 10000188 10000201 10000223 +5 more | — |
| 3 | ORG_CODE_OF_DRUG_PROVIDER | — | — | EKP02 EQM ED8Y0 EPO55 EJL +5 more | — |
| 4 | ACTUAL_DOSE_PER_ADMINISTRATION | — | — | 1100 130 120 200 8 +5 more | — |
| 5 | OPCS_DELIVERY_CODE | — | — | X729 X721 x721 X731 X387 +5 more | — |
| 6 | ADMINISTRATION_ROUTE | — | — | 4 9 47 12 10 +5 more | — |
| 7 | ADMINISTRATION_DATE | — | — | 2017-01-19 2016-12-08 2013-05-29 2017-12-10 2013-12-07 +5 more | — |
| 8 | DRUG_GROUP | — | — | NOT CHEMO EPIRUBICIN DENOSUMAB LIPOSOMAL DOXORUBICIN NINTEDANIB +5 more | — |
| 9 | MERGED_PATIENT_ID | — | — | 20123282 20123305 20123317 20123490 20123695 +5 more | — |
| 10 | MERGED_TUMOUR_ID | — | — | 20018375 20018411 20018433 20018434 20018438 +5 more | — |
| 11 | MERGED_REGIMEN_ID | — | — | 10000125 10000170 10000188 10000201 10000223 +5 more | — |