Table Detail Report
MLTM_ALR_INTERACT_TEXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum allergy interaction text |
Definition: | This table contains a number of template textual descriptions of allergic reactivity appropriate for display to clinical end users. Each of the textual descriptions present in this table is linked to the appropriate variables via the interaction_text_id field. |
Table Type: | REFERENCE |
Column Detail - MLTM_ALR_INTERACT_TEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
INTERACTION_TEXT | VARCHAR(2000) | Y | textual descriptions of allergic reactivity |
INTERACTION_TEXT_ID | DOUBLE | N | Each of the textual descriptions present in this table is linked to the appropriate variables via the interaction_text_id field. |
REV_INTERACTION_TEXT | VARCHAR(2000) | Y | Revised Interaction Text |
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 - MLTM_ALR_INTERACT_TEXT
Parent Column in MLTM_ALR_INTERACT_TEXT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | INTERACTION_TEXT_ID | MLTM_ALR_TEXT_MAP | INTERACTION_TEXT_ID |
MLTM_ALR_INTERACT_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum allergy interaction type |
Definition: | This table contains the interaction_type_id that is necessary for displaying appropriate messages to end users. It also contains a textual description of each allergic interaction type for purposes of application development only. |
Table Type: | REFERENCE |
Column Detail - MLTM_ALR_INTERACT_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
INTERACTION_DESCRIPTION | VARCHAR(255) | Y | a textual description of each allergic interaction type for purposes of application development only. |
INTERACTION_TYPE_ID | DOUBLE | N | Primary Key. Necessary for displaying appropriate messages to end users. |
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 - MLTM_ALR_INTERACT_TYPE
Parent Column in MLTM_ALR_INTERACT_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | INTERACTION_TYPE_ID | MLTM_ALR_TEXT_MAP | INTERACTION_TYPE_ID |
MLTM_ALR_TEXT_MAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum allergy text map |
Definition: | This table is intended to locate the most appropriate textual description of an allergy for display to clinical end users. Because certain allergy classifications are associated with specific textual descriptions (i.e., the Narcotic Analgesic Class is associated with different text than other classifications), this table allows association of an interaction type, an allergy classification, and an identifier for a textual description. |
Table Type: | REFERENCE |
Column Detail - MLTM_ALR_TEXT_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
ALR_CATEGORY_ID | DOUBLE | N | FK from ALR_CATEGORY table. |
INTERACTION_TEXT_ID | DOUBLE | N | FK from the ALR INTERACTION TEXT table |
INTERACTION_TYPE_ID | DOUBLE | N | FK from the ALR Interction Type 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 - MLTM_ALR_TEXT_MAP
Child Column in MLTM_ALR_TEXT_MAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ALR_CATEGORY_ID | MLTM_ALR_CATEGORY | ALR_CATEGORY_ID |
INTERACTION_TEXT_ID | MLTM_ALR_INTERACT_TEXT | INTERACTION_TEXT_ID | |
INTERACTION_TYPE_ID | MLTM_ALR_INTERACT_TYPE | INTERACTION_TYPE_ID |
MLTM_ALT_DRUG_CAT_NAME
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum Alt Drug Category Name |
Definition: | Alternate Drug Category Names |
Table Type: | REFERENCE |
Column Detail - MLTM_ALT_DRUG_CAT_NAME
Column Name | Type | Null? | Definition |
---|---|---|---|
ALTERNATE_DRUG_CAT_NAME | VARCHAR(60) | Y | Alternate Drug Category Name - Text |
ALTERNATE_DRUG_CAT_NAME_ID | DOUBLE | N | Primary Key column for this table |
CATEGORY_ID | DOUBLE | N | Category ID from the MLTM_DRUG_CATEGORIES 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 - MLTM_ALT_DRUG_CAT_NAME
Child Column in MLTM_ALT_DRUG_CAT_NAME(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATEGORY_ID | MLTM_DRUG_CATEGORIES | MULTUM_CATEGORY_ID |
MLTM_BCB_ALG_MAP
Column Section | Top of Page |
Table-level Detail
Description: | MLTM_BCB_ALG_MAP |
Definition: | Table used to store relationships between France's BCB identifier and Multum Drug Identifier's for use with allergy checking |
Table Type: | REFERENCE |
Column Detail - MLTM_BCB_ALG_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
BCB_CODE | DOUBLE | N | Code as provided by BCB |
BCB_DESCRIPTION | VARCHAR(255) | N | Description as provided by BCB |
DRUG_IDENTIFIER | VARCHAR(6) | N | Multum drug identifier associated to BCB Code |
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. |