Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHHST_CHARGES Pharmacy Historical Patient Charges
Column Name Column Datatype Column Null Option Column Comment
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
PAT_NUMvarchar(12)not null Patient Number
KEY3varchar(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
CHARGE_TYPEvarchar(6)null Charge Type(MED, IV, MISC, INTERV)
TRANS_DATE_TIMEvarchar(18)null Transaction Date/Time(DD/MM/YYYY HH:MMxx)
FUNCTION_ABBREVvarchar(3)null Function Abbreviation(Link to TRANFUNCTION_MASTER.FUNCTION)
TRANSACTION_QTYFLOATnull Transaction Quantity
TRANSACTION_AMTFLOATnull Transaction Amount
USER_IDvarchar(6)null User Id
ENTERED_FROMvarchar(12)null Entered From
COMMENTvarchar(60)null Comment
BUCKETvarchar(3)null Bucket
BOTTLESvarchar(8)null Bottles(IV & Miscellaneous Only)
UNIQ_BOTTLE_CYCLEvarchar(2)null Unique Bottle Cycle(IV Only)
LOT_NUMBERvarchar(10)null Lot Number(IV Only)
EXPIRATION_DATEvarchar(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_AMTvarchar(10)null Method Add-On-Amount(IV Only)
DAYS_SUPPLYvarchar(3)null Number of Days Supply(Med Only)
UNROUNDED_DUvarchar(10)null Unrounded Dispensing Units(Med Only)
NO_OF_DOSESvarchar(7)null Number Of Doses(Med Only)
PMPvarchar(5)null Pharmacy Order Number
INTERVENTION_NUMvarchar(6)null Intervention Number(Intervention Only)
DRUG_DESCvarchar(64)null Drug Description(Intervention Only)
TYPE_CHARGE_INDvarchar(1)null Type Charge Indicator(Miscellaneous Only: 0=One Time, 1=Every Bottle, 2=Daily)
PUMP_DRIP_SET_INDvarchar(1)null Pump Drip Set Indicator(Miscellaneous Only: 0=Additional Charge, 1=Method Charge, 2=Drip Set Charge, 3=Pump Charge)
MISC_CHARGE_NUMvarchar(5)null Miscellaneous Charge Number(Miscellaneous Only)
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