Page Comparison

Proposed Architecture/Reference:

COS_DATALAKEHOUSE.COS_CURATED.STUDENT_TERM

Domain:

...

COS_DATALAKEHOUSE.CURATED.STUDENT_TERM is built nightly. Functions execute on query.

...

Column	Definition

Lineage

Status

TERM_CODE

STUDENT_TERM.TERM_CODE

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	term_code
nopanel	true

STUDENT_TERM.TERM_CODE

Status

colour	Green
title	DONE

TERM

STUDENT_TERM.TERM

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	TERM
nopanel	true

STUDENT_TERM.TERM

Status

colour	Green
title	DONE

BANNER_ID

STUDENT_TERM.STUDENT_ALTERNATE_ID

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	studentid
nopanel	true

STUDENT_TERM.STUDENT_ALTERNATE_ID

Status

colour	Green
title	DONE

SSN

APPLICATION.APPLICATION_SSN

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	SSN
nopanel	true

APPLICATION.APPLICATION_SSN

Status

colour	Green
title	DONE

PIDM

STUDENT_TERM.STUDENT_ID

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	PIDM
nopanel	true

STUDENT_TERM.STUDENT_ID

Status

colour	Green
title	DONE

CCCID

APPLICATION_CCC_ID

Status

colour	Green
title	DONE

LAST_NAME

STUDENT_TERM.STUDENT_LAST_NAME

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	Lastname
nopanel	true

STUDENT_TERM.STUDENT_LAST_NAME

Status

colour	Green
title	DONE

FIRST_NAME

Insert excerptDOC:Common DefinitionsDOC:Common DefinitionsnameFIRSTNAMEnopaneltrue

https://sequoias.atlassian.net/browse/GOVPUB-29
MIDDLE_NAME	`STUDENT_TERM.STUDENT`

_FIRST

_

NAME

Status

colour	Green
title	DONE

MIDDLE_NAME

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	MIDINIT
nopanel	true

STUDENT_TERM.STUDENT_MIDDLE_NAME

Status

colour	Green
title	DONE

STUDENT_NAME

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	STUDENTNAME
nopanel	true

Status

colour	Green
title	DONE

ADDRESS

STUDENT_TERM.STUDENT_ADDRESS_STREET_1

Status

colour	Green
title	DONE

CITY

STUDENT_TERM.STUDENT_ADDRESS_CITY

Status

colour	Green
title	DONE

STATE

STUDENT_TERM.STUDENT_ADDRESS_STATE

Status

colour	Green
title	DONE

ZIP

STUDENT_TERM.STUDENT_ADDRESS_POSTAL_CODE

Status

colour	Green
title	DONE

BIRTH_DATE

STUDENT_TERM.STUDENT_BIRTH_DATE

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	BIRTHDATE
nopanel	true

STUDENT_TERM.STUDENT_BIRTH_DATE

Status

colour	Green
title	DONE

AGE_AT_TERM_START

STUDENT_TERM.AGE

Status

colour	Green
title	DONE

ETHNICITY

Insert excerpt

DOC:

	Common Definitions

DOC: Insert excerptDOC:Common DefinitionsDOC:Common DefinitionsnameGENDERnopaneltrue

STUDENT_TERM.STUDENT_GENDER

Status

colour	Blue
title	Rewriting Function

Status

title	Needs Validation

	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

https://sequoias.atlassian.net/browse/GOVPUB-9
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

Info
Uses SB37 DED Definitions

https://sequoias.atlassian.net/browse/GOVPUB-4

Jira LegacyserverSystem JIRAserverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4

Status

colour	Green
title	Done

keyAP-399

SEXUAL_ORIENTATION

The description of the SEXUAL_ORIENTATION_CODE

Jira Legacy

server	System JIRA
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	AP-399

Status

colour	Green
title	Done

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

CONFIDENTIAL

https://sequoias.atlassian.net/browse/GOVPUB-5
TRANSGENDER Previously TRANSGENDER_STATUS	https://sequoias.atlassian.net/browse/GOVPUB-8

SPBPERS_GNDR_CODE

Status

colour	Blue
title	Rewriting Function

CONFIDENTIAL_IND

SPBPERS_CONFID_IND

Insert excerpt

DOC:

	Common Definitions

DOC:

PHONE

Insert excerptDOC:Common DefinitionsDOC:Common DefinitionsnamePHONEnopaneltrue

	Common Definitions
name	confidential_indicator
nopanel	true

