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`	Campus
BUILDING_ROOM	GOVPUB-110 - Getting issue details... STATUS
CRN	`SZREARL_CRN`	Course Identifier / Number
SUBJECT_NUM	functional view reference jira	Alphanumeric course number, such as 031 or 13L
COURSE	function view reference jira	Title of the course
FACULTYNAME	GOVPUB-29 - Getting issue details... STATUS	Faculty Name
FACULTYID	`SIRASGN_PIDM`	Faculty ID
SZREARL_PIDM	PIDM	PIDM of the student ID
LAST_NAME	GOVPUB-29 - Getting issue details... STATUS
FIRST_NAME	GOVPUB-29 - Getting issue details... STATUS
STUDENTID	`SZREARL_PIDM`	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

FV References

Version	Date	Comment
Current Version (v. 3)	Feb 27, 2025 18:34	Farzan Yazdani
v. 4	Feb 28, 2025 17:07	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