Table Detail Report

MLTM_MMDC_NAME_MAP



Column Section Top of Page


Table-level Detail

Description: Contains a mapping between MMDCs and drug synonym terms.
Definition: This table contains a mapping between Main Multum Drug Codes (MMDCs) and drug synonym terms.
Table Type: REFERENCE





Column Detail - MLTM_MMDC_NAME_MAP


Column Name Type Null? Definition
DRUG_SYNONYM_ID DOUBLE N This field contains a unique numeric identifier for a description of a drug.
FUNCTION_ID DOUBLE N This field contains a numeric identifier that describes the classification of an entry. For example, a function_id of 16 represents a generic name for a drug; a function_id of 5 represents pregnancy text.
MAIN_MULTUM_DRUG_CODE DOUBLE N The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. An MMDC is assigned to each unique combination of the following fields: active ingredient(s), strength, route of administration, and dosage form.
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_MS_CATEGORIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Medical Supply Categories
Definition: This table contains the descriptions for a more specific categorization of medical supplies.
Table Type: REFERENCE





Column Detail - MLTM_MS_CATEGORIES


Column Name Type Null? Definition
MS_CATEGORY_ID DOUBLE N This field assigns a more specific category to a medical supply.
MS_CATEGORY_NAME VARCHAR(100) N This field provides a more specific textual description of the medical supply type.
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_MS_CATEGORIES




Parent Column in MLTM_MS_CATEGORIES (PK) Child Table Name Child Column Name
Children: MS_CATEGORY_ID MLTM_MS_CORE_DESCRIPTION MS_CATEGORY_ID


MLTM_MS_CORE_DESCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Medical Supplies Core Description
Definition: This table contains a listing of information about specific NDC-labeled medical items.
Table Type: REFERENCE





Column Detail - MLTM_MS_CORE_DESCRIPTION


Column Name Type Null? Definition
MS_BRAND_DESCRIPTION VARCHAR(45) N This field contains drug names as they appear on the label of a medical supply.
MS_CATEGORY VARCHAR(50) N This field provides a general textual description of the medical supply type: Medical Supplies, Diagnostic Supplies, Nutritional Supplements
MS_CATEGORY_ID DOUBLE N This field assigns a more specific category to a medical supply.
MS_INNER_PACKAGE_DESCRIPTION VARCHAR(30) Y This field contains a textual description of the packaging units.
MS_INNER_PACKAGE_SIZE DOUBLE N This field represents the number of individual units present in the innermost packaging of a drug.
MS_NDC_CODE VARCHAR(11) N The National Drug Code is the standard 11 digit identifier for each drug product, as recognized by HCFA, other federal and state agencies, and many commercial enterprises. It is unique to each specific product. The first 5 numbers identify the manufacturer of a product. The second 4 numbers identify the product, and the last 2 numbers identify the package size of that product.
MS_OUTER_PACKAGE_SIZE DOUBLE Y This field designates the total number of inner packages present in the final packaged product. Not all products require an outer package size for a complete representation of the packaging. (The package unit may suffice.)
MS_SOURCE_DESCRIPTION VARCHAR(120) N This field contains the names of manufacturers, redistributors, and repackagers of the medical product.
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_MS_CORE_DESCRIPTION


Child Column in MLTM_MS_CORE_DESCRIPTION(FK) Parent Table Name Parent Column Name
Parents: MS_CATEGORY_ID MLTM_MS_CATEGORIES MS_CATEGORY_ID


MLTM_NDC_ACTIVE_INGRED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum NDC Active Ingredients
Definition: This table provides the full salt/chemical name of all active ingredients of drug products available in the United States
Table Type: REFERENCE





Column Detail - MLTM_NDC_ACTIVE_INGRED


Column Name Type Null? Definition
ACTIVE_INGREDIENT_CODE DOUBLE N This field contains a unique code for each active ingredient
ACTIVE_INGREDIENT_TXT VARCHAR(255) N This field contains textual descriptions of active drug ingredients; it contains complete salt/chemical/ester names and is therefore ideally suited for many applications desighed for pharmacist end users. In general, the drug_name field, may be more appropriate for use in applications designed for clinical or consumer end users.
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_NDC_ACTIVE_INGRED




Parent Column in MLTM_NDC_ACTIVE_INGRED (PK) Child Table Name Child Column Name
Children: ACTIVE_INGREDIENT_CODE MLTM_NDC_ACT_INGRED_LIST ACTIVE_INGREDIENT_CODE


MLTM_NDC_ACT_INGRED_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum NDC Active Ingredient List
Definition: This table identifies all of the active ingredients (and their individual strengths) in each group of drug products that shares the same Main Multum Drug Code (MMDC)
Table Type: REFERENCE





Column Detail - MLTM_NDC_ACT_INGRED_LIST


Column Name Type Null? Definition
ACTIVE_INGREDIENT_CODE DOUBLE N This field contains the code from the active ingredient table (Foreign Key)
INGREDIENT_STRENGTH_CODE DOUBLE N This field contains a unique code for each ingredient strength
MAIN_MULTUM_DRUG_CODE DOUBLE N The Main Multum Drug Code is Multum's designator for groups of similar drug products.
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_NDC_ACT_INGRED_LIST


Child Column in MLTM_NDC_ACT_INGRED_LIST(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_INGREDIENT_CODE MLTM_NDC_ACTIVE_INGRED ACTIVE_INGREDIENT_CODE