US Reports

This article covers the following US-only reports: 

• How Do I Use a CSFP Case Load Report? (US Only)
• How Do I Use a CSFP Ethnicity Report (Unique)? (US Only)
• How Do I Use a CSFP Ethnicity Report (Duplicated)? (US Only)
• How Do I Use a Social Services Outcomes Report? (US Only)
• How Do I Use a School Pantry Report? (US Only)
• How Do I Use an FFC Report? (US Only)

How Do I Use a CSFP Case Load Report?

The CSFP Case Load Report contains two tables and two bar graphs. The following information describes how to interpret the results.

Please see Report Setup Foundations (click here) for information on basic setup steps for all reports. 

The completed report will show the name you assigned to the report at the top of the page and will also show:

• Reporting for: a list of all the agencies reported on during the reporting period.
• For these program types: lists the programs reported on during the reporting period.
• With dates between: the dates used for the reporting period.

CSFP: Case Load Balance section

This table only includes the agencies that have a caseload.

The light blue header represents the title of the section.

The dark blue header describes the information being reported on.

The table reports on the number of case loads allocated to each agency, how many CSFP clients were served, and the balance of case loads remaining for the reporting period.

CSFP: Cumulative Visits with Case Load by Day bar graph

This bar graph reports the total number of visits with case loads on any given day within the reporting period.

The vertical axis contains the case load allocation (the values running up the left-hand side).

The horizontal axis contains the dates of the reporting period.

The results are shown in green.

Hover over any green bar and a pop-out box will appear showing the total (cumulative) visits for that day.

People Served by Day bar graph

This bar graph illustrates how many people were served on any given day within the reporting period.

The vertical axis represents the number of clients (the values running up the left-hand side).

The horizontal axis contains the dates of the reporting period.

The results are shown in green.

Hover over any green bar and a pop-out box will appear showing the total number of people served on that day.

CSFP: Case Load Daily Served section

This table includes all CSFP visits regardless of whether the agency has a caseload or not.

The light blue header represents the title of the section.

The dark blue header describes the information being reported on.

The table reports on the number of individuals served on each day within the reporting period.

How to copy, download and print the sections of the report

To print the tables on the report separately, click on the Tools button on the right-hand side within the light blue heading:

• Copy: copies the report contents to your computer's clipboard.
• CSV: downloads the report contents into a CSV file, generally viewed with Microsoft Excel.
• PDF: downloads the report contents into a PDF.
• Print: presents a printer-friendly version of the report contents.

To print the graphs on the report separately:

• Click the Convert to PNG button on the top right-hand side of the graph.
• The button will change to a green Download PNG button.
• Click the Download PNG button, and a copy will be saved to your device

It is possible to print the entire report with all tables and graphs:

• Click the blue Print View button at the top right-hand side of the report page.
• A secondary tab will open, click the Print Popup button on the left-hand side.
• A print options box will appear; complete the fields and click the Print button.

Clicking on the Enable Scrolling button will allow you to scroll to the right if there are more items in the table that are not currently in view. 

CSFP Case Load Report walk-through

 

How Do I Use a CSFP Ethnicity Report (Unique)?

The CSFP Ethnicity report contains one table and two sets of graphs, and reports on the ethnicities of clients served during the reporting period.

This is data required for the FNS-191. This version provides unique counts, so can be used for FNS reporting.

Please see Report Setup Foundations (click here) for information on basic setup steps for all reports. 

The completed report will show the name you assigned to the report at the top of the page and will also show:

• Reporting for: a list of all the agencies reported on during the reporting period.
• For these program types: lists the programs reported on during the reporting period.
• With dates between: the dates used for the reporting period.

The light blue header represents the title of the report.

The dark blue header describes what is being reported on.

The first column of the table lists all ethnicities included in the report. The next three columns capture how many clients were Hispanic/Latino, how many were Non-Hispanic/Latino, and the Total all ethnic groups within the reporting period.

