Reporting Data Models & Letter Configuration for 24/25 

With 24A, new reporting views were introduced account for the Consolidated Appropriations Act updates causing the 24/25 ISIR to be completely reformatted, and with 24B we have now incorporated those views into new product data models, product reports and product letters, including a new Verification Letter (VL1).

New Product Data Models

New product data models were created utilizing our V2 versions of our reporting views in order to allow reporting and letters to run or print with 24/25 ISIR data. We've added additional security measures to ensure any FTI data includes the CUI//SP-TAX labeling.

For custom Data Models that include FTI data fields, you can utilize our ISIR Extracted Fields Awy data model for an example of how to include CUI labeling in your output.

  • Delayed ISIR Awy 2025 onwards
  • ISIR Extracted Fields Awy (Contains FTI Data)
  • ISIR Name Value Pair Awy 2025 Onwards (Contains FTI Data)
  • ISIR Loading Integration Awy 2025 Onwards
  • ISIR Verification Result Awy 2025 Onwards
  • Valid ISIR Process Status Information Awy 2025 Onwards

New Product Reports

Since the ISIR has changed so much with 24/25 we created new reports for this Award Year. We've based our reports on our current production reports using the new data models previously mentioned. The original reports will still work for all Award Years prior to 24/25 and the new reports should be run for all Award years 24/25 and on. These have been appended with (24-25 through current) after the original name.

The following reports have been updated for 24/25:

  • ISIR Reconciliation Report (24-25 through current)
  • Delayed ISIR Processing Report (24-25 through current)
  • Student ISIR Report (24-25 through current)
  • Individual ISIR Report (Raw values, 24-25 through current)
  • Verification Results Report (24-25 through current)

Updates to Product Letters

We've also made updates to our Aid Offer Letter and Provisional Aid Offer Letter incorporating these changes while taking a similar approach to reports while creating a duplicate Verification Letter.  For the Aid Offer and the Provisional Aid Offer Letters we updated the actual letter to cover SAI and EFC for any crossover scenarios so both will be displayed on the ISIR.  With the Verification Letter, we created a VL1 letter which duplicates the current product 110 Letter.

  • Provisional Aid Offer Letter and the Aid Offer Letter
    • Please review our new updated letter in the SFP Letters Samples folder.  This includes our updated letter template incorporating 24/25 COA data as well as the SAI or EFC value depending on the Award Year of the fund.
  • Verification Letter
    • Created a VL1 Letter to trigger for 24/25 ISIR Award Years
    • Since the original Verification Letter will still be triggered for 23/24 funds, we have updated our LETTERS.csv workbook as well as created an update in the VerificationLetter.groovy script to call the correct letter code.  

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Student Financial Aid

  • Verification Letter (VL1)
    • Review baseline updates for the LETTERS.csv workbook and the accompanying VerificationLetter.groovy. 
    • We have mimicked our VL1 letter based on our original production 110 Letter. However, you'll need to review your current 110 letter and make customizations as you see fit to incorporate this new letter for your school.  
  • Provisional Aid Offer and Aid Offer Letters
    • Reporting Views were updated in 24A to incorporate the updates for 23/24 as well as 24/25 however the letter template needs to be updated. Please review your PO1 letter and FN1 letter to see what template changes need to be made. You can use our letter updates in 24B as a template. 

Tips And Considerations

  • For a full list of the reporting view updates and details about the new and updated product report and letters, see the release attachment updates published on My Oracle Support.
  • If updates are not made to your Verification Letter then your Letters will be blank for 24/25 ISIRs.
  • If updates are not made to your Provisional Aid Offer and Aid Offer Letters then 23/24 and 24/25 ISIR students may not understand 24/25 represents SAI and not EFC.

Key Resources