Generate 2019 Aggregate Report (Applications by Race and Sex)

[chynnakeys]

Applications by Race and Sex:

"DISPOSITION OF OF LOAN APPLICATIONS, BY RACE AND SEX OF APPLICANT"

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

lei
table: "Applications by Race and Sex"
type: "Aggregate"
desc: "Disposition of loan applications, by race and sex of applicant"
year "2018"
report-date
msa

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

Overall table filters

• Breaks down Race and Sex by characteristics
• Subtotaled by Action Taken Type 1, 2, 3, 4, 5, 6

Race and Sex Characteristics

Race and Sex Characteristics
• Race
• Sex

Dispositions

This table includes the following dispositions:

Action Taken
• Loans Originated: Action Taken = 1
• Applications Approved but not Accepted: Action Taken = 2
• Applications Denied by Financial Institution: Action Taken = 3
• Applications Withdrawn by Applicant: Action Taken = 4
• File Closed for Incompleteness: Action Taken = 5
• Purchased Loans: Action Taken = 6

Types of A&D Reports

Here

Sample Mockup: