Dream Act AB540 Affidavit

Data Source

Banner (Oracle)

Job/Process Source (Refresh Interval)

Live

Report Domain

Dream Act Students/Financial Aid.

Functional User(s)

Rosa Romo Sanchez, Elvia Rengel-Lemus, Rebecca Puga

Constituent(s)

David Loverin, Arianna Kennedy

Report Owner

Rebecca Puga

Data Domain(s)

Financial Aid

Contains PII

Yes

What It’s Used For

Cal ISIR and AB540 Affidavit information provided with a Dream Act student’s information.

Options

Options

Description

Options

Description

Aid Year

Distinct aid year from RCRAPP1 table. Only returns the most recent 10 aid year values.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

BANNER_ID

SPRIDEN_ID

Student’s Banner ID

FIRST_NAME

SPRIDEN_FIRST_NAME

Student’s first name

LAST_NAME

SPRIDEN_LAST_NAME

Student’s last name

U_VISA_FLAG

ROBUSDF_VALUE_11

Visa Flag

INTERESTED_IN_DSIG

ROBUSDF_VALUE_12

Student showed interest in DSIG

HS_GRAD_EQUIV

ROBUSDF_VALUE_13

High School Graduate or Equivalent

ASSOC_DEGREE

ROBUSDF_VALUE_14

Has an Associates Degree

TRANSFER_REQS_CSU_UC

ROBUSDF_VALUE_15

Meets Transfer Requirements for CSU or UC

THREE_YRS_CA_HS

ROBUSDF_VALUE_16

3+ years of CA high school(s)

THREE_YRS_HS_COURSEWORK_ATTEND

ROBUSDF_VALUE_17

3+ years of high school coursework completed

THREE_YRS_COMBO_HS_ADULT_CCC

ROBUSDF_VALUE_18

3+ years combination for HS, adult school and CCC

AB540_SIGNATURE

ROBUSDF_VALUE_19

AB540 signature

SSID

ROBUSDF_VALUE_20

Statewide Student Identifier (SSID)

CAL_ISIR

ROBUSDF_VALUE_21

California ISIR Indicator

SSN_VALUE

RCRAPP1_SSN

Not a “true” SSN. This is the student’s Dream Act ID for any students in the RCRAPP# tables with an INFC value of CAL

 


Version Date Comment
Current Version (v. 1) Oct 04, 2024 21:58 Michael Citi