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.