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 |