Each depositor insured to at least $250,000 per insured bank


Home > Industry Analysis > Failed Banks > Loss Share Data Specs Version 1.4


Loss Share Data Specifications Version 1.4

The FDIC defines the data reporting requirements for Loss Share Agreements via a set of detailed specifications that include file formatting instructions, Source validation criteria, RDVP validation criteria, reporting templates, and examples of reporting scenarios. These Loss Share Data Specifications have evolved over time. On June 28, 2013, the FDIC published version 1.4 of the Loss Share Data Specifications. The dates of the last revisions to the documents are given below.

Implementation Timeline for Loss Share Data Specifications Version 1.4

All Loss Share Acquiring Institutions must download and submit the Loss Share Data Specifications Version 1.4 for all Certificate submissions received on or after July 1, 2013. While there are no changes to the Certificate form, changes have been made to the template tabs of the FDIC Adjustment files. Adjustments have also been made to descriptions found on all of the Instructions tabs and RDVP Validation tabs, and a new Source Validation tab has been added to all detail files.

No changes were made to the customized Certificate sections 1, 2, or 3. Customized Certificates will not be regenerated.

For ease of use, AIs may choose to delete the Validation tab in the current customized Certificate and detail files and replace it with the 1.4 RDVP and Source validations tabs. Please reference to the Loss Share Data Specifications Version 1.4 and RDVP Scorecard sections below for further information.

Updates in Loss Share Data Specifications Version 1.4

Loss Share Data Specifications Version 1.4 is a moderate release as defined in the Change Management Plan. The following list summarizes the updates to Loss Share Data Specifications Version 1.4:

  • Addition of new Source Validations on certain fields in the detail files. Source Validations are data validations that are performed as the Certificate and Certificate detail files are uploaded into RTSP. These validations primarily apply to those data fields which ‘must be populated’. In some cases, Source Validations will perform in conjunction with other data validations particularly for those fields which ‘must be populated with defined allowable values’. The newly implemented Source Validations can be found on the Source Validation tab within the detail files.


  • Revisions to Validation tabs of the Certificate and detail files to include any new or revised validations, and removal of validations that are no longer effective. In some cases, this resulted in business language validations being broken into multiple technical validations.


  • Updates in the Instructions tabs to provide more clarity on certain fields that are components of new validations or required at the source.


  • New Single Family balance related validations have been developed to improve reporting consistency across loss types and within the program. These validations require AIs to report the appropriate starting balance as follows:

    • Asset with prior period restructuring: If an asset reported a prior period restructuring, any subsequent loss event must use the NPV of Projected Cash Flows from the most recently reported Restructure Loss file as the starting point for the loss calculation.


    • Loan written down to book value prior to Loss Share agreement: If an asset was written down prior to the Loss Share agreement, any subsequent loss claim must use the Book Value as the starting point for the loss calculation.


    • Asset that has NO prior period restructuring and was NOT been written down to book value prior to Loss Share agreement: If an asset has no history of Restructure Loss claims or failed bank write-downs, the balance directly prior to the loss event is the starting point for any loss claims.



  • Please see the document titled “Example SFR Loss Calculations” for more details.

  • Inclusion of the field “Unique Finding ID” in the NSF and SFR FDIC Adjustment files.


  • Addition of “Certificate Integrity Checks”, designed to verify certain calculated fields within the Certificates.


  • Addition of miscellaneous validations based on terms outlined in the Purchase and Assumption Agreement or based on general financial reporting.

Download Loss Share Data Specifications Version 1.4

FDIC Loss Share agreements include Single Family Residential or Non-Single Family portfolios. The documents below contain the instructions and reporting templates for each of these asset classes. The tables below contain links to the various documents that make up the data specifications:

Loss Share Data Specifications v1.4 for Single Family (SFR) Portfolios

File

Description

Instructions for SFR LS Specifications
(880 KB PDF File - PDF Help)

File describing detailed data requirements for the Loss Share Single Family Residential portfolios.

Example SFR Covered Loss Calculations(.xls)

File demonstrating how to calculate SFR covered losses.
All data, formulas and calculations are for illustrative purposes only.

SFR Certificate file(.pdf)

Aggregate Level file containing a summary of changes in the SFR portfolio, covered losses in the current period, and cumulative losses for all periods.

SFR Active Loans file(.xls)

Loan level file containing loans covered by Loss Share that are active at the end of the reporting period. Active loans should not also be found in the PIF, Loan Sale, or ORE files.

SFR Charge-Off Loss file(.xls)

Loan level file listing of second or greater lien mortgage loans charged-off during the reporting period.

SFR Foreclosure Loss file(.xls)

Loan level file listing assets with covered foreclosure and ORE sale loss events during the reporting period.

SFR Inactive Loans file(.xls)

Loan level file of all inactive assets that are still subject to recovery-sharing. For example, include loans that were fully charged off at time of closing. The file is not a reconciliation report but rather is intended for inactive assets with a potential for recovery-sharing. The Inactive Loans file should not include loans removed from Loss Share coverage.

SFR Loan Sales file(.xls)

Loan level file listing loan sales completed during the reporting period. Please provide information on all loan sales completed during the reporting period and the covered loss amount for loan sales approved for Loss Share coverage and completed during the reporting period.

SFR ORE Listing file(.xls)

Asset level file containing a listing of Other Owned Real Estate covered by Loss Share.

