Are you a recipient of CalWORKs, Temporary Assistance for Needy Families (TANF), or Aid to Families with Dependent Children (AFDC)?

SZRAPLY.SUPP_YESNO_03 to SZRCCAP_CALWORKS

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

SV03 First Position = 1

SV03 Second Position = S

Are you a recipient of Supplemental Security Income (SSI)?

SZRAPLY.SUPP_YESNO_04 to szrccap_SSI

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

SV03 First Position = 2

SV03 Second Position = S

Are you a recipient of General Assistance or General Relief?

SZRAPLY.SUPP_YESNO_05 to szrccap_GEN_ASSIST

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

SV03 First Position = 3

SV03 Second Position = S

Are you otherwise economically disadvantaged?

SZRAPLY.SUPP_YESNO_07 to SZRCCAP_ECON_DISADVANTAGE

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

SV03 First Position = 4

SV03 Second Position = S

CCCApply Standard Application Question

Are you receiving TANF/CalWORKs, SSI, or General Assistance?

tanf_ssi_ga

Yes [radio button]

No [radio button]

No selection

Imports into the szrccap table: szrccap_tanf_ssi_genasst, but we are not importing into Banner.

SV03, but it doesn’t match DED.

Are you a recipient of Cal Fresh, food stamps, or the Supplemental Nutrition Assistance Program (SNAP)?

SZRAPLY.SUPP_YESNO_06 to SZRCCAP_FOOD_STAMPS

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

Are you a single parent?

SZRAPLY.SUPP_YESNO_08 to szrccap_SINGLE_PARENT

Radio buttons:

• Yes

• No (defaulted)

sgbuser_sudd_code , if szrccap_SINGLE_PARENT = 1, then "P"

else “N”

SV04 = P

Are you a displaced homemaker?

SZRAPLY.SUPP_YESNO_09 to szrccap_DISPLACED_HOM

Radio buttons:

• Yes

• No (defaulted)

sgbuser_sude_code, if szrccap_SINGLE_PARENT = 1, then "D"

else “N”

SV05 = D

Have you, your parent, or guardian been employed as a migrant farmworker at any time in the past 36 months?

SZRAPLY.SUPP_YESNO_13 to SZRCCAP_FARMWORKER

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

SV09 = M

Do you possess attitudes, beliefs, customs, or practices that serve as a hindrance to employment?

SZRAPLY.SUPP_YESNO_10 to SZRCCAP_HINDERANCE_EMPLOY

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

If you are unemployed, have you been looking for work for 27 weeks or more?

SZRAPLY.SUPP_YESNO_11 to SZRCCAP_LONG_TERM_UNEMP

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

Are you an ex-offender?

SZRAPLY.SUPP_YESNO_12 to SZRCCAP_EXOFFENDER

Radio buttons:

• Yes

• No

Does not feed into Banner.

Are you or your parent/guardian employed on U.S. National Forest property within Tulare County: or, working in U.S. National Forest Service Facilities outside the National Forest but still within Tulare County boundaries?

SZRAPLY.SUPP_YESNO_01 to szrccap_FOREST_SER

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

Do you reside on U.S. National Forest land; or property leased from the U.S. Forest Service; or privately owned land (enclosed within the boundaries of the U.S. National Forest within Tulare County); or privately owned land within one mile of the boundaries of the U.S. National Forest?

SZRAPLY.SUPP_YESNO_02 to szrccap_LIVE_FOREST

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

First Name

SZRAPLY.SUPP_TEXT_01 to szrccap_EMER_FIRST_NAME and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab): SPREMRG_FIRST_NAMESPREMRG_FIRST_NAME

Last Name

SZRAPLY.SUPP_TEXT_02to szrccap_EMER_FIRST_NAME and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Area Code

SZRAPLY.SUPP_TEXT_03 to szrccap_EMER_PHONE_AREA and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Phone

SZRAPLY.SUPP_TEXT_04 to szrccap_EMER_PHONE_NUMBER and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Extension

SZRAPLY.SUPP_TEXT_05 to szrccap_EMER_PHONE_EXT and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Address Line 1

SZRAPLY.SUPP_TEXT_06 to szrccap_EMER_STREET_LINE1 and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Address Line 2

SZRAPLY.SUPP_TEXT_07 to szrccap_EMER_STREET_LINE2 and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

City

SZRAPLY.SUPP_TEXT_08 to szrccap_EMER_CITY and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Zip

SZRAPLY.SUPP_TEXT_09 to szrccap_EMER_ZIP and then to SPAEMRG

Text box

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Their relationship to you:

