Record The eligibility data is retrieved from the latest non-experimental Selection / caseload record. Filtering / The participation data is calculated based on the sum of the last 12 Calculations 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 Each Eligible and Participation Column is aggregated into Total Columns Totals Yes Primary Group None (page break) Additional None Group By
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
DFDD%20OP%20Operations%20Reports.docx