Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CHARGES_MEDANDIV_TOTALS Pharmacy Active Patient Med and IV Charges Level 2
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
PMPvarchar(5)not null Pharmacy Order Number
MED_IVvarchar(3)null MED or IV
CUM_QTYFLOATnull Cumulative Quantity for PMP(Pharmacy Order Number)
CUM_AMTFLOATnull Cumulative Amount for PMP(Pharmacy Order Number)
LAST_TRANSACTIONvarchar(6)null Last Transaction Sequence Number
CUM_DAYS_SUPPLYFLOATnull Cumulative Number of Days Supply
CUM_UNROUNDED_DUFLOATnull Cumulative Unrounded Dispensing Unit
CUM_DOSESFLOATnull Cumulative Number of Doses
CUM_METHOD_QTYFLOATnull Cumulative Method Quantity
CUM_METHOD_AMTFLOATnull Cumulative Method 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