Breakdown of table results.

• When running this report, the table is broken down into a list of races and whether or not the client identifies as being "Hispanic/Latino" or not. 
• This report considers "Hispanic/Latino" (rows) as an ethnic group and the other options are listed in rows as races.
• If someone selects any combination of ethnicities listed in rows 05-13 INCLUDING Hispanic/Latino, the count will be listed in that row under the "Hispanic/Latino" column.
• If someone selects any combination of ethnicities listed in rows 05-13 EXCLUDING Hispanic/Latino, the count will be listed in that row under the "Non-Hispanic/Latino" column.
• If someone selects more than one ethnicity that isn't specified in the table rows 05-13 INCLUDING Hispanic/Latino, the count will be listed in row 14 under the "Hispanic/Latino" column.
• If someone selects more than one ethnicity that isn't specified in rows 05-13 EXCLUDING Hispanic/Latino, the count will be listed in row 14 under the "Non-Hispanic/Latino" column.
• If someone selects "Other" INCLUDING Hispanic/Latino, the count will be listed in row "99 Other" under the "Hispanic/Latino" column.
• If someone selects "Other" EXCLUDING Hispanic/Latino, the count will be listed in row "99 Other" under the "Non-Hispanic/Latino" column.
• If someone selects "Not Applicable", the count will be listed in row "99 Not Applicable" under the "Non-Hispanic/Latino" column.
• If someone selects "Undisclosed", the count will be listed in row "99 Undisclosed" under the "Non-Hispanic/Latino" column.
• If someone is only Hispanic/Latino, the count will show in the "09 White" row under the "Hispanic/Latino" column.

Next in the report are 2 pairs of graphs.

The first pair is comprised of a donut graph and a bar graph, reporting only on Hispanic/Latino clients and Non-Hispanic Latino clients.

The second pair is comprised of a donut graph and a bar graph, reporting on all other ethnicities of clients.

The donut graph can be manipulated to remove categories by clicking on the radio button next to the category you wish to remove from the graph. Hovering over each category on both graphs will generate a pop-out box detailing how many clients identified with the ethnicity of that category.

How to copy, download and print the sections of the report

To print the table on the report separately, click on the Tools button on the right-hand side within the light blue heading:

• Copy: copies the report contents to your computer's clipboard.
• CSV: downloads the report contents into a CSV file, generally viewed with Microsoft Excel.
• PDF: downloads the report contents into a PDF.
• Print: presents a printer-friendly version of the report contents.

To print the graphs on the report separately:

• Click the Convert to PNG button on the top right-hand side of the graph.
• The button will change to a green Download PNG button.
• Click the Download PNG button, a copy will be saved to your device

It is possible to print the entire report:

• Click the blue Print View button at the top right-hand side of the report page.
• A secondary tab will open, click the Print Popup button on the left-hand side.
• A print options box will appear; complete the fields and click the Print button.

Clicking on the Enable Scrolling button will allow you to scroll to the right if there are more items in the table that are not currently in view. 

CSFP Ethnicity Report (Unique) walk-through

 

How Do I Use a CSFP Ethnicity Report (Duplicated)?

Reports on the ethnicities of clients served during the reporting period. This is a duplicated count, so each household or individual is counted for each time they received services during the reporting period. The report contains one table and two pairs of graphs.

This is duplicated data, as every visit is recorded, so it CANNOT be used for FNS reporting.

Please see Report Setup Foundations (click here) for information on basic setup steps for all reports. 

The completed report will show the name you assigned to the report at the top of the page and will also show:

• Reporting for: a list of all the agencies reported on during the reporting period.
• For these program types: lists the programs reported on during the reporting period.
• With dates between: the dates used for the reporting period.

The light blue header represents the title of the report.

The dark blue header describes what is being reported on.

The first column of the table lists all ethnicities included in the report. The next three columns capture how many clients were Hispanic/Latino, how many were Non-Hispanic/Latino, and the Total of all ethnic groups within the reporting period.

