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 | Not identified |
Data Domain(s) | Academic |
Contains PII | Yes |
...
Field Name | Data Source/Logic | Description (sample) | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
TERM |
| 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 |
| 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 |
...
🐤 Other Dependencies
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
| Change History |
|---|