Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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, and ; if they do not complete it within the seven days, the application expires, and they will need to apply again


Tip
titleData Updates

Data are continuously updated to provide real-time information.

...

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 fundingaid, 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. 

...

  • 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 sliders slicers to narrow down the time frame for submitted and reviewed applications. 

...

You can set ranges for dates for the Submitted Date element and the Reviewed Date elementfilters. Use the sliders 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. 

...

Element

Source

(System->Table->Column)

Description

Frequency of Update

Anchor
Amount Approved
Amount Approved
Amount Approved

appiandb->ssm_v_caresactsubmissions->amountapprovedIndicates the amount approved in aid for the student.Live

Anchor
Amount Requested
Amount Requested
Amount Requested

appiandb->ssm_v_caresactsubmissions->amountrequestedIndicates the amount the student requested in aid.Live

Anchor
Application Outcome
Application Outcome
Application Outcome

OR

Approval Status

appiandb->ssm_v_caresactsubmissions->status

Indicates the approval status or application outcome of the student's application for aid. Options are:

  • Approved
  • Denied
  • Incomplete
  • Submitted
  • Under Review
Live

Anchor
Approval Term
Approval Term
Approval Term

appiandb->ssm_v_caresactsubmissions->approvaltermThe academic term during which the student's aid was approved.Live

Anchor
Date of Birth
Date of Birth
Date of Birth

banner->spbpers->spbpers_birth_dateStudent's date of birthLive

Anchor
Expense Options
Expense Options
Expense Options

appiandb->ssm_v_caresactsubmissions->sectionthreeselectionsIndicates the expenses that will be covered by the aid the student receives. Students select from a list (including "Other") during the application process, and supply receipts if required.Live

Anchor
Impact Reasons
Impact Reasons
Impact Reasons

appiandb->ssm_v_caresactsubmissions->sectiononeselections

The reasons indicated by the student that the aid was requested as a result of COVID-19. Students include documentation with the request, as it pertains to the following selections:

  • Parent loss of income
  • Student/spouse loss of income
  • Unexpected circumstances
Live

Anchor
Reviewed Date
Reviewed Date
Reviewed Date

appiandb->ssm_v_caresactsubmissions->createdonDate the application for aid was reviewed.Live

Anchor
Reviewer Name
Reviewer Name
Reviewer Name

appiandb->ssm_v_caresactsubmissions->assignee

banner->spriden->spriden_last_name+spriden_first_name
USF staff member who reviewed the application.Live

Anchor
SSN
SSN
SSN

banner->spbpers->spbpers_ssnSocial Security Number of the student.Live

Anchor
Student Campus
Student Campus
Student Campus

appiandb->ssm_v_caresactsubmissions->studentcampusIdentifies the campus of the student applying for the relief.Live
Anchor
Student Level
Student Level

Student Level

appiandb->ssm_v_caresactsubmissions->studentlevelLevel of the student applying for aid: Undergraduate/Graduate/ProfessionalLive

Anchor
Student Name
Student Name
Student Name

banner->spriden->spriden_last_name+spriden_first_nameFirst and last name of the student.Live

Anchor
Student UID
Student UID
Student UID

appiandb->ssm_v_caresactsubmissions->studentuidThe unique University Identification number of the student.Live

Anchor
Submitted Date
Submitted Date
Submitted Date

appiandb->ssm_v_caresactsubmissions->submittedonIndicates the date the application for aid was submitted.Live

Anchor
Total Approved
Total Approved
Total Total Amount Approved

sum(appiandb->ssm_v_caresactsubmissions->amountapproved)Indicates the total amount of aid that was approved as of the refresh date/time.Live

Anchor
Total Requested
Total Requested
Total Amount Requested

sum(appiandb->ssm_v_caresactsubmissions->amountrequested)Indicates the total amount of aid that has been requested as of the refresh date/time.Live

Anchor
Date Refreshed
Date Refreshed
Date Refreshed

Current DatetimeIndicates the date/time the data pulled for the report was refreshed.Live

...