Versions Compared

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 excerpt
Student table (page 1)
Student table (page 1)
namestudent_table_1
nopaneltrue

Insert excerpt
Student table (page 2)
Student table (page 2)
namestudent_table_2
nopaneltrue

Insert excerpt
Student table (page 3)
Student table (page 3)
namestudent_table_4
nopaneltrue