MN WIC Program
|Use Ctrl + F to search page for keywords or phrases.|
|CLD029, "/n", ad-hoc, annual, back up onto flash drive, benefit pickup ,breastfeeding, chart audit, closeout, counts, county of issuance, daily, enrollment, EOM, FTP site, high risk, household table, IND PICKUP, infoview, initial, member table, monthly, OPR051, outlays, participation, pseudo-cert, redeemed, report generator, reports environment, reset local reference data, risk factor, some-breastfeeding, unduplicated, WIC START, year-to-date|
HuBERT Ad-Hoc Reports Generator No Longer Available after January 1, 2015
Infoview, our preferred ad-hoc reporting tool, was launched in July 2014. It provides much more accurate and robust reporting capabilities than the HuBERT ad-hoc Report Generator. Therefore, as of January 1, 2015, users will no longer have access to the HuBERT ad-hoc Report Generator.
Based on a daily report received by the Operations Unit, it appears that there aren’t many users that use the Report Generator. However, those that do will be contacted by the Operations Unit to ensure that any ad-hoc reports they are using are also available in Infoview. If not, an Infoview Report Template will be created to meet those reporting needs.
All current Ad-Hoc Report Template Documents that provide instructions on how to create certain ad-hoc reports using the Report Generator will be converted to Infoview Report Templates prior to January 1, 2015. A cross-reference document will be provided to assist with identifying the Infoview Report Template that can be used to replace the Report Generator report.
Please contact Sarah Mallberg at (firstname.lastname@example.org or 651.201.4430) with any questions.
August 2014 HuBERT Hints #3
Statewide Launch of Infoview Ad-Hoc Reporting Tool
The Infoview ad-hoc reporting tool is officially available to all agencies. At this time, all WIC coordinators/supervisors should identify at least one person to be their agency's Infoview user. To obtain a username and password for an Infoview user, the WIC coordinator/supervisor should submit the HuBERT User Request form on the WIC CFH Forms and Applications page. Simply select the user from the list, click to update the user's information, and select the Infoview checkbox.
All Infoview users are required to review the Infoview Training Modules on the Session 9: HuBERT Reports training page. There are three training modules; each about 20 minutes long. It should take only about one hour to complete all three modules.
Infoview Information on MDH WIC Website
The Reference Documents & Infoview page on the MDH WIC website, available via the purple button on the Reports & Data page, provides links to the Infoview login page, guidance documents, training modules, and the following reference documents:
- A Quick Reference that provides tips about common functions in Infoview.
- The Infoview Templates by Topic that lists all available report templates and the topic(s) under which the templates can be found. (This is a working document that will be updated each time a new Infoview report template is added.)
- The Infoview Templates List that is organized by topic and provides an overview of each report template along with a link to its guidance document. (This is a working document that will be updated each time a new Infoview report template is added.)
Infoview Report Templates
Report templates are queries/reports that have already been developed in Infoview. When run, formatted reports are generated based on specific information you enter into fields called USER PROMPTS. For example, for many reports you can enter the Agency ID into a PROMPT so that the report provides information specific to your agency.
Although all agencies are required to have an Infoview user, use of the available report templates is OPTIONAL. In the future, the State may have some recommendations about Infoview report templates that could be used to assist with program management or management evaluations.
Each report template has a Guidance Document that provides the following information about a report template:
- Short overview of information provided
- Notes for the user about specific fields or information they should be aware of when running the report
- Print screens of each tab of the report
- User Prompts including the table, field, operator, value and definition
- Any static criteria used
- Columns in the report (including the tables and fields used)
- Sorting, grouping and counts
- Technical notes (includes developer notes, variables, formulas and SQL)
Guidance Documents are available on both the MDH WIC website and in Infoview next to its corresponding report template. We strongly encourage users to review the Guidance Document up to the Technical Notes section BEFORE running an Infoview report template. In many cases, questions that may arise about the report output will be answered by the information provided in the Guidance Document.
Requesting Infoview Reports
If your agency would like an Infoview Report Template created to meet needs not already met by other available report templates, you can submit the Local Agency HuBERT – Change Request Form.
Communicating about New Infoview Report Templates
The HuBERT Hints will be used to communicate about all new Infoview Report Templates once they have been made available in the MN SHARED folder.
Please contact Sarah Mallberg at email@example.com if you have any questions about Infoview.
July 2014 HuBERT Hints #1
New Breastfeeding Reports on FileZilla
New breastfeeding reports are now available in the FileZilla agencyeom in the 2012/Annual Reports folder. These reports count infants who were born and participated in calendar year 2012 by agency or grantee.
"AOIC" in report titles stands for "Alone or in Combination". For participants with multiple races selected, the AOIC reports count the participant once in each racial category. You may see an increase in specific ethnic/racial combinations using "AOIC". Participants are counted only once in the "Multiple Races" category in the CY2012 BF "Unduplicated" reports.
For example: If both "White" and "American Indian or Alaskan Native" are selected then the participant is counted:
- AOIC: in both the "White" category and the "American Indian or Alaskan Native" category
- Unduplicated: once in the "Multiple Races" category
The new reports on FileZilla include:
- CY 2012 BF Duration 0-2 mos by Agency
- CY 2012 BF Duration 0-2 mos by Grantee
- CY 2012 BF Duration 1 day to 2 mos by Agency and AOIC Race/Ethnicity
- CY 2012 BF Duration 1 day to 2 mos by Grantee and AOIC Race/Ethnicity
- CY 2012 BF Duration 1 day to 2 mos by Agency and Unduplicated Race/Ethnicity
- CY 2012 BF Duration 1 day to 2 mos by Grantee and Unduplicated Race/Ethnicity
- CY 2012 BF I_3_6_12 mos by Agency and AOIC Race_Ethnicity
- CY 2012 BF I_3_6_12 mos by Grantee and AOIC Race_Ethnicity
- CY 2012 BF I_3_6_12 mos by Agency and Unduplicated Race/Ethnicity
- CY 2012 BF I_3_6_12 mos by Grantee and Unduplicated Race/Ethnicity
May 2014 HuBERT Hints #2
Mostly and Some-Breastfeeding Women Not Displaying on Benefit Pickup Report (TMP-158)
Description: Mostly and some-breastfeeding women are not displaying on the Benefit Pickup Report (CLN006); their infants, and other children in the household, do display.
What You Should Do: Keep in mind when using the report that the linked mom might also be eligible for benefits.
Resolution: This issue has been added to the issues queue.
Identified Issues - Posted 3/26/14
2012 Breastfeeding Annual Reports are Available
The calendar year 2012 Breastfeeding Annual Reports are now available (BF initiation and duration in total and at 3, 6, and 12 months). For Local Agency staff, the reports will be posted to the 2012/Annual Reports folder on the agencyeom in the secure FileZilla site. (These reports will be posted to the same folder on the stateeom for State staff.)
There are four reports posted for infants born in 2012:
- by Agency ("Agency BF Init and Dur CY2012.pdf");
- by Geographic County ("BF initiation and duration for MN WIC Infants born during CY2012 v5.pdf");
- by City ("Breastfeeding Initiation and Duration by City of Residence for 2012 grouped by CHB.pdf"); and
- by Grantee ("Grantee CY 2012 BF initiation and duration")
March 2014 HuBERT Hints #4
Participation vs. Enrollment Monthly Report Displays All Clinics when Run in Clinic Module (TMP-119)
Description: When running the Participation vs. Enrollment Monthly report (CLD029) in the Reports Environment's Clinic module, the Clinic(s) list displays all clinics instead of only those associated with the Agency selected when you first open HUBERT.
What you Should Do: This is a display issue and does not affect your ability to run the report for your clinics.Resolution: This issue has been added to the issues queue.
Identified Issues - Posted 2/24/14
Timeout Error Sometimes Displays when Running the Year-to-Date Participation and Outlays Report (TMP-10)
Description: An error "The underlying connection was closed: An unexpected error occurred on a receive" message will sometimes display when running the Year-to-Date Participant and Outlays report for larger clinics.
What you Should Do: If you receive this error, close out of the Reports screen, re-open and re-run the report.Resolution: This issue has been added to the issues queue.
Identified Issues - Posted 2/24/14
HuBERT On-Demand Reports Must Only Be Run in the Reports Environment – NEVER in Production!
We have received some feedback that there may be some confusion about where HuBERT reports can be run. HuBERT reports must always be accessed and run in the Reports Environment. The Reports Environment was created in order to ensure that running a report would not have a negative impact on Production.
Since reports require HuBERT to gather large amounts of data to produce, there is the potential for slowing down or locking up Production, which could affect all Local Agencies providing services to participants.
Reports should NEVER be run from Production.
January 2014 HuBERT Hints #3
As of December 31, 2013, WIC START will no longer be available. Most pertinent historical information should be available in HuBERT since it was converted during the transfer.
All reports currently available on WIC START have been moved to the agencyeom and stateeom sites on FileZilla. This includes the AS400 reports from August 2009 – July 2011. The following shows the file structure on the agencyeom and stateeom site.
Folders have been added for 2009-2011 indicating whether the reports are from CHIP or HuBERT. Beginning in 2012, only HuBERT reports are available.
October 2, 2013 Wednesday Update
Report: Participant Chart Audit Report (OPR051) Is Generated Regardless of Whether Specified Sample Size Is Met
When the Participant Chart Audit report is run, all participants who meet the specified criteria:
- WIC Category
- Certified at selected Agency/Clinic
- During specified FFY
…are included in the Randomizing Routine.
For each Min. Percent or Min. Number value specified, participants included in the initial Randomizing Routine are selected at random until the minimum threshold is met or no more participants belonging to that WIC Category remain.
Once all minimum requirements are met, the remaining participants are again selected at random until the Total Sample Size is reached.
If there aren't enough participants included in the initial randomizing routine to fulfill the specified Total Sample Size value or the specified Min. Percent or Min. Number values, the system will NOT DISPLAY any messages and the report will continue to be generated as if there were enough participants to meet the requirements.
From the 2.18.06 Release Document
Changes to MEMBER and HOUSEHOLD Tables Will Affect Ad-Hoc Reports
In Release 2.17.07, all fields associated with authorized and alternate representatives were moved from the MEMBER table to the HOUSEHOLD table. You will need to revise any saved ad-hoc reports that used these fields when they were in the MEMBER table.
However, it should be noted that the HOUSEHOLD table is only available when you select the Household report type. If your report uses another table (such as BLOODWORK or CERTCONTACT, etc.) besides MEMBER, you will not be able to include the representative fields in your report. The fields are no longer available for the Participant report type.
If you require assistance with re-creating a report that used to include representative information, you can request the State create the same report for you using Infoview via the Local Agency HuBERT Change Request Form (Type = Query/Report).
For reports that were created using the Household report type, these fields are usually selected as part of the Report Column Selection. To correct a saved report, simply click the Clear Last Column or the Clear All Columns button, and then re-add your selected fields. When re-adding the Authorized Representative fields, select the HOUSEHOLD table from the Select Field from Table drop-down.
The HuBERT Report Guidance documents for Ad-Hoc #20: Appointments for Date and Ad-Hoc #21: Households with Member in Current Cert have been revised in regard to this change.
March 2013 HuBERT Hints #1
Reset Local Reference Data Every Day
You must continue to Reset Local Reference Data every day before using the clinic application and whenever you change between the Production and Reports environments.
Resetting your Local Reference Data becomes especially important after downloading a Release.
Changes to food items and drop-down lists are stored on your computer. This information is reset and updated when you reset your Local Reference Data. Usually, when these types of changes need to be made, we try to coordinate them with a Release. However, they are not actually included as part of the Release installation but are performed on the HuBERT back-end at the same time. Resetting the Local Reference Data, which is the last step of the installation process, makes these changes to your computer and is necessary so that you don’t receive errors or have problems using new food items.
November 2012 HuBERT Hints #1
Hard Return in Notes and Alerts Results in "/n" Added to Text – Need to Be Aware if Using Text as Criteria in Reports
If you hit the Enter key after typing an alert or within notes, the system stores an additional character "/n" at the end of the typed text in the database.
For example, if you type text and hit the Enter key after each word:
This is how it is saved to the database: THIS\nIS\nA\nTEST\n
This does not display in the application but can cause problems if you are using specific text as a criterion for a report. For instance, if you wanted to identify all alerts that begin with "THIS IS A TEST", using ALERT.TEXT = 'THIS IS A TEST', it would only find those alerts that were typed without any hard returns.
September 2012 HuBERT Hints #1
Upcoming High Risk Appointments Report – Requires Appointment Type(s) with Short Description IND PICKUP
Description: The Upcoming High Risk Appointments Report is a recertified report available in the Clinic module of the Reports Environment. Some agencies have indicated that whenever they print the report, it doesn’t display any records. This is due to the criteria the report uses to pull records. The report will only pull appointments that have Appointment Types with a short description of IND PICKUP. If none of your Appointment Types have this Short Description, no records will display on the report.
What You Should Do: If you want to use this report, you will need to change the Short Description of appropriate Appointment Types to: IND PICKUP. (The Short Description does not have to be unique for each Appointment Type; it can be the same for multiple different Appointment Types.)NOTE: You cannot modify the Short Description for the System-Defined Appointment Types (High Risk Follow-Up, Mid Certification, Initial Certification and Subsequent Certification).
April 2012 HuBERT Hints #3
Ad-Hoc Reports Are Saved to Computer – Back Up onto Flash Drive
Description/Explanation: Ad-Hoc Reports created via the HuBERT Report Generator are saved to the computer on which they were created. If something were to happen to the computer and it would need to be replaced, you would lose any reports saved to it.
What You Should Do: If you are concerned about potentially losing Ad-Hoc reports that you have created, you can save them to a flash drive:
- STEP 1: Once you’ve saved the report as usual, insert a Flash Drive into a USB port on the computer
- STEP 2: Click on the Save Report Definition button (2) again
- STEP 3: In the Save Report As window, click the Save in drop-down (3)
- STEP 4: Select your Flash Drive (4) - in the image above the Flash Drive is 512MB (E:)
- STEP 5: Type the report name into the File Name field
- STEP 6: Click the Save button (6)
If your computer is replaced, you will need to call the Help Desk to assist you with saving your reports back into the appropriate folder for the Ad-Hoc Generator. Please note that the default folder for saving your reports is based on the type of report you create, typically either Participant or Household. (Participant Reports are automatically saved to the Participant folder while Household Reports are automatically saved to the Household folder.)
You may want to create a Participant and Household folder on your Flash Drive to make it easy to determine which reports belong in which folder in case they ever need to be saved from the Flash Drive onto a new computer.
NOTE: Keep all private data secured, including any reports that have been run and saved onto flash drives. Please reference the "Removable Storage" section of MOM, 9.3 for security policies regarding removable storage (flash drives).
March 2012 HuBERT Hints #1
You Can Use State Office or Central Administrative Site in the Reports Environment to View Participant Records
The HuBERT Reports Environment provides access to four different modules. Once you have logged into one of the REPORTS modules, you can open any of the other three REPORTS modules.
You can also have the Report Generator open at the same time as any one of the other three REPORTS modules. For instance, you can open REPORTS - State Office at the same time as you have the Report Generator open. This can be especially useful if you are working with a report and need to look up a participant's information. (Note: The Clinic, Central Administrative Site and State Office cannot be open at the same time.)
|The REPORTS – Central Administrative Site module can be used to run HuBERT reports and view all participant folders in your Local Agency.|
|The REPORTS – Clinic module can be used to run the same HuBERT reports that are found in the HuBERT clinic application.|
|The REPORTS – Report Generator can be used to create simple ad-hoc reports.|
|The REPORTS – State Office module can be used to run HuBERT reports and view all participant folders in the Statewide Database.|
Remember, all of the modules in the Reports Environment access the Reports Database, which is a copy of the Production database and is 12 hours behind your clinic application.
February 2012 HuBERT Hints #1
Creating Ad-Hoc Reports – Some General Information
The following information has been added to the HuBERT Ad-Hoc Report Generator Guidance.
When creating an ad-hoc report, it is important to first answer some basic questions about what information you want from the report and what you need in order to get that information. Outlined below is a process that may assist you in developing your own ad-hoc reports.
Process for Developing Ad-Hoc Reports
STEP 1: Define the question
- What information do you want the report to provide?
- How will this information be used?
- Is this information already available in the HuBERT reports or Pre-Defined Ad-Hoc Queries?
STEP 2: Define the criteria to help filter the records
- Any pertinent information that limits the number of records in your report
- Examples: Time frame/Cert Dates, Agency ID, Clinic ID
STEP 3: Determine which fields/columns should be used to filter the records and the appropriate operators and values (sometimes a table is helpful to organize requirements). Examples:
|CertStartDate||Between||01/01/2012 and 01/31/2012|
STEP 4: Determine which table contains the fields/columns needed
- The same field may be found in multiple different tables*
- It is important to understand the difference between the information the field provides based on the table used
|CertStartDate*||MEMBER||Most recent/current CertStartDate|
|AgencyID*||Agency ID/ServiceSiteID where participant currently belongs; not where cert was performed|
STEP 5: Determine which columns should display in the report
- Should only use fields from the same table(s) that were used to filter the report; don't use fields from different tables
- NOTE: If more than one table needs to be used, please contact the State Office to assist with its development
STEP 6: Determine primary sort order and output options
The following are some general rules to follow:
1. Report Type Selection is typically PARTICIPANT
2. Try not to use more than one table (contact State for assistance if needed)
3. Never use the OR logical operator (could run multiple reports instead)
4. Use CertStartDate instead of CertEffectiveDate whenever possible (CertEffectiveDate is updated each time a pseudo-cert is created)
If you would like assistance with creating an ad-hoc report, you can submit a request via the Local Agency HuBERT Change Request Form (Type = Query/Report).
February 2012 HuBERT Hints #1
How to Estimate Your Unduplicated Count
Description: It is possible to estimate your local agency's 2011 unduplicated participation by using the Cumulative Monthly participation counts. These were sent in the 12/21/2011 Wednesday Update in SUMMARY OF MONTHLY PARTICIPATION ACTIVITY (CLOSED OUT MONTHS ONLY) Cumulative Totals, FFY 2011. (This is not available on-line - please contact your Program Consultant if you need this report.) We recommend that you estimate the unduplicated count by multiplying the Monthly YTD AVE count by 1.6.
Explanation: State staff have received several local agency requests for an unduplicated participation count for 2011. We recommend using an estimate due to having two systems operating during this time. Staff have consistently come up with a ratio of 1.6 of unduplicated to monthly participation counts.
February 2012 HuBERT Hints #1
How Long Are Reports Maintained on the FTP Site?
The reports on the FTP site will continue to be available for a minimum of 6 years.
November 2011 HuBERT Hints #1
Reports Environment Also Installs Releases
This is just a reminder that when a Release is installed on Production, it is also installed on the Reports Environment. The first time you access the Reports Environment after a release is implemented, the system will automatically install the Release (just like Production).
August 2011 HuBERT Hints #2
How does HuBERT count some-breastfeeding women?
Some-breastfeeding women who are more than 6 months postpartum are automatically counted by HuBERT during the End-of-Month process. There is no correlation between these participants being counted and the letter that automatically prints for them when benefits are issued to their linked infants.
July 2011 HuBERT Hints #3
How Do I Monitor Daily Participation Counts?
Use the Year-to-date Participation and Outlays in State Office Reports Environment
This is the only HuBERT report that will provide your agency's month-to-date participation; use this report to print your daily count. The report displays the WIC fiscal year (October – September) and consists of two pages (use the arrow icons in the top left corner when displayed on screen). All references to Outlays can be ignored for participation purposes.
- C/O = months that have been closed out; a month's closeout occurs after 60 days
- 30DY = EOM has been run but not closed out yet
- ISSD = EOM has been run for that month (initial)
- OPEN = EOM has NOT run for that month
- Women/Infants Part. BF > Max = Mostly-breastfeeding
- Women/Infants Part. BF < Max = Some-breastfeeding
Report Guidance is also available.
Factors that Impact Participation Count
- This report is affected by the End-of-Month (EOM) process that currently runs between the 15th and 20th of each month.
- EOM adds participants without food packages (FBF Infants < 6 months old and Some-BF women > 6 months postpartum) to the count. These participants are counted at the clinic at which they were originally certified.
Late Issuance: Your count will continue to increase for the previous month due to late issuance since participants can receive benefits up until the day before their next set begins.
Tri-Monthly Issuance: Even though benefits are issued tri-monthly, the report will only show a count up to the current month; you cannot run the report for future months.
May 2011 HuBERT Hints #1