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 |