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


Home > Industry Analysis > Failed Banks > Failed Banks > Structured Data Specifications


Structured Transactions (LLC) Data Specifications (version 1.2)

FDIC structured transactions include both Single Family Deals and Non-Single Family/Commercial Deals. The table below contains two links to the specific FDIC LLC Data Specification required for monthly loan level detail reporting. Each link corresponds to the Data Specification pertaining to each asset class with transmission instructions, templates, and FAQs to provide guidance and clarification of the required data set. For both asset types, fields that cannot be populated should remain blank. For Non-Single Family/Commercial asset reporters, certain data elements may not pertain to the assets collateralizing a particular portfolio.

File

Description

LLC_Comm_Specification_201307.xlsx

File containing reporting requirements for Commercial assets in the LLC program.

LLC_SFR_Specification_201307.xlsx

File containing reporting requirements for Single Family assets in the LLC program. This applies only to asset pools containing developed 1-4 Single Family Residential Mortgages.

LLC Welcome Package

Detailed reporting instructions and Microsoft Excel Templates.
- Instructions for LLC Data Submissions (.doc)
- LLCDM Loan Details Template Commercial (.xlsx)
- LLCDM Loan Details Template SF (.xlsx)


Updates to the LLC Data Specification:

Reporting via RTSP: Datafiles are to be uploaded via:

https://drr-rtsp.com

Addition of source validations for the datafile. Source validations are data validations that are performed as the datafile is uploaded into RTSP. These validations primarily apply to those data fields which ‘must be populated’. Please see the applicable Specification above for details.

Addition of RDVP and LAD validations for the datafile. RDVP validations test certain fields for logic with related fields and enumerations. LAD validations test certain fields against the monthly accounting reports for reportable asset activity. Please see the applicable Specification above for details.

FDIC LLC Asset ID Assignment Methodology

The Structured Transactions Agreement requires Managing Members (MMs) to comply with LLC data reporting standards described in the LLC Data Specifications. The specifications require MMs to submit asset level data for each asset. One of the required asset level data elements, the FDICLOANID, is a unique identifier assigned by the FDIC to each asset. Since FDICLOANIDs serve the important purpose of tracking assets throughout the life of the Structured Transactions Agreement, FDIC will reject any data submission with blank or invalid FDIC LLC Asset IDs. The FDIC LLC Asset ID Assignment Methodology is the same methodology as found in Structured Transactions (LLC) Data Specifications 1.2.

Questions?

General Questions?

If you have general questions about FDIC Structured Transactions (LLCs) please read:

Questions About Structured Transactions (LLC) Data Reporting Requirements

If you have questions about your institutions' Structured Transactions (LLC) data reporting requirements, please see the FAQs tab in the LLC Specification files listed above.

Or if your question is not contained within the FAQs:

  • Contact your assigned FDIC RSAM specialist