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 | STUDENT_TERM.TERM_CODE
|
DOC:DOC: | Common Definitions |
|---|
| name | term_code |
|---|
| nopanel | true |
|---|
|
| |
TERM | STUDENT_TERM.TERM
|
DOC:DOC: | Common Definitions |
|---|
| name | TERM |
|---|
| nopanel | true |
|---|
|
| |
BANNER_ID | STUDENT_TERM.STUDENT_ALTERNATE_ID
|
DOC:DOC: | Common Definitions |
|---|
| name | studentid |
|---|
| nopanel | true |
|---|
|
| |
SSN | APPLICATION.APPLICATION_SSN
|
DOC:DOC: | Common Definitions |
|---|
| name | SSN |
|---|
| nopanel | true |
|---|
|
| |
PIDM | STUDENT_TERM.STUDENT_ID
|
DOC:DOC: | Common Definitions |
|---|
| name | PIDM |
|---|
| nopanel | true |
|---|
|
| |
CCCID | APPLICATION_CCC_ID
| |
LAST_NAME | STUDENT_TERM.STUDENT_LAST_NAME
|
DOC:DOC:DOC:DOC: | Common Definitions |
|---|
| name | MIDINIT |
|---|
| nopanel | true |
|---|
|
| |
STUDENT_NAME | |
DOC:DOC: | Common Definitions |
|---|
| name | STUDENTNAME |
|---|
| nopanel | true |
|---|
|
| |
ADDRESS | STUDENT_TERM.STUDENT_ADDRESS_STREET_1
| |
CITY | STUDENT_TERM.STUDENT_ADDRESS_CITY
| |
STATE | STUDENT_TERM.STUDENT_ADDRESS_STATE
| |
ZIP | STUDENT_TERM.STUDENT_ADDRESS_POSTAL_CODE
| |
BIRTH_DATE | STUDENT_TERM.STUDENT_BIRTH_DATE
|
DOC:DOC: | Common Definitions |
|---|
| name | BIRTHDATE |
|---|
| nopanel | true |
|---|
|
| |
AGE_AT_TERM_START | STUDENT_TERM.AGE
| |
ETHNICITY | |
DOC:DOC:DOC:DOC:DOC:DOC: JIRA JIRA| Jira | | serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | GOVPUB-31 |
|---|
|
| |
PARENT_EDLV_2_CODE | |
JIRA| Jira | | serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | GOVPUB-31 |
|---|
|
| |
PARENT_EDLV_2_DESC | |
JIRA| Jira | | serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | GOVPUB-31 |
|---|
|
| |
HIGHSCHOOL | APPLICATION.APPLICATION_NAME_HSCH
|
DOC:DOC: | Common Definitions |
|---|
| name | HIGHSCHOOL |
|---|
| nopanel | true |
|---|
|
| |
ENGL_PLACE Previously named ENG251_ELIG | |
DOC:DOC: | Common Definitions |
|---|
| name | ENG251_ELIG |
|---|
| nopanel | true |
|---|
|
| |
ENGL_TEST_DATE Previously named ENG_TEST_DATE | |
DOC:DOC: | Common Definitions |
|---|
| name | eng_test_date |
|---|
| nopanel | true |
|---|
|
| |
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 | STUDENT_TERM.STUDENT_TERM_PROGRAM_CODE
| |
PROG_DEPT | | |
PROG_GE_PATTERN | | |
MAJOR_CODE | STUDENT_TERM.STUDENT_TERM_MAJOR_CODE
| |
MAJOR | STUDENT_TERM.STUDENT_TERM_MAJOR
|
DOC:DOC:COHORTS | Info |
|---|
Student Success,
COS Foundation |
| https://sequoias.atlassian.net/browse/AP-357