Table Detail Report

MED_ADMIN_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medication Administration Event
Definition: Medication Administration Event Table
Table Type: ACTIVITY





Column Detail - MED_ADMIN_EVENT


Column Name Type Null? Definition
BEG_DT_TM DATETIME Y The beginning date/time of the range of medication admin events.
CAREAWARE_USED_IND DOUBLE N Maintains whether CareAware was used to obtain drug related information.
CLINICAL_WARNING_CNT DOUBLE N The number of clinical warnings presented for this medication admin event.
CRITICAL_DRUG_IND DOUBLE N Indicates that the alert occurred upon a medication that was critically defined.
DOCUMENTATION_ACTION_SEQUENCE DOUBLE N The action sequence of the order that the medication admin event is associated to.
END_DT_TM DATETIME Y The end date/time of the range of medication admin events.
EVENT_CNT DOUBLE N The number of medication admin events in the range of beginning and end date/time.
EVENT_ID DOUBLE N The ID of the clinical event associated to this medication admin event.
EVENT_TYPE_CD DOUBLE N Identifies what type of event was audited. Values can be code_value for TASKPURGED, TASKCOMPLETE, NOTDONE, or NOTGIVEN from code_set 4000040.
MED_ADMIN_EVENT_ID DOUBLE N The ID of the medication administration event.
NEEDS_VERIFY_FLAG DOUBLE N Indicator on whether this order is verified. 0 No Verify Needed 1 Verify 40 Needed 2 Superseded 3 Verified 4 Rejected 5 Reviewed
NURSE_UNIT_CD DOUBLE N The nurse unit of the device the user is using to enter the medication admin event.
ORDER_ID DOUBLE N The ID of the order associated to this med admin event.
ORDER_RESULT_VARIANCE_IND DOUBLE N Indicates if the documented result details do not match the order details.
POSITION_CD DOUBLE N The position of the user documenting the medication admin event.
POSITIVE_MED_IDENT_IND DOUBLE N Indicates if the medication was positively identified for this medication admin event.
POSITIVE_PATIENT_IDENT_IND DOUBLE N Indicates if the patient was positively identified for this medication admin event.
PRSNL_ID DOUBLE N The ID of the user documenting the medication admin event.
SCHEDULED_DT_TM DATETIME Y The date and time the task was scheduled to be given.
SCHEDULED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SOURCE_APPLICATION_FLAG DOUBLE Y Identification for source application used to chart med event.0
TEMPLATE_ORDER_ID DOUBLE N Order id for the template order.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VERIFICATION_DT_TM DATETIME Y The date and time verification of the order took place.
VERIFICATION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
VERIFIED_PRSNL_ID DOUBLE N The personnel that verified the order.



Relationship Detail - MED_ADMIN_EVENT


