Skip to Main Content

Scholarship Management System

Award Change Report


For the Scholarship Management System, produce a list of Award Changes that have been approved but have not been loaded into Banner.  These awards must be entered manually.

 

The report is sent to Q:\FinAid\SMS Processing.

 

Technical Notes:  

AppWorx Chain NAID_NIGHTLY
Job WSR1000
Package wksrsmp
Procedure p_award_change_report

  



Load Foundation Scholarships


This process selects the scholarships from the Scholarship Management System that are in an Offered status and have been through the approval process.  The process attempts to load each scholarship into Banner.  There are reports that include information regarding each scholarship and whether or not the scholarship was loaded successfully.  There is a separate report for athlete as they cannot be loaded automatically. 

 

Technical Notes: 

AppWorx Chain NAID_NIGHTLY
Job WRP6100
Package wkrclyr
Procedure p_update_fdn_schl

  



Set Offered to Active


Set award status from Offered to Active for awards that have been loaded into Banner. 

 

The report is sent to Q:\FinAid\SMS Processing.

 

Technical Notes:  

AppWorx Chain NAID_NIGHTLY
Job WSR5110
Package wksrsmp
Procedure p_set_offered_to_active

   



Update Donor Information


Donor information from Raiser's Edge is copied into a temporary table in the NFVIEW schema. 


This process will update the Scholarship Management System donor table (WTSRDNR) in the NFSTU schema from this table.


Donors will be updated and inserted but not deleted.

 

Technical Notes:  

 

AppWorx Chain NAID_NIGHTLY
Job WSR5200
Package wksrsmp
Procedure p_update_donors

 



Update Loaded into Banner Checkbox


Once awards have been loaded into Banner using the process (WRP6100) then this process will run to update the award to indicate that the award has been loaded into Banner.

 

Technical Notes:   

 

AppWorx Chain NAID_NIGHTLY
Job WSR5120
Package wksrsmp
Procedure p_set_loaded_into_banner