Scintilla Health
| Technical Name | Business Name | Glossary Definition | Table Name | DSS Element Name | Sensitive Metric | Scintilla Health 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.0 December Release |
| invt_dt | Inventory Date | The date to which the inventory quantity metrics apply. | Store Inventory | - | Available | 25.12.0 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 | Curr On Hand Qty,Curr Str On Hand Qty,Sat On Hand Qty,Hist On Hand Qty,Fri On Hand Qty,Sun On Hand Qty,Mon On Hand Qty,Tue On Hand Qty,Wed On Hand Qty,Thu On Hand Qty,Store Weeks Supply,Est Retail Turns | Available | 25.12.0 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.0 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.0 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 | Store Nbr | Available | 25.12.0 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 | Curr On Hand Qty,Curr Str On Hand Qty,Sat On Hand Qty,Hist On Hand Qty,Fri On Hand Qty,Sun On Hand Qty,Mon On Hand Qty,Tue On Hand Qty,Wed On Hand Qty,Thu On Hand Qty,Store Weeks Supply,Est Retail Turns | Available | 25.12.0 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 | Sale WM Week | Available | 25.12.0 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.0 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 | Store Nbr,POS Store Count | Available | 25.12.0 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 | Store Weeks Supply | Available | 25.12.0 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.0 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 | Op cmpny cd | Available | 25.12.0 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 | POS Qty, Fri Qty, Sat Qty, Sun Qty, Mon Qty, Tue Qty, Wed Qty, Thu Qty, COMP Store Qty, Units per Store per Week (w/o zeros), Units per Store per Week (w/zeros), Store Weeks Supply, Avg Price, Sales Type, Est Retail Turns, Alternate Selling Unit POS Qty, Sell Thru, Alternate Selling Unit POS Avg Price | Available | 25.12.0 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.0 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 | POS Sales, Sat Sales, Sun Sales, Mon Sales, Fri Sales, Wed Sales, Thu Sales, Tue Sales, COMP Store Sales, Sales $ per Store per Week (w/o zeros), Sales$ per Store per Week (w/zeros), Avg Price, MUMD as % of Sales, Sales Type, Est Unit Turns, Alternate Selling Unit POS Sales, Alternate Selling Unit POS Avg Price | Available | 25.12.0 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 | POS Sales,Sat Sales,Sun Sales,Mon Sales,Fri Sales,Wed Sales,Thu Sales,Tue Sales | Available | 25.12.0 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 | WM Week | Available | 25.12.0 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 | Acct Dept Nbr | Available | 25.12.0 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 | Item Name | Available | 25.12.0 December Release |
| omni_catg_grp_nbr | Omni Category Group Number | The department category group number. | Item Dimensions | - | Available | 25.12.0 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 | Walmart Item Number | Available | 25.12.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 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.0 December Release |
| lat_dgr | Latitude Degree | This indicates the Latitude degree of the store's physical location. | Store Dimensions | - | Available | 25.12.0 December Release |
| long_dgr | Longitude Degree | This indicates the Longitude degree of the store's physical location. | Store Dimensions | - | Available | 25.12.0 December Release |
| st_addr_line_1 | Street Address Line 1 | The street address of the store location. | Store Dimensions | Building Address | Available | 25.12.0 December Release |
| st_addr_line_2 | Street Address Line 2 | The street address of the store location. | Store Dimensions | Street Address | Available | 25.12.0 December Release |
| st_addr_line_3 | Street Address Line 3 | The street address of the store location. | Store Dimensions | Street Address | Available | 25.12.0 December Release |
| st_addr_line_4 | Street Address Line 4 | The street address of the store location. | Store Dimensions | Street Address | Available | 25.12.0 December Release |
| city_nm | City Name | This is the name of the city in which the Distribution Center/store resides. | Store Dimensions | City | Available | 25.12.0 December Release |
| st_prov_nm | State Province Name | The name of the state or province where the business unit is located. | Store Dimensions | State | Available | 25.12.0 December Release |
| state_prov_cd | State or Province Code | The state or province code in which the Distribution Center(DC) or store resides. | Store Dimensions | Whse State | Available | 25.12.0 December Release |
| postal_cd | Zip Code or Postal Code | An identifier for geographic area for the purpose of delivering mail. | Store Dimensions | Zip Code | Available | 25.12.0 December Release |
| store_type_cd | Store Type Code | A code which identifies a type of physical building. Values: 'D' - DOT'S Drug, 'G'- General Office, 'H' - Helen's Crafts, 'M' - Most Outlet, 'R' - Regular (Wal-Mart) 'S' - SAM'S Wholesale Club 'T' - Test or Control 'W - Warehouse 'Y' - WalMart Owned Hypermart 'J' - Joint Owned Hypermart 'U' - SuperCenter, 'X' - International SuperCenter, 'F' - Fuel | Store Dimensions | - | Available | 25.12.0 December Release |
| drv_thru_pharm_ind | Drive Through Pharmacy Indicator | This indicates if the location has a drive thru pharmacy or not. | Store Dimensions | - | Available | 25.12.0 December Release |
| store_nbr | Store Number | A unique numerical identifier assigned to each Walmart Store location | Store Dimensions | Store Nbr | Available | 25.12.0 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 Dimensions | Available | 25.12.0 December Release |
