Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CLIN_AUDIT_ADDL_DRUGS Pharmacy Clinical Checking Audit - Additional Drugs of Current Order
Column Name Column Datatype Column Null Option Column Comment
CONFLICT_DATEvarchar(8)not null Conflict Date(YYYYMMDD)
CONFLICT_TYPE_CODEvarchar(2)not null Conflict Type Code. Corresponds to Column CONFLICT_DESC.(1=Gen Dup, 2=Algy, 3=Thera Dup, 4=Drug-Drug Int, 5=Ped Prec, 6=Geri Precaution, 7=Drug Lab, 8=IV Incompat, 9=Min/Max, 10=Min/Max Warning)
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
PAT_NUMvarchar(12)not null Patient Number
SEQvarchar(3)not null Sequence Number
ADDL_DRUG_SEQvarchar(3)not null Previous Admin Drug Sequence Number
CONFLICT_DESCvarchar(25)null Conflict Type Description. Corresponds to column CONFLICT_TYPE_CODE. Use CONFLICT_TYPE_CODE to select certain types of conflicts.(GENERIC DUPLICATE, ALLERGY, THERAPEUTIC, DUPLICATE, DRUG-DRUG-INTERACTION, PEDIATRIC PRECAUTION, GERIATRIC PRECAUTION, DRUG-LAB INTERFERENCE, IV INCOMPATIBILITY, MIN/MAX DOSE, MIN/MAX WARNING)
COMPONENT_TYPEvarchar(3)null Component Type - for MEDs and IVs.(CXM = Complex Med, ADD = Additive, SOL = Solution, MED = Med)
COMP_NOvarchar(2)null Sequential Component number for the ingredient on the IV order or Complex Med order.
DEA_CODEvarchar(2)null DEA(Drug Enforcement Administration) Code
DOSEvarchar(47)null Dose
DRUG_CODEvarchar(6)null Drug Code
DOSAGE_FORMvarchar(7)null Dosage Form
GCSFLOATnull GCS(Generic Code Sequence Number)
INGRED_DOSEvarchar(16)null Ingredient Dose
NDC_NUMBERvarchar(14)null NDC(National Drug Code) Number
IVM_INCOMPAT_CODEvarchar(6)null IVM(in vitro maturation) Incompatibility Code
IVM_INCOMPAT_CODE_DESCvarchar(50)null IVM(in vitro maturation) Incompatibility Code Description
PRIMARY_NAMEvarchar(30)null Primary Name
PRIMARY_NAME_TMvarchar(30)null Primary Name of Drug in Tall Man Format
GCNvarchar(6)null GCN(Generic Code Number)
PRIMARY_NAME_INDvarchar(8)null Primary Name Indicator(GENERIC or BRAND)
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