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 |