Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_MAC_ERR_DTL Pharmacy Med Administration Check Error Details
Column Name Column Datatype Column Null Option Column Comment
SITEvarchar(2)not null Hospital Site
CHARTED_DATEvarchar(8)not null Charted Date reflects the date the error event occurred(YYYYMMDD)
CHARTED_HOURvarchar(2)not null Charted Hour reflects the hour the error event occurred(HH)
LOCATIONvarchar(13)not null Pharmacy Location
SEQvarchar(6)not null Sequence Number
COMP_NOvarchar(2)not null Sequential Component number for the ingredient on the IV order or Complex Med order
ERROR_CODEvarchar(2)null Error Code for type of error. For error code description, see ERR_CODE_DESC Column
CHARTED_TIMEvarchar(5)null Charted Time reflects the time the error event occurred(HH:MM)
NURSE_IDvarchar(12)null Nurse ID - Initials
FUNCTION_TYPE_CODEvarchar(1)null Function Type Code
FUNCTION_TYPE_DESCvarchar(20)null Function Type Code Description
NURSE_VERIFIEDvarchar(3)null Nurse Verified(YES or NO)
NURSE_VERIFIED_DATEvarchar(8)null Nurse Verified Date in format(YYYYMMDD)
NURSE_VERIFIED_TIMEvarchar(5)null Nurse Verified Time in format(HH:MM)
NURSE_VERIFIED_BYvarchar(6)null Nurse Verified By
ADMIN_DATEvarchar(8)null Administration Date - YYYYMMDD
ADMIN_TIMEvarchar(5)null Administration Time in format HH:MM
ADMIN_STATUSvarchar(20)null Admin Status - indicates Charted/Not charted administration.
SCANNED_DATAvarchar(60)null Scanned Data - the value of the Bar Code that was scanned.
SCANNED_DATA_PAT_NUMvarchar(60)null Patient Number from Scan Data With Leading Zeros
DRUG_DESC_SCAN_ERRvarchar(128)null Drug Description Scanned in Error
DRUG_STRN_SCAN_ERRvarchar(64)null Drug Strength Scanned in Error
DRUG_NDC_SCAN_ERRvarchar(13)null Drug NDC Scanned in Error
REASONvarchar(60)null Reason
ADMIN_SITEvarchar(32)null Administration Site
TEMPERATUREvarchar(6)null Temperature
PULSEvarchar(3)null Pulse
BLOOD_PRESSUREvarchar(8)null Blood Pressure
RESPIRATIONvarchar(3)null Respiration
BLOOD_GLUCOSEvarchar(4)null Blood Glucose
PAIN_SCALEvarchar(16)null Pain Scale
PAIN_SCALE_LOCvarchar(30)null Pain Scale Location
TEMP_REQvarchar(3)null Temperature Required(YES or NO)
PULSE_REQvarchar(3)null Pulse Required(YES or NO)
BP_REQvarchar(3)null Blood Pressure Required(YES or NO)
RESP_REQvarchar(3)null Respiration Required(YES or NO)
BS_REQvarchar(3)null Blood Sugar Required(YES or NO)
PS_REQvarchar(3)null Pain Scale Required(YES or NO)
PSLOC_REQvarchar(3)null Pain Scale Location Required(YES or NO)
TEMP_FOLL_MINSFLOATnull Temperature Follow-up Minutes
PULSE_FOLL_MINSFLOATnull Pulse Follow-up Minutes
BP_FOLL_MINSFLOATnull Blood Pressure Follow-up Minutes
RESP_FOLL_MINSFLOATnull Respiration Follow-up Minutes
BS_FOLL_MINSFLOATnull Blood Sugar Follow-up Minutes
PS_FOLL_MINSFLOATnull Pain Scale Follow-up Minutes
PSLOC_FOLL_MINSFLOATnull Pain Scale Location Follow-up Minutes
UNCHART_TRANSvarchar(3)null Unchart Function Performed(YES or NO)
CHRT_ENT_DATEvarchar(8)null System Date Chart Entered(YYYYMMDD)
CHRT_ENT_TIMEvarchar(5)null System Time Chart Entered(HH:MM)
ITNvarchar(12)null Internal Number used to create a Unique Key for Active Patient Files
PAT_NUMvarchar(12)null Patient Number
PTMEDRECvarchar(12)null Medical Record Number
PTNAMEvarchar(32)null Patient Name
PTCLASSvarchar(1)null Patient Class(I, O, or E)
PTTYPEvarchar(1)null Patient Type
PTBEDvarchar(6)null Bed - Full Room/Bed Code
PTSERVvarchar(3)null Patient Service
ATTDOCNUvarchar(6)null Attending Physician Number
ATTDOCNAvarchar(32)null Attending Physician Name
PTSEXvarchar(1)null Patient Sex
PTAGEvarchar(5)null Patient Age
PTBIRTHvarchar(8)null Patient Date of Birth(YYYYMMDD)
PAT_HEIGHT_CMvarchar(12)null Patient Height in CM
PAT_WEIGHT_KGvarchar(12)null Patients Weight in Kilograms
ICD9_1varchar(12)null Primary ICD9 Diagnosis Code
DIAGNOSIS_1varchar(64)null Primary ICD9 Diagnosis Code Description
ICD9_2varchar(12)null Secondary ICD9 Diagnosis Code
DIAGNOSIS_2varchar(64)null Secondary ICD9 Diagnosis Code Description
ALLERGY_1varchar(64)null Nursing Allergy 1
ALLERGY_2varchar(64)null Nursing Allergy 2
CCRC_DATEvarchar(8)null Calculated Creat Clearance Date(YYYYMMDD)
CCRC_TIMEvarchar(5)null Calc Creatinine Clearance Time
CALC_CREAT_CLEARFLOATnull Calculate Creatinine Clearance
PMPvarchar(5)null Pharmacy Order Number
ANC_ORD_NOvarchar(23)null Ancilliary Order Number
SIGvarchar(15)null SIG - Latin Directions
SIG_DESCvarchar(30)null SIG Description - Latin Directions Expanded
FREQUENCYvarchar(8)null Frequency(Interval)
FREQUENCY_UNITvarchar(4)null Frequency Unit(Mins: If FREQUENCY value is displayed in Minutes(less than 60 minutes), Hrs: If FREQUENCY value is displayed in Hours(60 minutes or more))
DAYS_OF_WEEKvarchar(20)null Days of the Week
RATEvarchar(8)null IV Rate(ml per hour) - IV only
RUN_IN_TIMEvarchar(8)null IV Run in Time in Hours - IV only
IV_METHOD_CODEvarchar(2)null IV Method Code(0 to 10). See Pharmacy Method Masterfile PHM_METHOD_MF
IV_METHODvarchar(6)null IV Method Abbreviation(Ex: PUSH,LVP,TPN,...). See Pharmacy Method Masterfile PHM_METHOD_MF
START_DATEvarchar(8)null Order Start Date(YYYYMMDD)
START_TIMEvarchar(5)null Start Time(HH:MM)
STOP_DATEvarchar(8)null Stop Date of the Order(YYYYMMDD)
STOP_TIMEvarchar(5)null Stop Time(HH:MM)
ORD_DRNOvarchar(6)null Ordering Doctor Number
ORD_DRNAMEvarchar(32)null Ordering Doctor Name
MED_IVvarchar(3)null MED or IV
SCH_PRNvarchar(3)null SCH or PRN
PRIORITYvarchar(15)null Order Priority
ONE_TIMEvarchar(3)null One Time(YES or NO)
VALIDATED_BYvarchar(6)null Order Validated by(RPH INIT)
VALIDATED_DATEvarchar(8)null Validated Date(YYYYMMDD)
VALIDATED_TIMEvarchar(5)null Validated Time(HH:MM)
ENTERED_BYvarchar(6)null Order Entered By(Initials)
ENTERED_DATEvarchar(8)null Entered Date(YYYYMMDD)
ENTERED_TIMEvarchar(5)null Entered Time(HH:MM)
ORDER_STATUSvarchar(20)null Order Status
DIRECTIONS_1varchar(30)null Directions 1
DIRECTIONS_2varchar(30)null Directions 2
DIRECTIONS_3varchar(30)null Directions 3
DIRECTIONS_4varchar(30)null Directions 4
DIRECTIONS_5varchar(30)null Directions 5
DIRECTIONS_6varchar(30)null Directions 6
COMPONENT_TYPEvarchar(3)null Component Type(CXM,ADD,SOL,MED,PMX,SCA)
GENERIC_NAMEvarchar(30)null Generic Name of Drug
BRAND_NAMEvarchar(30)null Brand Name of Drug
PRIMARY_NAMEvarchar(30)null Primary Name of Drug
DOSEvarchar(47)null Dose(Normalized Dose) - this should be the dose dispensed.
ADM_DOSE_OVRvarchar(20)null Administered Dose if Overridden
NDUvarchar(6)null Number of Dispensing Units
ROUTEvarchar(10)null Route of Administration
DOSAGE_FORMvarchar(10)null Dosage Form of Drug
LABELERvarchar(32)null Labeler
DRUG_CODEvarchar(5)null Drug Code
DEA_CODEvarchar(2)null DEA(Drug Enforcement Administration) Code
NDCvarchar(14)null NDC(National Drug Code) Number
GCSFLOATnull GCS(Generic Code Sequence Number)
THER_CODE_1varchar(8)null Therapeutic Code 1
THER_CODE_2varchar(8)null Therapeutic Code 2
THER_CODE_3varchar(8)null Therapeutic Code 3
PRIMARY_INGREDvarchar(3)null Primary Ingredient(YES or NO)
ORDER_REASONvarchar(30)null Order Reason
EARLY_OR_LATE_RSNvarchar(32)null Early or Late Reason
DRUG_RTE_SCAN_ERRvarchar(10)null DRUG ROUTE SCAN ERROR
ORD_FDB_DRUGvarchar(32)null Order FDB(First Databank) Drug Name
ORD_FDB_STRNvarchar(20)null Order FDB(First Databank) Strength
ORD_FDB_RTEvarchar(10)null Order FDB(First Databank) Route
IMRvarchar(16)null Internal Number used to create a Unique Key for Historical Files
PERSON_NUMBERvarchar(16)null Identifies a Patient uniquely across multiple sites for a single enterprise
PTAGE_IN_DAYSFLOATnull Patient Age Displayed in Number of Days
REMINDER_CODEvarchar(15)null Reminder Code
REMINDER_SHORT_DESCvarchar(30)null Reminder short description
RECONF_USER_FUNCTIONvarchar(24)null What function was the user performing when reconfirm user logged a bad scan
ORDER_SPECIFIC_BAR_CODEvarchar(3)null Order Specific Bar Code(YES or NO)
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
PRIMARY_NAME_TMvarchar(30)null Primary Name of Drug in Tall Man Format
SCANNED_DATA_PAT_NUM_NLZvarchar(60)null Patient Number from Scan Data with No Leading Zeros
VOLUMEvarchar(19)null Volume
PUMP_IDvarchar(32)null Pump ID
PUMP_MESSAGE_ERR_CODEvarchar(12)null Pump Message Error Code
PUMP_MESSAGE_ERR_DESCvarchar(128)null Pump Message Error Description
PUMP_DRUG_NAMEvarchar(30)null Pump Drug Name
PUMP_DOSEvarchar(47)null Pump Dose
PUMP_VOLUMEvarchar(19)null Pump Volume
PUMP_RATEvarchar(9)null Pump Rate
PUMP_OVERRIDE_REASONvarchar(32)null Pump Override Reason
PUMP_CODEvarchar(13)null Pump Code
DOSE_AS_LOGGEDvarchar(47)null Dose As Logged
INRvarchar(4)null INR(International Normalized Ratio, aka: standardized prothrombin time)
INR_REQvarchar(3)null INR(International Normalized Ratio, aka: standardized prothrombin time) Required(YES or NO)
INR_FOLL_MINSFLOATnull INR(International Normalized Ratio, aka: standardized prothrombin time) Follow-up Minutes
ERROR_CODE_DESCvarchar(45)null Error Code Description
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