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 |
KEY3 | varchar(5) | not null | PMP Number: Med & IV Charges or 'M': Misc Charges or 'I': Intervention Charges |
DATETIME_OF_ENTRY | varchar(12) | not null | Date/Time of Entry(YYYYMMDDHHMM) |
SEQ | varchar(3) | not null | Sequence Number |
CHARGE_TYPE | varchar(6) | null | Charge Type(MED, IV, MISC, INTERV) |
TRANS_DATE_TIME | varchar(18) | null | Transaction Date/Time(DD/MM/YYYY HH:MMxx) |
FUNCTION_ABBREV | varchar(3) | null | Function Abbreviation(Link to TRANFUNCTION_MASTER.FUNCTION) |
TRANSACTION_QTY | FLOAT | null | Transaction Quantity |
TRANSACTION_AMT | FLOAT | null | Transaction Amount |
USER_ID | varchar(6) | null | User Id |
ENTERED_FROM | varchar(12) | null | Entered From |
COMMENT | varchar(60) | null | Comment |
BUCKET | varchar(3) | null | Bucket |
BOTTLES | varchar(8) | null | Bottles(IV & Miscellaneous Only) |
UNIQ_BOTTLE_CYCLE | varchar(2) | null | Unique Bottle Cycle(IV Only) |
LOT_NUMBER | varchar(10) | null | Lot Number(IV Only) |
EXPIRATION_DATE | varchar(8) | null | Expiration date(IV Only). If date was entered as MM/YYYY, the last day of the month will be displayed |
METHOD_ADD_ON_AMT | varchar(10) | null | Method Add-On-Amount(IV Only) |
DAYS_SUPPLY | varchar(3) | null | Number of Days Supply(Med Only) |
UNROUNDED_DU | varchar(10) | null | Unrounded Dispensing Units(Med Only) |
NO_OF_DOSES | varchar(7) | null | Number Of Doses(Med Only) |
PMP | varchar(5) | null | Pharmacy Order Number |
INTERVENTION_NUM | varchar(6) | null | Intervention Number(Intervention Only) |
DRUG_DESC | varchar(64) | null | Drug Description(Intervention Only) |
TYPE_CHARGE_IND | varchar(1) | null | Type Charge Indicator(Miscellaneous Only: 0=One Time, 1=Every Bottle, 2=Daily) |
PUMP_DRIP_SET_IND | varchar(1) | null | Pump Drip Set Indicator(Miscellaneous Only: 0=Additional Charge, 1=Method Charge, 2=Drip Set Charge, 3=Pump Charge) |
MISC_CHARGE_NUM | varchar(5) | null | Miscellaneous Charge Number(Miscellaneous Only) |
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. |
|
|
|