General Subtab

At the bottom of the History tab - General subtab. the information related to transmission and receipt of NSLDS FAH and TSM requests and information from NSLDS on NSLDS Award History - Loans and NSLDS Award History – Grants is displayed. These features display financial award information for all awards received at the current institution and other institutions. The additional information can assist you in making awarding decisions.  

Data Requirements

Each field can have up to 4 different values. Sources are NSLDS, ISIR, COD, Manual.

The ISIR, COD, NSLDS, and Regent columns are READ ONLY.

Screenshots

Edit NSLDS Inform Files Sent

Loan Details

Image Modified

Grant Details

Image Modified

SULA Subtab

Screenshots

Student Subsidized Usage 

Student Award Level Data for Subsidized Usage by Loan

Loan Subsidized Usage by Payment Period

Data Requirements 

If the program is configured with "Apply SULA Calculations" set to No (or Inherits a value of No), then the screen will display a red (!) warning icon and the following sentence: (!) The current program is NOT configured to apply SULA calculations to awarding.

The program is the same program used for the "Current Program" in the data table (preexisting Current Program logic). The system will not display that sentence or warning indicator if the program is configured with Apply SULA Calculations set to Yes (or Inherits a value of Yes). However, the system will still display that sentence and indicator if the student has a SULA value of N. 

If the student's SULA=Y, Regent will still recalculate the student-level and loan-level SULA values for Subsidized loans, even when the program has "Apply SULA" = N.  Regent will run the SULA calculations, but will not limit Subsidized Loan awarding.

Subsidized Usage by Loan

The Subsidized Usage by Loan table gives detailed Award-Level data for all the student's Subsidized loans in Regent Award. All loans are tracked, regardless of status (Cancelled, Estimated, Offered, Accepted, etc.)

List of fields:

1. Final - Set an indicator that REM can use to track if the marked loan is the last eligible Sub loan for the student in the program in their REP (REP <= 1.0). A red (!) indicator will mark those loans. 

   1.  Help Text:

      1. Final Subsidized Loan

      2. Indicates if the loan is the last eligible Subsidized loan for the student in their program's remaining SULA eligibility.

2. Award ID - partial FAID from the "S" on (omit the 9-digit SSN prefix at the top).

   1. The FAID will be a hyperlink to access the Subsidized Usage - Payment Period Detail pop-up.

   2. A very similar hyperlink and pop-up already exists in the Student History tab, General sub-tab, NSLDS Award History - All Loans.

3. AY - Academic Year in Regent

4. AY Start - AY start date, from Award COD Metadata (same as "Academic Year Begin Date" on Loans tab)

5. AY End - AY End date, from Award COD Metadata (same as "Academic Year End Date" on Loans tab)

6. LP Start - Loan Period start date, from Award COD Metadata (same as "Financial Award Begin Date" on Loans tab)

7. LP End - Loan Period End date, from Award COD Metadata (same as "Financial Award End Date" on Loans tab)

8. Grade Level - Grade level for the loan in Regent

   1. Same data type as the Academic Plan, Grade Level field. It appears to be a numeric / integer, but it might be just a lookup table.

9. Regent Loan Amount - Current gross loan amount in Regent that will be used when exporting the loan's  <FinancialAwardAmount> to COD

   1.  Help Text:

      1. Regent Loan Amount

      2. Current gross Financial Award Amount amount in Regent, exported to COD as the <FinancialAidAmount>

10. Regent Paid Amount - Current gross paid amount in Regent.

    1. The sum of the paid disbursement amounts and paid loan origination fees.

    2.  Help Text:

       1. Regent Paid Amount

       2. The sum of the paid disbursement amounts and paid loan origination fees.

11. 0 SUP - Y if this loan is fully contained in another loan's Subsidized Usage Period and has no additional subsidized usage for the payment period; N if the loan period has its own SUP.  RNA-calculated.

    1.  Help text:

       1. Zero Subsidized Usage

          • Y: The loan is fully contained in another loan's Subsidized Usage Period (SUP) and has no additional subsidized usage for the Academic Year.

          • N: The loan period has its own SUP.

