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 |
MED_IV | varchar(3) | not null | MED or IV |
SERVICE_DATE | varchar(8) | not null | Service Date(YYYYMMDD) |
DRUG_CODE | varchar(5) | not null | Drug Code |
TRANS_DATE_TIME | varchar(12) | not null | Transaction Date and Time(YYYYMMDDHHMM) |
GENERIC_NAME | varchar(30) | null | Generic Name of Drug |
BRAND_NAME | varchar(30) | null | Brand Name of Drug |
STRENGTH | varchar(47) | null | Strength of Drug - Concatenation of Strength & Volume from Drug Master. |
DISP_UNIT | varchar(20) | null | Dispensing Unit |
TRANS_QTY | FLOAT | null | Quantity of the Transaction |
TRANS_AMT | FLOAT | null | Transaction Amt |
TRANS_NUM_DOSES | varchar(7) | null | Transaction Number of Doses |
CABINET | varchar(13) | null | Cabinet |
TAKEHOME | varchar(3) | null | Take Home?(YES or NO) |
SITE | varchar(2) | null | Hospital Site |
INITIALS | varchar(6) | null | Initials |
FLOORSTOCK | varchar(3) | null | Floorstock(YES or NO) |
IN_CURRENT | varchar(3) | null | Is this record in the Active Mini-Charge Table(PHM_CHARGES_MINI_TRANS) also?(YES or NO) |
NRS_STATION | varchar(13) | null | Nurse Station |
PTCLASS | varchar(1) | null | Patient Class(I, O, or E) |
DEA_CODE | varchar(2) | null | DEA(Drug Enforcement Administration) Code |
ROUTE | varchar(10) | null | Route of Administration |
ITN | varchar(12) | null | Internal Number used to create a Unique Key for Active Patient Files |
BRAND_NAME_TM | varchar(30) | null | Brand Name of Drug in Tall Man Format |
GENERIC_NAME_TM | varchar(30) | null | Generic Name of Drug in Tall Man Format |
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. |
|
|
|