Ad-Hoc Report Template Documents

Information and Resources for MN WIC Local Agencies



APPOINTMENTS


#13 - Scheduled Appointments with Interpreter Needed (PDF: 488KB/8 pages)
How to generate a list of participants who have an appointment scheduled in HuBERT during a specified date range who require an interpreter. The report output includes State WIC ID, Service Site ID (Clinic ID), Appointment Date, Appointment Time, and Language

#20 - Appointments for Date (PDF: 293KB/5 pages) - Revised 3/2013
How to generate a list of participants who have an appointment scheduled in HuBERT during a specified date range. This report can be used in conjunction with the Creating Labels document (below) to generate labels for household appointment reminders by Authorized Representatives. The report output includes the Authorized Representative's First and Last Name, Mailing Address, City, State, Zip and Household ID.

Back to Top

BENEFIT ISSUANCE


#5 - Number of Households that Received Benefits for Specified Month (PDF: 490KB/7 pages)
How to generate the number of households in which at least one member received a benefit during a specified month. The report output includes the Household ID and the Service Site ID/Clinic ID (optional).

#1 - List of Participants Issued Benefits on Specified Date(s) (PDF: 475KB/6 pages)
How to generate a list of participants issued benefits during specified dates. The report output includes Household ID, State WIC ID, First Name, Last Name, Date of Birth, WIC Status, and Issued Date (optional).

Back to Top

BLOOD/HEMOGLOBIN MEASUREMENTS


#12 - Children with Hemoglobin Less Than 10 (PDF: 497KB/8 pages)
How to generate a list of children with hemoglobin values less than 10. The report output includes the State WIC ID, Service Site/Clinic ID, Cert Date, and Hemoglobin value.

#16 - Hemoglobin with Measurements Not Done (PDF: 561KB/6 pages)
How to create a list of participants who have more than one record with "CPA determined not due for bloodwork" selected during a year. The report output includes State WIC ID, Cert Start Date, WIC Status, and Staff ID.

#17 - Number of Hemoglobin Measurements Performed during Specified Dates (PDF: 483KB/7 pages)
How to generate a list of participants with a hemoglobin recorded during a specified date range. The report output includes the State WIC ID, Hemoglobin value, Measurement Date, Staff ID, and Service Site ID/Clinic ID (optional).

Back to Top

BREASTFEEDING


#22 - Some-Breastfeeding Women Who Are More than 6 Months Postpartum (PDF: 359KB/4 pages)
How to generate a list of some-breastfeeding woman who are more than 6 months postpartum to audit Nutrition Education contacts after the participant is no longer receiving benefits. The report output includes State WIC ID.

#23 - Fully Breastfeeding Women (PDF: 369KB/4 pages)
How to generate a list of fully-breastfeeding women who received benefits during a specified time frame. The report output includes the State WIC ID, First Name, Last Name, Last Set's Last Date to Use (LDTU), and Cert End Date.

Back to Top

ELIGIBILITY


#3 - List of Participants with Presumptive Eligibility (PDF: 480KB/6 pages)
How to generate a list of participants with an income contact during a specified time period in which "Presumptive Eligibility" was selected for the Proof of Income. The report output includes the State WIC ID, Adjunctive ID (for MA and MN Care), and Staff ID.

#19 - Participants Determined Ineligible during Specified Date Range by Staff ID with Race/Ethnicity (PDF: 335KB/4 pages) - Revised 9/2012
How to generate a list of participants who have been determined ineligible during a specified date range by Staff ID. The report output includes the State WIC ID, Ineligible Date, Ineligible Reason, Staff ID, Cert Start Date, Race/Ethnicity Code (defined in the document below) and Service Site ID/Clinic ID.

Back to Top

HIGH RISK


#7 - Participants Certified during a Specified Date Range with High Risk Indicator(PDF: 315KB/4 pages) - Revised 9/2012
How to generate a list of participants that were certified during a specified time frame and flagged as High Risk. The report output includes the State WIC ID, Cert Start Date, WIC Category at time of cert, Staff ID and Service Site ID/Clinic ID (optional).

Back to Top

MID-CERTIFICATIONS


