Early Alert
- Farzan Yazdani
Data Source | Snowflake PROD_DB |
|---|---|
Job/Process Source (Refresh Interval) | Nightly refreshed data
|
Report Domain | Data from BannerWeb where Early Alert is inserted |
Functional User(s) | Faculty, Student Services |
Constituent(s) | |
Report Owner | Not identified |
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 an Early Alert and student related characteristic, which an instructor can filter and provide service to the student. Also it is a way for faculty to work with student programs (and vice versa) to support students.
Options
Options | Description |
|---|---|
Term | |
Student ID | |
Campus | Campus associated with the related CRN |
Group | Determines what group(s) the student is a part of. (EOPS, SSP, CalWORKs, etc.) |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
TERM_CODE |
|
|
CAMPUS |
|
|
BUILDING_ROOM | GOVPUB-110: BUILDING & ROOM OF CRN OR EVENTDone
|
|
CRN |
| Course Identifier / Number |
COURSE | Combination of Course Subject and Course Number (SUBJ_CODE CRSE_NUMB) | |
COURSE_TITLE | Title of the course | |
FACULTY | Faculty Name | |
FACULTY_ID |
|
|
LAST_NAME |
| |
FIRST_NAME |
| |
STUDENT_ID |
|
|
NEED_ALERT |
|
|
GRADE |
|
|
ACTIVITY_DATE |
| Activity date of the Early Alert record |
ATTENDANCE |
| Flag of student's attendance |
PARTICIPATION |
|
|
HOME |
|
|
TEST |
|
|
COMPREHENSION |
|
|
TUTOR |
|
|
DROP |
|
|
SEE |
|
|
AAC |
|
|
COMMENTS |
|
|
Other Dependencies
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 5) | Feb 28, 2025 18:08 | 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 |