Data Source	Oracle
Job/Process Source (Refresh Interval)	Live Data
Report Domain	High school student registration data
Functional User(s)	Regina Trevino, Nina Gomez, Arianna Kennedy, Maira Zavala
Constituent(s)
Report Owner	Regina Trevino
Data Domain(s)	Academic
Contains PII	Yes

What It’s Used For

A standard report for high school students who have registered for a term. Lists various data points that will be described below.

Options

Options	Description

Options	Description
Term	Select the term of interest.
ENGL 001	Checkbox to filter the results down to only students registered in ENGL 001
No ENGL	Checkbox to filter the results down to all records that do not contain a course in ENGL.

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
BANNER_ID	SPRIDEN_ID	Student’s Banner ID
STUDENT_NAME	`SPRIDEN_LAT_NAME`, `SPRIDEN_FIRST_NAME`, `SPRIDEN_MI`	Full name of the student.
EMAIL	`COS_F_GET_EMAIL_STU()`	Student’s @giant.cos.edu email.
PHONE	`COS_GENERAL.F_GET_PHONE()`	Student’s primary phone number.
AGE	`SPBPERS_BIRTH_DATE`	Age calculation based on date of birth
DOB	`SPBPERS_BIRTH_DATE`	Listed date of birth
COURSE	`SSBSECT_SUBJ_CODE`, `SSBSECT_CRSE_NUMB`	The registered course.
HIGH_SCHOOL	`STVSBGI_DESC`	Student’s graduation high school name

Version	Date	Comment
Current Version (v. 1)	Feb 03, 2025 17:44	Michael Citi