Child Column in MED_ADMIN_EVENT(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in MED_ADMIN_EVENT (PK) Child Table Name Child Column Name
Children: MED_ADMIN_EVENT_ID MED_ADMIN_ALERT MED_ADMIN_EVENT_ID


MED_ADMIN_IDENT_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medical Administration Identification Errors
Definition: Medical Administration Identification Errors Table
Table Type: ACTIVITY





Column Detail - MED_ADMIN_IDENT_ERROR


Column Name Type Null? Definition
ALERT_TYPE_CD DOUBLE N The type of error recorded
BAR_CODE_IDENT VARCHAR(50) N The bar code identifier that was scanned.
CAREAWARE_USED_IND DOUBLE N Maintains whether CareAware was used to obtain drug related information.
ENCNTR_ID DOUBLE N The ID of the patient Encounter, if known, associated to this identification error event.
EVENT_DT_TM DATETIME N The date/time that the identification error occurred.
MED_ADMIN_IDENT_ERROR_ID DOUBLE N The ID of the identification error event.
NURSE_UNIT_CD DOUBLE N The nurse unit of the device the user is using when the identification error happened.
PRSNL_ID DOUBLE N The ID of the user associated to this identification error event.
SOURCE_APPLICATION_FLAG DOUBLE Y Identification for source application used to chart med event.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MED_ADMIN_IDENT_ERROR


Child Column in MED_ADMIN_IDENT_ERROR(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PRSNL_ID PRSNL PERSON_ID


MED_ADMIN_MED_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medical Administration Medication Error
Definition: Medical Administration Medication Error Table
Table Type: ACTIVITY





Column Detail - MED_ADMIN_MED_ERROR


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The action sequence of the order that the medication admin error event is associated to.
ADMIN_DT_TM DATETIME Y The date/time of when the administration was given.
ADMIN_ROUTE_CD DOUBLE N The route chosen for event that the medication admin error event is associated to.
ADMIN_TZ DOUBLE Y The time zone associated to the admin date/time.
CRITICAL_DRUG_IND DOUBLE N Indicates that the medication error occurred on a critically defined medication.
ENCOUNTER_ID DOUBLE N The ID of the encounter associated to this medication admin error event.
EVENT_ID DOUBLE N The ID of the clinical event associated to this medication admin error event.
FREETEXT_REASON VARCHAR(255) Y The free text reason given for an event that the medication admin error event is associated.
MED_ADMIN_ALERT_ID DOUBLE N ID of a medication admin alert. The foreign key to the med_admin_alert table.
MED_ADMIN_MED_ERROR_ID DOUBLE N The id of the medication admin error event.
NEEDS_VERIFY_FLAG DOUBLE N Indicator on whether this order is verified. 0 No Verify Needed 1 Verify 40 Needed 2 Superseded 3 Verified 4 Rejected 5 Reviewed
NEXT_ADMIN_DT_TM DATETIME Y The date/time of the next scheduled administration for this event.
ORDER_ID DOUBLE N The ID of the order associated to this medication admin error event.
PERSON_ID DOUBLE N The ID of the person associated to this medication admin error event.
PREVIOUS_ADMIN_DT_TM DATETIME Y The date/time of the previous scheduled administration for this event.
REASON_CD DOUBLE N The reason selected for an event which the medication admin error event is associated. This column may hold reasons from multiple code sets. Alert Type to Code Set relationships: EARLYLATE/4000020, MEDINTALERT/4000020, MEDINTOVER/4000020, MEDSCANOVER/4003287
SCHEDULED_DT_TM DATETIME Y The date/time of when the administration was scheduled to be given.
SCHEDULED_TZ DOUBLE Y The time zone associated to the scheduled date/time.
TEMPLATE_ORDER_ID DOUBLE N Order id for the template order.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VERIFICATION_DT_TM DATETIME Y The date and time verification of the order took place.
VERIFICATION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
VERIFIED_PRSNL_ID DOUBLE N The personnel that verified the order.



Relationship Detail - MED_ADMIN_MED_ERROR


Child Column in MED_ADMIN_MED_ERROR(FK) Parent Table Name Parent Column Name
Parents: ENCOUNTER_ID ENCOUNTER ENCNTR_ID
MED_ADMIN_ALERT_ID MED_ADMIN_ALERT MED_ADMIN_ALERT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID


MED_ADMIN_MED_EVENT_INGRDNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Meds Admin - Medication Event Ingredient
Definition: Meds Admin - Medication Event Ingredient Table
Table Type: ACTIVITY





Column Detail - MED_ADMIN_MED_EVENT_INGRDNT


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The catalog code of the ingredient for the medication event.
DRUG_FORM_CD DOUBLE N The drug form of the ingredient for the medication event.
IDENTIFICATION_PROCESS_CD DOUBLE N The process used to identify the ingredient.
MED_EVENT_INGREDIENT_ID DOUBLE N The id of the medication event ingredient.
PARENT_ENTITY_ID DOUBLE N The foreign key to the parent table.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the parent table.
STRENGTH DOUBLE N The dose amount of the ingredient for the medication event (strength)
STRENGTH_UNIT_CD DOUBLE N The strength unit of the ingredient for the medication event.
SYNONYM_ID DOUBLE N The synonym id of the ingredient for the medication event.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VOLUME DOUBLE N The volume amount of the ingredient for the medication event.
VOLUME_UNIT_CD DOUBLE N The volume unit of the ingredient for the medication event.



Relationship Detail - MED_ADMIN_MED_EVENT_INGRDNT


Child Column in MED_ADMIN_MED_EVENT_INGRDNT(FK) Parent Table Name Parent Column Name
Parents: SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID


MED_ADMIN_PT_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medication Administration - Patient Error
Definition: Medication Administration - Patient Error Table
Table Type: ACTIVITY





Column Detail - MED_ADMIN_PT_ERROR


Column Name Type Null? Definition
BAR_CODE_IDENT VARCHAR(50) N The identifier that was scanned.
EXPECTED_PT_ID DOUBLE N The id of the patient that was expected to be identified.
FREETEXT_REASON VARCHAR(255) Y The free text reason given for an event which the patient error event is associated.
IDENTIFIED_PT_ID DOUBLE N The id of the patient that was identified.
MED_ADMIN_ALERT_ID DOUBLE N ID of a medication admin alert. The foreign key to the med_admin_alert table.
MED_ADMIN_PT_ERROR_ID DOUBLE N The id of the patient error event.
REASON_CD DOUBLE N The reason selected for an event which the patient error event is associated. This column may hold reasons from multiple code sets. Alert Type to Code Set relationships: PPIDOVER/4003287.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MED_ADMIN_PT_ERROR


Child Column in MED_ADMIN_PT_ERROR(FK) Parent Table Name Parent Column Name
Parents: MED_ADMIN_ALERT_ID MED_ADMIN_ALERT MED_ADMIN_ALERT_ID
EXPECTED_PT_ID PERSON PERSON_ID
IDENTIFIED_PT_ID PERSON PERSON_ID