| The Food and Nutrition Service (FNS) is collecting this information in order to allow WIC State agencies an efficient way to provide their annual report of WIC vendors and vendor monitoring activities. This is a mandatory collection and FNS will use the information to ensure the efficient management of the WIC Program. The collection does request personally identifiable information under the Privacy Act of 1974. Responses will be kept private to the extent provided by law and FNS regulations. According to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a valid OMB control number. The valid OMB control number for this information collection is 0584-0401. The time required to complete this information collection is estimated to average 1 hour 41 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, preparing system feedback, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: U.S. Department of Agriculture, Food and Nutrition Service, Office of Policy Support, 1320 Braddock Place, 5th Floor, Alexandria, VA 22314. ATTN: PRA (0584- 0401) |
| OMB Control Number: 0584-0401 |
| Expiration date: XX/xx/XXXX |
| Sheet | Cell or Reference | Field Name | Summary of Change | Prior Value | New Value |
| FDEs | G8 | Store Num | added special characters | ● 0-9 ● / (forward slash) ● - (dash) ● # (number sign) |
● 0-9 ● a-z ● A-Z ● Spaces ● # (number sign) ● - (dash) ● / (forward slash) |
| FDEs | J8 | Suite Unit Num | added special characters | ● 0-9 ● a-z ● A-Z ● # (number sign) ● . (period) ● - (dash) ● & (ampersand) ● / (forward slash) ● : (colon) |
● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) ● - (dash) ● # (pound or number sign) ● & (ampersand) ● / (forward slash) ● : (colon) |
| Sheet | Cell or Reference | Field Name | Summary of Change | Prior Value | New Value |
| FDEs | H5 | Street Num | Changed required value | Yes | No |
| FDEs | W6 | Retail Category | Changed required value | Conditionally | No |
| Annual and Training Data | C5 | State WIC ID | Changed required value | No | Yes |
| Annual and Training Data | C6 | State WIC ID | Changed required value | No | Yes |
| Investigations | C5 | State WIC ID | Changed required value | No | Yes |
| Investigations | C6 | State WIC ID | Changed required value | No | Yes |
| Redemptions | C5 | State WIC ID | Changed required value | No | Yes |
| Redemptions | C6 | State WIC ID | Changed required value | No | Yes |
| Violations | C5 | State WIC ID | Changed required value | No | Yes |
| Violations | C6 | State WIC ID | Changed required value | No | Yes |
| Sanctions and Claim Collections | C5 | State WIC ID | Changed required value | No | Yes |
| Sanctions and Claim Collections | C6 | State WIC ID | Changed required value | No | Yes |
| Sanctions and Claim Collections | K5 | Date Referred to SNAP | Changed required value | Conditionally | No |
| Sanctions and Claim Collections | K6 | Date Referred to SNAP | Changed required value | Conditionally | No |
| Sheet | Cell or Reference | Field Name | Summary of Change | Prior Value | New Value |
| FDEs | H5 | Street Num | Changed required value | Conditionally | Yes |
| FDEs | H6 | Street Name | Changed required value | No | Conditionally |
| FDEs | K5 | City | Changed required value | Conditionally | Yes |
| FDEs | L5 | State | Changed required value | Conditionally | Yes |
| FDEs | M5 | Zip Code | Changed required value | Conditionally | Yes |
| FDEs | P6 | Location Description | Changed required value | No | Conditionally |
| FDEs | W6 | Retail Category | Changed required value | No | Conditionally |
| FDEs | AB5 | Contractor | Changed required value | Conditionally | No |
| FDEs | AB6 | Contractor | Changed required value | Conditionally | No |
| FDEs | AL6 | Agreement Start Date | Changed required value | No | Conditionally |
| FDEs | AM6 | Agreement End Date | Changed required value | No | Conditionally |
| Annual and Training Data | D6 | Fiscal Year | Changed required value | No | Conditionally |
| Annual and Training Data | F5 | Num of RMVs this Year | Changed required value | Yes | No |
| Sanctions and Claim Collections | D6 | Investigation Start Date | Changed required value | No | Conditionally |
| Sanctions and Claim Collections | F6 | WIC Sanction Type | Changed required value | No | Conditionally |
| Sanctions and Claim Collections | K5 | Date Referred to SNAP | Changed required value | No | Conditionally |
| Sanctions and Claim Collections | K6 | Date Referred to SNAP | Changed required value | No | Conditionally |
| Sheet | Cell or Reference | Field Name | Summary of Change | Prior Value | New Value |
| FDEs | N5 | County | Changed required value | No |
Yes |
| FDEs | T5 | Peer Group | Changed required value | No |
Conditionally |
| FDEs | T6 | Peer Group | Changed required value | No |
Conditionally |
| FDEs | U5 | Initial Auth Date | Changed required value | No |
Conditionally |
| FDEs | U6 | Initial Auth Date | Changed required value | No |
Conditionally |
| FDEs | AB5 | Contractor | Changed required value | No |
Conditionally |
| FDEs | AB6 | Contractor | Changed required value | No |
Conditionally |
| FDEs | AI5 | Participant Access Reason | Changed required value | No |
Conditionally |
| FDEs | AI6 | Participant Access Reason | Changed required value | No |
Conditionally |
| FDEs | AJ5 | Denial Reason | Changed required value | No |
Conditionally |
| FDEs | AJ6 | Denial Reason | Changed required value | No |
Conditionally |
| FDEs | AK5 | Other Denial Reason | Changed required value | No |
Conditionally |
| FDEs | AK6 | Other Denial Reason | Changed required value | No |
Conditionally |
| FDEs | AN5 | Agreement Termination Date | Changed required value | No |
Conditionally |
| FDEs | AN6 | Agreement Termination Date | Changed required value | No |
Conditionally |
| FDEs | AO5 | Termination Reason | Changed required value | No |
Conditionally |
| FDEs | AO6 | Termination Reason | Changed required value | No |
Conditionally |
| FDEs | AP5 | Other Termination Reason | Changed required value | No |
Conditionally |
| FDEs | AP6 | Other Termination Reason | Changed required value | No |
Conditionally |
| FDEs | F5 | Num of RMVs This Year | Changed required value | No |
Yes |
| FDEs | H5 | High Risk Reasons | Changed required value | No |
Conditionally |
| FDEs | H6 | High Risk Reasons | Changed required value | No |
Conditionally |
| FDEs | I5 | State Risk Reason | Changed required value | No |
Conditionally |
| FDEs | I6 | State Risk Reason | Changed required value | No |
Conditionally |
| Annual and Training Data | I1 | Training Applied to Fiscal Year | New Column | Training Applied to Fiscal Year (csv) Training_Applied_to_Fiscal_Year (xml) |
|
| Annual and Training Data | I2 | Training Applied to Fiscal Year | New Column | Text | |
| Annual and Training Data | I3 | Training Applied to Fiscal Year | New Column | 4 | |
| Annual and Training Data | I4 | Training Applied to Fiscal Year | New Column | 2015 | |
| Annual and Training Data | I5 | Training Applied to Fiscal Year | New Column | Yes | |
| Annual and Training Data | I6 | Training Applied to Fiscal Year | New Column | Yes | |
| Annual and Training Data | I7 | Training Applied to Fiscal Year | New Column | The federal fiscal year (FY) to which the training record applies | |
| Annual and Training Data | I8 | Training Applied to Fiscal Year | New Column | ● 0-9 |
|
| Annual and Training Data | I9 | Training Applied to Fiscal Year | New Column | #### (4 Digits) |
|
| Annual and Training Data | M5 | Training Format | Changed required value | No |
Conditionally |
| Annual and Training Data | M6 | Training Format | Changed required value | No |
Conditionally |
| Redemptions | F6 | Non-CVB Redemptions | Changed required value | No |
Yes |
| Redemptions | G5 | CVB Redemptions | Changed required value | No |
Yes |
| Redemptions | G6 | CVB Redemptions | Changed required value | No |
Yes |
| Investigations | E5 | Investigation End Date | Changed required value | No |
Conditionally |
| Investigations | E6 | Investigation End Date | Changed required value | No |
Conditionally |
| Investigations | G5 | Reason Closed | Changed required value | No |
Conditionally |
| Investigations | G6 | Reason Closed | Changed required value | No |
Conditionally |
| Investigations | H5 | Investigation Outcome | Changed required value | No |
Conditionally |
| Investigations | H6 | Investigation Outcome | Changed required value | No |
Conditionally |
| Investigations | I5 | Num of Compliance Buys | Changed required value | No |
Conditionally |
| Investigations | I6 | Num of Compliance Buys | Changed required value | No |
Conditionally |
| Investigations | J5 | Inventory Audit Completed | Changed required value | No |
Conditionally |
| Investigations | J6 | Inventory Audit Completed | Changed required value | No |
Conditionally |
| Investigations | L5 | Administrative Review Status or Outcome | Changed required value | No |
Conditionally |
| Investigations | L6 | Administrative Review Status or Outcome | Changed required value | No |
Conditionally |
| Investigations | N5 | Judicial Review Status or Outcome | Changed required value | No |
Conditionally |
| Investigations | N6 | Judicial Review Status or Outcome | Changed required value | No |
Conditionally |
| Violations | F5 | State Violation | Changed required value | No |
Conditionally |
| Violations | F6 | State Violation | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | G5 | SNAP Sanction Type | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | G6 | SNAP Sanction Type | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | H5 | State Sanction | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | H6 | State Sanction | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | I5 | Disqualification Date | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | I6 | Disqualification Date | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | J5 | Disqualification Length | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | J6 | Disqualification Length | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | L5 | Date Referred to WIC | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | L6 | Date Referred to WIC | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | M5 | CMP Amount | Changed required value | No |
Conditionally |
| Sanctions and Claim Collections | M6 | CMP Amount | Changed required value | No |
Conditionally |
| Field Name 03/31/2022 |
FNS WIC ID (csv) FNS_WIC_ID (xml) |
State WIC ID (csv) State_WIC_ID (xml) |
FNS Num(csv) FNS_Num (xml) |
Name (csv) Name (xml) |
DBA (csv) DBA (xml) |
Store Num (csv) Store_Num (xml) |
Street Num (csv) Street_Num (xml) |
Street Name (csv) Street_Name (xml) |
Suite Unit Num (csv) Suite_Unit_Num (xml) |
City (csv) City (xml) |
State (csv) State (xml) |
Zip Code (csv) Zip_Code (xml) |
County (csv) County (xml) |
No Distinct Phy Address (csv) No_Distinct_Phy_Address (xml) |
Location Description (csv) Location_Description (xml) |
Latitude (csv) Latitude (xml) |
Longitude (csv) Longitude (xml) |
Unauth Store (csv) Unauth_Store (xml) |
Peer Group (csv) Peer_Group (xml) |
Initial Auth Date (csv) Initial_Auth_Date (xml) |
Delivery Method (csv) Delivery_Method (xml) |
Retail Category (csv) Retail_Category (xml) |
WIC Only Vendor (csv) WIC_Only_Vendor (xml) |
Authorized as Mobile Vendor (csv) Authorized_as_Mobile_Vendor (xml) |
Authorized as Internet Vendor (csv) Authorized_as_Internet_Vendor (xml) |
Internet Ordering Options (csv) Internet_Ordering_Options (xml) |
Contractor (csv) Contractor (xml) |
Primary Contract Record (csv) Primary_Contract_Record (xml) |
Contract Information (csv) Contract_Information (xml) |
Store Registers (csv) Store_Registers (xml) |
Store Sq Ft (csv) Store_Sq_Ft (xml) |
Status (csv) Status (xml) |
Assessed for Participant Access (csv) Assessed_for_Participant_Access (xml) |
Participant Access Reason (csv) Participant_Access_Reason (xml) |
Denial Reason (csv) Denial_Reason (xml) |
Other Denial Reason (csv) Other_Denial_Reason (xml) |
Agreement Start Date (csv) Agreement_Start_Date (xml) |
Agreement End Date (csv) Agreement_End_Date (xml) |
Agreement Termination Date (csv) Agreement_Termination_Date (xml) |
Termination Reason (csv) Termination_Reason (xml) |
Other Termination Reason (csv) Other_Termination_Reason (xml) |
Total Num of Stores Owned (csv) Total_Num_of_Stores_Owned (xml) |
Num of Other WIC Stores (csv) Num_of_Other_WIC_Stores (xml) |
| Field Type | Text | Text | Number | Text | Text | Text | Text | Text | Text | Text | Picklist | Text | Text | Boolean | Text | Number | Number | Boolean | Picklist | Date | Picklist | Picklist | Boolean | Boolean | Boolean | Picklist | Text | Boolean | Long Text | Number | Number | Picklist | Boolean | Picklist | Picklist | Text | Date | Date | Date | Picklist | Text | Number | Number |
| Field Length | 18 | 32 | 7 | 60 | 60 | 8 | 20 | 100 | 100 | 40 | 2 | 10 | 40 | 5 | 255 | 10-digit, 6 decimal places | 11-digit, 6 decimal places | 5 | 100 | 10 | 19 | 50 | 5 | 5 | 5 | 57 | 40 | 5 | 500 | 4 | 6 | 39 | 5 | 54 | 42 | 100 | 10 | 10 | 10 | 64 | 100 | 7 | 7 |
| Example Data | a2Q2J00000kMQKX | 4545 | 1234567 | Scott's Bakery, Inc. | Scott's Bakery, Inc. | #100 | 333-B | St. John's BLVD | 100 | Winston-Salem Sault Ste. Marie |
VA | 20155 | O'Brien County, Iowa Skagway-Hoonah-Angoon Census Area, Alaska |
Yes | In parking lot | 19.741755 (Hawaii) -37.840935 (Melbourne, Australia) |
-155.844437 (Hawaii) -96.808891 (Dallas) 170.1322 (American Samoa) |
No | Other (See Picklist Values below) | 10/10/2020 | Retail | Farmers' Market | Yes | No | Yes | Delivery | Pharmacy | Yes | Contract provides all WIC products outside of the metro area of the city. Allowable overhead costs are $10,000. Total contract value is $1,000,000. | 2 | 2400 | Authorized | No | Failed to meet business integrity selection criterion | Other | Store's application was incomplete, and not co-signed by all company officers. | 10/11/2020 | 10/11/2020 | 10/11/2020 | Other | FDE failed to train it's current employees on WIC procedures; and provided outdated materials in break rooms. | 3 | 1 |
| Is this field mandatory for creating a new record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
No |
Conditionally | No | Yes | No | No | No | Conditionally | No | Yes | Yes | Yes | Yes | No | Conditionally | No | No | No | Conditionally | Conditionally | Yes | Conditionally | No | No | No | No | No | No | No | No | No | Yes | No | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | No | No |
| Is this field mandatory for updating an existing record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Conditionally | No | Yes | No | No | No | Conditionally | No | No | No | No | No | No | Conditionally | No | No | No | Conditionally | Conditionally | No | No | No | No | No | No | No | No | No | No | No | No | No | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | No | No |
| Field Description | The unique Salesforce identifier for the FDE record. | The State agency (SA) generated ID for this record. | The FNS Number provided by SNAP, if applicable. | The full legal business name. | The Doing Business As (DBA) name, if applicable. | The chain store number, if applicable. | The street number associated with the address. | The street name associated with the address. | The suite or unit number associated with the address. | The city associated with the address. | The state associated with the address. | The zip code (Zip or Zip +4) associated with the address. | The county associated with the address. | This indicates the FDE does not have an exact address or easily definable physical location. | The description of the store’s exact location if no address can be provided. | The latitude coordinates for this address. | The longitude coordinates for this address. | This indicates the FDE was not authorized, but was investigated. | The name of the Peer Group to which this FDE belongs. | The date of the very first WIC authorization. | The food delivery method this entity operates under to ensure WIC participants have access to supplemental foods. | The type of retail FDE. | This indicates the FDE provides only WIC foods or identifies as a WIC only store. | This indicates the FDE is authorized as a mobile vendor. | This indicates the FDE operates solely on the internet (i.e., does not have a fixed location/storefront). | The ordering options offered by the store to their internet customers. | The name of the contractor when FDE is either home delivery or direct distribution | Indicates if this is the managing record for a group of direct distribution or home delivery contract sites. | The description of the contract details for a direct distribution or home delivery contract. | The number of cash registers at the store location. The total number of Point-of-Sale (POS) registers at the location. |
The square footage of the store location. | The current status of the vendor agreement. | This indicates the FDE was assessed for participant access during this agreement term. | The reason the vendor would not be fully authorized, and only kept in the Program because they are necessary for participant access. | The reason why the store’s application was denied. | The specific reason the store’s application was denied, if “Other” was cited as a denial reason. | The first day of the vendor agreement period. | The last day of the vendor agreement period. | The effective date of the vendor agreement termination. | The reason why the vendor agreement was terminated. | The specific reason the vendor’s agreement was terminated if “Other” was cited as a termination reason. | The total number of stores owned by the same ownership. | The number of other WIC authorized vendors by the same ownership. |
| Valid Values or Allowed Characters | ● 0-9 ● a-z ● A-Z |
● 0-9 ● a-z ● A-Z |
● 0-9 | ● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) ● – (hyphen) ● # (pound or number sign) ● & (ampersand) ● - (dash) ● / (forward slash) ● : (colon) |
● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) ● – (hyphen) ● # (pound or number sign) ● & (ampersand) ● - (dash) ● / (forward slash) ● : (colon) |
● 0-9 ● a-z ● A-Z ● Spaces ● # (number sign) ● - (dash) ● / (forward slash) |
● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) ● - (dash) ● # (pound or number sign) ● & (ampersand) ● / (forward slash) ● : (colon) |
● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) ● - (dash) ● # (pound or number sign) ● & (ampersand) ● / (forward slash) ● : (colon) |
● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) ● - (dash) ● # (number sign) ● & (ampersand) ● / (forward slash) ● : (colon) |
● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) ● - (dash) |
2-digit code of the State | ● 0-9 ● - (dash) |
● a-z ● A-Z ● Spaces ● ' (apostrophe) ● - (dash) |
● Yes ● No ● Y ● N ● True ● False |
● a-z ● A-Z ● Spaces ● 0-9 ● ' (apostrophe) ● - (dash) ● # (number sign) ● . (period) ● ; (semi colon) |
● 0-9 ● . (period) ● - (dash/minus) |
● 0-9 ● . (period) ● - (dash/minus) |
● Yes ● No ● Y ● N ● True ● False |
Custom picklist values will be entered from State agency data entry/input. | ● 0-9 ● - (dash) ● / (forward slash) |
● Retail ● Direct Distribution ● Home Delivery |
● Regular Vendor ● A50 - for profit ● A50 - nonprofit ● Pharmacy - only exempt infant formula/nutritionals ● Commissary ● Farmer ● Farmers’ market |
● Yes ● No ● Y ● N ● True ● False |
● Yes ● No ● Y ● N ● True ● False |
● Yes ● No ● Y ● N ● True ● False |
● In-store or curbside pickup ● Delivery ● Transaction in the presence of cashier ● Internet transaction |
● 0-9 ● a-z ● A-Z ● ” (double quote) ● ; (semi colon) ● | (vertical pipe) ● _ (underscore) ● , (comma) ● ' (apostrophe) ● Spaces ● . (period) |
Only available if Food Delivery Method is = 'Direct Distribution' or 'Home Delivery' | Only available if Food Delivery Method is = 'Direct Distribution' or 'Home Delivery' | ● 0-9 |
● 0-9 |
● Authorized ● Authorized with CMP ● Authorized for participant access ● Authorized with disaster waiver(s) ● Disqualified (and agreement terminated) ● Agreement expired ● Agreement terminated ● Application pending ● Application denied ● Never authorized |
● Yes ● No ● Y ● N ● True ● False |
● Failed to meet business integrity selection criterion ● Failed to meet competitive price selection criterion ● Failed to meet SA selection criterion ● Current SNAP disqualification/CMP for hardship, ● Serving a mandatory sanction from another WIC SA |
● Failed to meet federal selection criteria ● Failed to meet SA selection criteria ● Attempted to circumvent a sanction ● Submitted application outside of timeframe ● Withdrew application from WIC Program ● Limiting criteria ● Other |
● a-z ● A-Z ● Spaces ● ' (apostrophe) ● , (comma) ● - (dash) ● . (period) ● ; (semi colon) |
● 0-9 ● - (dash) ● / (forward slash) |
● 0-9 ● - (dash) ● / (forward slash) |
● 0-9 ● - (dash) ● / (forward slash) |
• Failed to continue to meet federal selection criteria • Failed to continue to meet State agency selection criteria • Failed to continue to meet terms of vendor agreement • Provided false information in connection with vendor application • Underwent a change in ownership • Underwent a change in location • Ceased operations • Voluntarily withdrew from WIC program • Other |
● a-z ● A-Z ● Spaces ● ' (apostrophe) ● , (comma) ● - (dash) ● . (period) ● ; (semi colon) |
● 0-9 |
● 0-9 |
| Formatting/Validation Notes | Not required for new Food Delivery Entities | Required for all Retail Food Delivery Entities with an Agreement Start Date. Must match with the existing record, if FNS WIC ID is provided. |
####### | No explicit validation if using allowed characters For XML files, to use the ampersand symbol (&), '&' should be replaced with '&' eg. M&M should be converted to M&M |
No explicit validation if using allowed characters For XML files, to use the ampersand symbol (&), '&' should be replaced with '&' eg. M&M should be converted to M&M |
No explicit validation if using allowed characters | Required when No Physical address is No For XML files, to use the ampersand symbol (&), '&' should be replaced with '&' eg. M&M should be converted to M&M |
Required when No Physical address is No and Unauth Store is No For XML files, to use the ampersand symbol (&), '&' should be replaced with '&' eg. M&M should be converted to M&M |
No explicit validation if using allowed characters For XML files, to use the ampersand symbol (&), '&' should be replaced with '&' eg. M&M should be converted to M&M |
Required when No Physical address is No | Required when No Physical address is No | #####, #####-#### Required when No Physical address is No |
No explicit validation if using allowed characters For XML files, to use the ampersand symbol (&), '&' should be replaced with '&' eg. M&M should be converted to M&M |
No explicit validation if using allowed values | Required if No distinct phy address is Yes | format ##########.###### | format ##########.###### | No explicit validation if using allowed values | Custom picklist values will be entered from State agency data entry/input. | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | Field cannot be updated through file upload after being set | Required if Food Delivery Method= 'Retail' | Only available if Vendor Type is = 'A50 - for profit' or 'A50 - nonprofit' | No explicit validation if using allowed values | No explicit validation if using allowed values | Multi-picklist: can have more than 1 value selected when separated by a ; (semicolon) | Required if Food Delivery Method= 'Direct Distribution' or 'Home Delivery' | No explicit validation if using allowed characters | No explicit validation if using allowed characters | #### (up to 4 digits) | ###### (up to 6 digits) | No explicit validation if using allowed values | No explicit validation if using allowed values | No explicit validation if using allowed values | No explicit validation if using allowed values | No explicit validation if using allowed characters | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. Agreement Start Date required if Status is one of [Authorized, Authorized with CMP, Authorized for participant access, Disqualified (and Agreement terminated), Agreement Terminated, Agreement expired] |
Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. Agreement End Date required if Status is one of [Authorized, Authorized with CMP, Authorized for participant access, Disqualified (and Agreement terminated), Agreement Terminated, Agreement expired] and must be after Agreement Start Date |
Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | No explicit validation if using allowed values | No explicit validation if using allowed characters | ####### (up to 7 digits) | ####### (up to 7 digits) |
| Field Name 02/2/2022 |
FNS WIC ID (csv) FNS_WIC_ID (xml) |
State WIC ID (csv) State_WIC_ID (xml) |
Fiscal Year (csv) Fiscal_Year (xml) |
Auth on Oct 1 (csv) Auth_on_Oct_1 (xml) |
Num of RMVs This Year (csv) Num_RMVs_this_year (xml) |
High Risk (csv) High_Risk (xml) |
High Risk Reasons (csv) High_Risk_Reasons (xml) |
State Risk Reason (csv) State_Risk_Reason (xml) |
Training Date (csv) Training_Date (xml) |
Training Applied to Fiscal Year (csv) Training_Applied_to_Fiscal_Year (xml) |
Training Type (csv) Training_Type (xml) |
Training Format (csv) Training_Format (xml) |
| Field Type | Text | Text | Text | Boolean | Number | Boolean | Picklist | Text | Date | Text | Picklist | Picklist |
| Field Length | 18 | 32 | 4 | 5 | 2 | 5 | 1459 | 100 | 10 | 4 | 15 | 42 |
| Example Data | a2Q2J00000kMQKX | 1234 | 2015 | Yes | 2 | Yes | Other - New Vendor | State WIC Signage Ordinance 1234.5 | 12/12/2010 | 2015 | Interactive | Interactive - On-site cashier training |
| Is this field mandatory for creating a new record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Conditionally | No | No | No | Conditionally | Conditionally | Yes | Yes | Yes | Conditionally |
| Is this field mandatory for updating an existing record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Conditionally | No | No | No | Conditionally | Conditionally | Yes | Yes | No | Conditionally |
| Field Description | The unique Salesforce identifier for the FDE record. | The State agency (SA) generated ID for this record. | The federal fiscal year (FY) for this record. | This indicates the FDE was authorized on October 1st of a fiscal year. | The number of routine monitoring visits (RMVs) conducted during this FY. | Indicates the FDE was identified as High Risk this FY. | Holds all the High Risk Reason(s) that were identified. | The SA specific High Risk Reason for this FDE. | The date the training was delivered to the FDE staff. | The federal fiscal year (FY) to which the training record applies | The type of training provided (e.g., Interactive, or non-interactive training). | How the training was delivered to the FDE staff. |
| Valid Values or Allowed Characters | ● 0-9 ● a-z ● A-Z |
● 0-9 ● a-z ● A-Z |
● 0-9 |
● Yes ● No ● Y ● N ● True ● False |
● 0-9 |
● Yes ● No ● Y ● N ● True ● False |
• Redemption - Extremely small amount of variation in food instrument prices • Redemption - Large percent of food instruments redeemed at same price • Redemption - Unusually high average food instrument prices • Redemption - Redeemed prices are higher than their price list • Volume - Large percent of high-priced food instruments • Volume - Volume of WIC business • Volume - Large increase of dollar volume of food instruments redeemed over time • Volume - Large percent of the area’s total WIC redemptions • Volume - WIC sales are an unusually high percentage of vendor’s total sales • Volume - High WIC to SNAP redemption ratio • Volume - WIC and SNAP Program sales are an unusually high percentage of total sales • Participant - Participant/other complaints • Participant - Large number of participants redeeming food instruments outside of their health service area • Participant - Large number of participants redeeming food instruments who are considered to be at high health risk • Non-EBT - Large number of food instruments with consecutive serial numbers • Non-EBT - Large percentage of manually issued food instruments • Non-EBT - Excessive number of returned checks due to errors • Other - Past history of violations and disqualifications • Other - Associations with known violators • Other - Multiple ownerships which include known violators • Other - Short on authorized food items or no inventory • Other - New Vendor • Other - Random Selection |
The valid values are determined by the state Policy Settings | ● 0-9 ● / (forward slash) ● - (dash) |
● 0-9 |
● Interactive ● Non-Interactive |
● Interactive - On-site cashier training ● Interactive - Off-site classroom training ● Interactive - Train-the-trainer sessions ● Interactive - Webinar ● Not interactive - Newsletter ● Not interactive - Video ● Not interactive - Webinar ● Not interactive - Other |
| Formatting/Validation Notes | Must exactly match an existing FDE record's FNS WIC ID. | Must exactly match the State WIC ID value for the existing record identified by the FNS WIC ID. | #### (4 Digits) If uploading Training records only, value of field must be empty but column(CSV)/tags(XML) must still exist |
No explicit validation if using allowed values If uploading Training records only, value of field must be empty but column(CSV)/tags(XML) must still exist |
## (up to 2 digits) If uploading Training records only, value of field must be empty but column(CSV)/tags(XML) must still exist |
No explicit validation if using allowed values If uploading Training records only, value of field must be empty but column(CSV)/tags(XML) must still exist |
Multi-picklist: can have more than 1 value selected separated by ; (semicolon) If uploading Training records only, value of field must be empty but column(CSV)/tags(XML) must still exist |
Valid Values defined in SA Policy Settings If uploading Training records only, value of field must be empty but column(CSV)/tags(XML) must still exist |
After Annual data, the next 3 fields will be for each trainings. Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | #### (4 Digits) |
No explicit validation if using allowed values | No explicit validation if using allowed values |
| Field Name 02/2/2022 |
FNS WIC ID (csv) FNS_WIC_ID (xml) |
State WIC ID (csv) State_WIC_ID (xml) |
Investigation Start Date (csv) Investigation_Start_Date (xml) |
Investigation End Date (csv) Investigation_End_Date (xml) |
Investigation Status (csv) Investigation_Status (xml) |
Reason Closed (csv) Reason_Closed (xml) |
Investigation Outcome (csv) Investigation_Outcome (xml) |
Num of Compliance Buys (csv) Num_of_Compliance_Buys (xml) |
Inventory Audit Completed (csv) Inventory_Audit_Completed (xml) |
Administrative Review Requested (csv) Administrative_Review_Requested (xml) |
Administrative Review Status or Outcome (csv) Administrative_Review_Status_or_Outcome (xml) |
Judicial Review Requested (csv) Judicial_Review_Requested (xml) |
Judicial Review Status or Outcome (csv) Judicial_Review_Status_or_Outcome (xml) |
| Field Type | Text | Text | Date | Date | Picklist | Text | Picklist | Number | Boolean | Boolean | Picklist | Boolean | Picklist |
| Field Length | 18 | 32 | 10 | 10 | 9 | 255 | 11 | 2 | 5 | 5 | 10 | 5 | 10 |
| Example Data | a2Q2J00000kMQKX | 21323 | 10/11/2020 | 10/11/2020 | Open | Store Closed | Yes | 2 | Yes | Yes | Pending | No | Pending |
| Is this field mandatory for creating a new record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Yes | Conditionally | Yes | Conditionally | Conditionally | Conditionally | Conditionally | No | Conditionally | No | Conditionally |
| Is this field mandatory for updating an existing record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Yes (must match existing to update record) | Conditionally | No | Conditionally | Conditionally | Conditionally | Conditionally | No | Conditionally | No | Conditionally |
| Field Description | The unique Salesforce identifier for the FDE record. | The State agency (SA) generated ID for this record. | The first day any work began for the investigation. | The day the investigation work is completed. | The current status of the investigation. | The reason the investigation was closed but not completed. | This indicates if there was a Sanction or No Sanction outcome. | The total number of compliance buys conducted in the investigation. | This indicates an inventory audit was conducted as part of the investigation. | This indicates an Admin Review has been requested by the FDE. | This indicates the status of the Admin Review. | This indicates a Judicial Review has been requested. | This indicates the status of the Judicial Review. |
| Valid Values or Allowed Characters | ● 0-9 ● a-z ● A-Z |
● 0-9 ● a-z ● A-Z |
● 0-9 ● / (forward slash) ● - (dash) |
● 0-9 ● / (forward slash) ● - (dash) |
● Open ● Completed ● Closed |
● a-z ● A-Z ● Spaces ● ' (apostrophe) ● , (comma) ● - (dash) ● . (period) ● ; (semi colon) |
● No Sanction ● Sanction |
● 0-9 | ● Yes ● No ● Y ● N ● True ● False |
● Yes ● No ● Y ● N ● True ● False |
● Pending ● Upheld ● Overturned ● Modified |
● Yes ● No ● Y ● N ● True ● False |
● Pending ● Upheld ● Overturned ● Modified |
| Formatting/Validation Notes | Must exactly match an existing FDE record's FNS WIC ID. | Must exactly match the State WIC ID value for the existing record identified by the FNS WIC ID. | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | Valid value required when creating new record | No explicit validation if using allowed characters | No explicit validation if using valid values | ## (up to 2 digits) | No explicit validation if using valid values | No explicit validation if using valid values | Required, if Administrative Review Requested is Yes | Optional. Only available if Administrative Review Status or Outcome is valued. | Required, if Judicial Review Requested = Yes |
| Field Name 02/2/2022 |
FNS WIC ID (csv) FNS_WIC_ID (xml) |
State WIC ID (csv) State_WIC_ID (xml) |
Calendar Year (csv) Calendar_Year (xml) |
Transaction Month (csv) Transaction_Month (xml) |
Non-CVB Redemptions (csv) Non_CVB_Redemptions (xml) |
CVB Redemptions (csv) CVB_Redemptions (xml) |
| Field Type | Text | Text | Number | Picklist | Number | Number |
| Field Length | 18 | 32 | 4 | 9 | 9-digit, 2 decimal places | 9-digit, 2 decimal places |
| Example Data | a2Q2J00000kMQKX | 1234 | 2020 | January | 200.50 | 100.50 |
| Is this field mandatory for creating a new record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Yes | Yes | Yes | Yes |
| Is this field mandatory for updating an existing record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Yes | Yes | Yes | Yes |
| Field Description | The unique Salesforce identifier for the FDE record. | The State agency (SA) generated ID for this record. | The calendar year for the transaction data provided. | The calendar month for the transaction data provided. | The total value of all Non-CVB redemptions in the calendar month. | The total value of all CVB redemptions in the calendar month. |
| Valid Values or Allowed Characters | ● 0-9 ● a-z ● A-Z |
● 0-9 ● a-z ● A-Z |
● 0-9 | ● January ● February ● March ● April ● May ● June ● July ● August ● September ● October ● November ● December |
● 0-9 ● . (period) |
● 0-9 ● . (period) |
| Formatting/Validation Notes | Must exactly match an existing FDE record's FNS WIC ID. | Must exactly match the State WIC ID value for the existing record identified by the FNS WIC ID. | #### ( 4 digits) | Valid value required | #########.## | #########.## |
| Field Name 02/2/2022 |
FNS WIC ID (csv) FNS_WIC_ID (xml) |
State WIC ID (csv) State_WIC_ID (xml) |
Investigation Start Date (csv) Investigation_Start_Date (xml) |
Violation (csv) Violation (xml) |
State Violation (csv) State_Violation (xml) |
Num of Violations (csv) Num_of_Violations (xml) |
Pattern Established (csv) Pattern_Established (xml) |
Notification Sent (csv) Notification_Sent (xml) |
Documented Non-notification (csv) Documented_Non_Notification (xml) |
|
| Field Type | Text | Text | Date | Picklist | Picklist | Number | Boolean | Boolean | Boolean | |
| Field Length | 18 | 32 | 10 | 143 | 100 | 2 | 5 | 5 | 5 | |
| Example Data | a2Q2J00000kMQKX | 21323 | 10/11/2020 | Overcharging | Other (See Picklist Values below) | 2 | Yes | Yes | Yes | |
| Is this field mandatory for creating a new record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Yes | Yes | Conditionally | Yes | No | No | No | |
| Is this field mandatory for updating an existing record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Yes | Yes | Conditionally | No | No | No | No | |
| Field Description | The unique Salesforce identifier for the FDE record. | The State agency (SA) generated ID for this record. | The Salesforce ID associated with the Investigation. The Investigation Start Date (in conjunction with the FNS WIC ID and State WIC ID) is used to find the investigation record. | The violations that result in mandatory vendor sanctions as outlined in 246.12(l)(1)(i-iv). | The violations that are included in the SA’s sanction schedule, but are not specified in the federal regulations. | The total number of times this Violation has been found during this Investigation. | This indicates a pattern has been established for this violation. | This indicates a notification was sent for the initial instance of this violation. | This indicates a notification was not sent to the vendor for this violation. | |
| Valid Values or Allowed Characters | ● 0-9 ● a-z ● A-Z |
● 0-9 ● a-z ● A-Z |
● 0-9 ● / (forward slash) ● - (dash) |
• Trafficking • Selling firearms, ammunition, explosives, and/or controlled substances • Selling alcohol and/or tobacco products • Claiming reimbursement in excess of the store’s documented inventory • Overcharging • Receiving, transacting, and/or redeeming through unauthorized channels • Charging for supplemental food not received by the participant • Providing credit and/or non-food items (other than alcohol, tobacco products, cash, firearms, ammunition, explosives, or controlled substances) • Providing unauthorized food items • Charging for supplemental foods provided in excess of those in the benefit balance • Providing prohibited incentive items • SA violation |
Custom picklist values will be entered from State agency data entry/input. | ● 0-9 | ● Yes ● No ● Y ● N ● True ● False |
● Yes ● No ● Y ● N ● True ● False |
● Yes ● No ● Y ● N ● True ● False |
|
| Formatting/Validation Notes | Must exactly match an existing FDE record's FNS WIC ID. | Must exactly match the State WIC ID value for the existing record identified by the FNS WIC ID. | Used to identify Investigation. Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | Num of violations is updated when new violations of the same type occur | Custom picklist values will be entered from State agency data entry/input. | XX (up to 2 digits) | No explicit validation if using valid values | No explicit validation if using valid values | No explicit validation if using valid values |
| Field Name 02/2/2022 |
FNS WIC ID (csv) FNS_WIC_ID (xml) |
State WIC ID (csv) State_WIC_ID (xml) |
Investigation Start Date (csv) Investigation_Start_Date (xml) |
Origin (csv) Origin (xml) |
WIC Sanction Type (csv) WIC_Sanction_Type (xml) |
SNAP Sanction Type (csv) SNAP_Sanction_Type (xml) |
State Sanction (csv) State_Sanction (xml) |
Disqualification Date (csv) Disqualification_Date (xml) |
Disqualification Length (csv) Disqualification_Length (xml) |
Date Referred to SNAP (csv) Date_Referred_to_SNAP (xml) |
Date Referred to WIC (csv) Date_Referred_to_WIC (xml) |
CMP Amount (csv) CMP_Amount (xml) |
Administrative Fine Amount (csv) Administrative_Fine_Amount (xml) |
Claim Amount (csv) Claim_Amount (xml) |
Claim Payment Date (csv) Claim_Payment_Date (xml) |
Claim Amount Received (csv) Claim_Amount_Received (xml) |
| Field Type | Text | Text | Date | Picklist | Picklist | Picklist | Picklist | Date | Picklist | Date | Date | Number | Number | Number | Date | Number |
| Field Length | 18 | 32 | 10 | 28 | 34 | 32 | 100 | 10 | 9 | 10 | 10 | 9-digit, 2 decimal places | 9-digit, 2 decimal places | 9-digit, 2 decimal places | 10 | 9-digit, 2 decimal places |
| Example Data | a2Q2J00000kMQKX | 21323 | 10/11/2020 | WIC Investigation | SA sanction | Permanent | Other (See Picklist Values below) | 10/10/2020 | 10 months | 10/11/2020 | 10/11/2020 | 2300.43 | 4000.25 | 2300.99 | 10/10/2020 | 10000.23 |
| Is this field mandatory for creating a new record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Conditionally | Yes | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | No | Conditionally | Conditionally | No | No | Yes (only if reporting a Claim Collection record. Leave field blank not reporting) | Yes (only if reporting a Claim Collection record. Leave field blank not reporting) |
| Is this field mandatory for updating an existing record with this template? This applies to the file upload process only, it does not indicate Program reporting requirements. |
Yes | Yes | Conditionally | No | Conditionally | Conditionally | Conditionally | Conditionally | Conditionally | No | Conditionally | Conditionally | No | No | Yes | Yes |
| Field Description | The unique Salesforce identifier for the FDE record. | The State agency (SA) generated ID for this record. | The Salesforce ID associated with the Investigation. The Investigation Start Date (in conjunction with the FNS WIC ID and State WIC ID) is used to find the investigation record, when the Origin = WIC Investigation. | The originating Program (either SNAP or WIC) for this sanction. | The type of WIC sanction documented in this record. | The type of SNAP sanction documented in this record. | The sanctions that are included in the SA’s sanction schedule, but are not federal mandatory sanctions. | The effective date of the disqualification. | The length of time of the disqualification. | The date the WIC SA referred this disqualification to FNS SNAP, if applicable. | The date FNS SNAP referred the disqualification to the WIC SA. | The total amount of any civil money penalty (CMP) assessed. Please update this field if the amount changes. | The total amount of any fine(s) assessed. Please update this field if the amount changes. | The total amount of all claims established in this investigation. | The date the amount collected was received. | The amount collected in this payment. |
| Valid Values or Allowed Characters | ● 0-9 ● a-z ● A-Z |
● 0-9 ● a-z ● A-Z |
● 0-9 ● / (forward slash) ● -(dash) |
● WIC investigation ● SNAP investigation ● Other WIC oversight activity |
● Mandatory federal disqualification ● CMP in lieu of disqualification ● SA sanction |
● SNAP reciprocal disqualification ● CMP for hardship |
Custom picklist values will be entered from State agency data entry/input. | ● 0-9 ● / (forward slash) ● - (dash) |
● Permanent ● 6 year ● 3 year ● 1 year ● 1 months ● 2 months ● 3 months ● 4 months ● 5 months ● 6 months ● 7 months ● 8 months ● 9 months ● 10 months ● 11 months |
● 0-9 ● / (forward slash) ● - (dash) |
● 0-9 ● / (forward slash) ● - (dash) |
● 0-9 ● . (period) |
● 0-9 ● . (period) |
● 0-9 ● . ( period) |
● 0-9 ● / (forward slash) ● - (dash) |
● 0-9 ● . (period) |
| Formatting/Validation Notes | Must exactly match an existing FDE record's FNS WIC ID. | Must exactly match the State WIC ID value for the existing record identified by the FNS WIC ID. | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | Where the sanction originated or authority to issue the sanction is traced | If origin= WIC or Other WIC oversight activity, this field is required | If origin= SNAP, this field is required | Custom picklist values will be entered from State agency data entry/input. | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | Number of months | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. | #########.## | #########.## | ########.## | To log multiple payments in one upload file, add sets of the two collections fields to the right for each Sanction record. Date must be in the mm-dd-yyyy, mm/dd/yyyy, m/d/yyyy, or m-d-yyyy format. |
#########.## |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |