Data Source	Oracle
Job/Process Source (Refresh Interval)	Live
Report Domain	Student financial aid completion status.
Functional User(s)	Rebecca Puga
Report Owner	Rebecca Puga
Data Domain(s)	Financial Aid
Contains PII	Yes

What It’s Used For

Find students that have incomplete or “not satisfied” financial aid application statuses and filter them by campus.

Options

Options	Description

Options	Description
Aid Year	Financial aid year.
Term	Term code selection.
Campus	All or a specific campus. May show several campuses per student if applicable.

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
Last_Name	SPRIDEN_LAST_NAME	Student’s last name
First_Name	SPRIDEN_FIRST_NAME	Student’s first name
Banner_ID	SPRIDEN_ID	Student's Banner ID
TREQ_CODE	RRRAREQ_TREQ_CODE	The code associated with the tracking requirement
TRST_CODE	RRRAREQ_TRST_CODE	The status of the tracking requirement
Aid_Year	RRRAREQ_AIDY_CODE	The related financial aid year
Term_Code	ROVTENR_TERM_CODE	The related term code
ENRR_CODE	ROVTENR_ENRR_CODE	The enrollment rule code associated with the aid year
ADJ_HRS	ROVTENR_ADJ_HRS	The adjusted hours for the enrollment rule code
CAMPUSES	REPORTSNET.f_get_campuses()	Student’s campus based on enrollment. Can return multiple values in the form of a pipe-delimited string.

Version	Date	Comment
Current Version (v. 1)	Apr 22, 2024 18:03	Michael Citi