Table Detail Report
MLTM_NDC_IMAGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM NDC IMAGE |
Definition: | Store Physical information for drug products (Shape, Color, Flavor, Inscriptions, etc.) |
Table Type: | REFERENCE |
Column Detail - MLTM_NDC_IMAGE
Column Name | Type | Null? | Definition |
---|---|---|---|
ADDITIONAL_DOSEFORM_ID | DOUBLE | N | Value from MLTM_ADDITIONAL_DOSEFORM table |
COLOR_ID | DOUBLE | N | Value from MLTM_COLOR table |
FLAVOR_ID | DOUBLE | N | Value from MLTM_FLAVOR table |
IMAGE | VARCHAR(50) | Y | File Name of Image JPEG |
NDC_LEFT_9 | VARCHAR(9) | N | First 9 digits of NDC_CODE. Primary Key for this table. |
SCORED_IND | DOUBLE | N | Scored Indicator. 1 = true, 0 = false. |
SHAPE_ID | DOUBLE | N | Value comes from the MLTM_SHAPE table |
SIDE_1_MARKING | VARCHAR(25) | Y | Inscription on Side 1 |
SIDE_2_MARKING | VARCHAR(25) | Y | Inscription on Side 2 |
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_IMAGE
Child Column in MLTM_NDC_IMAGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADDITIONAL_DOSEFORM_ID | MLTM_ADDITIONAL_DOSEFORM | ADDITIONAL_DOSEFORM_ID |
COLOR_ID | MLTM_COLOR | COLOR_ID | |
FLAVOR_ID | MLTM_FLAVOR | FLAVOR_ID | |
SHAPE_ID | MLTM_SHAPE | SHAPE_ID |
MLTM_NDC_INGRED_STRENGTH
Column Section | Top of Page |
Table-level Detail
Description: | Multum NDC Ingredient Strength |
Definition: | This table contains a listing of all of the mathematically expressed ingredient strengths in Multum's databases. Each ingredient strength is associated with a unique code and a collection of four fields |
Table Type: | REFERENCE |
Column Detail - MLTM_NDC_INGRED_STRENGTH
Column Name | Type | Null? | Definition |
---|---|---|---|
INGREDIENT_STRENGTH_CODE | DOUBLE | N | This field contains a unique code for each ingredient strength |
STRENGTH_DENOM_AMOUNT | DOUBLE | N | This field contains a number representing the denominator in expressions of strength (or concentration) |
STRENGTH_DENOM_UNIT | DOUBLE | N | This field contains a code representing the unit of measurement for the denominator of expressions of strength or concentration |
STRENGTH_DENOM_UNIT_CD | DOUBLE | N | Strength unit code from code set 54 |
STRENGTH_NUM_AMOUNT | DOUBLE | N | This field contains a number representing the numerator in expressions of strength (or concentration) |
STRENGTH_NUM_UNIT | DOUBLE | N | This field contains a code representing the unit of measurement for the numerator of expressions of strength or concentration |
STRENGTH_NUM_UNIT_CD | DOUBLE | N | Strength num unit code from code set 54 |
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_NDC_INNER_CORE_DESC
Column Section | Top of Page |
Table-level Detail
Description: | MLTM_NDC_INNER_CORE_DESC |
Definition: | Table used to store details about the inner packaging NDC codes |
Table Type: | REFERENCE |
Column Detail - MLTM_NDC_INNER_CORE_DESC
Column Name | Type | Null? | Definition |
---|---|---|---|
BRAND_CODE | DOUBLE | N | This field contains a unique code for each brand name. |
GBO | VARCHAR(1) | N | This field designates the product's status as a brand name product or a generic product. This status is based on Multum's internal editorial rules and cost algorithms that are used to determine whether a multi-source drug is generic or not. |
INNER_NDC_CODE | VARCHAR(25) | 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. |
INNER_PACKAGE_DESC_CODE | DOUBLE | N | This field contains a code that represents units that describe the package size. Not all drug products require a package unit description for a complete representation of the packaging. |
INNER_SIZE | DOUBLE | N | This field represents the number of individual units present in the innermost packaging of a drug. |
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. |
NDC_FORMATTED | VARCHAR(25) | N | This field presents the National Drug Code in the format #####-####-##, where the first set of numbers identify the manufacturer of a product, the second set of numbers identify the product, and the last set identifies the package size of the product. This field differs from the ndc_code field in that it includes dashes between each set of numbers. |
OBSOLETE_DATE | DATETIME | Y | This field contains data only if a drug product is no longer being manufactured. It will contain the date when the product became obsolete. Multum uses the shelf expiration date of the last batch produced by a manufacturer, or the date of drug withdrawal, when available. When not available, Multum provides its best estimate of the obsolete date based on information provided by wholesalers and manufacturers. |
ORANGE_BOOK_ID | DOUBLE | N | This field contains a unique code for each Orange Book code. |
OTC_STATUS | VARCHAR(1) | N | This field designates whether a product is available by prescription only (Rx) or if it is available over-the-counter (OTC). |
OUTER_PACKAGE_SIZE | DOUBLE | N | This field designates the total number of inner packages present in the final packaged product. Not all drug products require an outer package size for a complete representation of the packaging. (The package unit may suffice.) |
REPACKAGED | VARCHAR(1) | N | This field indicates whether another drug vendor has repackaged the original product. |
SOURCE_ID | DOUBLE | N | This field contains a unique code for each drug source (manufacturer/redistributor). |
UNIT_DOSE_CODE | VARCHAR(1) | N | This one character designation indicates if the product is supplied in unit dose packaging. Valid choices are: U - Packaged in unit dose. N - Not packaged in unit dose. |
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_NDC_MAIN_DRUG_CODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Contains a listing of all MMDCs - an important link to ancillary tables |
Definition: | Contains a listing of all MMDCs - an important link to ancillary tables. Each MMDC contains a unique combination of the following: drug_identifier, principal_route_code, dose_form_code, and product_strength_code. |
Table Type: | REFERENCE |
Column Detail - MLTM_NDC_MAIN_DRUG_CODE
Column Name | Type | Null? | Definition |
---|---|---|---|
CSA_SCHEDULE | VARCHAR(2) | Y | This field describes the drug class assigned to a specific product type (MMDC) under the Controlled Substances Act of 1970. |
DOSE_FORM_CKI | VARCHAR(255) | Y | CKI Code |
DOSE_FORM_CODE | DOUBLE | Y | This field contains a numeric designation for a dose form. |
DRUG_IDENTIFIER | VARCHAR(6) | Y | 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#####". |
GLOBAL_SECONDARY_IDENT | VARCHAR(50) | Y | Global drug identifier |
GLOBAL_TYPE_ID | DOUBLE | N | Identifies the type of Global Identifier stored in Global Secondary Id |
J_CODE | VARCHAR(10) | Y | This is Multum's designation for the Health Care Common Procedure Code (J-Code) used for submitting claims to insurance organizations. |
J_CODE_DESCRIPTION | VARCHAR(50) | Y | This field contains the full text of the Health Care Common Procedures Billing Code Description, including the code itself, the reimbursable route of administration, and the amount of drug to be administered. |
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. |
PRINCIPAL_ROUTE_CKI | VARCHAR(255) | Y | CKI code |
PRINCIPAL_ROUTE_CODE | DOUBLE | Y | This field contains a code for the principal (or most common) route of administration for a specific drug (MMDC). Values for these codes are located in the Multum_product_route table. |
PRODUCT_STRENGTH_CODE | DOUBLE | Y | This field contains a unique code for each product strength description. |
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_MAIN_DRUG_CODE
Child Column in MLTM_NDC_MAIN_DRUG_CODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DOSE_FORM_CODE | MLTM_DOSE_FORM | DOSE_FORM_CODE |
DRUG_IDENTIFIER | MLTM_DRUG_ID | DRUG_IDENTIFIER | |
GLOBAL_TYPE_ID | MLTM_GLOBAL_TYPE | GLOBAL_TYPE_ID | |
PRODUCT_STRENGTH_CODE | MLTM_PRODUCT_STRENGTH | PRODUCT_STRENGTH_CODE |
Parent Column in MLTM_NDC_MAIN_DRUG_CODE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MAIN_MULTUM_DRUG_CODE | MLTM_DDM_GROUP_MMDC_MAP | MAIN_MULTUM_DRUG_CODE |
MLTM_DRC_GROUP_RELTN | MAIN_MULTUM_DRUG_CODE | ||
MLTM_MMDC_ATTRIBUTE | MAIN_MULTUM_DRUG_CODE | ||
MLTM_RXB_ORDER | MAIN_MULTUM_DRUG_CODE | ||
PBS_OCS_MAPPING | MAIN_MULTUM_DRUG_CODE |
MLTM_NDC_ORANGE_BOOK
Column Section | Top of Page |
Table-level Detail
Description: | Contains a listing of Orange Book ratings. |
Definition: | This table contains a listing of Orange Book ratings. These ratings provide the FDA's indication of the relative similarity of the drug in question to a reference drug. |
Table Type: | REFERENCE |
Column Detail - MLTM_NDC_ORANGE_BOOK
Column Name | Type | Null? | Definition |
---|---|---|---|
ORANGE_BOOK_DESCRIPTION | VARCHAR(50) | Y | This field contains a textual description from the FDA's Orange Book concerning product equivalency. |
ORANGE_BOOK_DESC_AB | VARCHAR(2) | Y | This field contains the one-character FDA Orange Book rating abbreviation. Any abbreviation beginning with the letter A designates therapeutic equivalency. Abbreviations beginning with B denote a lack of equivalency. |
ORANGE_BOOK_ID | DOUBLE | N | This field contains a unique code for each Orange Book code. |
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. |