Page Comparison

TERM_CODE

STUDENT_TERM.TERM_CODE

TERM

STUDENT_TERM.TERM

BANNER_ID

STUDENT_TERM.STUDENT_ALTERNATE_ID

ssn

pidm

lastname

firstname

midinit

studentname

address

city

state

zip

phone

status

program

major_code

major

gender

birthdate

age

ageatterm

marital_code

highschool

eng251_elig

eng_test_date

mathplace

math_test_date

overall_gpa

overall_hrs_earned

overall_hrs_passed

transfer_in_units

transfer_in_gpa

term_gpa

term_hours

term_passed

term_passed_abc

term_accum_units_att

term_accum_units_passed

term_accum_gpa

eops

drc

drc_codes

vatea

puente

cast_code

email

visa_type

calworks

veteran

regis_appt

athlete

wia

pell

dependent

ed_plan_date

orientation

foster_youth

eops_care

fin_aid_ind_by_mjr

cte_ind_by_mjr

dean_pres_code

deans_pres_desc

resd_code

resd_desc

caa

trio

pers_email

cell_phone

parent_edlv_1_code

parent_edlv_1_desc

parent_edlv_2_code

parent_edlv_2_desc

prog_dept

prog_ge_pattern

homeless_status

sexual_orientation

transgender_status

cccid

completed_eleventh

sr_hs_gpa

sr_hs_highest_engl_course

sr_hs_highest_engl_grade

sr_hs_highest_math_course

sr_hs_highest_math_taken_grade

sr_hs_highest_math_pass_grade

sr_hs_highest_math_passed

sr_hs_years_english

sr_hs_lowest_engl_grade

sr_hs_current_math

confidential_ind

am_mathplace

SSN

APPLICATION.APPLICATION_SSN

PIDM

STUDENT_TERM.STUDENT_ID

CCCID

APPLICATION_CCC_ID

LAST_NAME

STUDENT_TERM.STUDENT_LAST_NAME

FIRST_NAME

STUDENT_TERM.STUDENT_FIRST_NAME

MIDDLE_NAME

STUDENT_TERM.STUDENT_MIDDLE_NAME

STUDENT_NAME

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

STUDENT_TERM.STUDENT_BIRTH_DATE

AGE_AT_TERM_START

STUDENT_TERM.AGE

GENDER

STUDENT_TERM.STUDENT_GENDER

SEXUAL_ORIENTATION

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

BANINST1.SV_MIS_SB_STU.f_get_sexual_orientation

TRANSGENDER

SPBPERS_GNDR_CODE is populated from CCCApply, but the Banner data architecture does not allow for a 1-to-1 relationship with CCCApply data.

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.

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

SPBPERS_GNDR_CODE

CONFIDENTIAL_IND

PHONE

STUDENT_TERM.STUDENT_PHONE_NUMBER

CELL_PHONE

EMAIL

PERSONAL_EMAIL

MARITAL_CODE

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

APPLICATION.APPLICATION_NAME_HSCH

ENGL_PLACE

ENGL_TEST_DATE

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

STUDENT_TERM.STUDENT_TERM_MAJOR

CTE_IND_BY_MJR

FIN_AID_IND_BY_MJR

REGIS_APPT

ED_PLAN_DATE

ACADEMIC_STANDING

CAST_CODE

STATUS

OVERALL_GPA

STUDENT_TERM_OVERALL_GPA

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