ALERT_AUDIT_ALLERGY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Allergy
Definition: Stores audited allergy 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_ALLERGY


Column Name Type Null? Definition
ALERT_AUDIT_ALLERGY_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.
ALLERGY_ALR_CATEGORY_ID DOUBLE N The allergy category id of the allergy.
ALLERGY_IDENTIFIER VARCHAR(6) N The allergy identifier from the mltm_drug_id table.
CLASS_ID DOUBLE N The allergy class id of the drug and allergy found in the mltm_alr_class table.
DCP_ENTITY_RELTN_ID DOUBLE N The dcp_entity_reltn_id relating to the customization details of the allergy interaction.
DESC_LONG_TEXT_ID DOUBLE N The long_text_id relating to the description of the allergy interaction
DRUG_ALLERGY_IND DOUBLE N Indicates if the interaction is a drug-allergy interaction or an allergy-drug interaction.
DRUG_ALR_CATEGORY_ID DOUBLE N The allergy category ID of the drug.
DRUG_IDENTIFIER VARCHAR(6) N The drug identifier from the table mltm_drug_id.
INTERACTION_LEVEL_FLAG DOUBLE N The interaction level of the allergy interaction. 0- Drug, 1 - Category, 2 - Class.
INTERACTION_TYPE_ID DOUBLE N The interaction type id of the allergy interaction from the mltm_alr_text_map table..
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_ALLERGY


Child Column in ALERT_AUDIT_ALLERGY(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_ALLERGY (PK) Child Table Name Child Column Name
Children: ALERT_AUDIT_ALLERGY_ID ALERT_AUDIT_ALLERGY_DOM ALERT_AUDIT_ALLERGY_ID


ALERT_AUDIT_ALLERGY_DOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Allergy Domain
Definition: Stores additional domain information relating to allergy 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_ALLERGY_DOM


Column Name Type Null? Definition
ALERT_AUDIT_ALLERGY_DOM_ID DOUBLE N The unique primary key of this table. It is an internally generated sequence number.
ALERT_AUDIT_ALLERGY_ID DOUBLE N The ID of the allergy interaction on table Alert_audit_allergy.
ALLERGY_ID DOUBLE N The ID of the allergy (from the allergy table) associated to this audit record.
CATALOG_CD DOUBLE N The catalog code associated to the order.
DRUG_ALLERGY_IND DOUBLE N Indicates if the interaction is a drug-allergy interaction or an allergy-drug interaction.
ENCNTR_ID DOUBLE N The encounter_id associated to the subject of the allergy interaction.
FREETEXT_OVERRIDE_REASON_IND DOUBLE N The indicator denoting if a free text override reason was provided.
NOMENCLATURE_ID DOUBLE N The nomenclature_id associated to the allergy.
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.
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_ALLERGY_DOM


Child Column in ALERT_AUDIT_ALLERGY_DOM(FK) Parent Table Name Parent Column Name
Parents: ALERT_AUDIT_ALLERGY_ID ALERT_AUDIT_ALLERGY ALERT_AUDIT_ALLERGY_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
OVERRIDE_REASON_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD


ALERT_AUDIT_DRUG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Drug
Definition: Stores audited drug-drug 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_DRUG


Column Name Type Null? Definition
ALERT_AUDIT_DRUG_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-drug interaction.
DESC_LONG_TEXT_ID DOUBLE N The long_text_id relating to the description of the drug-drug interaction.
DRUG_IDENTIFIER_1 VARCHAR(6) N The first drug identifier.
DRUG_IDENTIFIER_1_SUBJECT_IND DOUBLE N Indicator denoting whether the first drug identifier is the subject of the drug-drug interaction.
DRUG_IDENTIFIER_2 VARCHAR(6) N The second drug identifier.
SEVERITY_DETAILS_BIT DOUBLE N The severity details of the drug-drug interaction.
SEVERITY_FLAG DOUBLE N The severity of the drug-drug interaction. 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_DRUG


Child Column in ALERT_AUDIT_DRUG(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_DRUG (PK) Child Table Name Child Column Name
Children: ALERT_AUDIT_DRUG_ID ALERT_AUDIT_DRUG_DOM ALERT_AUDIT_DRUG_ID


ALERT_AUDIT_DRUG_DOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Drug Domain
Definition: Stores additional domain information relating to drug-drug 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_DRUG_DOM


Column Name Type Null? Definition
ALERT_AUDIT_DRUG_DOM_ID DOUBLE N The unique primary key of this table. It is an internally generated sequence number.
ALERT_AUDIT_DRUG_ID DOUBLE N The ID of the drug-drug interaction on table alert_audit_drug.
CAUSING_CATALOG_CD DOUBLE N The catalog code of the ingredient of the order that caused the alert.
CAUSING_ORDER_ID DOUBLE N The order id of the order that caused the 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.
SEVERITY_FLAG DOUBLE N The severity of the drug-drug interaction from the consumer's perspective. 0 - Minor, 1 - Moderate, 2 - Major.
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_DRUG_DOM


Child Column in ALERT_AUDIT_DRUG_DOM(FK) Parent Table Name Parent Column Name
Parents: ALERT_AUDIT_DRUG_ID ALERT_AUDIT_DRUG ALERT_AUDIT_DRUG_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_DUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alert Audit Duplication
Definition: Stores audited duplicate therapy alerts where each duplication 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_DUP


Column Name Type Null? Definition
ALERT_AUDIT_DUP_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.
CATEGORY_DUPLICATION_IND DOUBLE N Indicator denoting if the duplication is for a category or drug.
CATEGORY_LEVEL_FLAG DOUBLE N The level at which the duplication occurs at. 0 - Not a category duplication, 1 - First level, 2 - Second level, 3 - Third level.
DCP_ENTITY_RELTN_ID DOUBLE N The dcp_entity_reltn_id relating to the customization details of the duplicate therapy alert.
DRUG_IDENTIFIER VARCHAR(6) N The drug identifier relating to the duplicate therapy alert.
MAXIMUM_OCCURRENCES_NBR DOUBLE N The maximum number of allowed occurrences of the alert.
MULTUM_CATEGORY_ID DOUBLE N The Multum duplication category of the drug.
OBSERVED_OCCURRENCES_NBR DOUBLE N The number of observed occurrences resulting in the duplication.
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


Child Column in ALERT_AUDIT_DUP(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




Parent Column in ALERT_AUDIT_DUP (PK) Child Table Name Child Column Name
Children: ALERT_AUDIT_DUP_ID ALERT_AUDIT_DUP_CAT_CAUSE ALERT_AUDIT_DUP_ID
ALERT_AUDIT_DUP_DOM ALERT_AUDIT_DUP_ID