Column | Definition | Lineage | Status |
|---|
TERM_CODE | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | term_code |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.TERM_CODE
| |
TERM | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | TERM |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.TERM
| |
BANNER_ID | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | studentid |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_ALTERNATE_ID
| |
SSN | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | SSN |
|---|
| nopanel | true |
|---|
|
| APPLICATION.APPLICATION_SSN
| |
PIDM | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | PIDM |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_ID
| |
CCCID | | APPLICATION_CCC_ID
| |
LAST_NAME | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | Lastname |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_LAST_NAME
| |
FIRST_NAME | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | FIRSTNAME |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_FIRST_NAME
| |
MIDDLE_NAME | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | MIDINIT |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_MIDDLE_NAME
| |
STUDENT_NAME | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | STUDENTNAME |
|---|
| nopanel | true |
|---|
|
| | |
ADDRESS | | STUDENT_TERM.STUDENT_ADDRESS_STREET_1
| |
CITY | | STUDENT_TERM.STUDENT_ADDRESS_CITY
| |
STATE | | STUDENT_TERM.STUDENT_ADDRESS_STATE
| |
ZIP | | STUDENT_TERM.STUDENT_ADDRESS_POSTAL_CODE
| |
BIRTH_DATE | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | BIRTHDATE |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_BIRTH_DATE
| |
AGE_AT_TERM_START | | STUDENT_TERM.AGE
| |
ETHNICITY | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | RACE_ETHN_CDE |
|---|
|
| | | Status |
|---|
| colour | Red |
|---|
| title | Invoke is creating this |
|---|
|
|
GENDER | | Panel |
|---|
| panelIconId | 26d4 |
|---|
| panelIcon | :no_entry: |
|---|
| panelIconText | ⛔ |
|---|
| bgColor | #FFEBE6 |
|---|
| Rework to match Gender field on CCCApply: F = Female M = Male B = Non-binary X = Decline to state = No selection |
| Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | GENDER |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_GENDER
| | Status |
|---|
| colour | Blue |
|---|
| title | Rewriting Function |
|---|
|
|
SEXUAL_ORIENTATION_CODE | Sexual Orientation: Self-declared sexual orientation code value. Self-reported initially from the student’s application. This is stored in Banner in the table: SVBSXLO and the column: SVBSXLO_SXLO_CODE https://sequoias.atlassian.net/browse/GOVPUB-4 | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | AP-399 |
|---|
|
| |
SEXUAL_ORIENTATION | The description of the SEXUAL_ORIENTATION_CODE | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | AP-399 |
|---|
|
| |
TRANSGENDER Previously TRANSGENDER_STATUS | | Panel |
|---|
| panelIconId | 26d4 |
|---|
| panelIcon | :no_entry: |
|---|
| panelIconText | ⛔ |
|---|
| bgColor | #FFEBE6 |
|---|
| Rework to match Transgender field on CCCApply: 1 = Yes 2 = No 3 = Decline to State 0 = No selection Null = not displayed to user |
SPBPERS_GNDR_CODE is populated from CCCApply, but the Banner data architecture does not allow for a 1-to-1 relationship with CCCApply data.
| Code Block |
|---|
IF c1_rec.gender = 'B' AND c1_rec.transgender_encrypted BETWEEN '1' and '3'
THEN
--ryanwh: 11.2.2021: using DECODE to map the CCCApply values to the appropriate MIS values.
v_gndr_code :=
DECODE (
SUBSTR (c1_rec.transgender_encrypted,
0,
1),
'2', '0',
'3', '2',
'0', 'X',
SUBSTR (c1_rec.transgender_encrypted,
0,
1))
|| c1_rec.gender;
ELSE
v_gndr_code :=
DECODE (
SUBSTR (c1_rec.transgender_encrypted, 0, 1),
'2', '0',
'3', '2',
'0', 'X',
SUBSTR (c1_rec.transgender_encrypted, 0, 1));
END IF;
|
Because of this, Technology Services staff chose not to split that data back out to separate gender/transgender fields like CCCApply. We also crosswalk from CCCApply values to approved MIS values because MIS only allows certain codes and there is no known Banner process to do code conversions for SB reporting. Current Codes on related Validation Table GTVGNDR: Codes - Definitions
0 - Not transgender
0B - Non-Binary gender and Not transgender
1 - Transgender
1B - Non-Binary gender and transgender
2 - Decline to State
2B - Non-Binary gender and Decline to State
X - Uncollected
Null - Unknown
XB - Uncollected Non-Binary Gender | Note |
|---|
Codes 3 and 3B are no longer valid |
https://sequoias.atlassian.net/browse/GOVPUB-8 | SPBPERS_GNDR_CODE
| | Status |
|---|
| colour | Blue |
|---|
| title | Rewriting Function |
|---|
|
|
CONFIDENTIAL_IND | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | confidential_indicator |
|---|
| nopanel | true |
|---|
|
| SPBPERS_CONFID_IND
| |
PHONE | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | PHONE |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_PHONE_NUMBER
| |
CELL_PHONE | | | |
EMAIL | | | |
PERSONAL_EMAIL | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | PERSONAL_EMAIL |
|---|
| nopanel | true |
|---|
|
| | |
MARITAL_CODE | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | MARITAL_CODE |
|---|
| nopanel | true |
|---|
|
| APPLICATION.APPLICATION_MARITAL_STAT
| |
DEPENDENT | | | |
VISA_TYPE | | | |
RESD_CODE | | | |
RESD_DESC | | | |
PARENT_EDLV_1_CODE | | | |
PARENT_EDLV_1_DESC | | | |
PARENT_EDLV_2_CODE | | | |
PARENT_EDLV_2_DESC | | | |
HIGHSCHOOL | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | HIGHSCHOOL |
|---|
| nopanel | true |
|---|
|
| APPLICATION.APPLICATION_NAME_HSCH
| |
ENGL_PLACE Previously named ENG251_ELIG | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | ENG251_ELIG |
|---|
| nopanel | true |
|---|
|
| | |
ENGL_TEST_DATE Previously named ENG_TEST_DATE | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | eng_test_date |
|---|
| nopanel | true |
|---|
|
| | |
MATHPLACE | | | |
AM_MATHPLACE | | | |
MATH_TEST_DATE | | | |
COMPLETED_ELEVENTH | | | |
SR_HS_GPA | | | |
SR_HS_YEARS_ENGLISH | | | |
SR_HS_HIGHEST_ENGL_COURSE | | | |
SR_HS_HIGHEST_ENGL_GRADE | | | |
SR_HS_LOWEST_ENGL_GRADE | | | |
SR_HS_HIGHEST_MATH_COURSE | | | |
SR_HS_HIGHEST_MATH_TAKEN_GRADE | | | |
SR_HS_HIGHEST_MATH_PASS_GRADE | | | |
SR_HS_CURRENT_MATH | | | |
ORIENTATION | | | |
PROGRAM | | STUDENT_TERM.STUDENT_TERM_PROGRAM_CODE
| |
PROG_DEPT | | | |
PROG_GE_PATTERN | | | |
MAJOR_CODE | | STUDENT_TERM.STUDENT_TERM_MAJOR_CODE
| |
MAJOR | | Insert excerpt |
|---|
| DOC:Common Definitions |
|---|
| DOC:Common Definitions |
|---|
| name | MAJOR_DESC |
|---|
| nopanel | true |
|---|
|
| STUDENT_TERM.STUDENT_TERM_MAJOR
| |
CTE_IND_BY_MJR | | | |
FIN_AID_IND_BY_MJR | | | |
REGIS_APPT | | | |
ED_PLAN_DATE | | | |
ACADEMIC_STANDING | CAST_CODE | | |
STUDENT_STATUS | | SGBSTDN_STYP_CODE
| | Status |
|---|
| colour | Green |
|---|
| title | Rewritten. Pending Access to Write Function. |
|---|
|
|
OVERALL_GPA | | STUDENT_TERM_OVERALL_GPA
| Research assessing what STUDENT_TERM columns would be useful for GPA/HRS/Units |
OVERALL_HRS_EARNED | | STUDENT_TERM_OVERALL_HOURS_EARNED | |
OVERALL_HRS_PASSED | | STUDENT_TERM_OVERALL_HOURS_PASSED | |
TRANSFER_IN_UNITS | | | |
TRANSFER_IN_GPA | | | |
TERM_GPA | | STUDENT_TERM_GPA | |
TERM_HOURS | | STUDENT_TERM_HOURS_ATTEMPTED | |
TERM_PASSED | | STUDENT_TERM_HOURS_PASSED | |
TERM_PASSED_ABC | | | |
TERM_ACCUM_UNITS_ATT | | STUDENT_TERM_OVERALL_HOURS_ATTEMPTED | |
TERM_ACUM_UNITS_PASSED | | | |
TERM_ACCUM_GPA | | | |
DEAN_PRES_CODE | | | |
DEAN_PRES_DESC | | | |
EOPS | | | |
DRC | | | |
DRC_CODES | | | |
VTEA | | | |
PUENTE | | | |
CALWORKS | | | |
ATHLETE | | | |
WIA | | | |
FOSTER_YOUTH | | | |
TRIO | | | |
PELL | | | |
HOMELESS_STATUS | | | |
COHORTS | Info |
|---|
Student Success,
COS Foundation |
| https://sequoias.atlassian.net/browse/AP-357 | | |