StudentHolds table

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