Breakdown of table results.

• When running this report, the table is broken down into a list of races and whether or not the client identifies as being "Hispanic/Latino" or not. 
• This report considers "Hispanic/Latino" (rows) as an ethnic group and the other options are listed in rows as races.
• If someone selects any combination of ethnicities listed in the rows 05-13 INCLUDING Hispanic/Latino, the count will be listed in that row under the "Hispanic/Latino" column.
• If someone selects any combination of ethnicities listed in the rows 05-13 EXCLUDING Hispanic/Latino, the count will be listed in that row under the "Non-Hispanic/Latino" column.
• If someone selects more than one ethnicity that isn't specified in the table rows 05-13 INCLUDING Hispanic/Latino, the count will be listed in row 14 under the "Hispanic/Latino" column.
• If someone selects more than one ethnicity that isn't specified in the rows 05-13 EXCLUDING Hispanic/Latino, the count will be listed in row 14 under the "Non-Hispanic/Latino" column.
• If someone selects "Other" INCLUDING Hispanic/Latino, the count will be listed in row "99 Other" under the "Hispanic/Latino" column.
• If someone selects "Other" EXCLUDING Hispanic/Latino, the count will be listed in row "99 Other" under the "Non-Hispanic/Latino" column.
• If someone selects "Not Applicable", the count will be listed in row "99 Not Applicable" under the "Non-Hispanic/Latino" column.
• If someone selects "Undisclosed", the count will be listed in row "99 Undisclosed" under the "Non-Hispanic/Latino" column.
• If someone is only Hispanic/Latino, the count will show in the "09 White" row under the "Hispanic/Latino" column.

Next in the report are 2 pairs of graphs.

The first pair is comprised of a donut graph and a bar graph, reporting only on Hispanic/Latino clients and Non-Hispanic Latino clients.

The second pair is comprised of a donut graph and a bar graph, reporting on all other ethnicities of clients.

The donut graph can be manipulated to remove categories by clicking on the radio button next to the category you wish to remove from the graph. Hovering over each category on both graphs will generate a pop-out box detailing how many clients identified with the ethnicity of that category.

How to copy, download and print the sections of the report

To print the table on the report separately, click on the Tools button on the right-hand side within the light blue heading:

• Copy: copies the report contents to your computer's clipboard.
• CSV: downloads the report contents into a CSV file, generally viewed with Microsoft Excel.
• PDF: downloads the report contents into a PDF.
• Print: presents a printer-friendly version of the report contents.

To print the graphs on the report separately:

• Click the Convert to PNG button on the top right-hand side of the graph.
• The button will change to a green Download PNG button.
• Click the Download PNG button, a copy will be saved to your device

It is possible to print the entire report:

• Click the blue Print View button at the top right-hand side of the report page.
• A secondary tab will open, click the Print Popup button on the left-hand side.
• A print options box will appear; complete the fields and click the Print button.

Clicking on the Enable Scrolling button will allow you to scroll to the right if there are more items in the table that are not currently in view. 

CSFP Ethnicity Report (duplicated) walk-through

How Do I Use a Social Services Outcomes Report?

This report details results from the Social Services Outreach Application regarding the number of applications by status, reasons for denied applications, and the total sum of funds awarded.

Please see Report Setup Foundations (click here) for information on basic setup steps for all reports. 

The completed report will show the name you assigned to the report at the top of the page and will also show:

• For these program types: lists the programs reported on during the reporting period.
• With dates between: the dates used for the reporting period.

The light blue header represents the title of the report section.

The dark blue header describes what is being reported on.

The agencies appear on the leftmost column, and each organization's totals are listed in sequential columns. 

The rightmost column will be the total of all columns combined.

Sections on the report are:

• Application Programs - the count of times someone applied to each program. This is a customizable list of social programs.

• Application Sources - the total applications from a particular source. This is a customizable list of sources.

