SQL Script setup for NSO

Problem Description : 

Instructions for various SQL Scripts that need to be setup for NSO

 Resolution : 

All scripts are in \\vulture\d\batch\nso and scheduled to run through the Task Manager on Vulture. Tasks are setup on Vulture under the NSO Tasks folder.

DO NOT USE ANYMORE

* registration_unlock.sql - unlocks NSO attendees based on sysdate time and NSO group time in decode statement that were checked-in through scan.

-- Edit script to have correct NSO semester and unlocks times for groups. Note comments in script related to Summer/Fall NSOs.

-- Uses sysdate to determine which NSO to check for scans

-- Schedule to run from 10:00am with repeat every 5 minutes for duration of 6 hours

* immun_extension_update.sql - updates Immunization checklist items and holds in Banner for NSO attendees that sign/scan an extension form during NSO check-in

-- Edit script to include correct NSO semester and hold from date (date proof of immunization deadline is extended to)

-- Update Banner Web info text for HTML_REGIS.p_immunization_extension para2 with extension deadline

-- Update HTML_REGIS.p_regis_tranguid package to update term

-- Uses sysdate to determine which NSO to check for scans

-- Schedule to run from 9:00am repeating everying 15mins for 12 hours

DO NOT USE ANYMORE

* r30_r11_update.sql - updates timetickets R30 and R35 to R11 so NSO attendees can make schedule changes after leaving NSO

-- Update to include correct NSO term(s)

-- Uses sysdate to determine which NSO to check for scans

-- Schedule to run once at 5:00pm      

 Revision Date : 1/4/2016