Generate 2019 Aggregate Report (Reporting Financial Institutions)

[chynnakeys]

Reporting Financial Institutions:

"LIST OF FINANCIAL INSTITUTIONS WHOSE DATA MAKE UP THE 2018 MSA/MD AGGREGATE REPORT"

Report Structure

Data model: here

This table needs to include the 2018 data disclosure rules require that loan amount be binned to midpoint for the $10,000 interval into which the value falls (i.e. loans between $10,000 and $19,999.99 are binned to $15,000). See #2485

table: "Reporting Financial Institutions"
type: "Aggregate"
desc: "LIST OF FINANCIAL INSTITUTIONS WHOSE DATA MAKE UP THE 2018 MSA/MD AGGREGATE REPORT"
year
report-date
msa

2017 Report Example: https://ffiec.cfpb.gov/data-publication/aggregate-reports/2017/MD/47894/i

Overall table filters

• Includes only institutions whose data make up the 2018 MSA/MD Aggregate Report for that MSA

Dispositions

This table will not include any dispositions, as we will no longer distinguish between institutions who have a home or branch office in the MSA/MD and institutions who do not have a home or branch office in the MSA/MD.

Types of A&D Reports

Here

Sample Mockup:

[omnipresent07]

Closed via #2689