Data Source | Oracle & Data Warehouse |
|---|---|
Job/Process Source (Refresh Interval) | Live production data and Day old data from Data Warehouse |
Functional User(s) | Christy Ortega |
Constituent(s) | Arianna Kennedy |
|---|---|
Report Owner | Michele Brock |
Data Domain(s) | Academic |
Contains PII | Yes |
🛠 What It’s Used For
Reporting on the wide ranging student holds. This report can be narrowed down to a single term, student, hold code, CRN, and/or date range.
🔘 Options
Options | Description | ||||||
|---|---|---|---|---|---|---|---|
Term | Choose from any term (current and older). You can also select “All” which will look through all terms, or “Holds With No Term” to find holds not associated with any term. | ||||||
| From: A starting date range of your choosing. Leave blank for any beginning date. To: An ending date range of your choosing. Leave blank for any end date. Also leave blank if you need to find holds with a To Date of “12/31/2099” | ||||||
Student ID | Manually type out a student’s banner ID (including the @ symbol) to filter by a single student ID. | ||||||
Hold Code | This drop down provides some hard coded drop codes and some that are programmatically added depending on which term selection is used. Note: If a hold code doesn’t show up in this drop down using the term value you selected, it may not exist in that term. Try changing to “All” or “Holds With No Term” in the Term drop down list. | ||||||
CRN | Finds students that were enrolled in a specific CRN. | ||||||
Campus - Include “No Campus” | This checkbox allows for the report to find students who’s hold is not associated with a campus. | ||||||
Campus - List | A list containing all available campuses that have holds within the given term selection. These are multi-selectable by holding CTRL and Left-Clicking the campuses you want to use. |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
STUDENTID |
| Banner ID |
TERM |
| Extracted from the |
STUDENTNAME |
| Combination of last, first and middle name. |
HOLD_CODE |
| The hold code |
HOLD_DESC |
| The related description from the validation table |
FROM_DATE |
| Start date of the hold |
TO_DATE |
| End date of the hold, or 12/31/2099 |
RELEASE_IND |
| 'Y' = Only system user who entered the hold can release it. |
REASON |
| Reason for the hold |
AMOUNT_OWED |
| Amount owed for the hold (if exists) |
PHONE |
| Area code and phone number |
CAMPUSES |
| Extracted from |
REG_HOLD_IND |
| Hold type prevents registration. |
TRANS_HOLD_IND |
| Hold type prevents transcript generation. |
GRAD_HOLD_IND |
| Hold type prevents graduation. |
GRADE_HOLD_IND |
| Hold type prevents grade report generation. |
ENV_HOLD_IND |
| Enrollment verification hold indicator. |
| Student’s email address | |
STREET |
| Street section of the student’s address |
CITY_ST_ZIP |
| City state and zip code for student’s address. |
ADDRESS |
| Combined street and city_st_zip columns for the complete address. |
🗺 Report Domain
...
| Change History |
|---|