• Application Status: Initial - The state of all applications at the time of creation. This is a customizable list of statuses.

• Application Status: Most Recent - The most recent application status of applications. This is a customizable list of statuses.

• Reasons for Denied Applications - Reasons for denied applications.

• Total Awarded Applications - Most recent total dollar value awarded in approved applications.

Please click here for instructions on adding to, deleting, or editing lists.

How to copy, download and print the sections of the report

To print a section of the report separately, click on the Tools button on the right-hand side within the light blue heading:

• Copy: copies the report contents to your computer's clipboard.
• CSV: downloads the report contents into a CSV file, generally viewed with Microsoft Excel.
• PDF: downloads the report contents into a PDF.
• Print: presents a printer-friendly version of the report contents.

To print the entire report:

• Click the blue Print View button at the top right-hand side of the report page.
• A secondary tab will open, click the Print Popup button on the left-hand side.
• A print options box will appear; complete the fields and click the Print button.

Clicking on the Enable Scrolling button will allow you to scroll to the right if there are more items in the table that are not currently in view. 

Social Services Outcomes Report walk-through

How Do I Use a School Pantry Report?

The School Pantry report provides information concerning School Pantry services for a variety of metrics.

Please see Report Setup Foundations (click here) for information on basic setup steps for all reports. 

The completed report will show the name you assigned to the report at the top of the page and will also show:

• Reporting for: a list of all the agencies reported on during the reporting period.
• For these program types: lists the programs reported on during the reporting period.
• With dates between: the dates used for the reporting period.

The light blue header represents the title of the report section.

The dark blue header describes what is being reported on.

The table displays information pulled into the report; the school pantry agency and current school grade of all children in the household are listed in the very first column of their respective report section.

Report section definitions

• Household: Households/Individuals with persons less than 18 (Duplicated): The total number of households (and the total number of individuals in those households) containing at least one individual who is less than 18 years old (excludes individuals who are currently 18). This is a duplicated count, so any household with an individual less than 18 years old will be counted for each visit during the reporting period.
• Household: Households with persons less than 18 (Unique): The total number of households (and the total number of individuals in those households) containing at least one individual who is less than 18 years old (excludes individuals who are currently 18). This is a unique count, so any household with an individual less than 18 years old will only be counted once, regardless of the number of times they accessed services during the reporting period.
• Number of Days Food Distributed: Reports on the number of unique days that food was distributed during the reporting period.
• Required Grade Documentation (Unique): Reports on the number of unique documents provided during the reporting period. 
• School Attendance (Duplicated) - Reports on the schools attended by individuals during the reporting period. This is a duplicated count, so each individual is counted for each time they received services during the reporting period.
• School Attendance (Unique) - Reports on the schools attended by individuals during the reporting period. This is a unique count, so any individual will only be counted once regardless of the number of times they accessed services during the reporting period.
• Served: Adults (Duplicated) - Reports on the total number of adults served during the reporting period. This is a duplicated count, so each individual is counted for each time they received services during the reporting period.
• Served: Adults in Households with individuals 18 or less (Duplicated): The total number of individuals served that are 18 years old or older that live in a household with at least one individual who is younger than 18 years (excludes individuals who are currently 18). This is a duplicated count, so individuals will be counted for each visit during the reporting period.
• Served: Adults in Households with individuals less than 18 (Unique): The total number of individuals served that are 18 years old or older that live in a household with at least one individual who is less than 18 years old (excludes individuals who are currently 18). This is a unique count, so any individual will only be counted once regardless of the number of times they accessed services during the reporting period.
• Served: Children (Duplicated): Reports on the total number of children served during the reporting period. This is a duplicated count, so each child is counted for each time they received services during the reporting period. 
• Served: Children (Unique): Reports on the total number of children served during the reporting period. This is a unique count, so each child will only be counted once regardless of the number of times they accessed services during the reporting period. 
• Served: Household (Duplicated): Reports on the total number of households (counts just the household, not the number of people in it) and individuals (counts all people in the household) during the reporting period. This is a duplicated count, so each household or individual is counted for each time they received services during the reporting period.
• Served: Household (Unique): Reports on the total number of households (counts just the household, not the number of people in it) and individuals (counts all people in the household) during the reporting period. This is a unique count, so each household or individual is only counted once, regardless of the number of times they received services during the reporting period.

