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 | COURSE | function view reference jira |
| Alphanumeric course number, such as 031 or 13L | ||||||||
COURSE |
| 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 |
|---|