STUDENT_TERM (COS) View

Proposed Architecture/Reference:

COS_DATALAKEHOUSE.COS_CURATED.STUDENT_TERM

Domain:

Tables Used (Document these in each element instead):
GOREMAL, GORPRAC, SFBETRM, SFRTHST, SGBSTDN, SHRLGPA, SHRTGPA, SMRPRLE, SPBPERS, SPRADDR, SPRHOLD, SPRIDEN, SPRTELE, STATTR, STVACYR, STVCAMP, STVCIPC, STVCITZ, STVCOLL, STVDEGC, STVESTS, STVETCT, STVETHN, STVLEVL, STVMAJR, STVNATN, STVSTST, STVSTYP, STVTERM, STVTMST, TBRACCD, TVTERM

This view is built on COS_DATALAKEHOUSE.CURATED.STUDENT_TERM. Invoke documentation defines this table as "One row per student per term." They source from more than just Banner for this curated table.

More information available here: COS_DATALAKEHOUSE.CURATED.COLLECTION_DEFINITION

COS Applications and Research decided to utilize the Invoke Curated tables as a starting point and build views off those for as long as feasible and accurate.

How Invoke decided to join tables, build exclusions/inclusions is unknown.

Update Frequency Notes:

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

Column	Definition	Lineage
TERM_CODE	Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.	STUDENT_TERM.TERM_CODE
TERM	Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.	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