Table Detail Report

ALERT_AUDIT_DUP_CAT_CAUSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Duplication Category Cause
Definition: Stores the causes of each audited category duplicate therapy alert. The scope of the auditing is limited to the most basic reference information utilized by the clinical checking service.
Table Type: ACTIVITY





Column Detail - ALERT_AUDIT_DUP_CAT_CAUSE


Column Name Type Null? Definition
ALERT_AUDIT_DUP_CAT_CAUSE_ID DOUBLE N The unique primary key of this table. It is an internally generated sequence number.
ALERT_AUDIT_DUP_ID DOUBLE N Alert audit duplicate therapy alert id
DRUG_IDENTIFIER VARCHAR(6) N The drug identifier of the causing drug of a category duplication.
OBSERVED_OCCURRENCES_NBR DOUBLE N The number of observed occurrences for this drug.
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 - ALERT_AUDIT_DUP_CAT_CAUSE


Child Column in ALERT_AUDIT_DUP_CAT_CAUSE(FK) Parent Table Name Parent Column Name
Parents: ALERT_AUDIT_DUP_ID ALERT_AUDIT_DUP ALERT_AUDIT_DUP_ID


ALERT_AUDIT_DUP_DOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Duplication Domain
Definition: Stores additional domain information relating to duplicate therapy alerts. The scope of the auditing is limited to data provided by the consumer that relates to a particular duplication.
Table Type: ACTIVITY





Column Detail - ALERT_AUDIT_DUP_DOM


Column Name Type Null? Definition
ALERT_AUDIT_DUP_DOM_ID DOUBLE N The unique primary key of this table. It is an internally generated sequence number.
ALERT_AUDIT_DUP_ID DOUBLE N The Alert Audit Duplication ID relating to the duplicate therapy alert.
CAUSING_CATALOG_CD DOUBLE N The catalog code of the ingredient of the order that caused the duplicate therapy alert.
CAUSING_ORDER_ID DOUBLE N The order id of the order that caused the duplicate therapy alert.
ENCNTR_ID DOUBLE N The encounter ID associated to the subject order.
FREETEXT_OVERRIDE_REASON_IND DOUBLE N The indicator denoting if a free text override reason was provided.
NO_OVERRIDE_REASON_IND DOUBLE N The indicator denoting if an override reason was provided.
OVERRIDE_REASON_CD DOUBLE N The code value of the override reason.
OVERRIDE_REASON_LONG_TEXT_ID DOUBLE N The long_text_id relating to the free text override reason.
SUBJECT_CATALOG_CD DOUBLE N The catalog code of the ingredient of the subject order.
SUBJECT_ORDER_ID DOUBLE N The order ID of the subject 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.



Relationship Detail - ALERT_AUDIT_DUP_DOM


Child Column in ALERT_AUDIT_DUP_DOM(FK) Parent Table Name Parent Column Name
Parents: ALERT_AUDIT_DUP_ID ALERT_AUDIT_DUP ALERT_AUDIT_DUP_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
OVERRIDE_REASON_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
CAUSING_CATALOG_CD ORDER_CATALOG CATALOG_CD
SUBJECT_CATALOG_CD ORDER_CATALOG CATALOG_CD


ALERT_AUDIT_FOOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Food
Definition: Stores audited drug-food interactions where each interaction is tied to an auditing transaction. The scope of the auditing is limited to the most basic reference information utilized by the clinical checking service.
Table Type: ACTIVITY





Column Detail - ALERT_AUDIT_FOOD


Column Name Type Null? Definition
ALERT_AUDIT_FOOD_ID DOUBLE N The unique primary key of this table. It is an internally generated sequence number.
ALERT_AUDIT_TRANSACTION_ID DOUBLE N The primary key of the Alert Audit Transaction table.
DCP_ENTITY_RELTN_ID DOUBLE N The dcp_entity_reltn_id relating to the customization details of the drug-food interaction.
DESC_LONG_TEXT_ID DOUBLE N The long_text_id relating to the description of the drug-food interaction.
DRUG_IDENTIFIER VARCHAR(6) N The drug identifier of the drug-food interaction from the table mltm_int_drug_interactions.
SEVERITY_DETAILS_BIT DOUBLE N The severity details of the drug-food interaction.
SEVERITY_FLAG DOUBLE N The severity of the drug-food interaction. 0 - Minor, 2 - Moderate, 3 - Major.
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 - ALERT_AUDIT_FOOD


