BI Link - Health & Wellness Glossary
| Technical Name | Business Name | Glossary Definition | Table Name | DSS Element Name | Sensitive Metric | BI Link - Health & Wellness Release |
|---|---|---|---|---|---|---|
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Store Inventory | - | Available | 25.12.9 December Release |
| inv_dt | Inventory Date | The date to which the inventory quantity metrics apply. | Store Inventory | - | Available | 25.12.9 December Release |
| ly_on_hand_qty | Store On Hand Quantity - Last Year | The quantity of an item which is on hand at this store. | Store Inventory | - | Available | 25.12.9 December Release |
| ndc_nbr | National Drug Code Number | National Drug Code Number are 10-character codes used to uniquely identify drug products. Surgical supplies and non-prescription drug products may have an NDC and an HRI (Health Related Item Code) or UPC (Universal Product Code) according to the standards set forth by the Uniform Product Code Council, Inc. These codes are typically 10 characters in length but are converted to an 11-character standardized format, as required for pharmacy claims processing and interoperability, following the guidelines of the National Council for Prescription Drug Programs (NCPDP). | Store Inventory | - | Available | 25.12.9 December Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Inventory | - | Available | 25.12.9 December Release |
| store_nbr | Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | Store Inventory | - | Available | 25.12.9 December Release |
| ty_on_hand_qty | Store On Hand Quantity - This Year | The quantity of an item which is on hand at this store. | Store Inventory | - | Available | 25.12.9 December Release |
| wm_yr_wk_nbr | Walmart Year Week Number | A number representing the full Walmart year and week. The four-digit year is followed by a two-digit week count. Example: 200701. This year is the same for all countries. Since the fiscal year begins in February, January will continue the prior year count. For example, 200649 would be the Year Week Number for the first week of January, even though wm_year_nbr is 2007. | Store Inventory | - | Available | 25.12.9 December Release |
| ndc_nbr | National Drug Code Number | National Drug Code Number are 10-character codes used to uniquely identify drug products. Surgical supplies and non-prescription drug products may have an NDC and an HRI (Health Related Item Code) or UPC (Universal Product Code) according to the standards set forth by the Uniform Product Code Council, Inc. These codes are typically 10 characters in length but are converted to an 11-character standardized format, as required for pharmacy claims processing and interoperability, following the guidelines of the National Council for Prescription Drug Programs (NCPDP). | Store Sales | - | Available | 25.12.9 December Release |
| store_nbr | Walmart Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | Store Sales | - | Available | 25.12.9 December Release |
| bus_dt | Business Date | The authorized, cancelled, or refunded date depending on the event type. Use this report date for authorization-based reporting. | Store Sales | - | Available | 25.12.9 December Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Store Sales | - | Available | 25.12.9 December Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US or WMT.com based on international or US. Examples: WMT-US The operational company Walmart in the US . WMT The operational company Walmart in the worldwide. WMT-K1 The operational company Walmart in the Central America. WMT-CA The operational company Walmart in the Canada. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Sales | - | Available | 25.12.9 December Release |
| ty_sales_qty | POS Sales Quantity - This Year | Point of Sale (POS) Quantity is the quantity of items sold of a specific item number that is scanned at a store level register from all fulfillment channels. It includes all returns (total store returns) at the store level. If there are no sales on any item but there are returns, then this value shows up as a negative sales amount. When creating a report with POS Sales and POS Quantity for products that are sold with variable weight, you will want to include the following attributes: Sell Quantity and Sell UoM Description. These additional dimensions will help you to be able to answer that question. If the Sell Quantity = 1, then the POS Quantity will reflect the measure of unit. IIf the Sell Quantity > 1, then the POS Quantity will be in eaches. | Store Sales | - | Available | 25.12.9 December Release |
| ly_sales_qty | POS Sales Quantity - Last Year | Point of Sales quantity on previous year date from different fulfilment channels, such as online grocery and pick-up, pick up today, and ship from store.Point of Sale (POS) Quantity is the quantity of items sold of a specific item number that is scanned at a store level register. It includes all returns (total store returns) at the store level. If there are no sales on any item but there are returns, then this value shows up as a negative sales amount. When creating a report with POS Sales and POS Quantity for products that are sold with variable weight, you will want to include the following attributes: Sell Quantity and Sell UoM Description. These additional dimensions will help you to be able to answer that question. If the Sell Quantity = 1, then the POS Quantity will reflect the measure of unit. IIf the Sell Quantity > 1, then the POS Quantity will be in eaches. | Store Sales | - | Available | 25.12.9 December Release |
| ty_sales_amt | POS Sales-This Year | Point of Sale (POS) Sales is the dollar amount of sales for a specific item number that is scanned at a store level register. Corresponds to POS quantity; includes all returns (total store returns) at store level. If there are no sales on an item but there are returns, then this value shows up as a negative sales amount. | Store Sales | - | Available | 25.12.9 December Release |
| ly_sales_amt | POS Sales - Last Year | Realigns last year’s sales to the current 4-5-4 date (necessary for comp queries). | Store Sales | - | Available | 25.12.9 December Release |
| wm_yr_wk_nbr | Walmart Year Week Number | A number representing the full Walmart year and week. The four-digit year is followed by a two-digit week count. Example: 200701. This year is the same for all countries. Since the fiscal year begins in February, January will continue the prior year count. For example, 200649 would be the Year Week Number for the first week of January, even though wm_year_nbr is 2007. | Store Sales | - | Available | 25.12.9 December Release |
| acctg_dept_nbr | Accounting Department Number | The department number used for general accounting. This is the department number that sales and purchased are booked to. Accounting departments can have order departments aligned under, but all the order departments under the Accounting department will be rolled up. | Item Dimensions | - | Available | 25.12.9 December Release |
| item_name | Item Name | The product long name, if available. If not, it takes the default short desc1. Also, it is the essential product attribute for reporting. | Item Dimensions | - | Available | 25.12.9 December Release |
| omni_catg_grp_nbr | Omni Category Group Number | The department category group number. | Item Dimensions | - | Available | 25.12.9 December Release |
| wm_item_nbr | Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Item Dimensions | - | Available | 25.12.9 December Release |
| ndc_nbr | National Drug Code | National Drug Code Number are 10-character codes used to uniquely identify drug products. Surgical supplies and non-prescription drug products may have an NDC and an HRI (Health Related Item Code) or UPC (Universal Product Code) according to the standards set forth by the Uniform Product Code Council, Inc. These codes are typically 10 characters in length but are converted to an 11-character standardized format, as required for pharmacy claims processing and interoperability, following the guidelines of the National Council for Prescription Drug Programs (NCPDP). | Item Dimensions | - | Available | 25.12.9 December Release |
| brand_genic_type_cd | Brand Generic Type Code | The Brand Generic Type Code provides the product grouping by Brand, Generic and Other Brand Generics (OTC's). It can take any of these below values: 'B' - Branded 'G' - Generic 'O' - OTC | NDC Dimensions | - | Available | 25.12.9 December Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | NDC Dimensions | - | Available | 25.12.9 December Release |
| gph_innr_pk_qty | GPH Inner Pack Quantity | GPH( Global pharmacy hub) inner pack quantity represents the total size of the package in volume or number of units contained.(i.e. pills) | NDC Dimensions | - | Available | 25.12.9 December Release |
| gph_outer_pk_qty | GPH Outer Pack Quantity | GPH( Global pharmacy hub) outer pack quantity Identifies the number of individual containers or units per package as supplied by the manufacturer.(i.e. Bottles) | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_dea_class_cd | MDSPN DEA Class Code | The Medi-span DEA Class Code identifies federally controlled substances as classified by the Drug Enforcement Administration (DEA). Each code corresponds to a specific schedule, indicating the substance’s accepted medical use and potential for abuse or dependence: 1: No accepted medical use; high potential for abuse (e.g., heroin, LSD) 2: High potential for abuse; severe dependence liability (e.g., oxycodone, fentanyl) 3: Moderate dependence liability (e.g., anabolic steroids, codeine with acetaminophen) 4: Limited abuse potential (e.g., diazepam, alprazolam) 5: Limited abuse potential; small amounts of certain narcotics (e.g., cough preparations with less than 200 mg of codeine) b: DEA Class Code is not applicable | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_drug_nm | MDSPN Drug Name | The Medi-span Drug name reflects the product name shown by the manufacturer on the package. This 30-character name is depicted in upper and lower case. Some drug names are represented using Tall Man letters to distinguish similar drug names and reduce the potential for medication errors. Tall Man letters should be maintained and are not to be changed within your application. An example of drug names with Tall Man letters are VinCRIStine Sulfate and VinBLAStine Sulfate. | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_drug_type_nm | MDSPN Drug Type Name | The Medi-span Drug Type name indicates the type of name used in the Drug Name (Data Element Code F007). This field provides a general Name Type Code for all products sharing a Generic Product Identifier (GPI). The value is determined by the Name Type Code (Data Element Code H073) assigned to the National Drug Codes (NDCs) associated with the Drug Database Identifier (DDID). Possible values: T: Trademarked Name B: Branded Generic Name G: Generic Name | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_item_status_nm | MDSPN Item Status Name | The Medi-span Item Status name indicates the current status of a National Drug Code (NDC) item, distinguishing between active and various inactive states. It enables the Transaction Code (Transaction CD) to accurately reflect whether a record is being added, changed, or deleted. Drug products that have been inactive for more than 48 months are excluded from the Total Database. These are included in Incremental Updates (one time only) with a Transaction CD of “D” (Delete) and an Item Status Flag of “Z.” Such records should be retained in historical files for reference. Status Values: A: Active I: Inactive O: Override Z: Inactive for Greater than 48 Months | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_mfr_nm | MDSPN Manufacturer Name | The Medi-Span Manufacturer Name refers to the name of the company or entity that manufactures a drug product as recorded in the Medi-Span drug database. This name is used to identify the manufacturer associated with a specific National Drug Code (NDC) or drug product entry. | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_ndc_eff_dt | MDSPN NDC Effective Date | The Medi-span NDC Effective Date is the date that the NDC record become effective. | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_prev_ndc_upc_hri_cd | MDSPN Previous NDC UPC HRI Code | The Medi-span Previous NDC UPC HRI code refers to a code that identifies a previous National Drug Code (NDC), Universal Product Code (UPC), or Health Related Item (HRI) code associated with a drug product. For instance when the NDC-UPC-HRI for a product changes: - Two records are output at the time of the change. - The Medispan Previous NDC-UPC-HRI record will have an NDC active indicator set to 0, signaling the prior identifier is now inactive. - A new NDC-UPC-HRI record is created with the NDC active indicator set to 1, indicating a new addition to the file. - The Medispan Prev NDC-UPC-HRI field of the new record will contain the value of the prior identifier, providing a link to the previous record for historical reference. | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_strength_qty | MDSPN Strength Quantity | The Medi-span Strength quantity represents the strength (quantity) of the active ingredient(s) in a drug product, as specified by the manufacturer. The value is typically a numeric or character amount. When combined with the corresponding Strength Unit of Measure, it defines the precise dosage strength of the product. For Example:- If the strength quantity is "300" and the strength unit of measure is "mg," the product’s dosage strength is "300 mg." | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_strength_uom_cd | MDSPN Strength UOM Code | The Medi-span Strength Unit of Measure(UOM) code represents the Strength Unit of Measure (SUM) associated with a drug product. When combined with the Strength Quantity, it specifies the dosage strength as provided by the manufacturer (e.g., milligrams, micrograms, milliliters). For Example:- If the Strength Quantity is "300" and the Strength Unit of Measure code is "mg," the product’s dosage strength is "300 mg." | NDC Dimensions | - | Available | 25.12.9 December Release |
| mdspn_thrpc_class_nm | MDSPN Therapeutic Class Name | The Medi-span Therapeutic Class Name represents the therapeutic class name assigned to a drug product. It groups products by their Drug_Group based on similar therapeutic use or pharmacologic activity. Therapeutic classes are commonly used to determine which drugs are covered under contracts, formulary decisions, or are subject to specific regulatory requirements. For Example:- If a drug is classified as a statin for cholesterol management, the value for MDSPN_THRPC_CLASS_NM might be: • Therapeutic Class Name: "HMG CoA Reductase Inhibitors (Statins)" | NDC Dimensions | - | Available | 25.12.9 December Release |
| ndc_actv_ind | NDC Active Indicator | The NDC active indicator is used to designate whether a specific National Drug Code (NDC) is currently active or inactive in the drug database. Active (indicated by a value of 1): The NDC is available for use, dispensing, or sale. Inactive (indicated by a value of 0): The NDC is no longer available for use, dispensing, or sale. | NDC Dimensions | - | Available | 25.12.9 December Release |
| ndc_nbr | National Drug Code Number | National Drug Code Number are 10-character codes used to uniquely identify drug products. Surgical supplies and non-prescription drug products may have an NDC and an HRI (Health Related Item Code) or UPC (Universal Product Code) according to the standards set forth by the Uniform Product Code Council, Inc. These codes are typically 10 characters in length but are converted to an 11-character standardized format, as required for pharmacy claims processing and interoperability, following the guidelines of the National Council for Prescription Drug Programs (NCPDP). | NDC Dimensions | - | Available | 25.12.9 December Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | NDC Dimensions | - | Available | 25.12.9 December Release |
