Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Below are the setup items and validation rules to be used for each Fund Group that you configure in the system.

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 NameDescriptionRequired / OptionalTypeValuesBusiness Rules
Fund Group Name

School-provided name.

Required; Text - 1-50 characters

RequiredText1-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.

  • Error message: Fund Group Name must be unique within the 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).

Required

Text1-60 charactersValidations:
  • Will not allow characters other than letters A-Z, numbers 0-9, and underscores.
  • Must be a unique value within the Institution
  • Error message: Fund Group External ID must have a unique value within the Institution. Only letters, numbers, and underscores are allowed.
Fund Group Description

School-provided additional information

OptionalText256 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 NameDescriptionRequired / OptionalTypeValuesBusiness Rules
Max Amount Per Award Period

The school-provided upper limit for the total award amounts across all funds in the group. 

RequiredText (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.

  • FAY is not required if the group has only one limit specified.
  • FAY is required for saving the group if any selected fund is FAY-based (i.e., if Fund Scope is Federal Award Year) and the group has more than one limit specified.

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

Either the effective begin or end date are required, except:

  • No effective dates are required if FAY is specified and only one row is configured for a given FAY.  
  • No effective dates are required if only one row is configured.

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

Either the effective begin or end date are required, except:

  • No effective dates are required if FAY is specified and only one row is configured for a given FAY.  
  • No effective dates are required if only one row is configured.

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 NameDescriptionRequired / OptionalTypeValuesBusiness Rules
Add All

Button to add all funds in the Available Funds list to the Selected Funds.

N/AButtonN/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 AllButton to remove all funds in the Selected Funds list.N/AButtonN/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)TextFund names

The system will dynamically filter the list of Available Funds (behind the scenes), in addition to the normal user-entered text filters.

  • On initial load or edit, filter to only show funds that do not have any ruleset assigned in the Fund Model Rules table
  • 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. 
Add and Limit

When a fund is added to the Fund group with "Add and Limit," the system will limit and automatically adjust the award amounts, so the total will not exceed the fund group's limit. The system will only adjust amounts for the group's selected programs. 

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.

N/AButtonN/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.  

    1. The fund selection also sets the fund's constraint type to "Limit" - note, Limit is the only constraint type available.
  1. When the first fund is added to the Selected Funds list, the system will filter the remaining Available Funds (see "799932893" above).

    1. The scope filtering is in addition to any user-entered filters (e.g. if a user entered a text string).

Selected Funds

List of funds that have been added to the Fund Group.

Text (View-only)TextFund namesThe system will dynamically filter the list of Available Funds (behind the scenes) depending on the Selected Funds contents. See "799932893" for details.
RemoveRemove buttonN/AButtonN/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 NameDescriptionRequired / OptionalTypeValuesBusiness Rules
Fund Group NameName of the Fund GroupRequired (view-only)Text (view-only)Name of the fund group

Displays the Fund Group's name, view-only.

Apply Fund Group to All ProgramsAllows the group to optionally apply to all programs.OptionalCheckbox
  • Unselected (default)
  • Selected

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

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.

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 TypeType of Academic Calendar, such as SAY, BBAY3, etc.Required (view-only)

Text (view-only)

Program's Academic Calendar type
  • No labels