| Field Name | Description | Business Rules |
|---|
Active | Active
Flag indicating whether the OAY will affect awarding. - Yes - The Overlapping Academic Year data is available for use in awarding.
- No - The Overlapping Academic Year data either does not overlap any current Academic Years in Regent Award, or a user has indicated the OAY data should not be used for awarding.
| Values: Yes (default) or No If a user has edited and saved the value, mark it as Manual (green “M”). The flag should not be marked Manual if a user has not actively edited and saved the value. If an OAY has been marked Inactive, then that OAY and its loan amounts do not affect awarding within Regent. 'Active' must be Yes or No. It cannot be saved as blank. |
Regent Calc Overlapping AY | Regent Calculated Overlapping AY
First new Academic Year in Regent Award following a previous Overlapping Academic Year (OAY) that contained Subsidized and/or Unsubsidized Direct Loans, as determined during the student’s most recent packaging. If the previous OAY dates overlap with more than one Regent AY, the Regent AY is the first affected Academic Year on the Academic Plan. | Display “AY” and the number of the Regent Academic Plan AY, for example, AY1, AY2, etc. |
Regent Calc Overlap End Term | Regent Calculated Overlapping End Term
The latest term in the new Regent Academic Year that contains the previous OAY End Date (or Override End Date), as determined during the student’s most recent packaging. If the end date of the previous OAY occurs between two terms in Regent Award, the Overlap End Term is the last Regent term containing at least one day from the previous OAY. | Configured term name from Term Setup, such as “Fall 2022” |
Total Sub | Total Subsidized Loans
The total Federal Direct Subsidized Loan amounts from the previous Overlapping Academic Year (OAY) for the school code and AY date range. If any loan has a Loan Override Aggregate Amount, Regent substitutes the override amount for that individual loan. | Display the total sum of Subsidized loan amounts from the OAY. Zero or positive values, or zero or blank
User-editable for manual OAYs only
|
| Total Unsub | Total Unsubsidized Loans
The total Federal Direct Unsubsidized Loan amounts from the previous Overlapping Academic Year (OAY) for the school code and AY date range. If any loan has a Loan Override Aggregate Amount, Regent substitutes the override amount for that individual loan. | Display the total Unsubsidized loan amount from the OAY. Zero or positive values, or zero or blank.
User-editable for manual OAYs only
|
NSLDS AY Start | NSLDS AY Start Date
Academic Year Start Date from NSLDS FAH data | Display the NSLDS AY start date Display a blank value if the NSLDS AY start date is null/empty (will be null for manually created OAYs or assumed OAYs)
|
| NSLDS AY End | NSLDS AY End Date
Academic Year End Date from NSLDS FAH data | Display the NSLDS AY end date Display a blank value if the NSLDS AY end date is null/empty (will be null for manually created OAYs or assumed OAYs)
|
Internal AY Start | Internal AY Start Date
Academic Year Start Date from overlapping previous Academic Year in Regent Award | Display the Internal AY start date Display a blank value if the Internal AY start date is null/empty (will be null for external OAYs created from NSLDS FAH or assumed OAYs)
|
Internal AY End | Internal AY End Date
Academic Year End Date from overlapping previous Academic Year in Regent Award | Display the Internal AY end date Display a blank value if the Internal AY end date is null/empty (will be null for external OAYs created from NSLDS FAH or assumed OAYs)
|
| Override AY Start | Override AY Start Date
User editable date to substitute for the NSLDS Academic Year Start Date or Assumed AY Start Date values whenever the system packages loans affected by the Overlapping AY.
If Replace with FAH Data is Yes, and the loans have matching FAH data loaded, Regent will package using the AY values from the FAH data and the system will clear the Override AY Start and End dates. | Override AY Start User editable date Default value is blank
Validation: For a manual OAY, all three fields are Required (cannot be blank) for AY Start Date, AY End Date, and Replace with FAH Data. Only allow date values, or blank Prevent the user from saving a date value that is more than 5 years in the past or 5 years in the future from the current server date.
Start/End Date values must always be saved in a pair with both dates specified, or both blank. ‘Override AY Start Date’ and ‘Override AY End Date’ must each have a nonblank value to be saved with nonblank values, or both must be blank to save blank values. A non-blank ‘Override AY End Date’ value must be on or after the ‘Override AY Start Date’ value. If ‘Override AY Start Date’ and ‘Override AY End Date’ each have a nonblank value, when a user tries to save, then the user must also select a Yes or No value for ‘Replace with FAH Data.’
|
Override AY End | Override AY End Date
User editable date to substitute for the NSLDS Academic Year End Date or Assumed AY End Date values whenever the system packages loans affected by the Overlapping AY.
If Replace with FAH Data is Yes, and the loans have matching FAH data loaded, Regent will package using the AY values from the FAH data and the system will clear the Override AY Start and End dates. | User editable date Default value is blank
Same Validation as Override AY Start Date
|
Replace with FAH Data? | Replace with FAH Data
Yes: If Replace with FAH Data is Yes, and the underlying loans have matching FAH data loaded, Regent will package using the AY values from the FAH data and the system will clear the Override AY Start and End dates.
No: If Replace with FAH Data is No, Regent will package using the Override AY Start and End values regardless of the AY dates in FAH data. | Display Yes or No, or blank Default value is blank/empty
User editable Default value is blank Becomes required (must have a nonblank value of either Yes or No) if the ‘Override AY Start’ and ‘Override AY End’ are specified. See validation under ‘Override AY Start’
|
Type | Type
Internal: Overlapping Academic Year (OAY) is from an AY on the student Academic Plan in Regent Award
External: OAY is from another institution | Either Internal or External, as designated by RNA for system-created OAYs, or by the user for manual OAYs. |
Attended School Code | Attended School Code
School code (OPEID) where the student borrowed loans for the previous Overlapping Academic Year (OAY). | Attended School Code Display the six-digit school code for the OAY, if it exists. Include leading zeroes. Example values: 015640, blank (for Internal OAY)
User editable for manual OAYs only, six numeric digits, include any leading zeroes. Required value (cannot be blank) if the manual OAY type is External and the user is trying to edit and save an External manual OAY.
|
Assumed AY Start | Assumed AY Start Date
Academic Year Start Date for an overlapping AY created from ISIR NSLDS loan data. Regent will use this date for packaging unless a user has specified a value for the Override AY Start Date. The OAY Assumed AY Start Date value is the Loan Period start date. | Display the Assumed AY Start Date, if present Display a blank value if the Assumed AY Start Date is null/empty. Value will be empty for NSLDS FAH sourced OAYs and manually created OAYs.
|
| Assumed AY End | Assumed AY End Date
Academic Year End Date for an overlapping AY created from ISIR NSLDS loan data. Regent will use this date for packaging unless a user has specified a value for the Override AY End Date. The OAY Assumed AY End Date value is the Loan Period start date plus 209 days, or the Loan Period End Date, whichever is later. | Display the Assumed AY End Date, if present Display a blank value if the Assumed AY End Date is null/empty. Value will be empty for NSLDS FAH sourced OAYs and manually created OAYs.
|
| OAY ID | OAY ID
Regent Award unique identifier for the Overlapping Academic Year in the database. | System generated identifier number |
| Manual | Manual OAY
Yes for a user-created Manual Overlapping Academic Year.
No for a system-generated OAY created from underlying loans in Regent Award, NSLDS FAH, or NSLDS ISIR data. | Yes or No (not blank) Not directly user editable. The screen will set the Manual flag to Yes when a user saves a user-created Manual OAY. RNA will set to No for a system-generated AY.
|
| Updated | Updated
Date and time when the OAY information was last changed. | System date and timestamp when the OAY information was last changed, either by the system, or by a user editing the OAY and saving. Date should be saved using the database server’s system date and time (UTC etc.)
Display the date and time using the user’s local time zone (similar to Activity Log and other date/time displays in Regent Award). If a user edits an OAY and saves changes to any data other than the Notes field, the system will update this field to the server date. If a user edits an OAY, but does not make any changes to OAY data (or only makes changes to the Notes field), the system will not change this field.
|
| Notes | Notes
User-entered notes about the OAY. | Free-text field User-editable Nominal length 0-1000 characters Note for REM: For display purposes, the screen column can have a shorter default width than 1000 characters. The user just needs a way to view and edit the entire Note at once. Database can be similar to MAW’s Notes field on Award.
Required (cannot be blank) when a user is editing or saving a Manual OAY. Required if user is saving any user-edited field. Optional (can be blank) for non-Manual, system-generated OAYs that do not have any override values or user edits. Users may edit Notes for any OAY. If the only user change was editing the Notes field, REM will not update the ‘Updated’ timestamp value.
|
| Underlying Loan Aggregate Detail |
|---|
| If underlying loan data exists within the Loan Aggregate Detail data table, then users can expand the OAY and view the loan data that falls within the OAY date range. Loans are considered to be within the OAY if the loan dates are within the AY Start and AY End dates, using the following precedence order by OAY type: - Internal AYs: Use the Override AY Start/End if they exist; or the Internal AY Start/End dates.
- External AYs: Use the Override AY Start/End if they exist; or the NSLDS FAH AY Start/End if they exist; or the Assumed AY Start/End dates.
Users with the 'Edit History' permission may also edit the 'Loan Override Aggregate Amount' value on individual loans. | For non-manual AYs, users can view the underlying loan information for all external OAYs that have data in the Loan Aggregate Detail table. The Underlying Loans are loans that have their start and end date within the OAY AY end dates, and have the same six-digit OPEID value for Attended School Code. For internal OAYs, the Attended School Code may be blank or match the student's current site OPEID.
If a loan does not exist in the Loan Aggregate Detail table, then the system cannot display the loan for the OAY. For example, if the school has originated and paid a loan in Regent, but the school has not updated the FAH data and has not loaded any ISIRs since that loan was paid, then that underlying loan will not have data in the Loan Aggregate Detail table. Default sort order is similar to Loan Aggregate Detail table: - Loan Period Start Date, most recent first
- Loan Period End Date, most recent first
- Regent Calculated NSLDS Loan Aggregate Amount, greatest to least
- Award ID value
The grid does not have sorting and filtering. For full functionality, see the separate sub-tab for Loan Aggregates on Aggregate Adjustments and Data Table. |
| See full data requirements for the columns at Aggregate Adjustments and Data Table. | Sort order for displaying the Loan Aggregate Detail columns: Award ID Loan Type Regent Calculated NSLDS Aggregate Amount Loan Override Aggregate Amount User editable: Users with Edit permissions can edit and save the ‘Loan Override Aggregate Amount’ value. The field is the same field as the Loan_Aggregate_Detail and stored in the same place in the database.
LP Start LP End AY Start AY End Assumed AY Start For ISIR-only sourced loans, RNA will set the value to ISIR Loan Period Begin Date. Default value is blank/null/empty.
Assumed AY End For ISIR-only sourced loans, RNA will set the value to ISIR Loan Period Begin Date + 209 days, OR the ISIR Loan Period End Date, whichever date is later. Default value is blank/null/empty.
NSLDS Attended School Code
|
|
|
|