Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CHARGES_HELD Pharmacy Active Patient Charges Held
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
CHARGE_NOvarchar(15)not null Charge Number(Order or Adjust Number)
QTYvarchar(8)null Quantity
AMOUNTvarchar(10)null Amount
UNIT_COSTvarchar(15)null Unit Cost
DRUG_CODEvarchar(5)null Drug Code
CDM_NOvarchar(8)null CDM(charge description master) Number(drug or iv method)
DRUGNAME_IVMETHODvarchar(30)null Generic Name or IV Method
DRUGNAME_IVMETHOD_TMvarchar(30)null Generic Name Tall Man or IV Method
SITEvarchar(2)null Hospital Site
PAT_NUMvarchar(12)null Patient Number
PTNAMEvarchar(32)null Patient Name
CHARGE_TYPEvarchar(3)null Charge Type(Null=Order Ingredient Charge, INT=Intervention Charge, MCC=Mini Charge/Credit, MCS=Miscellaneous Charge, MTD=Method Charge)
BILLING_PAT_NUMvarchar(12)null Billing Patient Number
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