Table Detail Report

MLTM_FUNCTION_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Function Type
Definition: This table contains a code and textual description that identifies the topic of the information stored in other tables.
Table Type: REFERENCE





Column Detail - MLTM_FUNCTION_TYPE


Column Name Type Null? Definition
FUNCTION_DESCRIPTION VARCHAR(60) Y textual description that identifies the topic of the information stored in other tables.
FUNCTION_ID DOUBLE N Function ID. The PK for rows in this 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_FUNCTION_TYPE




Parent Column in MLTM_FUNCTION_TYPE (PK) Child Table Name Child Column Name
Children: FUNCTION_ID MLTM_DMD_NAME_MAP FUNCTION_ID
MLTM_XP_CLIN_TEXT_XREF FUNCTION_ID


MLTM_GLOBAL_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_GLOBAL_TYPE
Definition: Table for holding Multum Global Types
Table Type: REFERENCE





Column Detail - MLTM_GLOBAL_TYPE


Column Name Type Null? Definition
COUNTRY_ID DOUBLE N FK to MLTM_COUNTRY
DESCRIPTION VARCHAR(100) N Description for the global type
GLOBAL_TYPE_ID DOUBLE N Global Types as defined by external source
GLOBAL_TYPE_MEAN VARCHAR(12) N Abbreviated meaning for the global type for coding purposes
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_GLOBAL_TYPE


Child Column in MLTM_GLOBAL_TYPE(FK) Parent Table Name Parent Column Name
Parents: COUNTRY_ID MLTM_COUNTRY COUNTRY_ID




Parent Column in MLTM_GLOBAL_TYPE (PK) Child Table Name Child Column Name
Children: GLOBAL_TYPE_ID MLTM_BCB_DRC_UNITS GLOBAL_TYPE_ID
MLTM_DRUG_NAME_GLOBAL_TYPE GLOBAL_TYPE_ID
MLTM_NDC_CORE_DESCRIPTION GLOBAL_TYPE_ID
MLTM_NDC_MAIN_DRUG_CODE GLOBAL_TYPE_ID


MLTM_INTERACTION_DESCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Interaction Description
Definition: This table provides a textual description of each interaction and a unique code for each description. Specifically, the descriptions discuss the nature of the interaction, the frequency of occurrence (when known), the mechanism of action (when known), and a recommendation for appropriate clinical action.
Table Type: REFERENCE





Column Detail - MLTM_INTERACTION_DESCRIPTION


Column Name Type Null? Definition
INT_DESCRIPTION VARCHAR(2000) Y ** Obsolete ** This column is no longer used. Will be replaced by new column INT_DESC_TEXT.
INT_DESC_TEXT LONGTEXT Y Long Textual description of each interaction.
INT_ID DOUBLE N a unique code for each description. Primary Key.
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_INTERACTION_DESCRIPTION




Parent Column in MLTM_INTERACTION_DESCRIPTION (PK) Child Table Name Child Column Name
Children: INT_ID MLTM_INT_DRUG_INTERACTIONS INT_ID
MLTM_INT_INTERACT_SEVERITY_MAP INT_ID


MLTM_INT_DRUG_INTERACTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum drug Interactions
Definition: This table contains essential information about drug interactions, including codes for each of the drugs that participate in a specific interaction, a severity code, and a code representing specific text describing the interaction. Each interaction is described only once in the table, so interaction checking must also occur in the reverse order.
Table Type: REFERENCE





Column Detail - MLTM_INT_DRUG_INTERACTIONS


Column Name Type Null? Definition
DRUG_IDENTIFIER_1 VARCHAR(6) N This field contains Multum's identification codes for generic drugs.
DRUG_IDENTIFIER_2 VARCHAR(6) N This field contains Multum's identification codes for generic drugs.
INT_ID DOUBLE N FK from the interaction description table
SEVERITY_ID DOUBLE N FK from the Multum severity 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_INT_DRUG_INTERACTIONS


Child Column in MLTM_INT_DRUG_INTERACTIONS(FK) Parent Table Name Parent Column Name
Parents: DRUG_IDENTIFIER_1 MLTM_DRUG_ID DRUG_IDENTIFIER
DRUG_IDENTIFIER_2 MLTM_DRUG_ID DRUG_IDENTIFIER
INT_ID MLTM_INTERACTION_DESCRIPTION INT_ID


MLTM_INT_HEADER



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM INT Header
Definition: Multum INT_HEADER table
Table Type: REFERENCE





Column Detail - MLTM_INT_HEADER


Column Name Type Null? Definition
HEADER_DESCRIPTION VARCHAR(60) Y Header Description text
HEADER_ID DOUBLE N Header ID - PK column for this 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_INT_HEADER




Parent Column in MLTM_INT_HEADER (PK) Child Table Name Child Column Name
Children: HEADER_ID MLTM_INT_HEADER_SEVERITY_MAP HEADER_ID