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


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

Loss Share Data Specifications Version 1.3.3

The FDIC defines the data reporting requirements for Loss Share Agreements via a set of detailed specifications that include instructions, validation criteria, reporting templates, and examples of reporting scenarios. These Loss Share Data Specifications have evolved over time. On September 26, 2011, the FDIC published version 1.3.3 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.3.3

All Loss Share Acquiring Institutions must download and submit the Loss Share Data Specifications Version 1.3.3 for the September 30, 2011 reporting period end date. While there are no changes to the template tab of required files or the Certificate form, adjustments have been made to descriptions found on the instructions tab and the display of the validations tab.

No changes were made to the customized Certificate sections 1, 2, or 3. Customized Certificates will not be regenerated meaning the Certificate sent with the supporting 1.3.3 files will have version 1.3.2 in the upper right hand corner.

However, please be aware that the format of the validation tab has been updated to facilitate the RDVP Scorecard release and is included in the SFR and NSF Certificate files found on the Loss Share Data Specifications website. For ease of use, AIs may choose to delete the validation tab in the current customized Certificate and replace it with the 1.3.3 validations. Please reference the Download and RDVP Scorecard sections below for further information.

Updates in Loss Share Data Specifications Version 1.3.3

Loss Share Data Specifications Version 1.3.3 is a minor release as defined in the Change Management Plan and represents a refresh of Version 1.3.2. The following list summarizes the updates to Loss Share Data Specifications Version 1.3.3:

  • Incorporated the clarifications to version 1.3.2 posted to the website.
  • Updated Loss Share Data Specifications website to include a section on the RDVP Scorecard
  • Revised the Validation tabs of the Certificate and detail files to include information tying the validations to the RDVP scorecard. In some cases this resulted in business language validations being broken into multiple technical validations.

    For example the 1.3.2 validation tab for the NSF Certificate contains the following instructions for verifying the delinquency table found on Certificate page 3:

    Condition

    Loan Level File Field

    Amount for Each FDIC Asset Type Category Should Equal:

    Calculation: Total 'Balance Outstanding' of Active Loans by 'Days Past Due' into the following categories; Performing (less than 30 days), 30-59 days, 60-89 days, 90+ days. This excludes the following assets:

    1. Assets reported in the ORE Listing file
    2. Loans with an Exceptional Loan Status of 'F' (Foreclosure) in the Active Loan file

    In the version 1.3.3 the validation tab of the NSF Certificate breaks this into 20 validations with a validation specific to each asset type and performance category (see example below):

    Description

    Data Fields to Compare

    Section 3 Total Number of Loans/Properties - Performing Column Only Count for Construction and Development Category Should Equal Calculation: Count of Active Loans by 'Days Past Due' into the following categories: Performing. This excludes the following assets: 1) Loans with an Exceptional Loan Status of 'F' (Foreclosure) or '9' (Bankruptcy and Foreclosure) in the Active loan File; 2) Loans with a Nonaccrual status of 'Y' (Yes) in the Active loan file; and 3) Assets reported in the ORE Listing file.

    1. Days Past Due (Column AV) = 29 or less
            and
    2. Nonaccrual (Column AX) = N
            and
    3. Exceptional Loan Status (Column CS) = B, N or U
            and
    4. FDIC Asset Type (Column CF) = C&D

    Additionally, the validation update improved consistency in validations for related fields both across and within files.


  • Changed the name of the NSF Loan Sales file to Asset Sales file.
  • Added a new field called 'Adjustment Balance' to both the NSF and SFR FDIC Adjustment files to accommodate adjustments to asset balances. Please see FDIC adjustment link for additional reporting information.
  • Added allowable values for the 'State' fields in both the NSF and SFR detail files and for the fields 'Note Purpose', 'Borrower's internal rating', 'Note risk rating', and 'FFIEC code' in the NSF Active loan file.

Download Loss Share Data Specifications Version 1.3.3

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 1.3.3 for Single Family (SFR) Portfolios

File

Description

Instructions for SFR LS Specifications
(741 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.

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. Please be aware AIs that have a customized 1.3.2 Certificate should continue to report using this Certificate. Certificate sections 1, 2, and 3 are identical between the 2 versions. The 1.3.3 customized Certificate will only be distributed to new Loss Share institutions. However, the validation tab found in the 1.3.3 file is applicable to all AIs effective for the September 30, 2011 reporting period end date. For ease of use, AIs may choose to download this file and replace the validation tab found in the 1.3.2 customized Certificate.

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)

Listing 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)

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

SFR Related Loan file(.xls)

Loan level file listing 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 1.3.3 for Non-Single Family (NSF) Portfolios

File

Description

Instructions for NSF LS Specifications
(911 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 listing 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.

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 about 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.


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. The FDIC Asset ID Assignment Methodology is the same methodology as found in Loss Share Data Specifications 1.3.2.

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. After a thorough review of FDIC Adjustment reporting for the June 2011 Certificate reporting cycle, a field was added to the FDIC Adjustment file for reporting on active or ORE balance adjustments resulting from Adjustment amounts. If AIs are unable to populate this field for the September reporting cycle, please populate the field with a zero. Additionally, a new allowable value was added to the field 'Adjustment Requested By'. This value (PAAI) is designed to capture AI adjustments which result from post FDIC audit due diligence. If AIs are unable to differentiate between FDIC audit findings and post audit due diligence findings for the September reporting cycle, please code all findings related to FDIC audits as CMC. Lastly, the field FDIC Adjustment was retitled to FDIC Identified Amount to clarify the intent of this field.

Data Key Template

To ensure we have an AI's more recent data key and mapping to FDIC allowable values, please complete the SFR and NSF Data Key Templates and send with the September 30th and subsequent submissions. The first tab of the 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 for 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. FDIC 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 Scorecard.

The RDVP Scorecard consists of 3 reports: RDVP Detail, RDVP Schedule Reconciliation, and RDVP Allowable Values check. The RDVP Detail report will always be created and issued to the Acquiring Institution. The RDVP Schedule Reconciliation and RDVP Allowable Values reports will only be created in the event there are issues with these checks.

For easy identification of all validations, the file below contains all NSF and SFR 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.