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 |