Data Source	Snowflake Prod_DB
Job/Process Source (Refresh Interval)	Nightly refreshed data
Report Domain	Data from banner web where early alert is inserted
Functional User(s)	Faculty, Student services
Constituent(s)
Report Owner
Data Domain(s)	Academic
Contains PII	Yes

🛠 What It’s Used For

Early Alert is designed to help students be successful at College of the Sequoias. This is a report for students that has a Early Alert and student related characteristic, which an instructor can filter and provide service to the student.

🔘 Options

Options	Description
Term	Semester YYYY is the typical format for how this description field is populated. (Fall 2025)
Student ID	Student banner ID.
Campus	Campus that the building is located
Group	Determines what group(s) is the student part of. (EOPS, SSP, Calworks etc.)

📄 Results

Field Name	Data Source/Logic	Description (sample)
TERM	`SZREARL_TERM_CODE`	Term code
CAMPUS	`SSBSECT_CAMP_CODE`
CRN	`SZREARL_CRN`
SUBJECT_NUM	functional view reference jira
COURSE	function view reference jira
FACULTYNAME	GOVPUB-29 - Getting issue details... STATUS
FACULTYID	`SPRIDEN_ID`	Faculty ID
SZREARL_PIDM	PIDM
LAST_NAME	GOVPUB-29 - Getting issue details... STATUS
FIRST_NAME	GOVPUB-29 - Getting issue details... STATUS
STUDENTID	`SPRIDEN_ID`	Student banner ID
NEED_ALERT	`SZREARL_NEED_ALERT`	Student needs an alert
GRADE	`SZREARL_GRDE_CODE`	Student grade
SZREARL_ACTIVITY_DATE	`SZREARL_ACTIVITY_DATE`	Early alerts activity date
Atnd	`SZREARL_CATEGORY_1`	Attendance
Part	`SZREARL_CATEGORY_2`	Participation
Home	`SZREARL_CATEGORY_3`	Homework
Test	`SZREARL_CATEGORY_4`	Test Performance
Comp	`SZREARL_CATEGORY_5`	Comprehension
Tutr	`SZREARL_CATEGORY_6`	Tutor
Drop	`SZREARL_CATEGORY_7`	Drop
See	`SZREARL_CATEGORY_8`	See
DRC	`SZREARL_CATEGORY_9`	AAC
Comments	`SZREARL_COMMENT`	COMMENTS

Version	Date	Comment
Current Version (v. 1)	Feb 27, 2025 18:10	Farzan Yazdani
v. 3	Feb 27, 2025 18:34	Farzan Yazdani
v. 2	Feb 27, 2025 18:32	Farzan Yazdani
v. 1	Feb 27, 2025 18:10	Farzan Yazdani