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 |
| Term code | ||||||||
CAMPUS |
| |||||||||
BUILDING_ROOM |
| |||||||||
CRN |
| SUBJECT_NUM | functional view reference jira | COURSE | function view reference jira | FACULTYNAME | Course Identifier / Number | |||
COURSE |
| Combination of Course Subject and Course Number (SUBJ_CODE CRSE_NUMB) | ||||||||
COURSE_TITLE |
| Title of the course | ||||||||
FACULTY |
| FACULTYIDFaculty Name | ||||||||
SPRIDENFACULTY_ID | Faculty ID | SZREARL | PIDM | |||||||
LAST_NAME |
| |||||||||
FIRST_NAME |
| |||||||||
STUDENTID | SPRIDENSTUDENT_IDStudent banner ID |
| ||||||||
NEED_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 |
| Tutor | ||||||||
DropDROP |
| |||||||||
DropSEE | See |
| See | |||||||
DRCAAC |
| AAC | ||||||||
CommentsCOMMENTS |
|
🐤 Other Dependencies
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
| Change History |
|---|