How to copy, download and print the sections of the report

To print a section of the report separately, click on the Tools button on the right-hand side within the light blue heading:

• Copy: copies the report contents to your computer's clipboard.
• CSV: downloads the report contents into a CSV file, generally viewed with Microsoft Excel.
• PDF: downloads the report contents into a PDF.
• Print: presents a printer-friendly version of the report contents.

To print the entire report:

• Click the blue Print View button at the top right-hand side of the report page.
• A secondary tab will open, click the Print Popup button on the left-hand side.
• A print options box will appear; complete the fields and click the Print button.

Clicking on the Enable Scrolling button will allow you to scroll to the right if there are more items in the table that are not currently in view. 

School Pantry report walk-through

How Do I Use an FFC Report?

The FFC report provides an aggregate overview of FFC Visit statistics.

Please see Report Setup Foundations (click here) for information on basic setup steps for all reports. 

The completed report will show the name you assigned to the report at the top of the page and will also show:

• Reporting for: a list of all the agencies reported on during the reporting period.
• For these program types: lists the programs reported on during the reporting period.
• With dates between: the dates used for the reporting period.

The light blue header represents the title of the report section.

The dark blue header describes what is being reported on in the report section.

The table displays information pulled into the report section.

Report section definitions

• Served: Household Members by FFC Partners (Duplicated): all the FFC partners listed for household members that received services during the reporting period. This is a duplicated count, so all partners are counted for each time services were received during the reporting period.
• Served: Household Members by FFC Partners (Unique): all the FFC partners listed for household members that received services during the reporting period. This is a unique count, so all the partners for each household member are counted only once, regardless of the number of times the household member received services during the reporting period. The data reflects the most recently updated programs for the Household Member.
• Served: Household Members by FFC Programs (Duplicated): all the FFC programs listed for household members that received services during the reporting period. This is a duplicated count, so all programs are counted for each time services were received during the reporting period.
• Served: Household Members by FFC Programs (Unique): all the FFC programs listed for household members that received services during the reporting period. This is a unique count, so all the programs for each household member are only counted once, regardless of the number of times the household member received services during the reporting period, and the data reflects the most recently updated programs for the Household Member.
• Served: Household Members by FFC Statuses (Duplicated): all the FFC statuses listed for household members that received services during the reporting period. This is a duplicated count, so all statuses are counted for each time services were received during the reporting period.
• Served: Household Members by FFC Statuses (Unique): all the FFC statuses listed for household members that received services during the reporting period. This is a unique count, so all the statuses for each household member are only counted once, regardless of the number of times the household member received services during the reporting period, and the data reflects the most recently updated programs for the Household Member.
• Served: Household Members by FFC Types (Duplicated): all the FFC types listed for household members that received services during the reporting period. This is a duplicated count, so all types are counted for each time services were received during the reporting period.
• Served: Household Members by FFC Types (Unique): all the FFC types listed for household members that received services during the reporting period. This is a unique count, so all the types for each household member are only counted once, regardless of the number of times the household member received services during the reporting period, and the data reflects the most recently updated programs for the Household Member.
• Served: Households/Individuals (Duplicated): total number of households (counts just the household, not the number of people in it) and individuals (counts all people in the household) during the reporting period. This is a duplicated count, so each household or individual is counted for each time they received services during the reporting period.
• Served: Households/Individuals (Unique): total number of households (counts just the household, not the number of people in it) and individuals (counts all people in the household) during the reporting period. This is a unique count, so each household or individual is only counted once, regardless of the number of times they received services during the reporting period.
• Served: Households by FFC Partners (Duplicated): all the FFC partners listed for households that received services during the reporting period. This is a duplicated count, so all partners are counted for each time services were received during the reporting period.
• Served: Households by FFC Partners (Unique): all the FFC partners listed for households that received services during the reporting period. This is a unique count, so all the partners for each household are only counted once, regardless of the number of times the household received services during the reporting period, and the data reflects the most recently updated programs for the Household.
• Served: Households by FFC Programs (Duplicated): all the FFC programs listed for households that received services during the reporting period. This is a duplicated count, so all programs are counted for each time services were received during the reporting period.
• Served: Households by FFC Programs (Unique): all the FFC programs listed for households that received services during the reporting period. This is a unique count, so all the programs for each household are only counted once, regardless of the number of times the household received services during the reporting period, and the data reflects the most recently updated programs for the Household.
• Served: Households by FFC Statuses (Duplicated): all the FFC statuses listed for households that received services during the reporting period. This is a duplicated count, so all statuses are counted for each time services were received during the reporting period.
• Served: Households by FFC Statuses (Unique): all the FFC statuses listed for households that received services during the reporting period. This is a unique count, so all the statuses for each household are only counted once, regardless of the number of times the household received services during the reporting period, and the data reflects the most recently updated statuses for the Household.
• Served: Households by FFC Types (Duplicated): all the FFC types listed for households that received services during the reporting period. This is a duplicated count, so all types are counted for each time services were received during the reporting period.
• Served: Households by FFC Types (Unique): all the FFC types listed for households that received services during the reporting period. This is a unique count, so all the types for each household are only counted once, regardless of the number of times the household received services during the reporting period, and the data reflects the most recently updated types for the Household.
• Utilization - Registered vs. Visited: total number of people registered with FFC information compared with the number of people visiting an FFC program.
• Visits: Provided Food (Duplicated): counts of each type of food provided during the reporting period. This is a duplicated count, so all food items are counted for each time the household received services during the reporting period.

