Reports

MN WIC Information and Resources for Local Agencies

Brief Overview of WIC (Data) Reports Currently Available

HuBERT, the MN WIC Information System, currently has two report functions:

  • WIC staff can create their own reports using the HuBERT Report Generator, a simple query tool that's easy to use

Infoview Ad-Hoc Reporting Tool: Infoview is a robust query tool that allows more diverse and complex ad-hoc reports to be created. Queries could be run to look at, for example, assigned risk factors, redemption, benefits issued with specific food items, etc. The plan is to have guidance and training available by Fall 2013.

Data Dictionary: WIC data is very extensive and complex. To assist users, we have provided a Data Dictionary that lists some common tables, their fields, applicable values and allowed operators. We are revising the dictionary to be more user-friendly.

Pediatric Nutrition Surveillance (PedNSS) is a CDC report of MN WIC data.

Analysis of WIC Data Across Time: State staff are working on extensive analysis of WIC data across time, including health disparities, breastfeeding rates, weight status and birth outcomes. This information is available on the WIC Surveillance & Evaluation Data page.

To request data information or assistance with reports:

Local Agency HuBERT - Change Request Form

On this page:

HuBERT Reports References

Pre-Defined Reports Ad-Hoc Reports

HuBERT Reports References

Back to Top

Pre-Defined Reports

  • HuBERT Pre-Defined Reports Guidance

Benefits Reports

Breastfeeding Reports

Formula Reports

Nutrition Reports

Participation Reports

Archived Pre-Defined Report Guidance Documents

  • AS400 Reports (legacy system - CHIP)

    • The AS400 (central server) housed all Minnesota WIC participant, voucher and vendor data for our legacy system, CHIP. Prior to HuBERT roll-out (September 2010 - April 2011), a variety of reports were provided to local agencies each month.

  • Pediatric Nutrition Surveillance System (PedNSS) Report

    • This report summarizes health indicators for children enrolled in the Minnesota WIC Program. The original report included information from 1995 through 2004. Updated reports are added as they become available.

  • WIC Participant and Program Characteristics Report

    • As required by USDA, it is a comprehensive biennial report that is produced every two years using a subset of WIC data. This report can be found on the USDA web site along with other relevant WIC data.

Back to Top

Ad-Hoc Reports

Several methods are available to obtain ad-hoc report information. Please submit the Local Agency HuBERT - Change Request Form (Type = Query/Report) if you need assistance in creating your own ad-hoc reports or have other ad-hoc report needs.

  • HuBERT Ad-Hoc Report Templates
  • Infoview Reports/Templates

Infoview is an ad-hoc reporting tool that can be accessed via the Web. It is a more robust tool than the HuBERT Report Generator and has the capability of producing more sophisticated reports. Report templates are currently being piloted by a few Local Agencies.

The following Infoview report is run the first Monday of each month:

This report has three worksheets: Stores, Pharmacies and How to Filter by County. All counties are listed and the lists will need to be filtered by County. Download and save the Excel file, then filter by County.

Back to Top

State and/or local agency staff can use WIC START to create ad-hoc queries or reports to obtain data from our legacy system, CHIP.

Only Minnesota WIC Local Agency and State staff can obtain a user ID and password for WIC START. Please review the WIC START Terms and Conditions.

Back to Top