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 |
|
|
| Status | ||||
|---|---|---|---|---|
|
|
| |||||||||||||
FIRST_NAME |
STUDENT_TERM.STUDENT_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 |
PERSONAL_EMAIL
| 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 |
CAST_CODECALWORKS
ATHLETE
WIA
FOSTER_YOUTH
TRIO
| 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 |
Code saved on my laptop, waiting for place to store it and verification of changes for updated way of calculating.
HOMELESS_STATUS
COHORTS
| Info |
|---|
Student Success, |
| 28 | |
PELL | https://sequoias.atlassian.net/browse/ |
| GOVPUB-14 | ||
HOMELESS_STATUS |