Versions Compared

Version Old Version 22 New Version Current
Changes made by

Ryan W

Jordan Lamb

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
maxLevel6
minLevel1
include
outlinefalse
indent
exclude
typelist
printablefalse
class

CCCApply

Supplemental Questions

Expand
titleGet Questions from CCCApply Administrator

You can view or download the supplemental questions from the following page:

Jira Legacy
serverSystem JIRAJira
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-658

Question

Field Name

Field Type

Banner Integration

First Name

Required field

SZRAPLY.SUPP_TEXT_01 to szrccap_EMER_FIRST_NAME

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

Inserted into Banner through the procedure (cos_updateemrgcontacts), which calls the receiving TANF/CalWORKs, SSI, or General Assistance?Are you a recipient Are you a recipient of Cal Fresh, food stamps, or the Supplemental Nutrition Assistance Program (SNAP)06 FOOD_STAMPSSZRAPLY.SUPP_YESNO_07 to SZRCCAP_ECON_

sgbuser_sudd_code , if szrccap_SINGLE_PARENT = 1, then "P"

else “N”

Are you a displaced homemaker

sgbuser_sude_code, if szrccap_SINGLE_PARENT = 1, then "D"

else “N”

Do you possess attitudes, beliefs, customs, or practices that serve as a hindrance to employmentSZRAPLY.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 boundariesDo 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

Supplemental Questions

Panel
panelIconIdatlassian-question_mark
panelIcon:question_mark:
panelIconText:question_mark:
bgColor#B3D4FF

Consider including help text that can be shown while filling out the application. I didn’t see any for these supplemental questions.

Field Name

Field Type

Banner Integration

Purpose of Question

Standard Application Question

Field Name

Field Type

Banner Integration

Purpose of Question

Application’s Recommendation

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

Note

AFDC hasn’t been a program since 1997 when it was replaced by TANF. Should this even be a question anymore?

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

Note

Remove from Supplemental Questions since we are asking each term on PreReg Survey (below).

Are you

tanf_ssi_ga

Yes [radio button]

No [radio button]

No selection

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

szraplya 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

Note

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

tanf_ssi_ga

Yes [radio button]

No [radio button]

No selection

Remove from Supplemental Questions since we are asking each term on PreReg Survey (below).

Are you a recipient of General Assistance or General Relief?

Note

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

tanf_ssi_ga

Yes [radio button]

No [radio button]

No selection

Note

Remove from Supplemental Questions since we are asking each term on PreReg Survey (below).

Are you otherwise economically disadvantaged?

SZRAPLY.SUPP_YESNO_

07 to SZRCCAP_

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

Note

Unknown

Are you otherwise economically disadvantaged?

ECON_DISADVANTAGE

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

SV03 First Position = 4

SV03 Second Position = S

Are you a single parent?

SZRAPLY.SUPP_YESNO_08 to szrccap_SINGLE_PARENT

Radio buttons:

  • Yes

  • No (defaulted)

SV04 = P

Note

Remove from Supplemental Questions since we are asking each term on PreReg Survey (below).

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.

Note

Continue not ingesting. Doesn’t match DED.

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

SZRAPLY.SUPP_YESNO_09 06 to szrccapSZRCCAP_DISPLACEDFOOD_HOMSTAMPS

Radio buttons:

  • Yes

  • No (defaulted)

SV05 = D

Have you, your parent, or guardian been employed as a migrant farmworker at any time in the past 36 monthsDoes not feed into Banner.

Info

Pending Technology Services improvement.

https://sequoias.atlassian.net/browse/AP-679

Are you a single parent?

SZRAPLY.SUPP_YESNO_13 08 to SZRCCAPszrccap_FARMWORKERSINGLE_PARENT

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

SV09 = M

sgbuser_sudd_code , if szrccap_SINGLE_PARENT = 1, then "P"

else “N”

SV04 = P

Tip

No change.

Are you a displaced homemaker?

SZRAPLY.SUPP_YESNO_10 09 to SZRCCAPszrccap_HINDERANCEDISPLACED_EMPLOYHOM

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

Note

What is this? Why do we ask this?

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

sgbuser_sude_code, if szrccap_SINGLE_PARENT = 1, then "D"

else “N”

SV05 = D

Tip

No change.

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

SZRAPLY.SUPP_YESNO_11 13 to SZRCCAP_LONG_TERM_UNEMPFARMWORKER

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

Are you an ex-offender?

SV09 = M

Info

Pending Technology Services improvement.

https://sequoias.atlassian.net/browse/AP-680

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

SZRAPLY.SUPP_YESNO_12 10 to SZRCCAP_EXOFFENDERHINDERANCE_EMPLOY

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

Note

SV07 hasn’t been collected since

Info

SG15 is still be reported. SVBWIOA_EXOF_CODE

Info

Pending Technology Services improvement.

https://sequoias.atlassian.net/browse/AP-681

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

SZRAPLY.SUPP_YESNO_01 11 to szrccapSZRCCAP_LONG_FORESTTERM_SERUNEMP

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

Note

Why do we ask this question?

The Bureau of Labor Statistics defines long-term unemployment as being out of work for 27 weeks and actively searching for a job. - Concepts and Definitions (CPS) : U.S. Bureau of Labor Statistics (bls.gov)

Info

Pending Technology Services improvement.

https://sequoias.atlassian.net/browse/AP-682

Are you an ex-offender?

SZRAPLY.SUPP_YESNO_02 12 to szrccapSZRCCAP_LIVE_FORESTEXOFFENDER

Radio buttons:

  • Yes

  • No (defaulted)

Does not feed into Banner.

Note

Why do we ask this question?

Emergency Contact (required)

Note

What is this used for? Is it still necessary to collect this information? Who would use this?

SV07 hasn’t been collected since

Info

SG15 is still be reported. SVBWIOA_EXOF_CODE

Info

Pending Technology Services improvement.

https://sequoias.atlassian.net/browse/AP-683

Anchor
Forest-Worker
Forest-Worker
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.

https://sequoias.atlassian.net/browse/AP-721
Note

Remove. We aren’t using this data.

Anchor
Forest-Residence
Forest-Residence
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.

https://sequoias.atlassian.net/browse/AP-721
Note

Remove. We aren’t using this data.

Emergency Contact (required)

Question

Field Name

Field Type

Banner Integration

Recommendation

First Name

Required field.

SZRAPLY.SUPP_TEXT_01 to szrccap_EMER_FIRST_NAME and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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

Tip

No change.

Last Name

Required field.

SZRAPLY.SUPP_TEXT_02to szrccap_EMER_FIRST_NAME and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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):

Tip

No change.

Area Code

Required field.

SZRAPLY.SUPP_TEXT_03 to szrccap_EMER_PHONE_AREA and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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):

Tip

No change.

Phone

Required field.

SZRAPLY.SUPP_TEXT_04 to szrccap_EMER_PHONE_NUMBER and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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): :

Tip

No change.

Extension

Required field.

SZRAPLY.SUPP_TEXT_05 to szrccap_EMER_PHONE_EXT and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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):

Tip

No change.

Address Line 1

Required field.

SZRAPLY.SUPP_TEXT_06 to szrccap_EMER_STREET_LINE1 and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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):

Tip

No change.

Address Line 2

Required field.

SZRAPLY.SUPP_TEXT_07 to szrccap_EMER_STREET_LINE2 and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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):

Tip

No change.

City

Required field.

SZRAPLY.SUPP_TEXT_08 to szrccap_EMER_CITY and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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):

Tip

No change.

Zip

Required field.

SZRAPLY.SUPP_TEXT_09 to szrccap_EMER_ZIP and then to SPAEMRG

Text box

Note

Unvalidated; user can enter blatantly false data.

Info

Required field

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):

Tip

No change.

Their relationship to you:

Required field.

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):

Tip

No change.

State

Required field.

SZRAPLY.SUPP_STATE_01 to szrccap_EMER_STAT_CODE and then to SPAEMRG

