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 |