Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
CONFLICT_DATE | varchar(8) | not null | Conflict Date(YYYYMMDD) |
CONFLICT_TYPE_CODE | varchar(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) |
IMR | varchar(16) | not null | Internal Number used to create a Unique Key for Historical Files |
PAT_NUM | varchar(12) | not null | Patient Number |
SEQ | varchar(3) | not null | Sequence Number |
CONFLICT_DESC | varchar(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) |
PTNAME | varchar(32) | null | Patient Name |
PTCLASS | varchar(1) | null | Patient Class(I, O, or E) |
PTTYPE | varchar(24) | null | Patient Type(Link to PTM.PTTYPE) |
SITE | varchar(2) | null | Hospital Site |
LOCATION | varchar(13) | null | Patient Location |
PTSERV | varchar(3) | null | Patient Service |
PTFINCL | varchar(32) | null | Patient Financial Class |
PTSEX | varchar(1) | null | Patient Sex |
PTBIRTH | varchar(10) | null | Patient Date of Birth(MM/DD/YYYY) |
DIAGNOSIS_CODE_1 | varchar(13) | null | Admit Diagnosis Code 1 |
DIAGNOSIS_CODE_2 | varchar(13) | null | Admit Diagnosis Code 2 |
DIAGNOSIS_1 | varchar(64) | null | Diagnosis 1 |
DIAGNOSIS_2 | varchar(64) | null | Diagnosis 2 |
NRS_ALLERGY_1 | varchar(54) | null | Nursing Allergy 1 |
NRS_ALLERGY_2 | varchar(54) | null | Nursing Allergy 2 |
PAT_HEIGHT_CM | varchar(12) | null | Height in Centimeters |
FUNCTION | varchar(3) | null | Function Code(Link to TRANFUNCTION_MASTER.FUNCTION) |
TRANS_TIME | varchar(5) | null | Transaction Time(HH:MM) |
USER_INITIALS | varchar(6) | null | User Initials |
CLINICIAN_TYPE | varchar(30) | null | Clinician Type |
RX_LOCATION | varchar(4) | null | Pharmacy Location |
CONFLICT_CODE | varchar(6) | null | Conflict Code - relative to type of conflict.(Ex: 1 for Allergy or 316 for Interaction) |
UNIQUE_BOTTLE | varchar(2) | null | Unique Bottle(IV Only) |
INTERVENTION_NO | varchar(6) | null | Intervention Number. Key to Clinical Interventions Table(PHM_CLIN_INTERVS) |
INTERVENTION_OPTN | varchar(4) | null | Intervention Option(NONE,OPT,MAND,AUTO) |
MAND_VIEW | varchar(3) | null | Mandatory Clinical Checking View(YES or NO) |
APPLICATION | varchar(3) | null | Application that created(PHM or MAK) |
MAK_OCCUR_DATE | varchar(8) | null | Med Administration Check Occurrence Date(YYYYMMDD) |
MAK_OCCUR_TIME | varchar(5) | null | Med Administration Check Occurrence Time(HH:MM) |
INTERV_NUM_MAK | varchar(6) | null | Intervention Number Med Administration Check - Key to Clinical Interventions Table(PHM_CLIN_INTERVS) |
OVERRIDE_REASON | varchar(60) | null | Override Reason - could be a prompted for comment if not using clinical workstation, or a Clinical Intervention if using Clinical Workstation. |
ITN | varchar(12) | null | Internal Number used to create a Unique Key for Active Patient Files |
PMP | varchar(5) | null | Pharmacy Order Number |
COMPONENT_TYPE | varchar(3) | null | Component Type - for MEDs and IVs.(CXM = Complex Med, ADD = Additive, SOL = Solution, MED = Med) |
COMP_NO | varchar(2) | null | Sequential Component number for the ingredient on the IV order or Complex Med order. |
DRUG_CODE | varchar(5) | null | Drug Code |
PRIMARY_NAME | varchar(30) | null | Primary Name of Drug - unless a GENERIC DUPLICATE record which would always use the GENERIC_NAME. |
DOSAGE_FORM | varchar(10) | null | Dosage Form of Drug |
DOSE_OR_VOLUME | varchar(47) | null | Dose or Volume |
PCA | varchar(3) | null | Is this Order a PCA(patient-controlled analgesia)(YES or NO) |
PCA_PMX_STRENGTH | varchar(40) | null | PCA(patient-controlled analgesia) Strength if Premix Solution |
IVM_OR_ICM | varchar(3) | null | IVM(in vitro maturation) or ICM(Implantable cardiac monitors) Incompatibility Module |
IVM_INCOMPAT_DRUGS | varchar(255) | null | IVM(in vitro maturation) Incompatibility Drugs |
ROUTE_OR_METHOD | varchar(10) | null | Route or IV Method |
SIG_OR_FREQUENCY | varchar(30) | null | Sig or Frequency |
SCH_PRN_TKH | varchar(3) | null | Scheduled_PRN_Takehome(SCH, PRN, or TKH) |
START_DATE | varchar(8) | null | Order Start Date(YYYYMMDD) |
START_TIME | varchar(5) | null | Order Start Time(HH:MM) |
STOP_DATE | varchar(8) | null | Order Stop Date(YYYYMMDD) |
STOP_TIME | varchar(5) | null | Order Stop Time(HH:MM) |
DR_NAME | varchar(32) | null | Ordering Doctor Name |
DR_NO | varchar(6) | null | Ordering Doctor Number |
DR_DEA_NO | varchar(9) | null | Ordering Doctor DEA(Drug Enforcement Administration) Number |
PRESCRIPTION_NO | varchar(12) | null | Prescription Number |
DEA_NO | varchar(2) | null | DEA(Drug Enforcement Administration) Code |
ONE_TIME | varchar(3) | null | One Time(YES or NO) |
PRIORITY | varchar(15) | null | Order Priority |
NDC | varchar(18) | null | NDC(National Drug Code) Number |
CDM_NO | varchar(8) | null | CDM(Charge Description Master) Number |
CONF_ITN | varchar(12) | null | Conflicting Order ITN(Internal Number used to create a Unique Key for Active Patient Files) |
CONF_PMP | varchar(5) | null | Conflicting Order PMP(Pharmacy Order Number) |
CONF_COMP_TYPE | varchar(3) | null | Conflicting Order Component Type |
CONF_COMP_NO | varchar(2) | null | Conflicting Order Conponent Number |
CONF_DRUG_CODE | varchar(5) | null | Conflicting Order Drug Code |
CONF_PRIMARY_NAME | varchar(30) | null | Conflicting Order Primary Name |
CONF_PRIMARY_NAME_TM | varchar(30) | null | Conflicting Order Primary Name in Tall Man Format |
CONF_DOSAGE_FORM | varchar(10) | null | Conflicting Order Dosage Form |
CONF_DOSE_OR_VOLUM | varchar(25) | null | Conflicting Order Dose/Volume |
CONF_ORD_PCA | varchar(3) | null | Conflicting Order a PCA(patient-controlled analgesia)(YES/NO) |
CONF_PCA_PMX_STRN | varchar(13) | null | Conflicting Order PCA(patient-controlled analgesia) Premix Strength |
CONF_ROUTE_OR_METH | varchar(10) | null | Conflicting Route or Method |
CONF_SIG_OR_FREQ | varchar(30) | null | Conflicting SIG(Latin Directions for Use) or Frequency |
CONF_SCH_PRN_TKH | varchar(3) | null | Conflicting Scheduled, PRN(As Needed), Takehome |
CONF_START_DATE | varchar(8) | null | Conflicting Order Start Date(YYYYMMDD) |
CONF_START_TIME | varchar(5) | null | Conflicting Order Start Time(HH:MM) |
CONF_STOP_DATE | varchar(8) | null | Conflicting Order Stop Date(YYYYMMDD) |
CONF_STOP_TIME | varchar(5) | null | Conflicting Order Stop Time(HH:MM) |
CONF_ORDER_STATUS | varchar(18) | null | Conflicting Order Status |
CONF_DR_NAME | varchar(32) | null | Conflicting Order Doctor Name |
CONF_DR_NO | varchar(6) | null | Conflicting Order Doctor Number |
CONF_DR_DEA_NO | varchar(9) | null | Conflicting Order Doctor DEA(Drug Enforcement Administration) Number |
CONF_PRESCRIPT_NO | varchar(12) | null | Conflicting Order Prescription Number |
CONF_DEA_NO | varchar(2) | null | Conflicting Order DEA(Drug Enforcement Administration) Code |
CONF_ONE_TIME | varchar(3) | null | Conflicting Order One Time(YES or NO) |
CONF_PAT_NUM | varchar(12) | null | Conflicting Order Patient Number |
CONF_NDC | varchar(18) | null | Conflicting Order NDC(National Drug Code) Number |
CONF_GCS | FLOAT | null | Conflicting Order GCS(Generic Code Sequence Number) |
CONF_CDM_NO | varchar(8) | null | Conflicting Order CDM(Charge Description Master) Number |
CONF_PRIORITY | varchar(15) | null | Conflicting Order Priority |
CONF_REASON | varchar(30) | null | Conflicting Reason |
INT_SIGNIF_LEVEL | varchar(1) | null | Significance Level of Interaction |
INT_DRUG_CLASS_1 | varchar(60) | null | Interaction Drug Class 1 |
INT_VERB_1 | varchar(35) | null | Interaction Verbage |
INT_VERB_2 | varchar(35) | null | Interaction Verbage Continued |
INT_DRUG_CLASS_2 | varchar(60) | null | Interaction Drug Class 2 |
PAGE_REF | varchar(29) | null | Page Reference |
SEVERITY_CODE | varchar(1) | null | Severity Code(Allergy or Precautions) |
SEVERITY_CODE_DESC | varchar(512) | null | Severity Code Description(Allergy or Precautions) |
ALLERGY_REACTION | varchar(32) | null | Allergy Reaction |
REACTION_CLASS_CODE | varchar(3) | null | Reaction Classification Code |
REACTION_CLASS_CODE_DESC | varchar(50) | null | Reaction Classification Code Description |
REACTION_MANAGEMENT | varchar(60) | null | Reaction Management |
CONFLICT_DESCRIPTN | varchar(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. |
NARRATIVE | varchar(500) | null | Narrative(Precautions) |
PED_PREC_MIN_AGE | varchar(4) | null | Pediatric Precaution Minimum Age |
PED_PREC_MAX_AGE | varchar(4) | null | Pediatric Precaution Maximum Age |
GERI_RENAL_AFF | varchar(3) | null | Renal Affected - Geriatric Precaution(YES or NO) |
GERI_HEPATIC_AFF | varchar(3) | null | Hepatic Affected - Geriatric Precaution(YES or NO) |
GERI_CARDIO_AFF | varchar(3) | null | Cardio Affected - Geriatric Precaution(YES or NO) |
GERI_PULM_AFF | varchar(3) | null | Pulmonary Affected - Geriatric Precaution(YES or NO) |
GERI_NEURO_AFF | varchar(3) | null | Neuro Affected - Geriatric Precaution(YES or NO) |
GERI_ENDO_AFF | varchar(3) | null | Endo Affected - Geriatric Precaution(YES or NO) |
GERI_SYSTEMS_AFF | varchar(40) | null | Systems Affected(Geriatric Precaution) |
GCN | varchar(5) | null | GCN(Generic Code Number) |
RULE | varchar(6) | null | Rule - Lab Rule |
LAST_CREAT_NAME | varchar(12) | null | Last Creatinine Result |
LAST_CREAT_VALUE | varchar(8) | null | Last Creatinine Value |
LAST_CREAT_DATE | varchar(8) | null | Last Creatinine Date(YYYYMMDD) |
LAST_CREAT_TIME | varchar(5) | null | Last Creatinine Time(HH:MM) |
CCRC_NAME | varchar(12) | null | Calculated Creatinine Clearance Name |
CCRC_VALUE | varchar(8) | null | Calculated Creatinine Clearance Value |
CCRC_DATE | varchar(8) | null | Calculated Creat Clearance Date(YYYYMMDD) |
CCRC_TIME | varchar(5) | null | Calculated Creatinine Clearance Time(HH:MM) |
INC_REMARK_1 | varchar(60) | null | Incompatibility Remark 1 |
INC_REMARK_2 | varchar(60) | null | Incompatibility Remark 2 |
INC_REMARK_3 | varchar(60) | null | Incompatibility Remark 3 |
INC_REMARK_4 | varchar(60) | null | Incompatibility Remark 4 |
INC_TEST_SOL_1 | varchar(60) | null | Incompatibility Test Solution 1 |
INC_TEST_SOL_2 | varchar(60) | null | Incompatibility Test Solution 2 |
INC_TEST_SOL_3 | varchar(60) | null | Incompatibility Test Solution 3 |
INC_TEST_SOL_4 | varchar(60) | null | Incompatibility Test Solution 4 |
INC_TEST_SOL_5 | varchar(60) | null | Incompatibility Test Solution 5 |
INC_TEST_SOL_6 | varchar(60) | null | Incompatibility Test Solution 6 |
INC_TEST_SOL_7 | varchar(60) | null | Incompatibility Test Solution 7 |
INC_TEST_SOL_8 | varchar(60) | null | Incompatibility Test Solution 8 |
INC_TEST_SOL_9 | varchar(60) | null | Incompatibility Test Solution 9 |
INC_TEST_SOL_10 | varchar(60) | null | Incompatibility Test Solution 10 |
INC_TEST_SOL_11 | varchar(60) | null | Incompatibility Test Solution 11 |
INC_TEST_SOL_12 | varchar(60) | null | Incompatibility Test Solution 12 |
INC_TEST_SOL_13 | varchar(77) | null | Incompatibility Test Solution 13 |
MM_PEDIATRIC | varchar(12) | null | Min-Max Pediatric Indicator |
MM_AGE | varchar(5) | null | Min-Max Age |
MM_ORDERED_DOSE | varchar(23) | null | Min-Max Ordered Dose |
MM_UND_OVR_NTE | varchar(36) | null | Min-Max Over/Under/NTE Indicator |
MM_SINGLE_DAILY | varchar(12) | null | Min-Max Single/Daily Indicator |
MM_CALC_MIN_DOSE | varchar(23) | null | Min-Max Calculated Minimum Dose |
MM_CALC_MAX_DOSE | varchar(23) | null | Min-Max Calculated Maximum Dose |
MM_MIN_DOSE | varchar(23) | null | Min-Max Minimum Dose |
MM_MAX_DOSE | varchar(23) | null | Min-Max Maximum Dose |
MM_NTE_DOSE | varchar(23) | null | Min-Max Not to Exceed Dose |
WEIGHT_IND | varchar(4) | null | Weight Indicator(None/WGT/IBW/BSA) |
MM_NO_CHK_WARN | varchar(512) | null | Min-Max Warning Text(not checked) |
WEIGHT | varchar(32) | null | Weight |
IBW | varchar(8) | null | Ideal Body Weight |
BSA | varchar(8) | null | Body Surface Area |
ACCUM_DOSE | varchar(12) | null | Lifetime Cumulative Dose |
TOT_DOSE_ORD | varchar(12) | null | Total Dose for this Order from start to stop |
CDT_REPT_IN_METERS | varchar(3) | null | Report in Meters(YES or NO) |
CDT_REPORTING_UNIT | varchar(10) | null | Cumulative Dose Reporting Unit |
WARNING_THRESH | varchar(12) | null | Dose Warning Threshold |
MAX_THRESHOLD | varchar(12) | null | Cumulative Dose Maximum threshold |
DOSING_WEIGHT_COMMENT | varchar(10) | null | Dosing Weight Comment |
GCS | FLOAT | null | GCS(Generic Code Sequence Number) |
GESTATIONAL_AGE_WEEKS | varchar(2) | null | Gestational Age in Weeks |
INTERACTING_GCS | FLOAT | null | INTERACTING_GCS will show the same value of CONF_GCS. |
INTERACTING_NDC_NUMBER | varchar(14) | null | INTERACTING_NDC_NUMBER will show the same value of CONF_NDC. |
MINMAX_DOSE_TYPE | varchar(2) | null | Min-Max Dose Type |
MINMAX_ROUTE_CODE | varchar(4) | null | Min-Max Route Code |
ORDER_DOSING_BSA | varchar(8) | null | Order Dosing BSA(Body Surface Area) |
ORDER_DOSING_HEIGHT_CM | varchar(12) | null | Order Dosing Height in Centimeters |
ORDER_DOSING_WEIGHT_KG | varchar(12) | null | Order Dosing Weight in Kilograms |
PERSON_NUMBER | varchar(16) | null | Identifies a Patient uniquely across multiple sites for a single enterprise |
PTMEDREC | varchar(16) | null | Medical Record Number |
DRUG_DISEASE_ID | varchar(12) | null | Drug Disease Id |
ICD9_CODE | varchar(8) | null | ICD9(International Classification of Diseases, Ninth Revision ) Code(Link to PHM_ICD9_CODES.ICD9_CM) |
PRIMARY_NAME_TM | varchar(30) | null | Primary Name of Drug in Tall Man Format |
INGRED_DOSE | varchar(16) | null | Ingredient Dose |
HICROOT | varchar(6) | null | HIC(Hierarchical Ingredient Code) Number Root |
EXCRETION_EFFECT | varchar(2) | null | Excretion Effect |
LACTATION_EFFECT | varchar(2) | null | Lactation Effect |
EXCRETION_EFFECT_DESC | varchar(512) | null | Excretion Effect Description |
LACTATION_EFFECT_DESC | varchar(512) | null | Lactation Effect Description |
GERI_BEERS | varchar(3) | null | Geriatric List Beers |
GERI_HEDIS | varchar(3) | null | Geriatric List Hedis |
GERI_STOPP | varchar(3) | null | Geriatric List Stopp |
GERI_LISTS | varchar(32) | null | Geriatric List Beers,Hedis,Stopp |
MED_IV | varchar(1) | null | Med or Additive or Solution. |
STOP_DATE_PREF | varchar(1) | null | Stop Date Preference(L = Last TOA(Time of Administration), R = Last TOA + Run-in, N = Next TOA) |
RATE | varchar(8) | null | IV Rate(ml per hour) - IV only |
RUN_IN_TIME | varchar(8) | null | IV Run in Time in Hours - IV only |
BAG_VOLUME | varchar(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_ADMIN | varchar(18) | null | Charted Date/Time Last Administration(MM/DD/YYYY HH:MM) |
PATIENT_OID | INT | not null | Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export. |
|
|
|