Dismissed Students W/ Override
- Joshua Metry
Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | Â Velia Rodriguez |
Report Owner | Velia Rodriguez |
Data Domain(s) | Admissions and Records |
Contains PII | Yes |
What It’s Used For
Velia uses this report to see if students that were given an override are taking classes and if so how many units.
Options
Options | Description |
|---|---|
Override Dismissed | Choose the Term for which you want to look for an Override of being dismissed |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
SPRIDEN_ID |
| The Student ID that received the Override. |
SPRIDEN_LAST_NAME |
| The last name of the Student. |
SPRIDEN_FIRST_NAME |
| The first name of the Student. |
MAX_UNITS |
| The maximum units that can be taken based off the CAST code added for the override. |
SUBJECT |
| The Subject of the course taken |
COURSE |
| The Course Number |
CRN |
| the CRN of the Course taken |
SFRSTCR_GRDE_CODE |
| The Grade received in the class if one is available. |
TERM_DISMISSED |
| The Minimal term code with a dismissed ASTD code. |
Report Domain
This report is built off several tables in the SATURN schema for such as SGBSTDN, STVCAST, SFRSTCR, STVRSTS, SPRIDEN SSBSECT and SHRTTRM to pull together the information required for Admissions and Records.