Degree Work Audit In-progress Check
- Ryan W
Data Source | Snowflake |
|---|---|
Job/Process Source (Refresh Interval) | Nightly |
Report Domain | DW_PROD_DWSCHEMA_RAD_CLASS_DTL, COSBANNERPROD_SATURN_SPRIDEN, COSBANNERPROD_SATURN_SHRTCKN, COSBANNERPROD_SATURN_SHRTCKG |
Functional User(s) | Justine Kincade (Resource Specialist: DA&E • Matriculation) |
Constituent(s) | Yee Lee (Adm & Rec Equivalence Spec • Admissions & Records) |
Report Owner | Justine Kincade (Resource Specialist: DA&E • Matriculation) |
Data Domain(s) | ACAD |
Contains PII | Yes |
What It’s Used For
The report looks for an in-progress status in Degree Works when a final grade has been rolled for a course in Banner.
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
Bannerid | RAD_ID | Banner ID of the student |
First Name | SPRIDEN_FIRST_NAME | First name of the student |
Last Name | SPRIDEN_LAST_NAME | Last Name of the student |
DGW Grade | RAD_FINAL_GRADE | Grade listed on the student’s Degree Works Audit |
CRN | RAD_CRN | CRN listed on the student’s Degree Works Audit |
Term | RAD_TERM | Term listed on the student’s Degree Works Audit |
Ban Grade | SHRTCKG_GRDE_CODE_FINAL | Final Banner grade for the student for the CRN and term. |
Â
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 1) | Jan 18, 2024 18:23 | Ryan W |