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 |