Print Columns Local Agency: LA ID + Local Agency Name Total columns (labels): Total Cards Used: Cards Issued: Adjusted Stock: Replaced Cards – WIC System Initiated: Total Replaced Cards – EBT Host Initiated: Total Cards Used: Total Cards Issued + Adjusted Stock Cards Issued: See above Adjusted Stock: See above Total Replaced Cards – WIC System Initiated: See above Total Replaced Cards – EBT Host Initiated: See Above Reasons for Replacement Participant Damaged: See Lost: See above Other: See above Sort Local Agency ID / Count Columns NA State Totals Yes Primary Group (page break) Local Agency (no page break) Additional Group By None EBT Cards Issued Disposition Report (Smart Card EBT / Online Xerox EBT) Description The EBT Card Issued Disposition Report shows the EBT cards issued based on selection parameters. Issued and Replaced are where the activity happened, not where the family currently is.
Family Customer Service Log Report Description The Family Customer Service Log Report allows for the detail printing of log entries based on level (state, LA or Clinic), Time Period and Contact Type. Examples of its use include complaint monitoring or ME preparation. Parameters Level – State, LA or Clinic (data is tied to a family which is at the Clinic level) and End Dates Customer Service Type (select one, multiple or all) Record Selection / Filtering / Calculations Record selection is based on parameters This report excludes investigation family related data. Columns LA Clinic Family Last Name Family ID Recorded Date Customer Service Type Civil Right Complaint (Yes or No) Closed Date Referred To Description Resolution Sort LA Clinic Family Name Record Date (Most recent to oldest) Total / Count Columns Clinic Totals LA Totals State Totals Yes Primary Group (page break) Local Agency
Print Columns Matched Data is considered the data that had the exact content match. WIC system is considered the state’s WIC system Input Record is considered the other state’s input data. Matched Data – Last Name Matched Data – Date of Birth (Mask of mm/dd/yyyy) (Stored in FamilyMember.BirthDt) Matched Data – Sex (Mask of M or F) WIC System – LA ID/Clinic (Mask of 99-999) WIC System – Cert Date (Mask of mm/dd/yyyy) WIC System - City WIC System – First Name Record – First Name Record – Cert (Mask of mm/dd/yyyy) Input Record – From (this depends on what is available from other state) Sort Order Matched Data - last name and date of birth Total / Count Columns Number of Input Records (in Header or at top of report) Number of Potential Candidates (in Header or at top of report) Totals No Primary (page break) File Source (State Name) Additional Group By None Local Agency Eligibility Performance Report Description The Local Agency Eligibility Performance Report shows how the local agencies are performing in accordance with the latest caseload eligibility. Data Updated Monthly – Participation Parameters None
Record Selection / Filtering / Calculations The eligibility data is retrieved from the latest non-experimental caseload record. The participation data is calculated based on the sum of the last 12 months of the participation count table for each local agency. This is divided for each local agency by the number of months where that agency had any participation recorded. The percentage is calculated by dividing the eligible by the participation for each category. This report excludes investigation family related data. Print Columns Header parameter line – Date of the latest non-experimental caseload record. Agency ID Women Eligible Participation Percent Infants Eligible Participation Percent Children Eligible Participation Percent Total Eligible Eligible + Infants Eligible + Children Eligible) Participation (Women Participation + Infants Participation + Children Participation) Percent Sort Order By Local Agency Total / Count Columns Each Eligible and Participation Column is aggregated into Total Totals Yes Primary Group (page break) None Additional Group By None
WIC Outreach Mailing Labels Description The WIC Outreach Mailing Labels formats an address listing so that it can be saved to an Excel spreadsheet for importing into a MS Office product for label printing. MS Office products support the many industry standard label layouts. Parameters Local Agency Organization Name (one, multiple or all) Record Selection / Filtering / Calculations Select organization(s) based on parameters Print Columns Organization Name Attention Name Address Line 1 Address Line 2 Formatted concatenation of City, State, Zip and Zip+4 Sort Organization Name – alphabetic / Count Columns None State Totals No Primary Group (page break) No Additional By No Special Note The third column is Address Line 1 combined with the P.O. Box. The fourth column is Address Line 2 and the Suite combined. WIC Outreach Organization Listing