Data Source | Snowflake ProdPROD_DB |
|---|---|
Job/Process Source (Refresh Interval) | Nightly refreshed data |
Report Domain | Data from banner web where early alert BannerWeb where Early Alert is inserted |
Functional User(s) | Faculty, Student servicesServices |
Constituent(s) | |
Report Owner | Not identified |
Data Domain(s) | Academic |
Contains PII | Yes |
...
Early Alert is designed to help students be successful at College of the Sequoias. This is a report for students that has a 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 | 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 |
| ||||||||||
Student ID |
| |||||||||||
Campus | Campus associated with the related CRN | |||||||||||
Group | Determines what group(s) is the student is a part of. (EOPS, SSP, CalWORKs, Calworks etc.) |
📄 Results
Field Name | Data Source/Logic | Description (sample) | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
TERM_CODE |
| ||||||||||
CAMPUS |
| Campus | |||||||||
BUILDING_ROOM |
| ||||||||||
CRN |
| Course Identifier / Number | |||||||||
SUBJECT_NUMCOURSE |
| Alphanumeric course number, such as 031 or 13L | COURSECombination of Course Subject and Course Number (SUBJ_CODE CRSE_NUMB) | ||||||||
COURSE_TITLE |
| Title of the course | |||||||||
FACULTYNAMEFACULTY |
| Faculty Name | |||||||||
FACULTYID |
| Faculty ID | |||||||||
SZREARL_PIDM | PIDM | PIDM of the student IDFACULTY_ID |
| ||||||||
LAST_NAME |
| ||||||||||
FIRST_NAME |
| ||||||||||
STUDENTID |
| Student banner IDSTUDENT_ID |
| ||||||||
NEED_ALERT |
| Student needs an alert | |||||||||
GRADE |
| ||||||||||
SZREARL_ACTIVITY_DATE |
| Early alerts activity date | AtndActivity date of the Early Alert record | ||||||||
ATTENDANCE |
| Attendance | PartFlag of student's attendance | ||||||||
PARTICIPATION |
| Participation | |||||||||
HomeHOME |
| Homework | |||||||||
TestTEST |
| Test Performance | |||||||||
CompCOMPREHENSION |
| Comprehension | |||||||||
TutrTUTOR |
| ||||||||||
TutorDROP | Drop |
| Drop | ||||||||
SeeSEE |
| ||||||||||
SeeAAC | DRC |
| |||||||||
AACCOMMENTS | Comments |
|
🐤 Other Dependencies
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...