12. Regent Loan Actual SUP - RNA"s calculated SULA usage for a paid loan.

    1. Numeric; will use one decimal.  RNA-calculated.

    2.  Help text:

       1. Regent Actual Subsidized Usage Period

       2. The system's calculated Subsidized Usage, in Years, for a paid loan.

13. Regent Loan Anticipated SUP - RNA"s calculated SULA usage for an unpaid loan.

    1. Numeric; will use one decimal. RNA-calculated.

    2.  Help text:

       1. Regent Anticipated Subsidized Usage Period

       2. The system's calculated Subsidized Usage, in years, for an unpaid loan.

14. Regent Award Status - Accepted, Estimated, etc.

15. COD Loan Actual SUP - <ActualSubUsagePeriod> from COD data

    1.  Help text:

       1. COD Loan Actual Subsidized Usage Period

       2. <ActualSubUsagePeriod> from COD data for this paid loan, in years

16. COD Loan Ant SUP - <AnticipatedSubUsagePeriod> from COD data

    1.  Help text:

       1. COD Loan Anticipated Subsidized Usage Period

       2. <AnticipatedSubUsagePeriod> from COD data for this unpaid loan, in years

17. COD Loan MEP - <MaxSubEligibilityPeriod> from COD data

    1.  Help text:

       1. COD Loan Maximum Eligibility Period

       2. Maximum Eligibility Period: 150% of the program length, in years.

18. COD Student Sum Actual SUP - SumActualSubUsagePeriods from COD data

    1.  Help text:

       1. COD Student Sum of Actual Subsidized Usage Periods

       2. <SumActualSubUsagePeriods> from COD data, in years. The total of all the student's Subsidized Usage Periods for loans with a paid disbursement at COD.

19. COD Loan Sum Ant SUP  - <SumAnticipatedSubUsagePeriods> from COD data

    1.  Help text:

       1. COD Student Sum of Anticipated Subsidized Usage Periods

       2. <SumAnticipatedSubUsagePeriods> from COD data, in years. The total of all of the student's actual Subsidized Usage Periods at COD, plus the current unpaid loan's SUP.

20. COD Loan Remaining Eligibility Period - Actual  <RemainingActualSubEligibilityPeriod> from COD data

    1.  Help text:

       1. COD Loan Remaining Eligibility Period - Actual 

       2. <RemainingActualSubEligibilityPeriod> from COD data, for a loan that has been paid at COD.

21. COD Loan Remaining Eligibility Period - Anticipated  <RemainingAnticipatedSubEligibilityPeriod> from COD data

    1.  Help text:

       1. COD Loan Remaining Eligibility Period - Anticipated 

       2. <RemainingAnticipatedSubEligibilityPeriod> from COD data, for a loan that is not yet paid at COD.

22. COD Loan Program CIP Code - <ProgramCIPCode> from COD data

    1.  Help text:

       1. COD Loan Program Classification of Instructional Programs (CIP) Code

       2. <ProgramCIPCode> from COD data

23. COD Loan Program Length Years - <CalculatedPublishedPgmLengthYears> from COD data

    1.  Help text:

       1. COD Loan Program Length in Years

       2. <CalculatedPublishedPgmLengthYears> from COD data

24. Last COD Loan Import - If the loan was imported from COD, the most recent COD import date into Regent Award with Accepted status

    1.  Help text:

       1. Last COD Loan Import

       2. Date when the loan was last Imported from COD with an Accepted status

25. Last COD Export - If the loan was exported to COD, the most recent COD export date from Regent Award

    1.   Help text:

       1. Last COD Loan Export

       2. Date when the loan was last exported to COD

26. COD Response Processed Date - <ProcessDate> From the loan's latest COD file in Accepted status

    1.   Help text:

       1. COD Response Processed Date

       2. <ProcessDate> From the most recent COD file in Accepted status

