Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
SITE | varchar(2) | not null | Hospital Site |
CHARTED_DATE | varchar(8) | not null | Charted Date reflects the date the error event occurred(YYYYMMDD) |
CHARTED_HOUR | varchar(2) | not null | Charted Hour reflects the hour the error event occurred(HH) |
LOCATION | varchar(13) | not null | Pharmacy Location |
SEQ | varchar(6) | not null | Sequence Number |
COMP_NO | varchar(2) | not null | Sequential Component number for the ingredient on the IV order or Complex Med order |
ERROR_CODE | varchar(2) | null | Error Code for type of error. For error code description, see ERR_CODE_DESC Column |
CHARTED_TIME | varchar(5) | null | Charted Time reflects the time the error event occurred(HH:MM) |
NURSE_ID | varchar(12) | null | Nurse ID - Initials |
FUNCTION_TYPE_CODE | varchar(1) | null | Function Type Code |
FUNCTION_TYPE_DESC | varchar(20) | null | Function Type Code Description |
NURSE_VERIFIED | varchar(3) | null | Nurse Verified(YES or NO) |
NURSE_VERIFIED_DATE | varchar(8) | null | Nurse Verified Date in format(YYYYMMDD) |
NURSE_VERIFIED_TIME | varchar(5) | null | Nurse Verified Time in format(HH:MM) |
NURSE_VERIFIED_BY | varchar(6) | null | Nurse Verified By |
ADMIN_DATE | varchar(8) | null | Administration Date - YYYYMMDD |
ADMIN_TIME | varchar(5) | null | Administration Time in format HH:MM |
ADMIN_STATUS | varchar(20) | null | Admin Status - indicates Charted/Not charted administration. |
SCANNED_DATA | varchar(60) | null | Scanned Data - the value of the Bar Code that was scanned. |
SCANNED_DATA_PAT_NUM | varchar(60) | null | Patient Number from Scan Data With Leading Zeros |
DRUG_DESC_SCAN_ERR | varchar(128) | null | Drug Description Scanned in Error |
DRUG_STRN_SCAN_ERR | varchar(64) | null | Drug Strength Scanned in Error |
DRUG_NDC_SCAN_ERR | varchar(13) | null | Drug NDC Scanned in Error |
REASON | varchar(60) | null | Reason |
ADMIN_SITE | varchar(32) | null | Administration Site |
TEMPERATURE | varchar(6) | null | Temperature |
PULSE | varchar(3) | null | Pulse |
BLOOD_PRESSURE | varchar(8) | null | Blood Pressure |
RESPIRATION | varchar(3) | null | Respiration |
BLOOD_GLUCOSE | varchar(4) | null | Blood Glucose |
PAIN_SCALE | varchar(16) | null | Pain Scale |
PAIN_SCALE_LOC | varchar(30) | null | Pain Scale Location |
TEMP_REQ | varchar(3) | null | Temperature Required(YES or NO) |
PULSE_REQ | varchar(3) | null | Pulse Required(YES or NO) |
BP_REQ | varchar(3) | null | Blood Pressure Required(YES or NO) |
RESP_REQ | varchar(3) | null | Respiration Required(YES or NO) |
BS_REQ | varchar(3) | null | Blood Sugar Required(YES or NO) |
PS_REQ | varchar(3) | null | Pain Scale Required(YES or NO) |
PSLOC_REQ | varchar(3) | null | Pain Scale Location Required(YES or NO) |
TEMP_FOLL_MINS | FLOAT | null | Temperature Follow-up Minutes |
PULSE_FOLL_MINS | FLOAT | null | Pulse Follow-up Minutes |
BP_FOLL_MINS | FLOAT | null | Blood Pressure Follow-up Minutes |
RESP_FOLL_MINS | FLOAT | null | Respiration Follow-up Minutes |
BS_FOLL_MINS | FLOAT | null | Blood Sugar Follow-up Minutes |
PS_FOLL_MINS | FLOAT | null | Pain Scale Follow-up Minutes |
PSLOC_FOLL_MINS | FLOAT | null | Pain Scale Location Follow-up Minutes |
UNCHART_TRANS | varchar(3) | null | Unchart Function Performed(YES or NO) |
CHRT_ENT_DATE | varchar(8) | null | System Date Chart Entered(YYYYMMDD) |
CHRT_ENT_TIME | varchar(5) | null | System Time Chart Entered(HH:MM) |
ITN | varchar(12) | null | Internal Number used to create a Unique Key for Active Patient Files |
PAT_NUM | varchar(12) | null | Patient Number |
PTMEDREC | varchar(12) | null | Medical Record Number |
PTNAME | varchar(32) | null | Patient Name |
PTCLASS | varchar(1) | null | Patient Class(I, O, or E) |
PTTYPE | varchar(1) | null | Patient Type |
PTBED | varchar(6) | null | Bed - Full Room/Bed Code |
PTSERV | varchar(3) | null | Patient Service |
ATTDOCNU | varchar(6) | null | Attending Physician Number |
ATTDOCNA | varchar(32) | null | Attending Physician Name |
PTSEX | varchar(1) | null | Patient Sex |
PTAGE | varchar(5) | null | Patient Age |
PTBIRTH | varchar(8) | null | Patient Date of Birth(YYYYMMDD) |
PAT_HEIGHT_CM | varchar(12) | null | Patient Height in CM |
PAT_WEIGHT_KG | varchar(12) | null | Patients Weight in Kilograms |
ICD9_1 | varchar(12) | null | Primary ICD9 Diagnosis Code |
DIAGNOSIS_1 | varchar(64) | null | Primary ICD9 Diagnosis Code Description |
ICD9_2 | varchar(12) | null | Secondary ICD9 Diagnosis Code |
DIAGNOSIS_2 | varchar(64) | null | Secondary ICD9 Diagnosis Code Description |
ALLERGY_1 | varchar(64) | null | Nursing Allergy 1 |
ALLERGY_2 | varchar(64) | null | Nursing Allergy 2 |
CCRC_DATE | varchar(8) | null | Calculated Creat Clearance Date(YYYYMMDD) |
CCRC_TIME | varchar(5) | null | Calc Creatinine Clearance Time |
CALC_CREAT_CLEAR | FLOAT | null | Calculate Creatinine Clearance |
PMP | varchar(5) | null | Pharmacy Order Number |
ANC_ORD_NO | varchar(23) | null | Ancilliary Order Number |
SIG | varchar(15) | null | SIG - Latin Directions |
SIG_DESC | varchar(30) | null | SIG Description - Latin Directions Expanded |
FREQUENCY | varchar(8) | null | Frequency(Interval) |
FREQUENCY_UNIT | varchar(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_WEEK | varchar(20) | null | Days of the Week |
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 |
IV_METHOD_CODE | varchar(2) | null | IV Method Code(0 to 10). See Pharmacy Method Masterfile PHM_METHOD_MF |
IV_METHOD | varchar(6) | null | IV Method Abbreviation(Ex: PUSH,LVP,TPN,...). See Pharmacy Method Masterfile PHM_METHOD_MF |
START_DATE | varchar(8) | null | Order Start Date(YYYYMMDD) |
START_TIME | varchar(5) | null | Start Time(HH:MM) |
STOP_DATE | varchar(8) | null | Stop Date of the Order(YYYYMMDD) |
STOP_TIME | varchar(5) | null | Stop Time(HH:MM) |
ORD_DRNO | varchar(6) | null | Ordering Doctor Number |
ORD_DRNAME | varchar(32) | null | Ordering Doctor Name |
MED_IV | varchar(3) | null | MED or IV |
SCH_PRN | varchar(3) | null | SCH or PRN |
PRIORITY | varchar(15) | null | Order Priority |
ONE_TIME | varchar(3) | null | One Time(YES or NO) |
VALIDATED_BY | varchar(6) | null | Order Validated by(RPH INIT) |
VALIDATED_DATE | varchar(8) | null | Validated Date(YYYYMMDD) |
VALIDATED_TIME | varchar(5) | null | Validated Time(HH:MM) |
ENTERED_BY | varchar(6) | null | Order Entered By(Initials) |
ENTERED_DATE | varchar(8) | null | Entered Date(YYYYMMDD) |
ENTERED_TIME | varchar(5) | null | Entered Time(HH:MM) |
ORDER_STATUS | varchar(20) | null | Order Status |
DIRECTIONS_1 | varchar(30) | null | Directions 1 |
DIRECTIONS_2 | varchar(30) | null | Directions 2 |
DIRECTIONS_3 | varchar(30) | null | Directions 3 |
DIRECTIONS_4 | varchar(30) | null | Directions 4 |
DIRECTIONS_5 | varchar(30) | null | Directions 5 |
DIRECTIONS_6 | varchar(30) | null | Directions 6 |
COMPONENT_TYPE | varchar(3) | null | Component Type(CXM,ADD,SOL,MED,PMX,SCA) |
GENERIC_NAME | varchar(30) | null | Generic Name of Drug |
BRAND_NAME | varchar(30) | null | Brand Name of Drug |
PRIMARY_NAME | varchar(30) | null | Primary Name of Drug |
DOSE | varchar(47) | null | Dose(Normalized Dose) - this should be the dose dispensed. |
ADM_DOSE_OVR | varchar(20) | null | Administered Dose if Overridden |
NDU | varchar(6) | null | Number of Dispensing Units |
ROUTE | varchar(10) | null | Route of Administration |
DOSAGE_FORM | varchar(10) | null | Dosage Form of Drug |
LABELER | varchar(32) | null | Labeler |
DRUG_CODE | varchar(5) | null | Drug Code |
DEA_CODE | varchar(2) | null | DEA(Drug Enforcement Administration) Code |
NDC | varchar(14) | null | NDC(National Drug Code) Number |
GCS | FLOAT | null | GCS(Generic Code Sequence Number) |
THER_CODE_1 | varchar(8) | null | Therapeutic Code 1 |
THER_CODE_2 | varchar(8) | null | Therapeutic Code 2 |
THER_CODE_3 | varchar(8) | null | Therapeutic Code 3 |
PRIMARY_INGRED | varchar(3) | null | Primary Ingredient(YES or NO) |
ORDER_REASON | varchar(30) | null | Order Reason |
EARLY_OR_LATE_RSN | varchar(32) | null | Early or Late Reason |
DRUG_RTE_SCAN_ERR | varchar(10) | null | DRUG ROUTE SCAN ERROR |
ORD_FDB_DRUG | varchar(32) | null | Order FDB(First Databank) Drug Name |
ORD_FDB_STRN | varchar(20) | null | Order FDB(First Databank) Strength |
ORD_FDB_RTE | varchar(10) | null | Order FDB(First Databank) Route |
IMR | varchar(16) | null | Internal Number used to create a Unique Key for Historical Files |
PERSON_NUMBER | varchar(16) | null | Identifies a Patient uniquely across multiple sites for a single enterprise |
PTAGE_IN_DAYS | FLOAT | null | Patient Age Displayed in Number of Days |
REMINDER_CODE | varchar(15) | null | Reminder Code |
REMINDER_SHORT_DESC | varchar(30) | null | Reminder short description |
RECONF_USER_FUNCTION | varchar(24) | null | What function was the user performing when reconfirm user logged a bad scan |
ORDER_SPECIFIC_BAR_CODE | varchar(3) | null | Order Specific Bar Code(YES or NO) |
BRAND_NAME_TM | varchar(30) | null | Brand Name of Drug in Tall Man Format |
GENERIC_NAME_TM | varchar(30) | null | Generic Name of Drug in Tall Man Format |
PRIMARY_NAME_TM | varchar(30) | null | Primary Name of Drug in Tall Man Format |
SCANNED_DATA_PAT_NUM_NLZ | varchar(60) | null | Patient Number from Scan Data with No Leading Zeros |
VOLUME | varchar(19) | null | Volume |
PUMP_ID | varchar(32) | null | Pump ID |
PUMP_MESSAGE_ERR_CODE | varchar(12) | null | Pump Message Error Code |
PUMP_MESSAGE_ERR_DESC | varchar(128) | null | Pump Message Error Description |
PUMP_DRUG_NAME | varchar(30) | null | Pump Drug Name |
PUMP_DOSE | varchar(47) | null | Pump Dose |
PUMP_VOLUME | varchar(19) | null | Pump Volume |
PUMP_RATE | varchar(9) | null | Pump Rate |
PUMP_OVERRIDE_REASON | varchar(32) | null | Pump Override Reason |
PUMP_CODE | varchar(13) | null | Pump Code |
DOSE_AS_LOGGED | varchar(47) | null | Dose As Logged |
INR | varchar(4) | null | INR(International Normalized Ratio, aka: standardized prothrombin time) |
INR_REQ | varchar(3) | null | INR(International Normalized Ratio, aka: standardized prothrombin time) Required(YES or NO) |
INR_FOLL_MINS | FLOAT | null | INR(International Normalized Ratio, aka: standardized prothrombin time) Follow-up Minutes |
ERROR_CODE_DESC | varchar(45) | null | Error Code Description |
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. |
|
|
|