Create a trigger to release the DA hold

Problem statement

Students who graduate from TU in one term and are admitted to a new program in the next term have a DA Grad App Recvd Hold preventing registration. The DA hold expires automatically, but the new-department programs prefer that students be allowed to register upon confirming/depositing in the new program.

Logic

1. Upon entry of an Applicant Acceptance admissions decision code (codes attached) in SAADCRV/SARAPPD.SARAPPD_APDC_CODE,

2. Determine if an active or future DA hold exists.

   1. DA code field is SPRHOLD.SPRHOLD_HLDD_CODE

   2. Active means [the From Date is before today or today] AND [the To Date is after today].

   3. Future means the From Date is after today.

   4. From date field is SPRHOLD.SPRHOLD_FROM_DAT

3. Then, take action.

   1. No active or future hold means no action is needed.

   2. If the hold is active, change the To Date to today’s date.

   3. If the hold is future, change the To Date to the From date.

Practical examples

Today’s date is 6/28/24

Status notes