Child Column in ALERT_AUDIT_FOOD(FK) Parent Table Name Parent Column Name
Parents: ALERT_AUDIT_TRANSACTION_ID ALERT_AUDIT_TRANSACTION ALERT_AUDIT_TRANSACTION_ID
DCP_ENTITY_RELTN_ID DCP_ENTITY_RELTN DCP_ENTITY_RELTN_ID
DESC_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in ALERT_AUDIT_FOOD (PK) Child Table Name Child Column Name
Children: ALERT_AUDIT_FOOD_ID ALERT_AUDIT_FOOD_DOM ALERT_AUDIT_FOOD_ID


ALERT_AUDIT_FOOD_DOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Food Domain
Definition: Stores additional domain information relating to drug-food interactions. The scope of the auditing is limited to data provided by the consumer that relates to a particular interaction.
Table Type: ACTIVITY





Column Detail - ALERT_AUDIT_FOOD_DOM


Column Name Type Null? Definition
ALERT_AUDIT_FOOD_DOM_ID DOUBLE N The primary key of this table. It is an internally generated sequence number.
ALERT_AUDIT_FOOD_ID DOUBLE N The alert_audit_food_id related to the drug-food interaction.
CATALOG_CD DOUBLE N The catalog code associated to the order.
ENCNTR_ID DOUBLE N The encounter ID associated to the order.
FREETEXT_OVERRIDE_REASON_IND DOUBLE N The indicator denoting if a free text override reason was provided.
NO_OVERRIDE_REASON_IND DOUBLE N The indicator denoting if an override reason was provided.
ORDER_ID DOUBLE N The ID of the order from the Orders table.
OVERRIDE_REASON_CD DOUBLE N The code value of the override reason.
OVERRIDE_REASON_LONG_TEXT_ID DOUBLE N The long_text_id relating to the free text override reason.
SEVERITY_FLAG DOUBLE N The severity of the drug-food interaction from the consumer's perspective. 0 - Minor, 1 - Moderate, 2 - Major.
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 - ALERT_AUDIT_FOOD_DOM


Child Column in ALERT_AUDIT_FOOD_DOM(FK) Parent Table Name Parent Column Name
Parents: ALERT_AUDIT_FOOD_ID ALERT_AUDIT_FOOD ALERT_AUDIT_FOOD_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
OVERRIDE_REASON_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD


ALERT_AUDIT_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Transaction
Definition: Stores audit transactions for clinical alerting. An audit transaction describes all of the clinical alerts that were fired during a single transaction for a consumer.
Table Type: ACTIVITY





Column Detail - ALERT_AUDIT_TRANSACTION


Column Name Type Null? Definition
ALERT_AUDIT_TRANSACTION_ID DOUBLE N The unique primary key of this table. It is an internally generated sequence number.
DOMAIN_DATA_IND DOUBLE N Indicates where consumer supplied domain data exists for the audited alerts of the transaction.
PERSON_ID DOUBLE N The identifier of the patient whom the clinical checking is being performed for.
PRSNL_ID DOUBLE N The identifier of the personnel performing the clinical checking.
TRANSACTION_DT_TM DATETIME N The date/time the transaction was performed.
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 - ALERT_AUDIT_TRANSACTION


Child Column in ALERT_AUDIT_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in ALERT_AUDIT_TRANSACTION (PK) Child Table Name Child Column Name
Children: ALERT_AUDIT_TRANSACTION_ID ALERT_AUDIT_ALLERGY ALERT_AUDIT_TRANSACTION_ID
ALERT_AUDIT_DRUG ALERT_AUDIT_TRANSACTION_ID
ALERT_AUDIT_DUP ALERT_AUDIT_TRANSACTION_ID
ALERT_AUDIT_FOOD ALERT_AUDIT_TRANSACTION_ID