Snowflake STUDENT_TERM View
- Jordan Lamb
- Joshua Metry
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 |
| DONE |
TERM |
| DONE |
BANNER_ID |
| DONE |
SSN |
| DONE |
PIDM |
| DONE |
CCCID |
| DONE |
LAST_NAME |
| DONE |
FIRST_NAME |
| |
MIDDLE_NAME |
| DONE |
STUDENT_NAME | DONE | |
ADDRESS |
| DONE |
CITY |
| DONE |
STATE |
| DONE |
ZIP |
| DONE |
BIRTH_DATE |
| DONE |
AGE_AT_TERM_START |
| DONE |
ETHNICITY | Common Definitions | Invoke is creating this |
GENDER |
| |
SEXUAL_ORIENTATION_CODE |
| |
SEXUAL_ORIENTATION |
| |
TRANSGENDER |
| |
CONFIDENTIAL_IND |
| Done |
PHONE |
| 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 | Â | |
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 |
| Â |
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 |
|
|
OVERALL_GPA |
| HoldNeeds Validation |
OVERALL_HRS_EARNED |
| HoldNeeds Validation |
OVERALL_HRS_PASSED |
| HoldNeeds Validation |
TRANSFER_IN_UNITS | Â | HoldNeeds Validation |
TRANSFER_IN_GPA | Â | HoldNeeds Validation |
TERM_GPA |
| HoldNeeds Validation |
TERM_HOURS |
| HoldNeeds Validation |
TERM_PASSED |
| HoldNeeds Validation |
TERM_PASSED_ABC | Â | HoldNeeds Validation |
TERM_ACCUM_UNITS_ATT |
| HoldNeeds Validation |
TERM_ACUM_UNITS_PASSED | Â | HoldNeeds Validation |
TERM_ACCUM_GPA | Â | HoldNeeds Validation |
DEAN_PRES_CODE |
| Â |
DEAN_PRES_DESC |
| Â |
EOPS | Â | |
DRC | Â
| Â |
DRC_CODES | Â
| Â |
VTEA | Â
| Â |
PUENTE |
| Â |
CALWORKS |
| Â |
ATHLETE |
| Â |
WIA |
| Â |
FOSTER_YOUTH |
| Â |
TRIO |
| Â |
PELL |
| Â |
HOMELESS_STATUS | Â | Â |
Â