Scholarship/ Other Aid Packaging Rules
Scholarship/ Other Aid Packaging Rules
The Other Packaging Rules page allows a user to create rules to package scholarship/other awards.
Basic rules can be created then be used to add non-Pell/Direct Loan aid to a list of students from the student finder.
Advanced SQL query rules can be created to assign aid to a student through the F/A Auto Packaging process.
Users must have Permission 984 to access these features.
Creating Scholarship Disbursement Schedules on Term Rules
Before being able to create a Scholarship/Other Packaging Rule, the disbursement schedule and dates must be established on the Term Disbursement Rules page. Please reference the Term Disbursement Rules page for more detailed information on how to create a Term Rule.
- On Student Financials > F/A Disbursement Term Rules page click "Add"
- Select "INTERNAL" from Packaging Award Type (Award Codes must be created with the Packaging Award Type "INTERNAL" in F/A Code Maintenance to be used in this process.)
- Select Financial Aid Award Year that will be used for this scholarship.
- Select any other field that would be applicable and click add.
- Select the Award Code from the dropdown, select the percentage of aid for this disbursement, scheduled semester, scheduled date, and Academic Year (See Term Rules). Award, Payment Period, and Academic Year date fields may be optional for term based schools; Academic Year might be necessary for BBAY schools with more than 1 Academic Year.
- Once all of the scholarships have been created in Term Rules, the "admin servlet" may need to be refresh the Other Packaging Rules with the new scholarship disbursements.
Creating Basic Scholarship/Other Packaging Rules
- Navigate to Student Financials > F/A Other Packaging Rules
- Click "Add" to create new rule
- Type the name of this rule to display to users
- Select Award Code
- Select Year
- Input the Total Scholarship amount for period (If the selected term rule is created with two 50% disbursements, this amount would be split in half.)
- Choose the Award Term Rule schedule (these schedules are created on the Term Rulespage)
- The selected rule will reveal the award schedule that would be applied.
- Click "Enabled" to allow this rule to be used for either student finder or auto packaging
- Click "Save"
The Other Packaging Rule Page will now display the rules that have been created.
Creating Advanced SQL Packaging Rules
Advanced SQL rules can be created to auto-assign an award to a student upon packaging when they meet the criteria expressed in the query.
Advanced SQL rules that are not thoroughly tested could potentially lead to awarding of aid incorrectly
- To create an advanced rule, please follow the directions in the prior sections
- Once the rule has been created click the Caret Dropdown Icon to reveal SQL Query test window.
- A "Select ID_NUMBER" query can then be written and testing from this window.
- Note: The sql query must be written to select only the ID_NUMBER from whatever table is used, otherwise it will not return any students or allow you to save as a usable advanced rule.
- Once written, click "Test" to reveal the results of the query to verify that the correct students are being pulled
- Example: The screenshot is an advanced rule that will re-apply an academic scholarship for a student who has received a scholarship in the prior year who is meeting a 3.5 GPA requirement.
- Once your query results are satisfactory, click "Save" to convert this rule to an advanced rule.
Packaging Basic Rules From Student Finder
- Navigate to Student Finder
- Use Saved filter or create new listing of students by using filters
- Once a list has been generated click "To Other Packaging" button
- The group of students brought from the finder will now appear at the top of the packaging rules page to review once again.
- Select the Award Rules that you would like to package for this group of students
- Click Package Selected to create the awards for these students.
Advanced Rule Packaging Process
- Once a Packaging Rule has been created and tested with a valid SQL query it will be saved as an advanced rule as described prior.
- If the rule has been enabled from the edit rule page, the packaging query is now live, if the enabled is unchecked, then the rule will not run when packaging students. This can be used for testing rules without enabling them.
- Whenever auto packaging is run for one or multiple selected students, the Advanced packaging query rule is run, if the selected students for packaging are found by that query upon auto-packaging, the awards are then applied to the student(s).
- Note: That if a student has awards that have already been disbursed under the same financial aid Award Year, the system will not package the student.