/
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

Related content

Incomplete Status by Campus
Incomplete Status by Campus
More like this
Dream Act AB540 Affidavit
Dream Act AB540 Affidavit
More like this
High School Students By Term
High School Students By Term
More like this
AB 540 Relief Eligibility Search
AB 540 Relief Eligibility Search
More like this
StudentPuente table
StudentPuente table
More like this
EOPS Application Screening
EOPS Application Screening
More like this