Versions Compared

Key

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

...

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

...