Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CHARGES Pharmacy Active Patient Charges
Column Name Column Datatype Column Null Option Column Comment
ITNvarchar(12)not null Internal Number used to create a Unique Key for Active Patient Files
KEY2varchar(5)not null PMP Number: Med & IV Charges or 'M': Misc Charges or 'I': Intervention Charges
DATETIME_OF_ENTRYvarchar(12)not null Date/Time of Entry(YYYYMMDDHHMM)
SEQvarchar(3)not null Sequence Number
PMPvarchar(5)null Pharmacy Order Number
MED_IVvarchar(3)null Med or IV
TRANS_DATE_TIMEvarchar(12)null Transaction Date/Time(YYYYMMDDHHMM)
FUNCTION_ABBREVvarchar(3)null Function Abbreviation(Link to TRANFUNCTION_MASTER.FUNCTION)
TRANS_QUANTITYvarchar(6)null Transaction Quantity
TRANS_AMOUNTvarchar(10)null Transaction Amount
USER_IDvarchar(6)null User Id
ENTERED_FROMvarchar(12)null Entered From
COMMENTvarchar(60)null Comment
BUCKETvarchar(3)null Bucket
BOTTLE_NOvarchar(8)null Bottle Number
UNIQ_BTL_CYCLEvarchar(2)null Unique Bottle Indicator
LOT_NUMBERvarchar(10)null LOT Number
EXPIRATION_DATEvarchar(8)null Expiration Date. If date was entered as MM/YYYY, the last day of the month will be displayed
METHOD_ADD_ON_AMOUNTvarchar(10)null Method Add-On Amount
PMP_MISC_REFvarchar(5)null PMP Reference for Misc Charge(Misc Only)
TYPE_CHARGE_INDvarchar(1)null Type Charge Indicator(Misc Only: 0=One Time, 1=Every Bottle, 2=Daily)
PUMP_DRIP_SET_INDvarchar(1)null Pump Drip Set Indicator(Misc Only: 0=Additional Charge, 1=Method Charge, 2=Drip Set Charge, 3=Pump Charge)
MISC_CHARGE_NUMvarchar(5)null Misc Charge Number(Misc Only)
DAYS_SUPPLYvarchar(3)null Number of Days Supply
UNROUNDED_DUvarchar(10)null Unrounded Dispense Unit
NO_OF_DOSESvarchar(7)null Number of Doses
CHARGE_TYPEvarchar(6)null Charge Type(MED, IV, MISC, INTERV)
PATIENT_OIDINTnot null Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates