Table of Contents

maxLevel	6
minLevel	1
include
outline	false
indent
exclude
type	list
printable	false
class

CCCApply

Supplemental Questions

Expand

title	Get Questions from CCCApply Administrator

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

Jira Legacy

server	System JIRAJira
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	AP-658

Are you or Why do we ask this question?https://sequoias.atlassian.net/browse/AP-721

Supplemental Questions

Panel

panelIconId	atlassian-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

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

Note
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

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_ECON_DISADVANTAGE

Radio buttons:

Yes
No (defaulted)

Does not feed into Banner.

SV03 First Position = 4

SV03 Second Position = S

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. Request CCCApply or COMIS modify question or reporting requirementsDoesn’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.

Info
Pending Technology Services improvement.

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

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

Tip
No change.

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

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_13 to SZRCCAP_FARMWORKER

Radio buttons:

Yes
No (defaulted)

Does not feed into Banner.

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_10 to SZRCCAP_HINDERANCE_EMPLOY

Radio buttons:

Yes
No (defaulted)

Does not feed into Banner.

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_11 to SZRCCAP_LONG_TERM_UNEMP

Radio buttons:

Yes
No (defaulted)

Does not feed into Banner.

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_12 to SZRCCAP_EXOFFENDER

Radio buttons:

Yes
No

Does not feed into Banner.

Note
SV07 hasn’t been collected since 01 Oct 2000

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
Why do we ask this question?
Note
Remove from Supplemental QuestionsRemove. 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.

Note

Note
Remove from Supplemental Questions. 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 PreRegistration SurveyCCCApply. 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

title	Code 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)

Use it or get rid of it

Argos report Registration Questionnaire produces this data.

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

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

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

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.

Note

Tip
No change.

Choose which apply from the list below:

Required field.

pw_advising_check.p_validation_stampvalidationstamp

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:

Code Block
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

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

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

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

SGBUSER_MIGR_WORK_IND

SV09 = M

Tip
No change.

Versions Compared

Old Version 28

New Version Current

Key

CCCApply

Supplemental Questions

CCCApply Standard Application Question

Emergency Contact (required)

Current Math Class

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

Pre-Registration Survey

Page Comparison

Versions Compared

Old Version 28

New Version Current

Key

CCCApply

Supplemental Questions

CCCApply Standard Application Question

Emergency Contact (required)

Current Math Class

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

Pre-Registration Survey