CARES Act Report

The Coronavirus Aid, Relief, and Economic Security (CARES) Act contains a provision for Higher Education Emergency Relief and Student Aid. USF receives funds to be used for emergency student aid. Students who have expenses related to the disruption of campus operations due to COVID-19 are eligible to apply for this program. 

Eligible expenses for CARES Act funding include, but are not necessarily limited to, medical, food, housing, utilities, technology expenses, relocation costs to return home, unexpected childcare, course materials, and other unexpected expenses.

Students apply for assistance through the Archivum student portal, and the USF Financial Aid Office reviews applications to determine the amount distributed to each student. Students have seven days to complete the application after initiating; if they do not complete it within the seven days, the application expires, and they will need to apply again. 

Report Elements Glossary Table

Overview

The CARES Act report contains data pertaining to CARES Act applications and funding. Specifically, the report provides a table of all students who have initiated an application for CARES Act aid, including the amount requested, details of the virus impacts, and the expenses to which the funds will be applied, such as rent, relocation costs, or food. 

When a student initiates an application, Archivum records the entry with a status of Incomplete. Once the student submits all requested documentation, the Approval Status changes. A student has seven days to complete the application after initiating, after which time the Approval Status remains in the database as Incomplete and the student must submit another application. 

Filter Panels

Filters are listed on both the top and left panels of the report.

Notes:

• Click the down arrow to select from options in the filters and narrow down your results. 
• To deselect an item, click on the option again. 
• To select multiples in a filter, hold the Ctrl key as you check the boxes. 
• Blank options exist for some filters, which indicates the student did not complete this item in the application. 
• Use the date slicers to narrow down the time frame for submitted and reviewed applications. 

Data Panel

The panel on the right is the main work area showing the filtered results. To work with data in this panel:

• Select a column header to sort by that value, such as Student Name or Reviewed Date.
• Select an individual row in the table to highlight the item. Select it again to return to the full table view.

Tasks

Export Data to Excel

To export filtered results to Excel:

1. Hover over the table, then click the ellipses in the top right corner of the table display. 
   The report displays a menu:
   
2. Select Export Data, then work with the data in Excel.

Set Date Ranges

You can set ranges for dates for the Submitted Date and the Reviewed Date filters. Use the slicers in the side Filter panel to adjust or type dates in to the date fields. When you filter for date ranges, the table adjusts immediately. In addition, the selections available in the remaining filters are narrowed down to correspond with the selected dates. For example, reviewers who did not review applications during the specific time frame you filtered will not display in the Reviewer Name drop-down field. 

Reset to Default

If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image in the Report Header: 

Filters

Impact Reasons

Expense Options

Reviewer Name

Student Level

Approval Status

Student Campus

Submitted Date

Reviewed Date

Report Elements

Total Amount Approved

Total Amount Requested

Student UID

Student Name

SSN

Date of Birth

Student Level

Impact Reasons

Expense Options

Submitted Date

Amount Requested ($)

Reviewed Date

Amount Approved ($)

Application Outcome

Approval Term

Student Campus

Reviewer Name

Date Refreshed

Report Elements Glossary Table

The table below lists all of the elements used in the CARES Act report.

Note: To sort the table elements, click the up or down arrow in the column header.