/
Students With No FA Application

Students With No FA Application

Data Source

Oracle

Job/Process Source (Refresh Interval)

Live Data

Report Domain

Registration Records

Functional User(s)

Rebecca Puga, Isaiah Castro, David Loverin

Constituent(s)

Ā 

Report Owner

Rebecca Puga

Data Domain(s)

Financial Aid

Contains PII

Yes

What Itā€™s Used For

Contact info list of students who have not applied for financial aid (FAFSA/DREAM ACT) that also meet the following criteria: Not a high school student or a Non-Credit application.

Options

Options

Description

Options

Description

Term

Limit the results to a specific term.

Aid Year

Limit the results to a specific financial aid year.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

Banner ID

SPRIDEN_ID

Studentā€™s Banner ID

Student Name

SPRIDEN_LAT_NAME, SPRIDEN_FIRST_NAME, SPRIDEN_MI

Full name of the student.

Phone

COS_GENERAL.F_GET_PHONE()

Returns a phone number if one has been given, or ā€œMissing Phoneā€ if one cannot be found for the specific student.

Email

COS_F_GET_EMAIL_STU()
OR

COS_F_GET_CAMP_EMAIL()

Find the student email (@giant.cos.edu) or if it doesnā€™t exist, the older campus email (@cos.edu)

Ā 

Version Date Comment
Current Version (v. 1) Feb 03, 2025 17:31 Michael Citi