27. COD Student Sum Actual NonCred Teach Cert SUP - <SumActualNonCredTeacherCertSubUsagePeriods> from COD data

    1.   Help text:

       1. COD Student Sum Actual NonCred Teach Cert SUP

       2. <SumActualNonCredTeacherCertSubUsagePeriods> from COD data. Sum of the student's total Subsidized Usage from paid loans for non-credential teacher certification programs, in years.

28. COD Student Sum Ant NonCred Teach Cert SUP - <SumAnticipatedNonCredTeacherCertSubUsagePeriods> from COD data

    1.  Help text:

       1. COD Student Sum of Anticipated NonCred Teach Cert SUP

       2. <SumAnticipatedNonCredTeacherCertSubUsagePeriods>  from COD data. Sum of the student's total actual Subsidized Usage plus the current unpaid loan's SUP for non-credential teacher certification programs, in years.

29. COD Loan Actual NonCred Teacher Cert SUP - <ActualNonCredTeacherCertSubUsagePeriod> from COD data

    1.  Help text:  (based on TechRef Vol 2 p. 371)

       1. COD Loan Actual NonCred Teacher Cert SUP

       2. <ActualNonCredTeacherCertSubUsagePeriod> from COD data. The paid loan's Subsidized Usage at COD for a non-credential teacher certification program, in years.

30. COD Loan Ant NonCred Teacher Cert SUP -  <AnticipatedNonCredTeacherCertSubUsagePeriod> from COD data

    1.  Help text:  (based on TechRef Vol 2 p. 370)

       1. COD Loan Ant NonCred Teacher Cert SUP 

       2. <AnticipatedNonCredTeacherCertSubUsagePeriod> from COD data. The unpaid loan's Subsidized Usage at COD for a non-credential teacher certification program, in years.

Loan Subsidized Usage by Payment Period

Each Subsidized loan that has information in Regent has a hyperlink from the FAID to a pop-up modal with that individual loan's details. 

The pop-up includes the following detailed award-level information for each loan:

1. Non-PII part of the Financial Award ID
   1.  Help Text
      1. Loan identifier for a Direct Loan
2. Loan Amount - current gross loan amount in Regent
   1. Whole number, no dollar sign,  
      1. Include comma separators for values over 1,000. Do not display cents.    
      2. Example values:  5,500  or  1,000
   2. AwardDisbursement gross amount for the term or payment period 
   3.  Help Text
      1. Loan Amount 
      2. Current gross loan amount in Regent
3. Grade Level - Grade level for this loan
   1.  Help Text
      1. Grade Level
      2. Grade level for this loan
4. SULA Usage - Regent's calculated SULA usage in years, to one decimal place, for this loan.
   1.  Help Text
      1. SULA Usage
      2. Regent's calculated SULA usage in years
5. Indicator (next to SULA usage) if the loan is fully contained by another loan period and has 0 SULA usage as a result (working title is "0 SUP" above)
   1. Hover Text: This loan is fully contained by another Subsidized loan. This loan's calculated SULA usage will not count for the Subsidized Usage Period unless the other loan is canceled.
6. Academic Year Begin Date
   1.  Help Text
      1. Academic Year Begin Date
      2. The date the student's academic year starts.
7. Academic Year End Date
   1.  Help Text
      1. Academic Year End Date
      2. The date the student academic year ends.
8. Loan Period Begin Date
   1.  Help Text
      1. Loan Period Begin Date
      2. The start date of the academic period for which loan funds are used to cover the cost of education.
9. Loan Period End Date
   1.  Help Text
      1. Loan Period End Date
      2. The end date of the academic period for which loan funds are used to cover the cost of education.

The pop-up also displays detailed Payment Period or Term-level information, for each term or payment period in the loan's loan period. All information except the COD Enrollment Level is from Regent Award.

1. PP Start Date 
   1.  Help Text
      1. Payment Period Start date
      2. The start date in which a disbursement of the loan can be made