#9 - Infants 9 Months Old during a Specified Date Range - Midcert Report (PDF: 486KB/7 pages)
How to generate a list of infants who have turned, or are turning, 9 months old during a specified date range. The report output includes the State WIC ID, Date of Birth, and Last Set's Last Date to Use (LDTU).

#25 - Mid-Certifications for Children (PDF: 280KB/4 pages)
How to generate a list of children who should be scheduled for a Mid-certification 6 months after their Cert End Date. The report output includes the State WIC ID, Cert Start Date and Cert End Date.

Back to Top

MISCELLANEOUS


#4 - Participants in a Current Cert with MA or MNCare Selected for Insurance Type (PDF: 480KB/6 pages)
How to create a list of participants in a current certification who currently have MA or MN Care selected in the Insurance Type field in the Demographics AdditionalInfo1 tab. The report output includes the State WIC ID, Cert End Date, current WIC Status, Insurance Type, and Date of Birth (optional).

#15 - Referral Contacts by Organization (PDF: 515KB/7 pages)
How to create a list of participants who have received one or several Referral Contacts during a specified date range based on the Organization ID. The report output includes the State WIC ID, Referral Date, and Staff ID (optional: Organization ID, First Name, Last Name, and Date of Birth).

Back to Top

NUTRITION EDUCATION CONTACTS


#6 - Participants Certified during a Specified Date Range with Staff ID (PDF: 274KB/5 pages) - Revised 3/2012
How to generate a list of participants certified during a specified time frame along with the Staff ID of the person who performed the cert. The report output includes the State WIC ID, Cert Start Date, WIC Status, Service Site ID/Clinic ID, and Staff ID.

#8 - Infants Who Turned 3 or 6 Months Old during a Specified Date Range (PDF: 484KB/7 pages)
How to generate a list of infants who turned 3 or 6 months old during a specified time frame to assist with evaluating whether nutrition education contacts are being provided and documented. The report output includes the State WIC ID, Date of Birth and the Last Set's Last Date to Use (LDTU).

#10 - Infant Contacts - Currently Certified Children 12-15 Months Old (PDF: 487KB/7 pages)
How to generate a list of currently certified children who are 12-15 months old in order to review their infant nutrition education contacts. The report output includes the State WIC ID and Date of Birth.

#14 - Nutrition Education Contact by Topic (PDF: 500KB/6 pages)
How to generate a list of participants who have received an individual Primary or Secondary Nutrition Education contact during a specified date range based on topic. The report output includes the State WIC ID, Nutrition Ed Contact Date and the Staff ID.

Back to Top

PROGRAM MANAGEMENT


#2 - List of Participants with Certification End Date during Specified Dates - Due or Overdue (PDF: 487KB/8 pages)
How to generate a list of participants due or overdue for recertification, depending on the specified date range. The report output includes Household ID, State WIC ID, First Name (optional), Last Name (optional), Date of Birth, WIC Status, Service Site ID (Clinic ID), Certification Due Date, and Last Set's Last Date to Use (LDTU)

#11 - Pregnant Women with Expected Delivery Date during Specified Dates (PDF: 488KB/7 pages)
How to generate a list of women with an Expected Delivery Date during a specified date range. The report output includes the State WIC ID, Expected Delivery Date and Expecting Multiples (optional).

#18 - Number of Currently Certified Children between 2 and 5 Years Old (PDF: 483KB/7 pages)
How to generate a list of currently certified children who are between the ages of 2 and 5 years old as of today's date. The report output includes the State WIC ID and Service Site ID/Clinic ID ID (optional).

#21 - Households with Member in Current Cert (PDF: 297KB/5 pages) - Revised 3/2013
How to generate a list of households with a member in a current certification. This report can be used in conjunction with the Creating Labels document to generate labels for Households by Authorized Representative. This can also be used to create a list of all households in your Local Agency regardless of whether any members are in a current cert. The report output includes the Authorized Representatives First and Last Names, Mailing Address, City, State, Zip and Household ID.

#24 - New Participants (PDF: 298KB/4 pages)
How to generate a list of participants new to the WIC Program during a specified time period. The report output includes the Household ID, State WIC ID, Created Date and Time, Cert Start Date, Agency ID and current WIC Type.

Back to Top