Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CLIN_AUDIT_ADDL_DRUGS_CONF Pharmacy Clinical Checking Audit - Additional Drugs of Conflicting 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)
CONF_COMP_TYPEvarchar(3)null Conflict Component Type - for MEDs and IVs.(CXM = Complex Med, ADD = Additive, SOL = Solution, MED = Med)
CONF_COMP_NOvarchar(2)null Conflict Sequential Component number for the ingredient on the IV order or Complex Med order
CONF_DOSE_OR_VOLUMvarchar(47)null Conflict Dose or Volume
CONF_DRUG_CODEvarchar(6)null Conflict Drug Code
CONF_DOSAGE_FORMvarchar(7)null Conflict Dosage Form
CONF_GCSFLOATnull Conflict GCS(Generic Code Sequence Number)
CONF_NDCvarchar(14)null Conflict NDC(National Drug Code) Number
CONF_PRIMARY_NAMEvarchar(30)null Conflict Primary Name
CONF_PRIMARY_NAME_TMvarchar(30)null Conflict Primary Name of Drug in Tall Man Format
CONF_PRIMARY_NAME_INDvarchar(8)null Conflict 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