2. PP End Date
   1.  Help Text
      1. Payment Period End Date
      2. The end date in which a disbursement of a loan can be made
3. Actual Subsidized Usage Period
   1. If any disbursements for the loan are paid, then the portion of Regent-calculated SULA usage SUP for the term/PP
   2.   Help Text 
      1. Actual Subsidized Usage Period 
      2. Regent calculated total years for all the student's Subsidized Usage for loans that have a paid disbursement.
      3. If any disbursements for the loan are paid, then the portion of Regent-calculated SULA usage SUP for the term/PP
4. Anticipated Subsidized Usage Period
   1. If the entire loan is unpaid (all disbursements for the loan are unpaid), then the portion of Regent-calculated SULA usage SUP for that term/PP
   2.  Help Text
      1. Anticipated Subsidized Usage Period
      2. Regent calculated total years for all the student's Subsidized Usage for loans that have been accepted with any disbursements that have not been paid (anticipated). 
      3. If the entire loan is unpaid (all disbursements for the loan are unpaid), then the portion of Regent-calculated SULA usage SUP for that term/PP
5. Amount: AwardDisbursement Amount
   1.  Help Text
      1. Disbursement Amount 
      2. Gross amount for the term or payment period 
6. Current Enrollment Level:  Current enrollment level from the last time this term/PP was packaged
   1.  Help Text:
      1. Current Enrollment Level 
      2. Current enrollment level from the last time this term or payment period was packaged
7. Paid Amount: Gross paid amount
   1.  Help Text 
      1. Paid Amount
      2. Gross amount of all paid disbursements and fees in the term or payment period
8. COD Enrollment Level:  Enrollment level sent to COD for the first disbursement on the loan.
   1. This value will be frozen when the term or PP has its first disbursement successfully paid (DRI=True). Even if the student has later disbursements in the same term, and changes enrollment level, the COD Enrollment Level value will not change after the initial paid disbursement.
   2.  Help Text:
      1. COD Enrollment Level 
      2. Enrollment level sent to COD for the first disbursement on the loan.
9. Program:  Current program for that term or payment period.
   1.  Help Text
      1. Program 
      2. Current program for the term or payment period.

Census Subtab 

The Census Calculation History page on the Census subtab of the History tab, includes a view-only, filterable table of census data. When the census date value being used for the student changes, and/or the number of units in the census calculation changes during packaging, a new row is added to the table and each of the six columns in the row are populated with values applicable to the new calculation:

• Term Name

• Census Date

• Number of Units

• Census Date Type

• Calculation Date

• Program Name

Census Date Type column identifies if the census date used in the calculation was at student-level or one of the five configured types in Term Setup. Column values are as follows:

• Census Date 1

• Census Date 2

• Census Date 3

• Census Date 4

• Alternative Census Date

• Student-level

Loan Aggregates sub-tab (also see: Aggregate Adjustments and Data Table)

The Loan Aggregates sub-tab displays a detailed data table for each individual loan on the student's record. The table combines loan details from NSLDS FAH and ISIR data. Users with permissions to 'Edit History Tab' may also add an override for the 'Calculated Aggregate Amount' value.

Two system-generated student-level flags appear above the data table: Has Aggregate Adjustments and Uses Override Aggregate Amounts. The system tracks these values on the student level and stores them on each student's Academic Plan. The fields are visible in the Loan Aggregates sub-tab.

1. Has Aggregate Adjustments

   During packaging, the system sets this flag to True if any student-level aggregate total amounts were adjusted for specific scenarios:

   1. Undergraduate students with past Graduate loans

   2. Undergraduate dependent students with Additional Eligibility due to a Parent PLUS Denial

   3. Graduate students currently in programs that do not use the higher Health Professions (HPPA) loan limits, who have past HPPA loans
      

2. Uses Override Aggregate Amounts

   If any loan has a manually-entered Override Amount in the data table, this checkbox is selected.

   If no loans have a manual override amount, the indicator will display as Unselected. If a student previously had one or more Override Amounts, but ALL Override amounts are cleared (blank) on a student, the 'Uses Override Aggregate Amounts' checkbox will also be cleared upon saving.

