Table Detail Report

MLTM_DDI_COND_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Describe the relationship, if any, between the conditions
Definition: The child condition (represented by child_cond_ddi_id) is a member within the corresponding parent condition (represented by parent_cond_ddi_id). For example, condition "Felty's Syndrome" is a child of "Rheumatoid Arthritis", which is a child of "Collagen Vascular Disease", which in turn is a child of "Autoimmune Disorder". Interaction text blocks that are associated with a parent condition automatically apply to all children conditions nested below the parent level.
Table Type: REFERENCE





Column Detail - MLTM_DDI_COND_CATEGORY


Column Name Type Null? Definition
CHILD_COND_DDI_ID DOUBLE N The child condition (represented by child_condition_id) is a member within the corresponding parent condition (represented by parent_condition_id).
PARENT_COND_DDI_ID DOUBLE N The child condition (represented by child_condition_id) is a member within the corresponding parent condition (represented by parent_condition_id).
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_DDI_COND_CATEGORY


Child Column in MLTM_DDI_COND_CATEGORY(FK) Parent Table Name Parent Column Name
Parents: CHILD_COND_DDI_ID MLTM_DDI_DESCRIPTION DDI_ID
PARENT_COND_DDI_ID MLTM_DDI_DESCRIPTION DDI_ID


MLTM_DDI_DESCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DDI Description
Definition: This table contains the data for drug-disease interaction text blocks and severity level.
Table Type: REFERENCE





Column Detail - MLTM_DDI_DESCRIPTION


Column Name Type Null? Definition
DDI_DESCRIPTION VARCHAR(4000) Y Description for Drug-Drug InteractionColumn
DDI_ID DOUBLE N Unique Identifier for table. Externally generated ID. No Sequence required.
DDI_TITLE VARCHAR(100) Y Title for Drug-Drug InteractionColumn
FUNCTION_ID DOUBLE N Multum Function Type Identifier. This will be a Foreign Key from the Multum Function_Type table when it is brought into Millennium.
SEVERITY_ID_FLAG DOUBLE N The severity_id identifies the severity level of the interaction described in a text block (21 = minor, 22 = moderate, 23 = 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 - MLTM_DDI_DESCRIPTION




Parent Column in MLTM_DDI_DESCRIPTION (PK) Child Table Name Child Column Name
Children: DDI_ID MLTM_DDI_COND_CATEGORY CHILD_COND_DDI_ID
MLTM_DDI_COND_CATEGORY PARENT_COND_DDI_ID
MLTM_DDI_MAP DDI_ID


MLTM_DDI_DRUG_CONDITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DDI Drug Condition - drug-condition-plausibility combinations
Definition: This table contains the drug-condition-plausibility combinations that are assigned to appropriate interaction text blocks.
Table Type: REFERENCE





Column Detail - MLTM_DDI_DRUG_CONDITION


Column Name Type Null? Definition
CONDITION_ID DOUBLE N This value originates in the MULTUM_CONDITION table, which has not been brought into Millennium. No FK will be created. The value would assign a common name to a medical condition.
DC_ID DOUBLE N Primary Key. Externally Generated (no sequence required).
DRUG_IDENTIFIER VARCHAR(6) N Drug Identifier - text form
PLAUSIBILITY_FLAG DOUBLE N The plausibility_id represents the likelihood that a drug and condition pair will cause the specific interaction to which it is associated (18 = low, 19 = moderate, 20 = High). Clinically
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_DDI_DRUG_CONDITION




Parent Column in MLTM_DDI_DRUG_CONDITION (PK) Child Table Name Child Column Name
Children: DC_ID MLTM_DDI_MAP DC_ID


MLTM_DDI_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum DDI Mapping
Definition: This table contains the mapping of an interaction text block to the drug-condition-plausibility combination via the dc_id field.
Table Type: REFERENCE





Column Detail - MLTM_DDI_MAP


Column Name Type Null? Definition
DC_ID DOUBLE N The dc_id is assigned to a specific drug-condition-plausibility combination. FK from the MLTM_DDI_DRUG_CONDITION table.
DDI_ID DOUBLE N drug-disease interaction text block identifier. FK from the MLTM_DDI_DESCRIPTION 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_DDI_MAP


Child Column in MLTM_DDI_MAP(FK) Parent Table Name Parent Column Name
Parents: DDI_ID MLTM_DDI_DESCRIPTION DDI_ID
DC_ID MLTM_DDI_DRUG_CONDITION DC_ID


MLTM_DDM_BODY_SYSTEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM DDM Body System
Definition: Multum DDM Body System
Table Type: REFERENCE





Column Detail - MLTM_DDM_BODY_SYSTEM


Column Name Type Null? Definition
BODY_SYSTEM_DESCRIPTION VARCHAR(50) Y Body System Description - short text
BODY_SYSTEM_ID DOUBLE N 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_DDM_BODY_SYSTEM




Parent Column in MLTM_DDM_BODY_SYSTEM (PK) Child Table Name Child Column Name
Children: BODY_SYSTEM_ID MLTM_DDM_CONDITION BODY_SYSTEM_ID