Validation Requirements
When the user tries to Save a new or edited Fund Group, the screen checks for the following validation rules. If validation passes, the system successfully updates the Fund Group configuration in the database.
"Save" records the following information:
- Created By - standard user identifier in the database
- Created On date/time
- Modified By - standard user identifier in the database
- Modified On date/time
- Deleted yes/no
- Deleted by
- Deleted on date/time
Validations:
- Group Name cannot be blank. Group Name must be unique (cannot duplicate another existing Group Name).
- At least one Fund must be Selected.
- All selected funds must share the same Fund Scope (FAY or AY).
- if FAY scoped, all funds must also share the same FAY / Alt-FAY dates.
- Individual fields pass validation for size/length and type.
- Required fields are not blank.
- Each group has at least one Max Amount Per Award Period.
- No Duplicate and Overlapping Constraint Sets - see below.
Duplicate and Overlapping Constraint Sets
The screen will prevent users from saving overlapping or duplicated sets of constraints (same FAY, overlapping effective dates, multiple blank Start dates, multiple blank End dates, etc.). The duplication prevention works similarly to Fund Set-up Screen Requirements, Amount Per Payment Period.
Multiple entries per FAY are allowed, but due to the effective date validation, the values configured in a single FAY should not be able to have overlapping effective date ranges
The Federal Award Year field is required for FAY scope funds, except if only a single data set is configured. If there is only a single data set it means that the amount(s) configured will apply to all FAYs.
This table allows, within a given FAY, one entry can have either a NULL end date OR a NULL Start Date, while still ensuring that effective date ranges entered for the values of a given FAY are not overlapping.
The system prevents overlapping ranges for limits.
- If no Federal Award Year or Effective dates are configured, the configured Flat Amount Per Payment Period and Amount Per Unit amounts will be used for the award for all FAYs and PPs. When FAY and Effective Date are blank, only one limit (one row of data) can be configured.
- Regent Award validates that the Effective Dates entered fall within the system configured effective date range for the FAY chosen. For example, if the FAY date range is July 1 to June 30, any data sets provided for a given FAY must fall within these specific dates.
- If a NULL value is provided for an Effective Start or End Date, it will be implied that the Start or End date aligns with the FAY date range. For example:
- Data Set 1 for 2019-2020: Null Start Date; End Date of Dec. 1, 2019; The implied Start Date is the system's FAY start date, either July 1 or the start date of one of the Alt-FAY values, depending on configuration.
- Data Set 2 for 2019-2020: Start Date of Dec. 2, 2019; Null End Date; The implied End Date is the system's FAY end date, either June 30 or the end date of one of the Alt-FAY values, depending on configuration.
Matching configured Amounts to Payment Periods:
- For FAY-scoped Funds, Regent Award will first match the FAY value configured to the FAY value on the payment period. This check is not performed for AY-Scoped funds.
- Then the system will validate that the payment period start date falls within the effective date range provided for a given set of per PP/per Unit values. If the payment period falls within the effective date range, the configured award amount will be used.
Data Requirements
Fund Group Setup - General tab
Fund Group Detail
Field Name | Description | Required / Optional | Type | Values | Business Rules |
---|---|---|---|---|---|
Fund Group Name | School-provided name. Required; Text - 1-50 characters | Required | Text | 1-50 characters | The Fund Group Name must be unique within the institution. In other words, fund group names cannot be duplicated across the Campuses within an Institution.
|
Fund Group External ID | School-provided Fund Group unique identifier. RNA does not use this field. However, it is added for possible future expansion with Client Configuration Management (aka Project Contour). Help text:
| Required | Text | 1-60 characters | Validations:
|
Fund Group Description | School-provided additional information | Optional | Text | 256 characters maximum |
Amount Limit Per Award Period
These fields specify a Maximum Amount that can be awarded for the selected programs, for all grouped funds within the same award period (per FAY or Academic Year).
The system first calculates award eligibility based on fund setup, packaging philosophy, and other rules. Then, the system awards each award in the fund group, in order of the packaging philosophy, up to the configured maximum for the fund group. Any calculated amounts above the configured maximum for the fund group will not be awarded.
The Maximum Amount may be optionally further configured to apply only to a specific FAY or Effective Date range. Award amounts from the fund group will be applied to the Maximum when the Payment Period Start Date falls during the FAY or within the Effective Date range, as applicable. The Effective End Date may be left blank until the maximum amount expires or needs to be changed.
Field Name | Description | Required / Optional | Type | Values | Business Rules |
---|---|---|---|---|---|
Max Amount Per Award Period | The school-provided upper limit for the total award amounts across all funds in the group. | Required | Text (numeric) | Positive numeric values, up to two decimal places | Positive numbers only. May enter positive integers, or decimals to two decimal places (pennies). A Fund Group must have at least one non-blank Maximum Amount to be saved. |
Federal Award Year | Optional per-FAY restriction for FAY-based funds. The payment period will use the Federal Award Year column along with the Effective Start Date and Effective End Date columns to determine if the fund group limit will apply for the amount configured. | Optional (see Business Rules) | Drop-down | Blank (Default) List of FAYs in CCYY-CCYY format (example: 2019-2020) | The setting applies to FAY-based funds only.
Optional (will not have any effect) if the selected funds are all AY-based. |
Effective Start Date | The school-provided date range for when the system will start to enforce the fund group's limits. | Optional (see Business Rules) | Combination date picker and date text entry. | Blank (Default) Dates | Effective Start Date is either Required or Optional, using the same validation rules as Fund Setup, Amount Per Payment Period
Displayed as mm/dd/yyyy American date format (no times) Regent Award will apply the limit to all payment periods having a Payment Period start date on or after the Effective Start Date, and an award period for the given limit. If the Effective Start Date is blank, then the system will limit all Payment Periods (in conjunction with the Effective End Date, if configured). |
Effective End Date | The school-provided date range for when the system will stop enforcing the fund group's limits. | Optional (see Business Rules) | Combination date picker and date text entry. | Blank (Default) Dates | Effective End Date is either Required or Optional, using the same validation as Fund Setup, Amount Per Payment Period
Displayed as mm/dd/yyyy American date format (no times) Regent Award will apply the limit to all payment periods having a PP start date on or before the Effective End Date. If the Effective End Date is blank, then the system will limit all Payment Periods (in conjunction with the Effective Start Date, if configured). |
Funds Association
Selects one or more funds to add to the Fund Group.
All the selected funds must share the same Fund Scope and the same Award Period. For example, if a fund has a Fund Scope of Federal Award Year in Fund Setup, all funds must also share the same Alternative FAY Schedule.
- When a user selects the first Fund, that fund's selection will filter the list of Available Funds to only show funds sharing the same fund scope as the selected Fund. The "Add All" button becomes available when at least one fund is selected.
- For the initial implementation, the user may only select funds that do not have any custom ruleset.
All selected Funds must have the same budget scope. When the first fund is selected, the screen will filter the Available Funds to only show other funds sharing the same fund scope and same award period. If the funds use an alternative Federal Award Year calendar, all the selected funds must also have the same Alt-FAY dates.
The system dynamically filters the list of Available Funds (behind the scenes), in addition to the normal user-entered text filters.
- On initial load or edit, the system filters the list to only show funds that use configuration-driven awarding.
- When the Selected Funds column contains a Fund, the system will additionally filter to the list of remaining funds to only allow funds with the same Fund Scope (FAY or AY), and the same Alt-FAY (for example, Jan 01 - Dec 31) as the already-selected Fund.
- Users can additionally filter for specific text values. If the user clears the user-entered text filters, the system will still filter the funds based on the scope of the current Selected Funds.
- If the user selects a fund, the system will filter the list of remaining Available Funds to match the same award period as the selected fund.
Limit - During packaging, the system will check each fund marked with "Limit" and ensure it does not exceed the group's overall maximum amount. The system will automatically adjust the award amounts from that fund.
Field Name | Description | Required / Optional | Type | Values | Business Rules |
---|---|---|---|---|---|
Add All | Button to add all funds in the Available Funds list to the Selected Funds. | N/A | Button | N/A | The Add All button is disabled until at least one fund is in the "Selected Funds" column. The enabling/disabling allows the screen to filter the group of available funds matching the same Fund Scope as the selected fund. The "Add All" button is Disabled if the Selected Funds list is completely empty. |
Remove All | Button to remove all funds in the Selected Funds list. | N/A | Button | N/A | The Remove All button is disabled until at least one fund is in the Selected Funds column. When a user clicks Remove All, the system removes all funds meeting the current display filters. The screen also disables the "Add All" button when no funds are selected, to allow filtering the funds based on Fund Scope. |
Available Funds
| List of available fund names. | Text (View-only) | Text | Fund names | The system will dynamically filter the list of Available Funds (behind the scenes), in addition to the normal user-entered text filters.
|
Add and Limit | Add and Limit button Help text:
| N/A | Button | N/A | When a user clicks Add and Limit next to a fund, the system adds the chosen fund to the Fund Group and displays the fund in the Selected Funds instead of Available Funds list.
|
Selected Funds | List of funds that have been added to the Fund Group. | Text (View-only) | Text | Fund names | The system will dynamically filter the list of Available Funds (behind the scenes) depending on the Selected Funds contents. See "799932893" for details. |
Remove | Remove button | N/A | Button | N/A | "Remove" moves a fund from the Selected Funds list, to the Available Funds list. The system will dynamically filter the list of Available Funds (behind the scenes) depending on the Selected Funds contents. See 799932893 for details. If the user removes the last fund from the Selected Funds list, the system will disable the "Add All" and "Remove All" buttons until the list has another fund selected. |
Fund Group Setup - Programs tab
The Programs tab displays the Fund Group Name, read-only. In view-only mode, the screen displays the list of the group's Selected Programs only.
A user may optionally select a checkbox for "Apply Fund Group to All Programs." The default setting is unselected. Program selection is only available if the checkbox for "Apply Fund Group to All Programs" is unselected. The selection behavior is similar to Fund Setup, Programs tab.
The "Add" and "Remove" buttons are used to select or unselect the programs and move them to the relevant column.
A user must have permission to Edit Fund Groups to add or edit the selected programs.
The non-button columns have standard text filters available.
Saving Selected Programs
Saving will also save the user identifier and the date/time stamp for auditing purposes.
- A user may save the Fund Group with no programs selected. Reason: The school might add some programs later.
Field Name | Description | Required / Optional | Type | Values | Business Rules |
---|---|---|---|---|---|
Fund Group Name | Name of the Fund Group | Required (view-only) | Text (view-only) | Name of the fund group | Displays the Fund Group's name, view-only. |
Apply Fund Group to All Programs | Allows the group to optionally apply to all programs. | Optional | Checkbox |
| If the checkbox is selected, Regent Award applies the Fund Group's limit to all programs during packaging. If the checkbox is unselected, and the Programs tab is in Edit mode, the screen displays the list of Available Programs. |
Add All (Available programs) | Apply any filters and move all the filtered Available Programs to the Selected Programs list. | ||||
Remove All (Selected Programs) | Apply any filters and move all the filtered Selected Programs to the Available Programs list. |
Available and Selected Programs
Field Name | Description | Required / Optional | Type | Values | Business Rules |
---|---|---|---|---|---|
Program Name | Name of the Academic Program | Required (view-only) | Text (view-only) | Program Name | |
Program Type | Type of Program, such as Graduate or Undergraduate | Required (view-only) | Text (view-only) | Type of program, e.g. Graduate or Undergraduate | |
External Program ID | School's identifier for the Program | Required (view-only) | Text (view-only) | Program's External Program ID | |
Calendar Type | Type of Academic Calendar, such as SAY, BBAY3, etc. | Required (view-only) | Text (view-only) | Program's Academic Calendar type |
Help Text for Selected Programs
Selected Programs
Configures which Programs the system will apply the limit to. The system will apply the limit based on the active program for the term or payment period.
For example, if an employer has a $5250 annual benefit limit cap for Undergraduates, but the limit does not apply to Graduate students, then the Selected Programs should only include the Undergraduate programs that are subject to the $5250 limit.
If students in a program are not subject to a limit, the Fund Group should not select those programs. The Funds may still be linked to those programs in Fund Setup.