Each loan appears only once within the data table. Loans might have different data reported from NSLDS FAH and ISIR data sources. Regent Award matches loans from ISIR and NSLDS FAH data. When the data is imported, Regent identifies which data source is most recent, and determines the Regent Calculated NSLDS Aggregate Amount. That Regent-calculated value is the amount that loan contributes toward the student's Total Aggregate Oustanding Principal Balance.

Regent Calculated NSLDS Aggregate Amount

Within the table, Regent joins loan from ISIR FAH data and NSLDS FAH (Type 5) records. Regent determines the Regent calculated 

Regent Calculated NSLDS Aggregate Amount

1. Title: Regent Calculated NSLDS Aggregate Amount
2. Data Source: Regent calculated see FR section 3
3. DB field in Loan_Aggregate_Detail: calculatedAggregateAmount
4. FAH data field, NSLDS_TMSFAHType5LoanDetail: fahCalculatedAggregatePrincipalBalance  or NetLoanAmount (see business rules).
5. ISIR data field, Loan 1: NSLDSLoan1AggregatePrincipalBalance
6. Example FAH value 
7. FAH Position#
8. Example ISIR Values: 
9. ISIR Position, Loan 1, 2022-2023
10.  Help Text:
    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.
    * Current or recent loans in an in-school or in-grace status, having loan period end dates less than 90 days in the past, use the greater of the Outstanding Principal Balance or the Disbursed Amount.
    * Older loans with a Loan Period ending at least 91 days in the past, or more recent loans not in an in-school or in-grace status, use the lowest nonzero value of the three NSLDS FAH data fields: Net Loan Amount, Disbursed Amount, and Outstanding Principal Balance.

Loan Aggregate Detail Data Table - Data Elements

See Aggregate Adjustments and Data Table

Award ID

1. Title: Award ID

2. Data Source: FAH only
3. DB field in Loan_Aggregate_Detail: awardId
4. FAH data field, NSLDS_TMSFAHType5LoanDetail: dataProviderLoanIDAwardID
5. ISIR data field, Loan 1: N/A
6. Example FAH values (with SSN masked):
   1. 06042112B 1 
   2. S11G06731001
7. Example ISIR Values: N/A
8.  Help Text:
   Award ID
   Financial Award Identifier (FAID) or other unique identifier for a loan, if available.
9. Business Rules:
   1. When the screen displays this field's values, for values in the 21-digit FAID format, the screen will omit (will not display) the first 9 digits (social security number).
   2. If the system created a unique ID because of the lack of any ID provided in the data source, the system displays the system-generated unique ID.

Loan Type

1. Title: Loan Type
2. Data Source: Regent Calculated
3. DB field in Loan_Aggregate_Detail:
4. FAH data field
   1. Joined from NSLDS_TMSFAHType5LoanDetail.LoanTypeProgramCode value, used to link to FundOfficialTypeNSLSDFundCode.nsldsAwardName
5. ISIR data field, Loan 1:
   1. Joined based on loanTypeCode
6. Example FAH value: N/A  
7. FAH Position#  N/A
8. Example ISIR Values:  N/A
9. ISIR Position, Loan 1, 2022-2023:   N/A
10.  Help Text:
    Loan Type
    NSLDS Award Name - Official Fund Type
11. Business Rules:
    1. For NSLDS and ISIR data the value is joined from NSLDS_TMSFAHType5LoanDetail. 
       1. Look up LoanTypeProgramCode value, and display the FundOfficialTypeNSLSDFundCode.nsldsAwardName. 
       2. For example: nlsdsFundCode value of D0 has a nsldsAwardName value of "Direct Stafford Subsidized (SULA Eligible)".

Reference list of Fund Official Types, NSLDS Fund Codes, and NSLDS Award Names:

