Proposed Architecture/Reference:
COS_DATALAKEHOUSE.COS_CURATED.STUDENT_TERM
Domain:
...
COS_DATALAKEHOUSE.CURATED.STUDENT_TERM is built nightly. Functions execute on query.
Column | Definition | Status |
|---|---|---|
TERM_CODE |
|
|
|
| |||||||||||||
TERM |
|
|
|
| |||||||||||||
BANNER_ID |
|
|
|
| |||||||||||||
SSN |
|
|
|
| |||||||||||||
PIDM |
|
|
|
| |||||||||||||
CCCID |
|
| ||||||||||||
LAST_NAME |
|
|
|
| |||||||||||||
FIRST_NAME | https://sequoias.atlassian.net/browse/GOVPUB-29 | |||||||||||||
MIDDLE_NAME |
|
|
|
| |||||||||||||
STUDENT_NAME |
|
|
|
| |||||||||||||
ADDRESS |
|
| ||||||||||||
CITY |
|
| ||||||||||||
STATE |
|
| ||||||||||||
ZIP |
|
| ||||||||||||
BIRTH_DATE |
|
|
|
| |||||||||||||
AGE_AT_TERM_START |
|
| ||||||||||||
ETHNICITY |
|
|
|
| |||||||||||
GENDER | https://sequoias.atlassian.net/browse/GOVPUB-9 | |||||||||||
SEXUAL_ORIENTATION_CODE | https://sequoias.atlassian.net/browse/GOVPUB-4 | |||||||||||
SEXUAL_ORIENTATION | https://sequoias.atlassian.net/browse/GOVPUB-5 | |||||||||||
TRANSGENDER Previously TRANSGENDER_STATUS | https://sequoias.atlassian.net/browse/GOVPUB-8 | |||||||||||
CONFIDENTIAL_IND |
|
|
|
| |||||||||||||
PHONE |
|
| ||||||||||||
CELL_PHONE | https://sequoias.atlassian.net/browse/GOVPUB-12 | |||||||||||||
PERSONAL_EMAIL | ||||||||||||||
MARITAL_CODE |
|
|
| ||||||||||
DEPENDENT | ||||||||||
VISA_TYPE | https://sequoias.atlassian.net/browse/GOVPUB-35 | |||||||||
RESD_CODE | https://sequoias.atlassian.net/browse/GOVPUB-34 | |||||||||
RESD_DESC |
| |||||||||
PARENT_EDLV_1_CODE | https://sequoias.atlassian.net/browse/GOVPUB-31 | |||||||||
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 | https://sequoias.atlassian.net/browse/GOVPUB-33 | |||||||||||
STUDENT_STATUS Previously STATUS | https://sequoias.atlassian.net/browse/GOVPUB-7 | |||||||||||
OVERALL_GPA |
|
Research assessing what STUDENT_TERM columns would be useful for GPA/HRS/Units | ||||||||||
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_ACUM_UNITS_PASSED |
| |||||||||||
TERM_ACCUM_GPA |
| |||||||||||
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 | ||||||||||||
DRC_CODES | ||||||||||||
VTEA | ||||||||||||
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 | https://sequoias.atlassian.net/browse/GOVPUB-28 | |||||||||||
PELL | https://sequoias.atlassian.net/browse/GOVPUB-14 | |||||||||||
HOMELESS_STATUS |
COHORTS
| Info |
|---|
Student Success, |
COMING SOON