Dropdown

States (and Territories, Armed Forces)

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):

Tip

No change.

Countries

Required field.

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):

Tip

No change.

Current Math Class

The following question will help us place you in the most appropriate Math class.

Question

Field Name

Field Type

Banner Integration

Recommendation

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

Required field.

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..

Note

Remove from CCCApply.
Isn’t in use given work undertaken on AB1705.

Pre-Registration Survey

The Pre-Registration Survey is asked every term. Student’s must complete this prior to being allowed to register for sections in that term.

...

Expand
titleCode locations of pre-reg processing

Modded baseline package BANINST1.bwskfreg >  pw_advising_check.p_start_here > pw_advising_check.p_validation_stamp validationstamp > Banner data/SZRDURT data > Banner Web Registration (bwskfreg.P_AltPin)

Question

Field Name

Field Type

Banner Integration

Purpose of Question

Recommendation

My Campus:

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

Required field.

SZRDURT.SZRDURT_COSCAMP_CODE

Dropdown:

Visalia Campus

Hanford Campus

Tulare Campus

Jira Legacy
serverSystem JIRA
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key

No known Banner Integration

https://sequoias.atlassian.net/browse/AP-652

Info

Was used on old Student Education Plan.

It used the following procedure: cos_general.get_Stu_Main_Campus_From_Pidm.

Info

Not used on the current Degree Works SEP

Info

No known dependencies in the database, Datawarehouse, or reporting.

Checked CAB, version control, GitHub, EIS.

Note

Remove from PreRegistration Survey

Are you interested in resources for undocumented students?

Required field.

pw_advising_check.p_validation_stampvalidationstamp

input variable: qt1

Yes/No Radio Boxes

input:

Yes = Y

No = N

Null=N

table: :

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.

Yes/No Radio Boxes

https://sequoias.atlassian.net/browse/AP-653
Note

Use it or get rid of it.

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

Required field.

pw_advising_check.p_validation_stampvalidationstamp

input variable: qt2

input:

Yes = Y

No = N

Null=N

table: SZRDURT_HOMELESS

Yes/No Radio Boxes

https://sequoias.atlassian.net/browse/AP-654.atlassian.net/browse/AP-654

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.

Tip

No change.

Choose which apply from the list below:

Required field.

pw_advising_check.p_validation_stampvalidationstamp

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

inputCheckboxes:

Yes = Y

No = N

Null=N

table: SZRDURT_HOMELESSopt1

opt2

opt3

opt4

opt5

Checkboxes:

  • CalWORKs/TANF/AFDC recipient

  • SSI recipient

  • General Assistance recipient

  • Other economically disadvantaged status

  • None of the above

input:

Code Block
CalWORKs/TANF/AFDC
recipient

  • SSI recipient

  • General Assistance recipient

  • Other economically disadvantaged status

  • None of the above

    • Note
    None of the above can be selected in addition to any/all of the above. Don’t know how the ingest is handling this.
     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

    https://sequoias.atlassian.net/browse/AP-655

    • 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

    Tip

    No change.

    Are you a single Parent?

    Required field.

    pw_advising_check.p_validation_stampvalidationstamp

    input variable: vt1

    Yes/No Radio Boxes

    input:

    Yes = P

    No = N

    Null = Not allowed

    table: sgbuser_sudd_code

    Yes/No Radio Boxes

    		https://sequoias.atlassian.net/browse/AP-656

    SV04 = PSV04 = P

    Tip

    No change.

    Are you a displaced homemaker?

    Required field.

    pw_advising_check.p_validation_stampvalidationstamp

    input variable: vt2

    Yes/No Radio Boxes

    input:

    Yes = D

    No = N

    Null = Not allowed

    table: sgbuser_sude_code

    SV05 = D

    No = N

    Null=Not allowed

    table: sgbuser_sude_code

    Tip

    No change.

    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

    		https://sequoias.atlassian.net/browse/AP-657

    SV05 = PSGBUSER_MIGR_WORK_IND

    SV09 = M

    Tip

    No change.