Sort Order Agency, Clinic, Certification End Date (Closest to today’s date first), Family ID, Person ID Total / Count Columns Clinic total number of participants listed. Local Agency total number of participants listed. Total of all participants listed for all selected Local Agencies. State Totals No Primary Group (page break) Additional Group By Local Agency Clinic Note: Font in the body of the report is Arial 8.
Print Columns Agency/Clinic Header, Person ID, Participant Name, Endorser Name, Category, Priority, Risk Factors, HR Follow-Up, DOB Note: The agencies and clinics listed in the header areas are in the format agency number – agency name and clinic number – clinic name. Person ID = FamilyMember.FFMemberID Display Participant Name as FamilyMember.FirstName + FamilyMember.MiddleName + FamilyMember.LastName +FamilyMember.LastNameSuffix. Display Endorser Name as FamilyMember.FirstName + FamilyMember.MiddleName + FamilyMember.LastName + FamilyMember.LastNameSuffix when FamilyMember.ParentGuardianIn = Yes. Utilize the system parameter ClinicServices.HeadofHouseholdLabelToUse to create the Endorser Name column heading. If no record is found, set the column heading to “Endorser Name”. Category = ParticipantType.ParticipantTypeCD Priority = Select the highest priority (lowest priority number) (RiskDet.ParticipantRiskPrtyNr) among the RiskDet records for the most recent risk assessment Risk Factors = ParticipantRiskCode.ParticipantRiskCd + ParticipantRiskCode.Name HR Follow-Up = CompletedNtrEd.HighRiskFollowUpIn DOB = FamilyMember.BirthDt Sort Order Participant Last Name Total / Count Columns NA State Totals NA Primary Group (page break) Local Agency Additional Group By Clinic
Prevalence of Nutrition Risk By LA and County Report Description This report is used to show the frequency of risk by participant category of all active participants by local agency, county, and clinic. Parameters Local Agency, Effective Date, State Totals (Yes or No), Risks Record Selection / Filtering / Calculations All for active participants at the time the data is compiled Total Participants = All participants with a WIC Status of Active Participants per category = All participants with a WIC Status of Active and ParticipantType.ParticipantTypeCd of Pregnant, Breastfeeding, Not Breastfeeding, Infants, or Child Number of Participants with Risk (for each category) = All participants with a WIC Status of Active and ParticipantType.ParticipantTypeCd of Pregnant, Breastfeeding, Not Breastfeeding, Infants, or and have the specified risk Percentage of Participants with Risk (for each category) = All participants with a WIC Status of Active and ParticipantType.ParticipantTypeCd of Pregnant, Breastfeeding, Not Breastfeeding, Infants, or Child and have the specified risk / Participants per category * 100 The Risks parameter contains all ParticipantRiskCode.ParticipantRiskCd values where ParticipantRiskCode.Status = ‘A’. Filter the participants to be only with a RiskDet.ParticipantRiskCd equal to a value selected in the Risks parameter. This report excludes investigation family related data. Print Columns Agency header, Clinic header, County header, Category columns (Pregnant, Breastfeeding, Not Breastfeeding, Infants, Child), Total Participants, Participants per category, Risk, Participants with Risk (for each Category column), % Participants with Risk (for each Category column) Note: The agencies and clinics listed in the header areas are in the format agency number – agency name and clinic number – clinic name. Risk = Display as ParticipantRiskCode.ParticipantRiskCd + ParticipantRiskCode.Name Sort Order Local Agency, County, Clinic, Frequency of Risk for all active participants (high to low) Total / Count Columns All columns
Content/Format Report Subtitle: Start and End Dates (display as <Month Name yyyy – Month Name yyyy) Group: <LA ID – LA Description> Sub <Clinic ID – Clinic Description> Detail Headings/Columns: Excl BF 1 Wk – means 0-6 days Excl BF 3 mo Excl BF 6 mo Ever BF 1Wk – means 0-6 days 2Wk – means 7-13 days 3Wk – means 14-20 days 4Wk – means 21-27 days 5Wk – means 28-34 days 6Wk – means 35-41 days 2M – means 9 weeks 3M – 13 weeks 6M – means 26 weeks 9M – means 39 weeks 12M – means 52 weeks 18M – means 78 weeks 24M – means 104 weeks Sort Order Local Agency, Clinic Page Breaks Primary group by Local Agency with page breaks for each local agency. Secondary group by Clinic with no page breaks. Totaling Percentage and Total for each column for each grouping: State, Local, Clinic
Breastfeeding and Formula Issuance Report Description This report shows issuance trend data for exclusively and primarily exclusive/no formula package and primarily exclusive/complementary food combined descriptions of breastfeeding infants. It specifically identifies infants who had a description of one of the categories of exclusively breastfeeding infants at their first visit, tracks them, and identifies when they first receive powdered formula (first food package effective date with a food package containing formula) and the quantity (in cans) of formula provided. Displayed as percentages of number of cans per age in months. Run for a local agency to show clinic data for a 12- month period. Parameters Ending Month, Ending Year (user provides the last month of a 12 month reporting period), Local Agency, State Totals (Yes or No) Record Selection / Filtering / Calculations All infants with Breastfeeding Description=EXCL, PRIM, or COMP at first WIC visit that are within the date range. Month column – Determined based on the difference between participant’s birth date and the first food package effective date with a food package containing formula. The infant is only counted in the first month where the food package indicates that they could start to receive formula. Rows are the number of cans of powdered formula issued: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15. Rows are not displayed unless is data to display for the row. The number of cans is based on the full proration food package. Calculation: Percentage of infants (with EXCL, PRIM or COMP at first WIC visit) that were issued powdered formula by month of age and recorded by number of cans BF Description based on InterviewInfant.BFActionCd = EXCL, PRIM, COMP Powdered formula based on Product.FormulaTypeCd = Powder Date of Birth = FamilyMember.BirthDt This report excludes investigation family related data.
Content Format Report Subtitle: Start and End Dates (display as <Month Name yyyy – Month Name yyyy) Group: <LA ID – LA Description> Sub Group: <Clinic ID – Clinic Description> Detail Headings/Columns: Cans < 1 Month – <4 weeks 1 Month - ≥4 weeks and ≤8 weeks 2 Months - ≥9 weeks and ≤12 weeks 3 Months - ≥13 weeks and ≤16 weeks 4 Months - ≥17 weeks and ≤21 weeks 5 Months - ≥22 and ≤25 weeks 6 Months - ≥26 weeks and ≤29 weeks 7 Months - ≥30 weeks and ≤34 weeks 8 Months - ≥35 weeks and ≤38 weeks 9 Months - ≥39 weeks and ≤42 weeks 10 Months - ≥43 weeks and ≤47 weeks 11 Months - ≥48 weeks and ≤51 weeks 12 Months - ≥52 Sort Order Number of Cans of formula Total / Count Columns No Totals Yes Primary Group (page break) Local Agency Additional Group By Clinic
Print Columns File line: File/PAN (width 25) – Concatenate file name and date (EBTRemoteIssuance.AvailFileNm and .SentAvailableDt) Pan line File/PAN - PAN (EBTRemoteIssuance.EBTC_ID) Ref Num – Remote Issuance Reference Number (EBTRemoteIssuance.RemoteRefNr Economic Unit Name (width 20) - Based on EBTRemoteIssuance.EBTC_ID Clinic – LA ID + ‘-‘ + Clinic ID (Based on EBTRemoteIssuance.EBTC_ID) Status 10)– EBTRemoteIssuance.StatusCd – ‘EBT Remote Status’ code description Date – If status is Available, then EBTRemoteIssuance.SentAvailableDt If status is Loaded, then EBTRemoteIssuance.IssueDt If status is Canceled, then EBTRemoteIssuance.CancelDt FDTU – EBTRemoteIssuedFood.FirstUseDt Category 35)– FoodCategory.CategoryNr Subcategory (width 40)– Based on EBTRemoteIssuedFood.PCon_ID. Product.SubCategoryNr UOM 6) – Based on EBTRemoteIssuedFood.PCon_ID. ProdContainer.ContainerSizeCd - USDA UOM Description Units – EBTRemoteIssuedFood.Quantity Vendor (width 40) – Based on EBTRemoteIssuance.Vend_ID. Vendor.FFVendorID - Vendor.StoreName if EBTRemoteIssuance.Vend_ID is populated, otherwise blank Sort Order File, PAN, FDTU, Category Number, Subcategory Number Total / Count Columns None State Totals None Primary Group (page break) None Additional Group By File Name Due to amount of displayed information (150% of normal report); the standard report font is not used. A smaller font is selected. This small mockup may need to be viewed in MS Word’s zoom mode.