SPBPERS_CONFID_IND

Status

colour	Green
title	Done

PHONE

STUDENT_TERM.STUDENT_PHONE_NUMBER

CELL_PHONE

EMAIL

PERSONAL_EMAIL

Insert excerptDOC:Common DefinitionsDOC:Common Definitionsname

or:

https://sequoias.atlassian.net/browse/GOVPUB-19

Status

colour	Yellow
title	Requires Research Validation

CELL_PHONE

https://sequoias.atlassian.net/browse/GOVPUB-12

EMAIL

PERSONAL_EMAIL

nopaneltrue


MARITAL_CODE	`APPLICATION.APPLICATION_MARITAL_`

CODE

STAT

Insert excerpt

DOC:

	Common Definitions

DOC:

	Common Definitions
name	MARITAL_CODE
nopanel	true

APPLICATION.APPLICATION_MARITAL_STAT

DEPENDENT

VISA_TYPE

https://sequoias.atlassian.net/browse/GOVPUB-35

RESD_CODE

https://sequoias.atlassian.net/browse/GOVPUB-34

RESD_DESC

Jira Legacy

server	System Jira
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	GOVPUB-34

PARENT_EDLV_1_CODE

https://sequoias.atlassian.net/browse/GOVPUB-31

PARENT_EDLV_1_DESC

Jira Legacy

server	System Jira
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	GOVPUB-31

PARENT_EDLV_2_CODE

Jira Legacy

server	System Jira
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	GOVPUB-31

PARENT_EDLV_2_DESC

Jira Legacy

server	System Jira
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	GOVPUB-31

HIGHSCHOOL

APPLICATION.APPLICATION_NAME_HSCH

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

STUDENT_TERM.STUDENT_TERM_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

https://sequoias.atlassian.net/browse/GOVPUB-33
STUDENT_STATUS Previously STATUS

SGBSTDN_STYP_CODE

StatuscolourGreentitleRewritten. Pending Access to Write Function.

https://sequoias.atlassian.net/browse/GOVPUB-7

OVERALL_GPA

STUDENT_TERM_OVERALL_GPA

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

Research assessing what STUDENT_TERM columns would be useful for GPA/HRS/Units

OVERALL_HRS_EARNED

STUDENT_TERM_OVERALL_HOURS_EARNED

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

OVERALL_HRS_PASSED

STUDENT_TERM_OVERALL_HOURS_PASSED

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TRANSFER_IN_UNITS

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TRANSFER_IN_GPA

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TERM_GPA

STUDENT_TERM_GPA

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TERM_HOURS

STUDENT_TERM_HOURS_ATTEMPTED

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TERM_PASSED

STUDENT_TERM_HOURS_PASSED

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TERM_PASSED_ABC

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TERM_ACCUM_UNITS_ATT

STUDENT_TERM_OVERALL_HOURS_ATTEMPTED

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TERM_ACUM_UNITS_PASSED

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

TERM_ACCUM_GPA

Status

colour	Yellow
title	Hold

Status

title	Needs Validation

DEAN_PRES_CODE

https://sequoias.atlassian.net/browse/GOVPUB-30

DEAN_PRES_DESC

https://sequoias.atlassian.net/browse/GOVPUB-30

EOPS

https://sequoias.atlassian.net/browse/GOVPUB-15

DRC

https://sequoias.atlassian.net/browse/GOVPUB-18

DRC_CODES

https://sequoias.atlassian.net/browse/GOVPUB-20

VTEA

https://sequoias.atlassian.net/browse/GOVPUB-17

PUENTE

https://sequoias.atlassian.net/browse/GOVPUB-13

CALWORKS

https://sequoias.atlassian.net/browse/GOVPUB-23

ATHLETE

https://sequoias.atlassian.net/browse/GOVPUB-25

WIA

https://sequoias.atlassian.net/browse/GOVPUB-26

FOSTER_YOUTH

https://sequoias.atlassian.net/browse/GOVPUB-27

TRIO

PELL

HOMELESS_STATUS

COHORTS

Info
Student Success, COS Foundation

COMING SOON

	https://sequoias.atlassian.net/browse/GOVPUB-28
PELL	https://sequoias.atlassian.net/browse/

AP

GOVPUB-

357

...

14
HOMELESS_STATUS

Version	Old Version 21	New Version Current
Changes made by	Jordan Lamb	Jordan Lamb
Saved on	Feb 24, 2023	Mar 06, 2024

Versions Compared

Key