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 receiving TANF/CalWORKs, SSI, or General Assistance?

tanf_ssi_ga

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 receiving TANF/CalWORKs, SSI, or General Assistance?

tanf_ssi_ga

Yes [radio button]

No [radio button]

No selection

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)

Are you otherwise economically disadvantaged?

Radio buttons:

• Yes

• No (defaulted)

SV03 First Position = 4

SV03 Second Position = S

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 = PD

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.

SZRAPLY.SUPP_YESNO_01 to szrccap_FOREST_SER

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

SZRAPLY.SUPP_YESNO_02 to szrccap_LIVE_FOREST

Radio buttons:

• Yes

• No (defaulted)

Does not feed into Banner.

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

From what I could find, it is used primarily by the counseling office for the old student ed plan and the new program change form to determine the student’s primary campus, which is updated by the student each term. It uses

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?
Argos report Registration Questionnaire produces this data.

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

SV05 = P

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