.
 

Enterprise Systems

 

Globe and planet

     

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:  

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: 

Technical Notes
    AppWorx Chain      NAID_NIGHTLY
  Job   WRP6100
  Package   wkraunp
  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:  

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:  

 

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:   

 

Technical Notes
    AppWorx Chain      NAID_NIGHTLY
  Job   WSR5120
  Package   wksrsmp
  Procedure   p_set_loaded_into_banner