Table Detail Report

MLTM_NDC_ADDITIONAL_DESC



Column Section Top of Page


Table-level Detail

Description: NDC additional description
Definition: This table contains additional information about a drug product, including its status as a Top 200 drug and if it is equivalent to a brand name product.
Table Type: REFERENCE





Column Detail - MLTM_NDC_ADDITIONAL_DESC


Column Name Type Null? Definition
EQUIVALENT_BRAND_ID DOUBLE N This field contains an identifier representing equivalent brand names for a particular product.
NDC_LEFT_9 VARCHAR(9) N This field presents the National Drug Code that is unique to a product, the left 9 characters without the remaining 2, which are packaging descriptions.
TOP_200_IND DOUBLE Y This field designates a drug's status as one of the 200 most prescribed brand or generic drugs in the United States during the previous year.
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_BRAND_NAME



Column Section Top of Page


Table-level Detail

Description: Contains a listing of brand names and a unique identifier for each name.
Definition: This table contains a listing of brand names and a unique identifier for each name. The same names/identifiers can be found in the multum_drug_name table; however, this table is included for backward compatibility.
Table Type: REFERENCE





Column Detail - MLTM_NDC_BRAND_NAME


Column Name Type Null? Definition
BRAND_CODE DOUBLE N This field contains a unique code for each brand name.
BRAND_DESCRIPTION VARCHAR(255) Y This textual field contains drug names as they appear on labels of 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.


MLTM_NDC_CORE_DESCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains a listing of information about specific NDC-labeled products.
Definition: Contains a listing of information about specific NDC-labeled products including the manufacturer, packaging information, and over-the-counter/prescription-only status. It also contains the MMDC to link each NDC to "higher-level" information in Multum DB.
Table Type: REFERENCE





Column Detail - MLTM_NDC_CORE_DESCRIPTION


Column Name Type Null? Definition
BRAND_CODE DOUBLE Y This field contains a unique code for each brand name.
GBO VARCHAR(1) Y 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.
GLOBAL_SECONDARY_IDENT VARCHAR(50) N Global drug identifier
GLOBAL_TYPE_ID DOUBLE N Identifies the type of Global Identifier stored in Global Secondary Id (from MLTM_GLOBAL_TYPE)
INNER_PACKAGE_DESC_CODE DOUBLE Y 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_PACKAGE_SIZE DOUBLE Y This field represents the number of individual units present in the innermost packaging of a drug.
MAIN_MULTUM_DRUG_CODE DOUBLE Y 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_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.
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.
NDC_REGULATION VARCHAR(10) Y National Drug Code RegulationColumn
NDC_SCHEME VARCHAR(3) Y National Drug Code SchemeColumn
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) Y 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 Y 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) Y 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) Y 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.



Relationship Detail - MLTM_NDC_CORE_DESCRIPTION


Child Column in MLTM_NDC_CORE_DESCRIPTION(FK) Parent Table Name Parent Column Name
Parents: GLOBAL_TYPE_ID MLTM_GLOBAL_TYPE GLOBAL_TYPE_ID




Parent Column in MLTM_NDC_CORE_DESCRIPTION (PK) Child Table Name Child Column Name
Children: NDC_CODE MLTM_NDC_COST NDC_CODE


MLTM_NDC_CORE_DESC_HIST



Column Section Top of Page


Table-level Detail

Description: MLTM_NDC_CORE_DESC_HIST
Definition: Table used to store the history of an NDC to synonym_id and mmdc codes.
Table Type: REFERENCE





Column Detail - MLTM_NDC_CORE_DESC_HIST


Column Name Type Null? Definition
CREATE_DATE DATETIME N Date the row was generated by Multum
NDC_CODE VARCHAR(25) N NDC Code as defined by governing body
PREVIOUS_DRUG_IDENT VARCHAR(25) N Drug ID previously related to the NDC Code
PREVIOUS_DRUG_SYNONYM_ID DOUBLE N Drug Synonym ID previously related to the NDC code
PREVIOUS_MMDC DOUBLE N MMDC previously related to the NDC Code
SEQUENCE_NUMBER DOUBLE N Generated sequence per NDC_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.


MLTM_NDC_COST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains a collection of pricing information about specific NDC-labeled products
Definition: This table contains a collection of pricing information about specific NDC-labeled products.
Table Type: REFERENCE





Column Detail - MLTM_NDC_COST


Column Name Type Null? Definition
COST DOUBLE Y This field contains a specific cost for a drug. There is one cost stored for each inventory type, so it is possible to maintain separate price information for each inventory type. The cost is defined as 0 (zero) for obsolete drugs.
INVENTORY_TYPE VARCHAR(1) N This field designates the pricing description for the product.
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.
TIME_STAMP DATETIME Y This field contains the Time/Date when each cost record was added to Multum's databases. If the record was added at 12:00 am, the time stamp will be blank and only the date stamp will appear.
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_COST


Child Column in MLTM_NDC_COST(FK) Parent Table Name Parent Column Name
Parents: NDC_CODE MLTM_NDC_CORE_DESCRIPTION NDC_CODE