EOPS Application Screening

Data Source

Oracle

Job/Process Source (Refresh Interval)

Live Data

Functional User(s)

 

Report Owner

Adrian Beltran

Data Domain(s)

Financial Aid

Contains PII

Yes

What It’s Used For

Assist with the EOPS application screening process.

Options

Options

Description

Options

Description

Aid Year

Choose the aid year.

Banner ID

Specify a student’s Banner ID to narrow down results.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

Banner ID

SPRIDEN.SPRIDEN_ID

A student’s Banner ID

Last Name

SPRIDEN.SPRIDEN_LAST_NAME

A student’s last name

First Name

SPRIDEN.SPRIDEN_FIRST_NAME

A student’s first name

Residence Code

STVRESD.STVRESD_DESC

Residence status description

Current Term Units

Sum of units registered in the current term. Data Source: SFRSTCR.SFRSTCR_CREDIT_HR

Current term units

Next Term Reg Units

Sum of units registered in the next major term. Data Source: SFRSTCR.SFRSTCR_CREDIT_HR

Units registered for next term

Total Deg Appl Units

Calculated based on SHRTCKG_CREDIT_HOURS and various other validation fields to determine if the earned units apply to their COS degree.

Total degree applicable units completed

INFC Code

RVRISIR.RVRISIR_INFC_CODE

A code from the Interface Tape Table indicating the source and format of the application record.

Dependency

RVRISIR.RVRISIR_DEPENDENCY_STAT

Dependency Status. D = Dependent, I = Independent

Num In House

RVRISIR.RVRISIR_DEP_NO_HOUSE

Or

RVRISIR.RVRISIR_IND_NO_HOUSE

Determined by “Dependency” code.

Number in household

AGI

RVRISIR.RVRISIR_DEP_AGI

Or

RVRISIR.RVRISIR_IND_AGI

Determined by “Dependency” code.

Parent’s (or student & spouse) Adjusted Gross Income. IRS Tax form 1040.

Oth Income

RVRISIR.RVRISIR_DEP_OTHER_INC

Or

RVRISIR.RVRISIR_IND_OTHER_INC

Determined by “Dependency” code.

All other income not included in the AGI

Total Income

RVRISIR.RVRISIR_DEP_TOTAL_INC

Or

RVRISIR.RVRISIR_IND_TOTAL_INC

Determined by “Dependency” code.

Total of all income, including AGI and Other income.

Total Contribution

RVRISIR.RVRISIR_TOT_CTRB

Total family contribution of applicant.

Need

RVRISIR.RVRISIR_PELL_NEED

Calculated need applicant for 9 months.

C ISIR Eligible

Calculated field. Baseline banner functionality to determine C Eligibility

This is calculated by the system and is Yes if the value in the relevant Need field for the dependency status is greater than or equal to the value in the Minimum Unmet Need field on RVACCPG.

B ISIR Eligible

Calculated field. Baseline banner functionality to determine B Eligibility

This is calculated by the system and is Yes if the value in the relevant Total Income field for the dependency status is less than or equal to the value in the Eligible Income field (calculated from the RVAINCR rules) for the student's dependency status.

Report Domain


Version Date Comment
Current Version (v. 3) Nov 29, 2023 19:25 Jordan Lamb
v. 2 May 05, 2023 22:50 Michael Citi
v. 1 May 05, 2023 22:50 Michael Citi

Related content