Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 24 Next »

CCCApply

Supplemental Questions

 Get Questions from CCCApply Administrator

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

AP-658 - Getting issue details... STATUS

Supplemental Questions

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

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

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

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

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

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.

Unknown

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

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.

What is this? Why do we ask this?

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.

SV07 hasn’t been collected since

SG15 is still be reported. SVBWIOA_EXOF_CODE

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.

Why do we ask this question?

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.

Why do we ask this question?

Emergency Contact (required)

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

Question

Field Name

Field Type

Banner Integration

First Name

Required field

SZRAPLY.SUPP_TEXT_01 to szrccap_EMER_FIRST_NAME

Text box

Unvalidated; user can enter blatantly false data.

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

Last Name

Required field

SZRAPLY.SUPP_TEXT_02to szrccap_EMER_FIRST_NAME

Text box

Unvalidated; user can enter blatantly false data.

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

Area Code

Required field

SZRAPLY.SUPP_TEXT_03 to szrccap_EMER_PHONE_AREA

Text box

Unvalidated; user can enter blatantly false data.

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

Phone

Required field

SZRAPLY.SUPP_TEXT_04 to szrccap_EMER_PHONE_NUMBER

Text box

Unvalidated; user can enter blatantly false data.

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

Extension

Required field

SZRAPLY.SUPP_TEXT_05 to szrccap_EMER_PHONE_EXT

Text box

Unvalidated; user can enter blatantly false data.

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

Address Line 1

Required field

SZRAPLY.SUPP_TEXT_06 to szrccap_EMER_STREET_LINE1

Text box

Unvalidated; user can enter blatantly false data.

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

Address Line 2

Required field

SZRAPLY.SUPP_TEXT_07 to szrccap_EMER_STREET_LINE2

Text box

Unvalidated; user can enter blatantly false data.

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

City

Required field

SZRAPLY.SUPP_TEXT_08 to szrccap_EMER_CITY

Text box

Unvalidated; user can enter blatantly false data.

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

Zip

Required field

SZRAPLY.SUPP_TEXT_09 to szrccap_EMER_ZIP

Text box

Unvalidated; user can enter blatantly false data.

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

Their relationship to you:

Required field

SZRAPLY.SUPP_MENU_01 to szrccap_EMER_RELT_CODE

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

Required field

SZRAPLY.SUPP_STATE_01 to szrccap_EMER_STAT_CODE

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

Countries

Required field

SZRAPLY.SUPP_COUNTRY_01 to szrccap_EMER_NATN_CODE

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

Current Math Class

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

Question

Field Name

Field Type

Banner Integration

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.

Pre-Registration Survey

 Code locations of pre-reg processing

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

Question

Field Name

Field Type

Banner Integration

Purpose of Question

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

AP-652 - Getting issue details... STATUS

Was used on old Student Education Plan.

It used the following procedure: cos_general.get_Stu_Main_Campus_From_Pidm.

Not used on the current Degree Works SEP

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

Checked CAB, version control, GitHub, EIS.

Are you interested in resources for undocumented students?

Required field

pw_advising_check.p_validation_stamp

input variable: qt1

input:

Yes = Y

No = N

Null=N

table: SZRDURT_UNDOCUMENTED_RESOURCES

Yes/No Radio Boxes

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

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

Required field

pw_advising_check.p_validation_stamp

input variable: qt2

input:

Yes = Y

No = N

Null=N

table: SZRDURT_HOMELESS

Yes/No Radio Boxes

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

Choose which apply from the list below:

Required field

pw_advising_check.p_validation_stamp

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

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

Checkboxes:

  • CalWORKs/TANF/AFDC recipient

  • SSI recipient

  • General Assistance recipient

  • Other economically disadvantaged status

  • None of the above

None of the above can be selected in addition to any/all of the above. Don’t know how the ingest is handling this.

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

Are you a single Parent?

Required field

pw_advising_check.p_validation_stamp

input variable: vt1

input:

Yes = P

No = N

Null=Not allowed

table: sgbuser_sudd_code

Yes/No Radio Boxes

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

SV04 = P

Are you a displaced homemaker?

Required field

pw_advising_check.p_validation_stamp

input variable: vt2

input:

Yes = D

No = N

Null=Not allowed

table: sgbuser_sude_code

Yes/No Radio Boxes

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

SV05 = P

  • No labels