Attachment A__Data Template__FY23 HFMI1.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- SNAP HFMI-2023
- Opportunity number
- USDA-FNS-SNAP-HFMI-2023
About this file
This document contains a data template and federal grant opportunity details. The data template provides guidance for weekly reporting of Supplemental Nutrition Assistance Program incentive redemption data by store, including milk subcategory sales completed with SNAP Electronic Benefit Transfer cards versus other tender types. Definitions are included for required data fields. A sample data report is also provided listing store identifiers, distribution details, and milk purchase thresholds corresponding to incentive levels.
The federal grant opportunity is titled SNAP HFMI-2023 and is issued by the USDA Food and Nutrition Service under the Supplemental Nutrition Assistance Program federal grant program. The grant supports incentives for SNAP recipients' purchases of healthy foods. Relevant details include the solicitation number, assistance type, issuing agency, and associated federal grant program.
Data Template
View the file
Other files
| File | Type | Posted |
|---|---|---|
| FNS-906 - FINAL1.pdf | ||
| FY23 SNAP Healthy Fluid Milk Incentive RFA.pdf. 07_20_2023.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Template store start date end date issued_dollars issued_count issued_uniqueID skim_SNAP skim_other 1pct_SNAP 1pct_other 2pct_SNAP 2pct_other whole_SNAP whole_other flavored_SNAP flavored_other
Definitions
| Label | Definition |
| store | Store name or ID |
| start_date | Week start date |
| end_date | Week end date |
| issued_dollars | Dollar amount of incentives or discounts issued ($) |
| issued_count | Number of incentives or discounts issued |
| issued_uniqueID | Number of unique SNAP households issued incentives or discounts |
| skim_SNAP | Total weekly sales of skim milk completed with SNAP EBT ($) |
| skim_other | Total weekly sales of skim milk completed with other tender type, including WIC EBT ($) |
| 1pct_SNAP | Total weekly sales of 1 percent milk completed with SNAP EBT ($) |
| 1pct_other | Total weekly sales of 1 percent milk completed with other tender type, including WIC EBT ($) |
| 2pct_SNAP | Total weekly sales of 2 percent milk completed with SNAP EBT ($) |
| 2pct_other | Total weekly sales of 2 percent milk completed with other tender type, including WIC EBT ($) |
| whole_SNAP | Total weekly sales of whole milk completed with SNAP EBT ($) |
| whole_other | Total weekly sales of whole milk completed with other tender type ($) |
| flavored_SNAP | Total weekly sales of flavored milk completed with SNAP EBT ($) |
| flavored_other | Total weekly sales of flavored milk completed with other tender type ($) |
| Notes: | |
| Reporting on the number of unique SNAP households is optional. | |
| There are two options for reporting the "other" fields: (1) All other tenders, besides SNAP EBT or (2) All tenders, including SNAP EBT. |
data
| BL | Barcode | Offer Num | Distribution | Redmp | Type | Store | W/E Date | Promotion | 01.SNAP ID file + Fat Free or 1% Milk purchase of $1.00 to $3.99 | 02.SNAP ID file + Fat Free or 1% Milk purchase of $4.00 to $5.99 | 03a.SNAP ID file + Fat Free or 1% Milk purchase of $6.00 to $7.99 | 03b.SNAP ID file + Fat Free or 1% Milk purchase of $6.00 to $7.99 | 04a.SNAP ID file + Fat Free or 1% Milk purchase of $8.00 to $9.99 | 04b.SNAP ID file + Fat Free or 1% Milk purchase of $8.00 to $9.99 | 05a.SNAP ID file + Fat Free or 1% Milk purchase of $10.00 or more | 05b.SNAP ID file + Fat Free or 1% Milk purchase of $10.00 or more | ||
| USA-BLIP-BL_1931_8463 | 9725 | 1 | 33 | Main | 105 | 6/26/22 | Distribution Qty | 21 | 1 | 1 | 4 | 4 | ||||||
| BL_4165_5880 | 9725 | 1 | 0 | Failsafe | 159 | 6/26/22 | Distribution Qty | 5 | 11 | 1 | 1 | 3 | 3 | 2 | 2 | Lookup: | 6 | |
| USA-BLIP-BL_4029_2495 | 9726 | 2 | 20 | Main | 225 | 6/26/22 | Distribution Qty | 7 | 9 | 1 | 1 | 3 | 3 | Previous Month | June | |||
| BL_0002_5951 | 9726 | 2 | 0 | Failsafe | 105 | 7/3/22 | Distribution Qty | 27 | 6 | 6 | 5 | 5 | ||||||
| USA-BLIP-BL_4050_8101 | 9727 | 3a | 3 | Main | 159 | 7/3/22 | Distribution Qty | 8 | 16 | 1 | 1 | 3 | 3 | Num | Month | |||
| BL_9793_0908 | 9727 | 3a | 0 | Failsafe | 216 | 7/3/22 | Distribution Qty | 3 | 1 | 2 | 2 | 1 | January | |||||
| USA-BLIP-BL_0815_3453 | 9728 | 3b | 3 | Main | 225 | 7/3/22 | Distribution Qty | 9 | 13 | 7 | 7 | 2 | February | |||||
| BL_9471_0031 | 9728 | 3b | 0 | Failsafe | 105 | 7/10/22 | Distribution Qty | 3 | March | |||||||||
| USA-BLIP-BL_2835_8982 | 9729 | 4a | 3 | Main | 119 | 7/10/22 | Distribution Qty | 4 | April | |||||||||
| BL_9471_0031 | 9729 | 4a | 0 | Failsafe | 130 | 7/10/22 | Distribution Qty | 5 | May | |||||||||
| USA-BLIP-BL_2837_5554 | 9730 | 4b | 3 | Main | 139 | 7/10/22 | Distribution Qty | 6 | June | |||||||||
| BL_5518_3082 | 9730 | 4b | 0 | Failsafe | 159 | 7/10/22 | Distribution Qty | 7 | July | |||||||||
| USA-BLIP-BL_8748_0505 | 9731 | 5a | 9 | Main | 191 | 7/10/22 | Distribution Qty | 8 | August | |||||||||
| BL_3139_3150 | 9731 | 5a | 0 | Failsafe | 216 | 7/10/22 | Distribution Qty | 9 | September | |||||||||
| USA-BLIP-BL_3048_5679 | 9732 | 5b | 9 | Main | 225 | 7/10/22 | Distribution Qty | 10 | October | |||||||||
| BL_3139_3150 | 9732 | 5b | 0 | Failsafe | 105 | 7/17/22 | Distribution Qty | 11 | November | |||||||||
| 119 | 7/17/22 | Distribution Qty | 12 | December | ||||||||||||||
| 130 | 7/17/22 | Distribution Qty | ||||||||||||||||
| 139 | 7/17/22 | Distribution Qty | ||||||||||||||||
| 159 | 7/17/22 | Distribution Qty | ||||||||||||||||
| 191 | 7/17/22 | Distribution Qty | ||||||||||||||||
| 216 | 7/17/22 | Distribution Qty | ||||||||||||||||
| 225 | 7/17/22 | Distribution Qty |
File details come from the government source that posted it. Updated .