Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHHST_CHARGES_MISC_TOTALS Pharmacy Historical Patient Miscellaneous Charge Totals
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
CHARGE_NUMvarchar(6)not null Charge Number
CHARGE_DESCvarchar(64)null Charge Description
CUMMULATIVE_QUANTITYFLOATnull Cumulative Quantity
CUMMULATIVE_AMOUNTFLOATnull Cumulative Amount
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