Generate 2019 Aggregate Report (Applications by Ethnicity and Sex)

[chynnakeys]

Applications by Ethnicity and Sex:

"DISPOSITION OF OF LOAN APPLICATIONS, BY ETHNICITY 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 Ethnicity and Sex"
type: "Aggregate"
desc: "Disposition of loan applications, by ethnicity 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 Ethnicity and Sex by characteristics
• Subtotaled by Action Taken Type 1, 2, 3, 4, 5, 6

Ethnicity and Sex Characteristics

Ethnicity and Sex Characteristics

• Race
• Ethnicity

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:

[omnipresent07]

Closed via #2699

The report still needs to be rendered on the UI. Issue for pub-ui is here: cfpb/hmda-pub-ui#265