Table Detail Report

MLLD_DRUG_LEAFLET_MAP



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRUG_LEAFLET_MAP


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N Drug Identifier Multum's identification codes for generic drugs.
LEAFLET_ID DOUBLE N patient education leaflet row identifier
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_DRUG_MODIFIER



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRUG_MODIFIER


Column Name Type Null? Definition
MODIFIER_DESCRIPTION VARCHAR(60) N This field contains a textual description of a drug name modifier.
MODIFIER_ID DOUBLE N This field contains a unique identifier for each drug name modifier.
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_DRUG_MODIFIER_MAP



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRUG_MODIFIER_MAP


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N This field contains Multum's identification codes for generic drugs.
MODIFIER_ID DOUBLE N This field contains a unique identifier for each drug name modifier.
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_DRUG_NAME



Column Section Relationship Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRUG_NAME


Column Name Type Null? Definition
DRUG_NAME VARCHAR(255) Y This field contains Multum's succinct, fixed-length generic drug names. This field also contains brand names, which are the drug names as they appear on labels of drug products.
DRUG_SYNONYM_ID DOUBLE N This field contains a unique numeric identifier for a description of a drug.
IS_OBSOLETE VARCHAR(1) Y This field indicates whether a drug is currently available on the market in the United States.
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_DRUG_NAME




Parent Column in MLLD_DRUG_NAME (PK) Child Table Name Child Column Name
Children: DRUG_SYNONYM_ID MLLD_DMD_NAME_MAP DRUG_SYNONYM_ID
MLLD_DRUG_NAME_GLOBAL_TYPE DRUG_SYNONYM_ID
MLLD_MANUFACT_DRUG_NAME DRUG_SYNONYM_ID
MLLD_RXN_MAP DRUG_SYNONYM_ID


MLLD_DRUG_NAME_DERIVATION



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRUG_NAME_DERIVATION


Column Name Type Null? Definition
BASE_DRUG_SYNONYM_ID DOUBLE N This field contains the drug synonym ID of the generic or trade name used to generate a particular generic or trade product name.
BASE_FUNCTION_ID DOUBLE N This field contains the function ID (generic or trade) of the base_drug_synonym_id.
DERIVED_DRUG_SYNONYM_ID DOUBLE N This field contains the drug synonym ID of the generic or trade product name that was derived from a generic or trade name combined with a Main Multum Drug Code (MMDC).
DERIVED_FUNCTION_ID DOUBLE N This field contains the function ID (59 or 60) of the derived_drug_synonym_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.