Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHHST_CHARGES_MINI Pharmacy Historical Patient Mini-Charges summarized by Patient per Day per Drug
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
MED_IVvarchar(3)not null MED or IV
SERVICE_DATEvarchar(8)not null Service Date(YYYYMMDD)
DRUG_CODEvarchar(6)not null Drug Code
GENERIC_NAMEvarchar(30)null Generic Name of Drug
BRAND_NAMEvarchar(30)null Brand Name of Drug
STRENGTHvarchar(47)null Strength of Drug - Concatenation of Strength & Volume from Drug Master.
DISP_UNITSvarchar(20)null Dispensing Units
DOSESvarchar(7)null Doses
TOTAL_QTYFLOATnull Total Quantity
TOTAL_PRICEFLOATnull Total Price
IN_ACTIVEvarchar(3)null Is this record in Active Mini-Charge Table(PHM_CHARGES_MINI) Also?(YES or NO)
BRAND_NAME_TMvarchar(30)null Brand Name of Drug in Tall Man Format
GENERIC_NAME_TMvarchar(30)null Generic Name of Drug in Tall Man Format
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