Table Detail Report

MLLD_GLOBAL_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLLD_GLOBAL_TYPE
Definition: Table for loading Multum Global Types
Table Type: REFERENCE





Column Detail - MLLD_GLOBAL_TYPE


Column Name Type Null? Definition
COUNTRY_ID DOUBLE N FK to MLLD_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 - MLLD_GLOBAL_TYPE


Child Column in MLLD_GLOBAL_TYPE(FK) Parent Table Name Parent Column Name
Parents: COUNTRY_ID MLLD_COUNTRY COUNTRY_ID




Parent Column in MLLD_GLOBAL_TYPE (PK) Child Table Name Child Column Name
Children: GLOBAL_TYPE_ID MLLD_BCB_DRC_UNITS GLOBAL_TYPE_ID
MLLD_DRUG_NAME_GLOBAL_TYPE GLOBAL_TYPE_ID
MLLD_NDC_CORE_DESCRIPTION GLOBAL_TYPE_ID
MLLD_NDC_MAIN_DRUG_CODE GLOBAL_TYPE_ID


MLLD_INTERACTION_DESCRIPTION



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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_DESCRIPTION_ID DOUBLE N Interaction Description ID
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.


MLLD_INT_DRUG_INTERACTIONS



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.


MLLD_INT_HEADER



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.


MLLD_INT_HEADER_SEVERITY_MAP



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_INT_HEADER_SEVERITY_MAP


Column Name Type Null? Definition
HEADER_ID DOUBLE N Header ID - 1st column in 2-column PK. FK from table MLTM_INT_HEADER
SEQUENCE_NUMBER DOUBLE N Sequence Number
SEVERITY_ID DOUBLE N Severity ID - 2nd column of 2-column PK. FK from MLTM_SEVERITY
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.