Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Jira Legacy
serverSystem JIRA
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-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.

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 variablevariables: opt1, opt2, opt3, opt4, opt5

input:

Yes = Y

No = N

Null=N

table: SZRDURT_HOMELESSopt1

opt2

opt3

opt4

opt5
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

Checkboxes:

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

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

...