Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHHST_CHARGES_MINI_TRANS Pharmacy Historical Patient Mini-Charges individual transactions
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(5)not null Drug Code
TRANS_DATE_TIMEvarchar(12)not null Transaction Date and Time(YYYYMMDDHHMM)
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_UNITvarchar(20)null Dispensing Unit
TRANS_QTYFLOATnull Quantity of the Transaction
TRANS_AMTFLOATnull Transaction Amt
TRANS_NUM_DOSESvarchar(7)null Transaction Number of Doses
CABINETvarchar(13)null Cabinet
TAKEHOMEvarchar(3)null Take Home?(YES or NO)
SITEvarchar(2)null Hospital Site
INITIALSvarchar(6)null Initials
FLOORSTOCKvarchar(3)null Floorstock(YES or NO)
IN_CURRENTvarchar(3)null Is this record in the Active Mini-Charge Table(PHM_CHARGES_MINI_TRANS) also?(YES or NO)
NRS_STATIONvarchar(13)null Nurse Station
PTCLASSvarchar(1)null Patient Class(I, O, or E)
DEA_CODEvarchar(2)null DEA(Drug Enforcement Administration) Code
ROUTEvarchar(10)null Route of Administration
ITNvarchar(12)null Internal Number used to create a Unique Key for Active Patient Files
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