SZRAPLY.SUPP_MENU_01 to szrccap_EMER_RELT_CODE and then to SPAEMRG

Dropdown:

• Mother

• Father

• Spuse

• Brother

• Sister

• Ex-spouse

• Grandparent

• Relative

• Guardian

• Domestic Partner

• Significant Other

• Child

• Doctor

• Employer

• Neighbor

• Friend

Inserted into Banner through the procedure (cos_updateemrgcontacts: rship input parameter), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

State

SZRAPLY.SUPP_STATE_01 to szrccap_EMER_STAT_CODE and then to SPAEMRG

Dropdown

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

Countries

SZRAPLY.SUPP_COUNTRY_01 to szrccap_EMER_NATN_CODE and then to SPAEMRG

Dropdown

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the Ellucian API (gb_emergency_contact.p_create). Data can be found on the following form (SPAIDEN > Emergency Contact Tab):

If you are taking a math class currently, which class is it?

SZRAPLY.SUPP_MENU_07 to szrccap_current_math

Dropdown

• Pre-algebra or lower

• Algebra 1

• Integrated Math 1

• Integrated Math 2

• Geometry

• Algebra 2

• Integrated Math 3

• Statistics

• Integrated Math 4

• Trigonometry

• Pre-Calculas

• Calculus or higher

• None of the Above

• I am not currently taking a math class

cos_admissions.cos_mm > v_MATH_CURRENT input variable. Inserted into p_sabsupl_update_insert, which inserts into the “SABSUPL_INST_DATA7.” It is passed into cos_multiple_measures.apply_mm_from_app > v_current_math input parameter, but it is not used for self-reported math assessment.

My Campus:

Select the campus that you will attend most/all of your classes:

SZRDURT.SZRDURT_COSCAMP_CODE

Dropdown:

Visalia Campus

Hanford Campus

Tulare Campus

No known Banner Integration

Are you interested in resources for undocumented students?

pw_advising_check.p_validationstamp

input variable: qt1

Yes/No Radio Boxes

input:

Yes = Y

No = N

Null=N

table: SZRDURT_UNDOCUMENTED_RESOURCES

Asked the question for “reporting purposes” Ticket 25621, Ticket 23053, Ticket 23668.

No known use in Argos, EIS, no known database dependencies on SZRDURT_UNDOCUMENTED_RESOURCES.

Are you interested in receiving information about housing and/or homeless resources?

pw_advising_check.p_validationstamp

input variable: qt2

input:

Yes = Y

No = N

Null=N

table: SZRDURT_HOMELESS

Yes/No Radio Boxes

The intent was to allow Basic Needs to do outreach and case management. Ryan W do you know if this ever turned into an automated email or report?
I’ve looked in EIS/Argos and came up empty. The last communication I (Jordan Lamb) had on this was 04 May 2022.

Choose which apply from the list below:

pw_advising_check.p_validationstamp

input variables: opt1, opt2, opt3, opt4, opt5

Checkboxes:

• CalWORKs/TANF/AFDC recipient

• SSI recipient

• General Assistance recipient

• Other economically disadvantaged status

• None of the above

input:

CalWORKs/TANF/AFDC recipient > opt1 > 1S
SSI recipient > opt2 > 2S >
General Assistance recipient > opt3 > 3S
Other economically disadvantaged status > opt4 > 4S
None of the above > opt5 > NN

If all boxes are checked = NN

If multiple boxes are checked and box 5 is not checked, (opt1 || opt2 || opt3 || opt4)

table: sgbuser_sudc_code

• CalWORKs/TANF/AFDC recipient

  • SV03 First Position = 1

    SV03 Second Position = S

• SSI recipient

  • SV03 First Position = 2

    SV03 Second Position = S

• General Assistance recipient

  • SV03 First Position = 3

    SV03 Second Position = S

• Other economically disadvantaged status

  • SV03 First Position = 4

    SV03 Second Position = S

Are you a single Parent?

pw_advising_check.p_validationstamp

input variable: vt1

Yes/No Radio Boxes

input:

Yes = P

No = N

Null = Not allowed

table: sgbuser_sudd_code

SV04 = P

Are you a displaced homemaker?

pw_advising_check.p_validationstamp

input variable: vt2

Yes/No Radio Boxes

input:

Yes = D

No = N

Null = Not allowed

table: sgbuser_sude_code

SV05 = D

Have you, your parent, or guardian been employed as a migrant farmworker at any time in the past 36 months?

pw_advising_check

Yes/No Radio Boxes

SGBUSER_MIGR_WORK_IND

SV09 = M