Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CHARGES_IV_CMP_TOTALS Pharmacy Active Patient IV Charges by Component
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
INGR_LEVELvarchar(3)not null Ingredient Level
CUM_QTY_COMPvarchar(7)null Cumulative Quantity for IV Component
CUM_AMT_COMPvarchar(10)null Cumulative Amount for Component
TOT_UNRND_DUvarchar(10)null Total Unrounded Dispense Units
IV_COMP_INDvarchar(32)null Component Indicator
CUM_UB_QTYvarchar(7)null Cumulative Unique Bottle Quantity
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