Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CLIN_AUDIT Pharmacy Clinical Checking Audit
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
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)
PTNAMEvarchar(32)null Patient Name
PTCLASSvarchar(1)null Patient Class(I, O, or E)
PTTYPEvarchar(24)null Patient Type(Link to PTM.PTTYPE)
SITEvarchar(2)null Hospital Site
LOCATIONvarchar(13)null Patient Location
PTSERVvarchar(3)null Patient Service
PTFINCLvarchar(32)null Patient Financial Class
PTSEXvarchar(1)null Patient Sex
PTBIRTHvarchar(10)null Patient Date of Birth(MM/DD/YYYY)
DIAGNOSIS_CODE_1varchar(13)null Admit Diagnosis Code 1
DIAGNOSIS_CODE_2varchar(13)null Admit Diagnosis Code 2
DIAGNOSIS_1varchar(64)null Diagnosis 1
DIAGNOSIS_2varchar(64)null Diagnosis 2
NRS_ALLERGY_1varchar(54)null Nursing Allergy 1
NRS_ALLERGY_2varchar(54)null Nursing Allergy 2
PAT_HEIGHT_CMvarchar(12)null Height in Centimeters
FUNCTIONvarchar(3)null Function Code(Link to TRANFUNCTION_MASTER.FUNCTION)
TRANS_TIMEvarchar(5)null Transaction Time(HH:MM)
USER_INITIALSvarchar(6)null User Initials
CLINICIAN_TYPEvarchar(30)null Clinician Type
RX_LOCATIONvarchar(4)null Pharmacy Location
CONFLICT_CODEvarchar(6)null Conflict Code - relative to type of conflict.(Ex: 1 for Allergy or 316 for Interaction)
UNIQUE_BOTTLEvarchar(2)null Unique Bottle(IV Only)
INTERVENTION_NOvarchar(6)null Intervention Number. Key to Clinical Interventions Table(PHM_CLIN_INTERVS)
INTERVENTION_OPTNvarchar(4)null Intervention Option(NONE,OPT,MAND,AUTO)
MAND_VIEWvarchar(3)null Mandatory Clinical Checking View(YES or NO)
APPLICATIONvarchar(3)null Application that created(PHM or MAK)
MAK_OCCUR_DATEvarchar(8)null Med Administration Check Occurrence Date(YYYYMMDD)
MAK_OCCUR_TIMEvarchar(5)null Med Administration Check Occurrence Time(HH:MM)
INTERV_NUM_MAKvarchar(6)null Intervention Number Med Administration Check - Key to Clinical Interventions Table(PHM_CLIN_INTERVS)
OVERRIDE_REASONvarchar(60)null Override Reason - could be a prompted for comment if not using clinical workstation, or a Clinical Intervention if using Clinical Workstation.
ITNvarchar(12)null Internal Number used to create a Unique Key for Active Patient Files
PMPvarchar(5)null Pharmacy Order Number
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.
DRUG_CODEvarchar(5)null Drug Code
PRIMARY_NAMEvarchar(30)null Primary Name of Drug - unless a GENERIC DUPLICATE record which would always use the GENERIC_NAME.
DOSAGE_FORMvarchar(10)null Dosage Form of Drug
DOSE_OR_VOLUMEvarchar(47)null Dose or Volume
PCAvarchar(3)null Is this Order a PCA(patient-controlled analgesia)(YES or NO)
PCA_PMX_STRENGTHvarchar(40)null PCA(patient-controlled analgesia) Strength if Premix Solution
IVM_OR_ICMvarchar(3)null IVM(in vitro maturation) or ICM(Implantable cardiac monitors) Incompatibility Module
IVM_INCOMPAT_DRUGSvarchar(255)null IVM(in vitro maturation) Incompatibility Drugs
ROUTE_OR_METHODvarchar(10)null Route or IV Method
SIG_OR_FREQUENCYvarchar(30)null Sig or Frequency
SCH_PRN_TKHvarchar(3)null Scheduled_PRN_Takehome(SCH, PRN, or TKH)
START_DATEvarchar(8)null Order Start Date(YYYYMMDD)
START_TIMEvarchar(5)null Order Start Time(HH:MM)
STOP_DATEvarchar(8)null Order Stop Date(YYYYMMDD)
STOP_TIMEvarchar(5)null Order Stop Time(HH:MM)
DR_NAMEvarchar(32)null Ordering Doctor Name
DR_NOvarchar(6)null Ordering Doctor Number
DR_DEA_NOvarchar(9)null Ordering Doctor DEA(Drug Enforcement Administration) Number
PRESCRIPTION_NOvarchar(12)null Prescription Number
DEA_NOvarchar(2)null DEA(Drug Enforcement Administration) Code
ONE_TIMEvarchar(3)null One Time(YES or NO)
PRIORITYvarchar(15)null Order Priority
NDCvarchar(18)null NDC(National Drug Code) Number
CDM_NOvarchar(8)null CDM(Charge Description Master) Number
CONF_ITNvarchar(12)null Conflicting Order ITN(Internal Number used to create a Unique Key for Active Patient Files)
CONF_PMPvarchar(5)null Conflicting Order PMP(Pharmacy Order Number)
CONF_COMP_TYPEvarchar(3)null Conflicting Order Component Type
CONF_COMP_NOvarchar(2)null Conflicting Order Conponent Number
CONF_DRUG_CODEvarchar(5)null Conflicting Order Drug Code
CONF_PRIMARY_NAMEvarchar(30)null Conflicting Order Primary Name
CONF_PRIMARY_NAME_TMvarchar(30)null Conflicting Order Primary Name in Tall Man Format
CONF_DOSAGE_FORMvarchar(10)null Conflicting Order Dosage Form
CONF_DOSE_OR_VOLUMvarchar(25)null Conflicting Order Dose/Volume
CONF_ORD_PCAvarchar(3)null Conflicting Order a PCA(patient-controlled analgesia)(YES/NO)
CONF_PCA_PMX_STRNvarchar(13)null Conflicting Order PCA(patient-controlled analgesia) Premix Strength
CONF_ROUTE_OR_METHvarchar(10)null Conflicting Route or Method
CONF_SIG_OR_FREQvarchar(30)null Conflicting SIG(Latin Directions for Use) or Frequency
CONF_SCH_PRN_TKHvarchar(3)null Conflicting Scheduled, PRN(As Needed), Takehome
CONF_START_DATEvarchar(8)null Conflicting Order Start Date(YYYYMMDD)
CONF_START_TIMEvarchar(5)null Conflicting Order Start Time(HH:MM)
CONF_STOP_DATEvarchar(8)null Conflicting Order Stop Date(YYYYMMDD)
CONF_STOP_TIMEvarchar(5)null Conflicting Order Stop Time(HH:MM)
CONF_ORDER_STATUSvarchar(18)null Conflicting Order Status
CONF_DR_NAMEvarchar(32)null Conflicting Order Doctor Name
CONF_DR_NOvarchar(6)null Conflicting Order Doctor Number
CONF_DR_DEA_NOvarchar(9)null Conflicting Order Doctor DEA(Drug Enforcement Administration) Number
CONF_PRESCRIPT_NOvarchar(12)null Conflicting Order Prescription Number
CONF_DEA_NOvarchar(2)null Conflicting Order DEA(Drug Enforcement Administration) Code
CONF_ONE_TIMEvarchar(3)null Conflicting Order One Time(YES or NO)
CONF_PAT_NUMvarchar(12)null Conflicting Order Patient Number
CONF_NDCvarchar(18)null Conflicting Order NDC(National Drug Code) Number
CONF_GCSFLOATnull Conflicting Order GCS(Generic Code Sequence Number)
CONF_CDM_NOvarchar(8)null Conflicting Order CDM(Charge Description Master) Number
CONF_PRIORITYvarchar(15)null Conflicting Order Priority
CONF_REASONvarchar(30)null Conflicting Reason
INT_SIGNIF_LEVELvarchar(1)null Significance Level of Interaction
INT_DRUG_CLASS_1varchar(60)null Interaction Drug Class 1
INT_VERB_1varchar(35)null Interaction Verbage
INT_VERB_2varchar(35)null Interaction Verbage Continued
INT_DRUG_CLASS_2varchar(60)null Interaction Drug Class 2
PAGE_REFvarchar(29)null Page Reference
SEVERITY_CODEvarchar(1)null Severity Code(Allergy or Precautions)
SEVERITY_CODE_DESCvarchar(512)null Severity Code Description(Allergy or Precautions)
ALLERGY_REACTIONvarchar(32)null Allergy Reaction
REACTION_CLASS_CODEvarchar(3)null Reaction Classification Code
REACTION_CLASS_CODE_DESCvarchar(50)null Reaction Classification Code Description
REACTION_MANAGEMENTvarchar(60)null Reaction Management
CONFLICT_DESCRIPTNvarchar(60)null For allergies, this is the ingredient description. For pediatric & geriatric precautions, this is the drug description from the precautions files. For CDT, this is the CDT Table description. For Ingredient Max Dose conflicts & warnings, it is the ingredient description.
NARRATIVEvarchar(500)null Narrative(Precautions)
PED_PREC_MIN_AGEvarchar(4)null Pediatric Precaution Minimum Age
PED_PREC_MAX_AGEvarchar(4)null Pediatric Precaution Maximum Age
GERI_RENAL_AFFvarchar(3)null Renal Affected - Geriatric Precaution(YES or NO)
GERI_HEPATIC_AFFvarchar(3)null Hepatic Affected - Geriatric Precaution(YES or NO)
GERI_CARDIO_AFFvarchar(3)null Cardio Affected - Geriatric Precaution(YES or NO)
GERI_PULM_AFFvarchar(3)null Pulmonary Affected - Geriatric Precaution(YES or NO)
GERI_NEURO_AFFvarchar(3)null Neuro Affected - Geriatric Precaution(YES or NO)
GERI_ENDO_AFFvarchar(3)null Endo Affected - Geriatric Precaution(YES or NO)
GERI_SYSTEMS_AFFvarchar(40)null Systems Affected(Geriatric Precaution)
GCNvarchar(5)null GCN(Generic Code Number)
RULEvarchar(6)null Rule - Lab Rule
LAST_CREAT_NAMEvarchar(12)null Last Creatinine Result
LAST_CREAT_VALUEvarchar(8)null Last Creatinine Value
LAST_CREAT_DATEvarchar(8)null Last Creatinine Date(YYYYMMDD)
LAST_CREAT_TIMEvarchar(5)null Last Creatinine Time(HH:MM)
CCRC_NAMEvarchar(12)null Calculated Creatinine Clearance Name
CCRC_VALUEvarchar(8)null Calculated Creatinine Clearance Value
CCRC_DATEvarchar(8)null Calculated Creat Clearance Date(YYYYMMDD)
CCRC_TIMEvarchar(5)null Calculated Creatinine Clearance Time(HH:MM)
INC_REMARK_1varchar(60)null Incompatibility Remark 1
INC_REMARK_2varchar(60)null Incompatibility Remark 2
INC_REMARK_3varchar(60)null Incompatibility Remark 3
INC_REMARK_4varchar(60)null Incompatibility Remark 4
INC_TEST_SOL_1varchar(60)null Incompatibility Test Solution 1
INC_TEST_SOL_2varchar(60)null Incompatibility Test Solution 2
INC_TEST_SOL_3varchar(60)null Incompatibility Test Solution 3
INC_TEST_SOL_4varchar(60)null Incompatibility Test Solution 4
INC_TEST_SOL_5varchar(60)null Incompatibility Test Solution 5
INC_TEST_SOL_6varchar(60)null Incompatibility Test Solution 6
INC_TEST_SOL_7varchar(60)null Incompatibility Test Solution 7
INC_TEST_SOL_8varchar(60)null Incompatibility Test Solution 8
INC_TEST_SOL_9varchar(60)null Incompatibility Test Solution 9
INC_TEST_SOL_10varchar(60)null Incompatibility Test Solution 10
INC_TEST_SOL_11varchar(60)null Incompatibility Test Solution 11
INC_TEST_SOL_12varchar(60)null Incompatibility Test Solution 12
INC_TEST_SOL_13varchar(77)null Incompatibility Test Solution 13
MM_PEDIATRICvarchar(12)null Min-Max Pediatric Indicator
MM_AGEvarchar(5)null Min-Max Age
MM_ORDERED_DOSEvarchar(23)null Min-Max Ordered Dose
MM_UND_OVR_NTEvarchar(36)null Min-Max Over/Under/NTE Indicator
MM_SINGLE_DAILYvarchar(12)null Min-Max Single/Daily Indicator
MM_CALC_MIN_DOSEvarchar(23)null Min-Max Calculated Minimum Dose
MM_CALC_MAX_DOSEvarchar(23)null Min-Max Calculated Maximum Dose
MM_MIN_DOSEvarchar(23)null Min-Max Minimum Dose
MM_MAX_DOSEvarchar(23)null Min-Max Maximum Dose
MM_NTE_DOSEvarchar(23)null Min-Max Not to Exceed Dose
WEIGHT_INDvarchar(4)null Weight Indicator(None/WGT/IBW/BSA)
MM_NO_CHK_WARNvarchar(512)null Min-Max Warning Text(not checked)
WEIGHTvarchar(32)null Weight
IBWvarchar(8)null Ideal Body Weight
BSAvarchar(8)null Body Surface Area
ACCUM_DOSEvarchar(12)null Lifetime Cumulative Dose
TOT_DOSE_ORDvarchar(12)null Total Dose for this Order from start to stop
CDT_REPT_IN_METERSvarchar(3)null Report in Meters(YES or NO)
CDT_REPORTING_UNITvarchar(10)null Cumulative Dose Reporting Unit
WARNING_THRESHvarchar(12)null Dose Warning Threshold
MAX_THRESHOLDvarchar(12)null Cumulative Dose Maximum threshold
DOSING_WEIGHT_COMMENTvarchar(10)null Dosing Weight Comment
GCSFLOATnull GCS(Generic Code Sequence Number)
GESTATIONAL_AGE_WEEKSvarchar(2)null Gestational Age in Weeks
INTERACTING_GCSFLOATnull INTERACTING_GCS will show the same value of CONF_GCS.
INTERACTING_NDC_NUMBERvarchar(14)null INTERACTING_NDC_NUMBER will show the same value of CONF_NDC.
MINMAX_DOSE_TYPEvarchar(2)null Min-Max Dose Type
MINMAX_ROUTE_CODEvarchar(4)null Min-Max Route Code
ORDER_DOSING_BSAvarchar(8)null Order Dosing BSA(Body Surface Area)
ORDER_DOSING_HEIGHT_CMvarchar(12)null Order Dosing Height in Centimeters
ORDER_DOSING_WEIGHT_KGvarchar(12)null Order Dosing Weight in Kilograms
PERSON_NUMBERvarchar(16)null Identifies a Patient uniquely across multiple sites for a single enterprise
PTMEDRECvarchar(16)null Medical Record Number
DRUG_DISEASE_IDvarchar(12)null Drug Disease Id
ICD9_CODEvarchar(8)null ICD9(International Classification of Diseases, Ninth Revision ) Code(Link to PHM_ICD9_CODES.ICD9_CM)
PRIMARY_NAME_TMvarchar(30)null Primary Name of Drug in Tall Man Format
INGRED_DOSEvarchar(16)null Ingredient Dose
HICROOTvarchar(6)null HIC(Hierarchical Ingredient Code) Number Root
EXCRETION_EFFECTvarchar(2)null Excretion Effect
LACTATION_EFFECTvarchar(2)null Lactation Effect
EXCRETION_EFFECT_DESCvarchar(512)null Excretion Effect Description
LACTATION_EFFECT_DESCvarchar(512)null Lactation Effect Description
GERI_BEERSvarchar(3)null Geriatric List Beers
GERI_HEDISvarchar(3)null Geriatric List Hedis
GERI_STOPPvarchar(3)null Geriatric List Stopp
GERI_LISTSvarchar(32)null Geriatric List Beers,Hedis,Stopp
MED_IVvarchar(1)null Med or Additive or Solution.
STOP_DATE_PREFvarchar(1)null Stop Date Preference(L = Last TOA(Time of Administration), R = Last TOA + Run-in, N = Next TOA)
RATEvarchar(8)null IV Rate(ml per hour) - IV only
RUN_IN_TIMEvarchar(8)null IV Run in Time in Hours - IV only
BAG_VOLUMEvarchar(8)null This value will be either the FINAL_VOLUME or SOL_VOLUME, depending on the setting for the IV Method in profile PHMBORIC(VOLUME USED TO CALCULATE RATE/RUN-IN FOR IV ORDERS)
CHARTED_DATE_TIME_LAST_ADMINvarchar(18)null Charted Date/Time Last Administration(MM/DD/YYYY HH:MM)
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