The FR Y-14Q A10 (Retail Student Loan) Report is enhanced to support Back-Dated Execution and the Segment Reclassification Reporting Layer.
As part of the enhancement, there are new Derived Entities and T2Ts are created without modifying the existing metadata that supports FR Y-14Q A10.
For customers already filing the FR Y-14Q A10
As part of this enhancement, both Data flow-related and Reporting-related Metadata are introduced, but to support existing immediate filing requirements, the OFSAA Lombard Integration Package (Configuration Package) will continue to have existing Metadata-based Integration. The existing process of FR Y-14Q PRFD_USFED_FRY14Q_REG_PROCESS (USFED Regulatory Reporting FR Y-14Q Process) will continue to exist in the system to support the existing Integration Package but the same will not be a part of the ready-to-use Run. Customers can have this process in their Custom Run for the filing requirements. From the 8.0.9.7.0 release onwards, the Integration Package will start referring only to the New Metadata.
As part of this enhancement, the FR Y-14Q process is split into two processes, which are PRFD_USFED_FRY14QA_REG_PROCESS (USFED Regulatory FRY14Q A Retail Process) and PRFD_USFED_FRY14QH_REG_PROCESS (USFED Regulatory Reporting FR Y-14Q H Process).
FR Y-14Q A process refers to the new enhanced reclassification
and other related Data Flow for
FR Y-14Q A Report and FR Y-14 Q H process refer to the existing FR Y-14Q
H related Data Flow. You can either use FR Y-14Q A or FR Y-14Q H or the
existing FR Y-14Q REG Processes.
To minimize the sourcing impact, the product also supports a Migration Data transformation (DT) which can be plugged along with the new FR Y-14Q A Process which allows you to use the existing sourcing requirements and report using the New Metadata.
The migration steps using the Existing Sourcing and New Metadata are as follows:
1. The FSI_RR_MIGRATION_SETUP Table will be created as part of the installer in the Atomic Schema and contains the Source and Target Columns for migration.
2. The default value for the column UPDATE_OPTION is N, which means no migration is enabled for the mentioned Source-Target Columns.
If you want to migrate the data from the Source to Target Columns, then update the column UPDATE_OPTION to either U or O. Here, the value U means upgrading the Null Value in the Target Columns and O means overriding all the Target Values irrespective of Null Values.
After updating the FSI_RR_MIGRATION_SETUP table with either O or U, then add the process PMUS_FRY14Q_A_MIGRATION_PROCESS before the PRFD_USFED_FRY14QA_REG_PROCESS to enable the migration as part of the Run Execution.