Snowflake STUDENT_TERM 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 | Status |
|---|---|---|
TERM_CODE |
| status:DONE |
TERM |
| status:DONE |
BANNER_ID |
| status:DONE |
SSN |
| status:DONE |
PIDM |
| status:DONE |
CCCID |
| status:DONE |
LAST_NAME |
| status:DONE |
FIRST_NAME |
| |
MIDDLE_NAME |
| status:DONE |
STUDENT_NAME | status:DONE | |
ADDRESS |
| status:DONE |
CITY |
| status:DONE |
STATE |
| status:DONE |
ZIP |
| status:DONE |
BIRTH_DATE |
| status:DONE |
AGE_AT_TERM_START |
| status:DONE |
ETHNICITY | Common Definitions | status:Invoke is creating this |
GENDER |
| |
SEXUAL_ORIENTATION_CODE |
| |
SEXUAL_ORIENTATION |
| |
TRANSGENDER Previously TRANSGENDER_STATUS |
| |
CONFIDENTIAL_IND |
| status:Done |
PHONE |
| status:Requires Research Validation |
CELL_PHONE |
| |
|
| |
PERSONAL_EMAIL |
|
|
MARITAL_CODE |
|
|
DEPENDENT |
|
|
VISA_TYPE |
|
|
RESD_CODE |
|
|
RESD_DESC |
| |
PARENT_EDLV_1_CODE |
|
|
PARENT_EDLV_1_DESC |
| |
PARENT_EDLV_2_CODE |
| |
PARENT_EDLV_2_DESC |
| |
HIGHSCHOOL |
|
|
ENGL_PLACE Previously named ENG251_ELIG |
| |
ENGL_TEST_DATE Previously named ENG_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 |
|
|
PROG_DEPT |
|
|
PROG_GE_PATTERN |
|
|
MAJOR_CODE |
|
|
MAJOR |
|
|
CTE_IND_BY_MJR |
|
|
FIN_AID_IND_BY_MJR |
|
|
REGIS_APPT |
|
|
ED_PLAN_DATE |
|
|
ACADEMIC_STANDING |
|
|
STUDENT_STATUS Previously STATUS |
|
|
OVERALL_GPA |
| status:Holdstatus:Needs Validation Research assessing what STUDENT_TERM columns would be useful for GPA/HRS/Units |
OVERALL_HRS_EARNED |
| status:Holdstatus:Needs Validation |
OVERALL_HRS_PASSED |
| status:Holdstatus:Needs Validation |
TRANSFER_IN_UNITS |
| status:Holdstatus:Needs Validation |
TRANSFER_IN_GPA |
| status:Holdstatus:Needs Validation |
TERM_GPA |
| status:Holdstatus:Needs Validation |
TERM_HOURS |
| status:Holdstatus:Needs Validation |
TERM_PASSED |
| status:Holdstatus:Needs Validation |
TERM_PASSED_ABC |
| status:Holdstatus:Needs Validation |
TERM_ACCUM_UNITS_ATT |
| status:Holdstatus:Needs Validation |
TERM_ACUM_UNITS_PASSED |
| status:Holdstatus:Needs Validation |
TERM_ACCUM_GPA |
| status:Holdstatus:Needs Validation |
DEAN_PRES_CODE |
|
|
DEAN_PRES_DESC |
|
|
EOPS |
| |
DRC |
|
|
DRC_CODES |
|
|
VTEA |
|
|
PUENTE |
|
|
CALWORKS |
|
|
ATHLETE |
|
|
WIA |
|
|
FOSTER_YOUTH |
|
|
TRIO |
|
|
PELL |
|
|
HOMELESS_STATUS |
|
|