• C3 D0 Direct Stafford Subsidized (SULA Eligible)
• C3 D1 Direct Stafford Subsidized
• C3 SF FFEL Stafford Subsidized
• C4 D2 Direct Stafford Unsubsidized
• C4 FI FISL Federally Insured Loan
• C4 RF FFEL Refinanced Loan
• C4 SL FFEL Supplemental Loan
• C4 SN Non-subsidized FFEL Stafford Loan
• C4 SU FFEL Stafford Unsubsidized

LP Start

1. Title: LP Start
2. Data Source: Both
3. DB field in Loan_Aggregate_Detail: loanPeriodBeginDate
4. FAH data field, NSLDS_TMSFAHType5LoanDetail:  loanPeriodBeginDate
5. ISIR data field, Loan 1: NSLDSLoan1BeginDate
6. Example FAH value 3/4/2019
7. FAH Position#
8. Example ISIR Values:  20190304
9. ISIR Position, Loan 1, 2022-2023: 
10.  Help Text:
    Loan Period Start Date
    Financial Award Begin Date
11. Business Rules:
    1. Display the values using the standard US date format m/d/yyyy.
       1. Note, the ISIR data has a different date format (YYYYMMDD).

LP End

1. Title: LP End
2. Data Source: Both 
3. DB field in Loan_Aggregate_Detail: loanPeriodEndDate
4. FAH data field, NSLDS_TMSFAHType5LoanDetail: loanPeriodEndDate
5. ISIR data field, Loan 1: NSLDSLoan1EndDate
6. Example FAH value: 8/25/2019
7. FAH Position# 
8. Example ISIR Value: 20190825
9. ISIR Position, Loan 1, 2022-2023
10.  Help Text:
    Loan Period End Date
    Financial Award End Date
11. Business Rules:
    1. Display the values using the standard US date format m/d/yyyy.
       1. Note, the ISIR data has a different date format (YYYYMMDD).

AY Start

1. Title: AY Start
2. Data Source: FAH only
3. DB field in Loan_Aggregate_Detail:  academicYearBeginDate
4. FAH data field, NSLDS_TMSFAHType5LoanDetail: academicYearBeginDate
5. ISIR data field, Loan 1: N/A
6. Example FAH value: 1/27/2019
7. FAH Position#
8. Example ISIR Values:  20190127
9. ISIR Position, Loan 1, 2022-2023
10.  Help Text:
    Academic Year Start Date
    Start date of the Academic Year
11. Business Rules:
    1. 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

1. Title: AY End
2. Data Source: FAH only
3. DB field in Loan_Aggregate_Detail:  academicYearEndDate
4. FAH data field, NSLDS_TMSFAHType5LoanDetail: academicYearEndDate
5. ISIR data field, Loan 1: N/A
6. Example FAH value: 8/27/2019
7. FAH Position#
8. Example ISIR Values:  20190827
9. ISIR Position, Loan 1, 2022-2023
10.  Help Text:
    Academic Year End Date
    End date of the Academic Year
11. Business Rules:
    1. 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. 

Overlapping AYs 

The Overlapping Academic Years subtab displays information on Subsidized and Unsubsidized Loans that occur in previous Academic Years that potentially overlap the student's Academic Years in Regent Award.

Users may also view and edit the Overlapping Academic Year information.

See data requirements at Overlapping AYs.  Additional information is at Loan Automation for Overlapping Academic Years (OAYs).

COA Subtab

The COA subtab displays the Payment Period Cost History grid for the student. The grid displays a record, by date, for each unique Payment Period/Program Name/Total PP COA amount for the student, to provide visibility to cost changes within a Payment Period. When a line item in the grid is selected, details for each cost item that makes up the Total PP COA will display below. Details include the following information:

1. Adjustment
   1. Yes/No
2. Cost Item Name
3. Cost Category
4. Cost Change From
5. Cost Change To
6. Direct Costs
   1. Yes/No
7. Billed by School
   1. Yes/No
8. Date
9. User ID

Image Added

Image Added

Change Log