Early Alert
- Farzan Yazdani
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 |
| Term code |
CAMPUS |
| Campus |
BUILDING_ROOM | GOVPUB-110: BUILDING & ROOM OF CRN OR EVENTDone
|
|
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 | Faculty Name | |
FACULTYID |
| Faculty ID |
SZREARL_PIDM | PIDM | PIDM of the student ID |
LAST_NAME |
| |
FIRST_NAME |
| |
STUDENTID |
| Student banner ID |
NEED_ALERT |
| Student needs an alert |
GRADE |
| Student grade |
SZREARL_ACTIVITY_DATE |
| Early alerts activity date |
Atnd |
| Attendance |
Part |
| Participation |
Home |
| Homework |
Test |
| Test Performance |
Comp |
| Comprehension |
Tutr |
| Tutor |
Drop |
| Drop |
See |
| See |
DRC |
| AAC |
Comments |
| COMMENTS |
FV References
| Version | Date | Comment |
|---|---|---|
| Current Version (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 |