Column | Definition | Status |
|---|
TERM_CODE | STUDENT_TERM.TERM_CODE
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | term_code |
|---|
| nopanel | true |
|---|
|
| |
TERM | STUDENT_TERM.TERM
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | TERM |
|---|
| nopanel | true |
|---|
|
| |
BANNER_ID | STUDENT_TERM.STUDENT_ALTERNATE_ID
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | studentid |
|---|
| nopanel | true |
|---|
|
| |
SSN | APPLICATION.APPLICATION_SSN
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | SSN |
|---|
| nopanel | true |
|---|
|
| |
PIDM | STUDENT_TERM.STUDENT_ID
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | PIDM |
|---|
| nopanel | true |
|---|
|
| |
CCCID | APPLICATION_CCC_ID
| |
LAST_NAME | STUDENT_TERM.STUDENT_LAST_NAME
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | Lastname |
|---|
| nopanel | true |
|---|
|
| |
FIRST_NAME | https://sequoias.atlassian.net/browse/GOVPUB-29 | |
MIDDLE_NAME | STUDENT_TERM.STUDENT_MIDDLE_NAME
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | MIDINIT |
|---|
| nopanel | true |
|---|
|
| |
STUDENT_NAME | | Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF: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
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | BIRTHDATE |
|---|
| nopanel | true |
|---|
|
| |
AGE_AT_TERM_START | STUDENT_TERM.AGE
| |
ETHNICITY | | Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | RACE_ETHN_CDE |
|---|
|
| | Status |
|---|
| colour | Red |
|---|
| title | 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 | SPBPERS_CONFID_IND
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | confidential_indicator |
|---|
| nopanel | true |
|---|
|
| |
PHONE | STUDENT_TERM.STUDENT_PHONE_NUMBER or:
https://sequoias.atlassian.net/browse/GOVPUB-19 | | Status |
|---|
| colour | Yellow |
|---|
| title | Requires Research Validation |
|---|
|
|
CELL_PHONE | https://sequoias.atlassian.net/browse/GOVPUB-12 | |
EMAIL | | |
PERSONAL_EMAIL | | |
MARITAL_CODE | APPLICATION.APPLICATION_MARITAL_STAT
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | MARITAL_CODE |
|---|
| nopanel | true |
|---|
|
| |
DEPENDENT | | |
VISA_TYPE | https://sequoias.atlassian.net/browse/GOVPUB-35 | |
RESD_CODE | https://sequoias.atlassian.net/browse/GOVPUB-34 | |
RESD_DESC | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | GOVPUB-34 |
|---|
|
| |
PARENT_EDLV_1_CODE | https://sequoias.atlassian.net/browse/GOVPUB-31 | |
PARENT_EDLV_1_DESC | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | GOVPUB-31 |
|---|
|
| |
PARENT_EDLV_2_CODE | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | GOVPUB-31 |
|---|
|
| |
PARENT_EDLV_2_DESC | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
| key | GOVPUB-31 |
|---|
|
| |
HIGHSCHOOL | APPLICATION.APPLICATION_NAME_HSCH
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | HIGHSCHOOL |
|---|
| nopanel | true |
|---|
|
| |
ENGL_PLACE Previously named ENG251_ELIG | | Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | ENG251_ELIG |
|---|
| nopanel | true |
|---|
|
| |
ENGL_TEST_DATE Previously named ENG_TEST_DATE | | Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF: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
| Insert excerpt |
|---|
| DOCBF:Common DefinitionsDOC |
|---|
| BF:Common Definitions |
|---|
| name | MAJOR_DESC |
|---|
| nopanel | true |
|---|
|
| |
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 | https://sequoias.atlassian.net/browse/GOVPUB-7 | |
OVERALL_GPA | STUDENT_TERM_OVERALL_GPA
| Research assessing what STUDENT_TERM columns would be useful for GPA/HRS/Units |
OVERALL_HRS_EARNED | STUDENT_TERM_OVERALL_HOURS_EARNED
| |
OVERALL_HRS_PASSED | STUDENT_TERM_OVERALL_HOURS_PASSED
| |
TRANSFER_IN_UNITS | | |
TRANSFER_IN_GPA | | |
TERM_GPA | STUDENT_TERM_GPA
| |
TERM_HOURS | STUDENT_TERM_HOURS_ATTEMPTED
| |
TERM_PASSED | STUDENT_TERM_HOURS_PASSED
| |
TERM_PASSED_ABC | | |
TERM_ACCUM_UNITS_ATT | STUDENT_TERM_OVERALL_HOURS_ATTEMPTED
| |
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 | 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 | 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,
COS Foundation |
| https://sequoias.atlassian.net/browse/AP-357 | |