Table Detail Report

MLTM_DRUG_ID



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains a listing of all of Multum's unique generic drug identifiers
Definition: This table contains a listing of all of Multum's unique generic drug identifiers, as well as specific attributes of each.
Table Type: REFERENCE





Column Detail - MLTM_DRUG_ID


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N This field contains Multum's identification codes for generic drugs. These are extremely important codes for developers who are using Multum's database products because they serve as the primary link to all of Multum's advanced clinical services. Multum's drug_id is always of the form "d#####".
DRUG_SYNONYM_ID DOUBLE N This field contains a unique numeric identifier for a description of a drug.
EMPIRICALLY VARCHAR(1) Y This field indicates whether drug half-life information is available for the drug.
HALF_LIFE DOUBLE Y This field contains an estimate of the amount of time necessary for a drug to be eliminated from the body. This estimate may be used to determine the length of time to continue checking for a drug interaction after use of a drug is discontinued. The length of time is reported as a half-life measured in hours.
IS_SINGLE_INGREDIENT VARCHAR(1) Y This field indicates whether a drug is available as a single product or if it is only available in combination with other drugs.
MAX_THERAPEUTIC_DUPLICATION DOUBLE Y This field contains a number representing how many orders for a specified drug may be prescribed before therapeutic duplication warnings should be generated.
PREGNANCY_ABBR VARCHAR(1) Y This is a one-character field that represents the FDA's pregnancy hazard classification scheme.
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_DRUG_ID


Child Column in MLTM_DRUG_ID(FK) Parent Table Name Parent Column Name
Parents: DRUG_SYNONYM_ID MLTM_DRUG_NAME DRUG_SYNONYM_ID




Parent Column in MLTM_DRUG_ID (PK) Child Table Name Child Column Name
Children: DRUG_IDENTIFIER MLTM_ADDITIONAL_TEXT DRUG_IDENTIFIER
MLTM_ALR_CATEGORY_DRUG_MAP DRUG_IDENTIFIER
MLTM_CATEGORY_DRUG_XREF DRUG_IDENTIFIER
MLTM_DRUG_LEAFLET_MAP DRUG_IDENTIFIER
MLTM_DRUG_MODIFIER_MAP DRUG_IDENTIFIER
MLTM_DUPLICATION_DRUG_XREF DRUG_IDENTIFIER
MLTM_FTD_TEXT DRUG_IDENTIFIER
MLTM_FTD_TEXT_CONDITION DRUG_IDENTIFIER
MLTM_INT_DRUG_INTERACTIONS DRUG_IDENTIFIER_1
MLTM_INT_DRUG_INTERACTIONS DRUG_IDENTIFIER_2
MLTM_NDC_MAIN_DRUG_CODE DRUG_IDENTIFIER
MLTM_REF_DRUG DRUG_IDENTIFIER
MLTM_XP_CLIN_TEXT_XREF DRUG_IDENTIFIER
PBS_OCS_MAPPING DRUG_IDENTIFIER


MLTM_DRUG_LEAFLET_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum drug leaflet map
Definition: This table maps a patient education leaflet to a Multum nomenclature drug_id.
Table Type: REFERENCE





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



Relationship Detail - MLTM_DRUG_LEAFLET_MAP


Child Column in MLTM_DRUG_LEAFLET_MAP(FK) Parent Table Name Parent Column Name
Parents: DRUG_IDENTIFIER MLTM_DRUG_ID DRUG_IDENTIFIER


MLTM_DRUG_MODIFIER



Column Section Top of Page


Table-level Detail

Description: Multum Drug Modifier
Definition: This table assigns a textual description to each drug modifier identification number.
Table Type: REFERENCE





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


MLTM_DRUG_MODIFIER_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Drug Modifier Map
Definition: This table contains a listing of modifiers for Multum's generic drug names. This table can be used to filter drug lists so that they contain only the desired products. Examples include illicit drugs, herbal products or topical products.
Table Type: REFERENCE





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



Relationship Detail - MLTM_DRUG_MODIFIER_MAP


Child Column in MLTM_DRUG_MODIFIER_MAP(FK) Parent Table Name Parent Column Name
Parents: DRUG_IDENTIFIER MLTM_DRUG_ID DRUG_IDENTIFIER


MLTM_DRUG_NAME



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM DRUG NAME
Definition: This table contains names used to identify a drug or drug product.
Table Type: REFERENCE





Column Detail - MLTM_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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - MLTM_DRUG_NAME




Parent Column in MLTM_DRUG_NAME (PK) Child Table Name Child Column Name
Children: DRUG_SYNONYM_ID MLTM_DMD_NAME_MAP DRUG_SYNONYM_ID
MLTM_DRC_GROUP_RELTN SYNONYM_ID
MLTM_DRUG_ID DRUG_SYNONYM_ID
MLTM_DRUG_NAME_GLOBAL_TYPE DRUG_SYNONYM_ID
MLTM_MANUFACT_DRUG_NAME DRUG_SYNONYM_ID
MLTM_MMDC_ATTRIBUTE GENERIC_SYNONYM_ID
MLTM_ORDER_CATALOG DRUG_SYNONYM_ID
MLTM_RXN_MAP DRUG_SYNONYM_ID
PBS_OCS_MAPPING DRUG_SYNONYM_ID