Table Detail Report

MLLD_NDC_IMAGE



Column 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 - MLLD_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 DOUBLE Y ** obsolete column - replaced by SCORED_IND. Scored Indicator. 1 = true, 0 = false.
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.


MLLD_NDC_INGRED_STRENGTH



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





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


MLLD_NDC_INNER_CORE_DESC



Column Section Top of Page


Table-level Detail

Description: MLLD_NDC_INNER_CORE_DESC
Definition: Table used to store details about the inner packaging NDC codes
Table Type: REFERENCE





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


MLLD_NDC_MAIN_DRUG_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_NDC_MAIN_DRUG_CODE


Column Name Type Null? Definition
CSA_SCHEDULE VARCHAR(1) 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 - MLLD_NDC_MAIN_DRUG_CODE


Child Column in MLLD_NDC_MAIN_DRUG_CODE(FK) Parent Table Name Parent Column Name
Parents: GLOBAL_TYPE_ID MLLD_GLOBAL_TYPE GLOBAL_TYPE_ID


MLLD_NDC_ORANGE_BOOK



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





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