Versions Compared

Version Old Version 3 New Version 4
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 excerptStudent (page 1)Student (page 1)namestudent_table_1nopaneltrue Insert excerptStudent (page 2)Student (page 2)namestudent_table_2nopaneltrue Insert excerptStudent (page 3)Student (page 3)namestudent_table_4nopaneltrueProposed 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.

Info

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.
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.