Versions Compared

Old Version 39

changes.mady.by.user Jordan Lamb

Saved on

compared with

New Version 40

changes.mady.by.user Jordan Lamb

Saved on

Key

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

...

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

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_validationstamp

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 .

Note

Use it or get rid of it.

Choose which apply from the list below:

Required field.

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:

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_validationstamp

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_validationstamp

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.

...