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 | Status |
|---|---|---|---|
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 | |||
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 |
0 Comments