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 |