Each record describes a hold code for a student. This table includes unregistered students as well as registered students, unlike the Student table which only contains registered students. The hold is effective for the dates between the From_Date and To_Date field values. The Term is attempted to be parsed from the Reason field, but sometimes the Reason field does not include the term. In that case, the Term field will be null. These example records show a student that has 3 holds for the 200520 term:
PIDMTERMHLDD_CODEFROM_DATETO_DATEREASONACTIVITY_DATE
6643200520351/3/20055/31/2005Need Orientation - 2005201/3/2005 8:46:13 AM
6643200520371/3/2005 5/31/2005Need Ed Plan - 2005201/3/2005 8:46:13 AM
6643200520381/3/2005 5/31/2005Need Assessment - 2005201/3/2005 8:46:13 AM
Oracle source: ReportsNet.Student_Holds view
Oracle objects: BANINST1.COS_SV_TAGS
Updated: nightly
Oracle Field/Calc | DW Field | Description or Sample |
PIDM | PIDM | Up to 10-digit unique Banner id for student |
substr(f_find_term_in_string(h.REASON),1,6) | TERM | The term at which the hold code became active, if it can be determined. This code is parsed from the Reason field. If no term can be determined in that field, then this field is null. |
SPRIDEN_ID | STUDENTID | Banner Id (@12345678) |
SSN | SSN | Social Security Number |
nvl(spriden_last_name, '') || ', ' || nvl(spriden_first_name, '') || ' ' || nvl(spriden_mi, '') | STUDENTNAME | |
HOLD_CODE | HOLD_CODE | Hold Code. See Hold Code in Appendix |
HOLD_DESC | HOLD_DESC | Hold Code description from STVHLDD |
FROM_DATE | FROM_DATE | The beginning effective date |
TO_DATE | TO_DATE | The end effective date |
RELEASE_IND | RELEASE_IND | A ‘Y’ indicates that only the user who initiated the record may release the hold |
REASON | REASON | Hold reason / description |
AMOUNT | AMOUNT_OWED | Monetary amount owed, if any |
decode(h.Phone_Area, null, h.Phone_No, '(' || h.Phone_Area || ') ' || h.Phone_No) | PHONE |
Add Comment