Aggregate Adjustments and Data Table
The following section outlines the fields and business rules of the data on the Loan Aggregate screen, as well as provides a system screenshot of the screen.
Data Fields
Field Name | Description | Business Rules |
---|---|---|
Award ID | Financial Award Identifier (FAID) or other unique identifier for a loan, if available. |
|
Loan Type | NSLDS Award Name - Official Fund type |
|
LP Start | Loan Period Start Date Financial Award Begin Date |
|
LP End | Loan Period End Date Financial Award End Date |
|
AY Start | Academic Year Start Date Start date of the Academic Year | If the FAH data does not have a value (caused when the value is "N/A" in the raw FAH data import file), then the table will display a blank/empty/null value for the AY Start. |
AY End | Academic Year End Date | If the FAH data does not have a value (caused when the value is "N/A" in the raw FAH data import file), then the table will display a blank/empty/null value for the AY Start. |
Regent Calculated NSLDS Aggregate Amount | Loan amount used toward the Calculated Undergraduate and Graduate Combined Aggregate Principal Balance. For ISIR data, the amount is the loan Aggregate Principal Balance. For NSLDS FAH data, the value varies depending on the loan status. | |
Flag | Additional Unsubsidized Loan Flag | |
Academic / Grade Level | Academic/Grade Level | |
Loan Override Aggregate Amount | User-entered override amount. Regent Award will substitute the override value instead of the Regent Calculated NSLDS Aggregate Amount when making adjustments for Aggregate calculations. | |
Status | Two-letter code indicating the loan's current status. | |
NSLDS Net Loan Amount | Approved Gross amount at NSLDS, including Fees, after adjusting for any cancelations or refunds. | |
NSLDS Unpaid Amount | Informational only. Regent calculated difference between the total loan amount and the amount . | |
NSLDS Attended School Code | Office of Postsecondary Education (OPEID) identifier for the school attended by the student when the loan was originated. The last two digits indicate the branch, or 00 if no branch code. | Display the full 8-digit value including any leading zeroes. |
Federal School Code | An 8-digit OPEID code used to identify the school. Last 2 digits equal 00 if no branch code. | Display the full 8-digit value including any leading zeroes. |
NSLDS Data Source | Source type of the most recent data source with NSLDS data * FAH: NSLDS Financial Aid History (FAH) * ISIR: Institutional Student Information Record If both sources have the same date value, Regent uses FAH data. | |
NSLDS Data Source Date | Date of the most recent NSLDS data source. * FAH: Date when the Alert or FAH data file was generated by NSLDS. * ISIR: Transaction Processed Date for the most recent transaction with an NSLDS database results flag of 1-4. | |
Type | Loan Type Code
| |
FAH Date | Data source date when the Alert or Financial Aid History (FAH) data file was generated by NSLDS. |
|
FAH Outstanding Principal Balance | Amount currently owed on the loan. This may include capitalized interest | |
FAH Total Disbursement Amount | Cumulative amount disbursed. | |
FAH Regent Calculated Aggregate Principal Balance | FAH Regent Calculated Aggregate Principal Balance The loan amount included in aggregate adjustments. * For current loans with IA/ID/IG/IM status and loan periods ending less than 90 days in the past, the amount is the greater of the Total Disbursement Amount or the Outstanding Principal Balance. * For older loans and all other status values, the amount is the smallest nonzero value of the Net Loan Amount, the Total Disbursement Amount, or the Outstanding Principal Balance. | |
ISIR FAY | Loan's Federal Award Year received in ISIR NSLDS data. |
|
isirTransactionNumber | Transaction number for the loan FAY | |