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: MN WIC also uses Infoview software, a robust query tool that allows direct access to database tables. Templates can be created by the State and made available to local agency staff. We are currently piloting several templates with some local agencies. The ad-hoc query methods require familiarity with WIC data, tables and table structure, etc.

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
    •

The following documents provide guidance, including where to find the report, a brief description, criteria and filters used, possible ways to use, and information about how to read the HuBERT pre-defined report.

Benefits Reports - Guidance

Breastfeeding Reports - Guidance

Formula Reports - Guidance

Nutrition Reports - Guidance

Participation Reports - Guidance

Monthly 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

The following documents provide guidance on how to create an ad-hoc report using the HuBERT Report Generator.

  • Infoview

Reports

The following Infoview report is run the first Monday of each month. It 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.

WIC-Allowed Stores and Pharmacies by County Name (EXCEL: 301KB) - May 2013

Report Template Guidance (Pilot)

The following documents provide guidance about Infoview report templates currently being piloted, including a brief overview of the report, and report criteria and columns.

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