How to copy, download and print the sections of the report

To print a section of the report separately, click on the Tools button on the right-hand side within the light blue heading:

• Copy: copies the report contents to your computer's clipboard.
• CSV: downloads the report contents into a CSV file, generally viewed with Microsoft Excel.
• PDF: downloads the report contents into a PDF.
• Print: presents a printer-friendly version of the report contents.

To print the entire report:

• Click the blue Print View button at the top right-hand side of the report page.
• A secondary tab will open, click the Print Popup button on the left-hand side.
• A print options box will appear; complete the fields and click the Print button.

Clicking on the Enable Scrolling button will allow you to scroll to the right if there are more items in the table that are not currently in view. 

FFC report walk-through

Queue times explained:

When it comes to generating reports, we acknowledge the importance of minimizing wait times for our users. Currently, our metric for determining the wait time is based on the number of organizations included in the report as well as the duration covered. Let's delve into the details of our report queues to provide a clearer picture.

For comprehensive reports that span over 3 months and encompass more than 50 sites, we classify them as "Big Reports." Due to their complexity and scale, these reports are processed in a separate queue, which can sometimes result in significant wait times, typically measured in hours. We recognize that this can be inconvenient, and we are actively working towards optimizing the processing time for such reports in the future.

On the other hand, we have the "Small Report" queue, which handles reports consisting of approximately 50 sites and covering a duration of 3 months or less. Generally, these reports are generated swiftly, taking only a few seconds. However, there are instances where these "small" reports can take longer, ranging from 20 to 30 minutes each. Furthermore, it's worth noting that even a quick report may experience further delays if there are several 20-30 minute reports ahead of it in the queue.

As we are actively working towards optimizing the processing time for reports in the future, your feedback is crucial in this endeavor, so please don't hesitate to share your thoughts and suggestions with our Support team if you are a Network Admin. By doing so, you contribute to the ongoing efforts of our team to improve and streamline this process for a better user experience.