Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
ITN | varchar(12) | not null | Internal Number used to create a Unique Key for Active Patient Files |
KEY2 | 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 |
PMP | varchar(5) | null | Pharmacy Order Number |
MED_IV | varchar(3) | null | Med or IV |
TRANS_DATE_TIME | varchar(12) | null | Transaction Date/Time(YYYYMMDDHHMM) |
FUNCTION_ABBREV | varchar(3) | null | Function Abbreviation(Link to TRANFUNCTION_MASTER.FUNCTION) |
TRANS_QUANTITY | varchar(6) | null | Transaction Quantity |
TRANS_AMOUNT | varchar(10) | 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 |
BOTTLE_NO | varchar(8) | null | Bottle Number |
UNIQ_BTL_CYCLE | varchar(2) | null | Unique Bottle Indicator |
LOT_NUMBER | varchar(10) | null | LOT Number |
EXPIRATION_DATE | varchar(8) | null | Expiration Date. If date was entered as MM/YYYY, the last day of the month will be displayed |
METHOD_ADD_ON_AMOUNT | varchar(10) | null | Method Add-On Amount |
PMP_MISC_REF | varchar(5) | null | PMP Reference for Misc Charge(Misc Only) |
TYPE_CHARGE_IND | varchar(1) | null | Type Charge Indicator(Misc Only: 0=One Time, 1=Every Bottle, 2=Daily) |
PUMP_DRIP_SET_IND | varchar(1) | null | Pump Drip Set Indicator(Misc Only: 0=Additional Charge, 1=Method Charge, 2=Drip Set Charge, 3=Pump Charge) |
MISC_CHARGE_NUM | varchar(5) | null | Misc Charge Number(Misc Only) |
DAYS_SUPPLY | varchar(3) | null | Number of Days Supply |
UNROUNDED_DU | varchar(10) | null | Unrounded Dispense Unit |
NO_OF_DOSES | varchar(7) | null | Number of Doses |
CHARGE_TYPE | varchar(6) | null | Charge Type(MED, IV, MISC, INTERV) |
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. |
|
|
|