Remove Early Alert Holds

 Problem Description : 

How to remove the Early Alert holds.

 Resolution : 

In Toad:

select student.id(sprhold_pidm),student.name(sprhold_pidm), sprhold_activity_date from sprhold

--delete from sprhold

where sprhold_hldd_code = 'SB'

and sprhold_reason = 'Always Alert'

The select statement provides the list of the Early Alert holds. Run the delete statement to delete the Early Alert holds. 

 Revision Date : 8/21/2015

 Keywords : banner, delete