Each record describes a student and their information for each term. In order to be in this table, the student has to be registered for classes for the term on the record AND have shown up to class. The vStudent view in the Data Warehouse’s StudentNet database contains a subset of the fields from this table as well as a CALC_RACE_ETHN field which is an ethnicity code derived from Ethnicity, New Ethnicity, Visa Type, and Race information of the student. This field is a calculation provided by Tim Garner and Ryan Barry-Souza of the Research department (this also is included in the Applicant table).
| Info |
|---|
SGBSTDN (SGASTDN Front End Page) snapshots SORCMJR/SOACURR data and keeps that on the student’s record. |
Oracle source: ReportsNet.Student view
Oracle objects: SFBETRM, SPRADDR, SPRIDEN, SPRTELE, SPBPERS, STVTERM, SGBSTDN
Updated: Nightly
Insert excerpt
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.
| Info |
|---|
More information available here: |
- 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.
| Note |
|---|
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 |
|
| ||||||||||||||||
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 |