Anchor |
---|
| Amount Approved |
---|
| Amount Approved |
---|
|
Amount Approved | appiandb->ssm_v_caresactsubmissions->amountapproved | Indicates the amount approved in aid for the student. | Live |
Anchor |
---|
| Amount Requested |
---|
| Amount Requested |
---|
|
Amount Requested | appiandb->ssm_v_caresactsubmissions->amountrequested | Indicates 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->approvalterm | The 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_date | Student's date of birth | Live |
Anchor |
---|
| Expense Options |
---|
| Expense Options |
---|
|
Expense Options | appiandb->ssm_v_caresactsubmissions->sectionthreeselections | Indicates 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->createdon | Date 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 |
| banner->spbpers->spbpers_ssn | Social Security Number of the student. | Live |
Anchor |
---|
| Student Campus |
---|
| Student Campus |
---|
|
Student Campus | appiandb->ssm_v_caresactsubmissions->studentcampus | Identifies the campus of the student applying for the relief. | Live |
Anchor |
---|
| Student Level |
---|
| Student Level |
---|
|
Student Level | appiandb->ssm_v_caresactsubmissions->studentlevel | Level of the student applying for aid: Undergraduate/Graduate/Professional | Live |
| banner->spriden->spriden_last_name+spriden_first_name | First and last name of the student. | Live |
| appiandb->ssm_v_caresactsubmissions->studentuid | The unique University Identification number of the student. | Live |
Anchor |
---|
| Submitted Date |
---|
| Submitted Date |
---|
|
Submitted Date | appiandb->ssm_v_caresactsubmissions->submittedon | Indicates 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 Datetime | Indicates the date/time the data pulled for the report was refreshed. | Live |