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_NUM | functional view reference jira | Alphanumeric course number, such as 031 or 13L | ||||||||||
COURSE | function view reference jira | COURSE |
| Combination of Course Subject and Course Number (SUBJ_CODE CRSE_NUMB) | ||||||||
COURSE_TITLE |
| Title of the course | ||||||||||
FACULTYNAMEFACULTY |
| Faculty Name | ||||||||||
FACULTYID | SPRIDENFACULTY_ID | Faculty ID | ||||||||||
SZREARL_PIDM | PIDM | PIDM of the student ID | ||||||||||
| ||||||||||||
LAST_NAME |
| |||||||||||
FIRST_NAME |
| |||||||||||
STUDENTID | SPRIDENSTUDENT_IDStudent banner 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 |
| |||||||||||
ParticipationHOME | Home |
| Homework | |||||||||
TestTEST |
| |||||||||||
Test PerformanceCOMPREHENSION | Comp |
| ||||||||||
ComprehensionTUTOR | Tutr |
| Tutor | |||||||||
DropDROP |
| Drop | ||||||||||
SeeSEE |
| See | ||||||||||
DRCAAC |
| |||||||||||
AACCOMMENTS | Comments |
| COMMENTS |
...
🐤 Other Dependencies
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
| Change History |
|---|