SFR Paid in Full file(.xls)

Listing of paid in full loans covered by Loss Share within the reporting period. Do not report loans on the PIF file where a partial payment has been made.

SFR Recoveries and Expense file(.xls)

Asset level file containing details about recoveries and expenses on the assets covered by Loss Share.

SFR Related Loan file(.xls)

Loan level file of assets with related loans defined by the Purchase and Assumption Agreement. Submitted on a semi-annual basis.

SFR Restructure Loss file(.xls)

Loan level file listing assets with covered restructuring/modification loss events during the reporting period. This list applies only to loan modifications performed per HAMP or FDIC modification standards. Loans restructured under other approved programs may have additional data reporting requirements.

SFR Short Sale Loss file(.xls)

Loan level file listing assets with covered short sale loss events during the reporting period.



Loss Share Data Specifications v1.4 for Non-Single Family (NSF) Portfolios

File

Description

Instructions for NSF LS Specifications
(966 KB PDF File - PDF Help)

File describing detailed data requirements for the Loss Share Non-Single Family Residential portfolios.

NSF Certificate file(.pdf)

Aggregate level file containing a summary of changes in the NSF portfolio, covered losses in the current period, and cumulative losses for all periods.

NSF Active Loans file(.xls)

Loan level file containing loans covered by Loss Share that are active at the end of the reporting period. Active loans should not also be found in the PIF, Asset Sales, or ORE Listing files.

NSF Inactive Loans file(.xls)

Loan level file of all inactive assets that are still subject to recovery-sharing. For example, include loans that were fully charged off at time of closing. The file is not a reconciliation report but rather is intended for inactive assets with a potential of recovery-sharing. The Inactive Loans file should not include loans removed from Loss Share coverage.

NSF Asset Sales file(.xls)

Asset level file containing a listing of loans and ORE assets sold during the reporting period.

NSF Loss and Recoveries file(.xls)

Asset level file containing details on losses, recoveries, and expenses covered by Loss Share.

NSF ORE Listing file(.xls)

Asset level file containing a listing of Other Owned Real Estate covered by Loss Share.

NSF Paid in Full file(.xls)

Asset level file containing paid in full loans covered by Loss Share within the reporting period. Do not report loans on the PIF file where a partial payment has been made.

NSF Related Loan file(.xls)

Loan level file containing assets with "related loans" as defined by the Purchase and Assumption Agreement. Submitted on a semi-annual basis.


FDIC Asset ID Assignment Methodology

The Shared-Loss agreement requires Acquiring Institutions (AIs) to comply with Loss Share data reporting standards described in the Loss Share Data Specifications. The specifications require AIs to submit asset level data for each covered asset. One of the required asset level data elements, the FDIC Asset ID, is a unique identifier assigned by the FDIC to each covered asset subject to loss sharing under the Shared-Loss Agreement and provided on Schedules 4.15. Since FDIC Asset IDs serve the important purpose of tracking covered assets throughout the life of the Shared-Loss Agreement, FDIC will reject any loss claim certificate submission with blank or invalid FDIC Asset IDs.

FDIC Adjustments

FDIC adjustments relate to activity reported in previous reporting periods that require restatement. Such adjustments may result from onsite compliance reviews, FDIC review of processed certificate submissions, or AI review of processed certificate submissions. A new field titled Unique Finding ID is added in Data Specification version 1.4. This field only applies to AIs accessing a CMC Adjustment file in RTSP.

Data Key Template

Certificate submissions containing values other than the specified FDIC allowable values require a data key template. The first tab of the NSF and SFR data key template lists the FDIC allowable values for either all SFR or NSF files and the third tab provides a mapping. Please complete the second tab of the template with a comprehensive mapping of the AI provided values to FDIC allowable values. It is important the AI review all data files prior to submission and ensure that fields with allowable values are either populated with FDIC allowable values or a Data Key Template is provided to link all AI provided values to FDIC allowable values. Any unrecognized values will result in an error.

When completing the template located on the second tab, please ensure that the fields FDIC File, FDIC Field, and FDIC Allowable Values are consistent with the values provided in the first tab. It is important that these values are not truncated or altered in any manner. Commas and semicolons in the FDIC allowable values should not be included in the template; these are provided for ease of understanding the provided allowable values.

Lastly, allowable values of unknown or not applicable have been added to many of the FDIC fields. Please be aware that the value unknown should be used sparingly and generally only at the initiation of Certificate reporting or during system conversions. RSAM Specialists may contact the AI where the value unknown is used excessively.

Data Key Templates:

Validation Tool for Data Key Templates:

The FDIC is providing a tool for AIs to use in validating the data key templates. Please use the tool (links below) for validation purposes only. Please submit your data key mappings in the templates provided above.

RDVP Scorecard

The RSAM Data Validation Process (RDVP) is an automated data validation process which validates AI Certificate submissions based on parameters outlined in the Loss Share Data Specifications. The results of this automated review are provided in the RDVP Detail Scorecard Report. This report will always be generated and issued to the Acquiring Institution.

For easy identification of all validations, the file below contains all NSF and SFR RDVP and Source validations consolidated into one report (see link below).

Questions?

General Questions

If you have general questions about FDIC Loss Share please read:

Questions about Loss Share Data Reporting Requirements

If you have questions about your Institution's Loss Share data reporting requirements, please contact your RSAM Specialist.