Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
IMR | varchar(16) | not null | Internal Number used to create a Unique Key for Historical Files |
PAT_NUM | varchar(12) | not null | Patient Number |
PMP | varchar(5) | not null | Pharmacy Order Number |
COMPONENT | varchar(12) | not null | Component Indicator |
CUM_QTY_COMP | FLOAT | null | Cumulative Quantity for IV Component |
CUM_AMT_COMP | FLOAT | null | Cumulative Amount for Component |
TOT_UNRND_DU | FLOAT | null | Total Unrounded Dispensing Units |
CUM_UB_QTY | FLOAT | null | Cumulative Unique Bottle Quantity |
PATIENT_OID | INT | not null | Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export. |
|
|
|