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 |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
TERM |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
BANNER_ID |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
SSN |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
PIDM |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
CCCID |
| DONE |
LAST_NAME |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
FIRST_NAME | https://sequoias.atlassian.net/browse/GOVPUB-29 |
|
MIDDLE_NAME |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
STUDENT_NAME | Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
ADDRESS |
| DONE |
CITY |
| DONE |
STATE |
| DONE |
ZIP |
| DONE |
BIRTH_DATE |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
AGE_AT_TERM_START |
| DONE |
ETHNICITY | Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | INVOKE IS CREATING THIS |
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 |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | DONE |
PHONE |
| REQUIRES RESEARCH VALIDATION |
CELL_PHONE | https://sequoias.atlassian.net/browse/GOVPUB-12 | |
PERSONAL_EMAIL | ||
MARITAL_CODE |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | |
DEPENDENT | ||
VISA_TYPE | ||
RESD_CODE | https://sequoias.atlassian.net/browse/GOVPUB-34
| |
RESD_DESC | GOVPUB-34 - Getting issue details... STATUS | |
PARENT_EDLV_1_CODE | https://sequoias.atlassian.net/browse/GOVPUB-31
| |
PARENT_EDLV_1_DESC | GOVPUB-31 - Getting issue details... STATUS | |
PARENT_EDLV_2_CODE | GOVPUB-31 - Getting issue details... STATUS | |
PARENT_EDLV_2_DESC | GOVPUB-31 - Getting issue details... STATUS | |
HIGHSCHOOL |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | |
ENGL_PLACE Previously named ENG251_ELIG | Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | |
ENGL_TEST_DATE Previously named ENG_TEST_DATE | Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | |
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 |
Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. | |
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 |
| HOLDNEEDS VALIDATION Research assessing what STUDENT_TERM columns would be useful for GPA/HRS/Units |
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 | 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 | https://sequoias.atlassian.net/browse/GOVPUB-18
| |
DRC_CODES | https://sequoias.atlassian.net/browse/GOVPUB-20
| |
VTEA | https://sequoias.atlassian.net/browse/GOVPUB-17
| |
PUENTE | Code saved on my laptop, waiting for place to store it and verification of changes for updated way of calculating. | |
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 Student Success, COMING SOON | https://sequoias.atlassian.net/browse/AP-357 |
Add Comment