Generate 2019 Aggregate Report (Applications by Median Age of Homes)

[chynnakeys]

"DISPOSITION OF LOAN APPLICATIONS, BY MEDIAN AGE OF HOMES AND TYPE OF LOAN"

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: "Applications by Median Age of Homes"
type: "Aggregate"
desc: "Disposition of loan applications, by median age of homes and type of loan"
year "2018"
report-date
msa

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

Overall table filters

• Action Taken Type 1, 2, 3, 4, 5

Census Tract Characteristics

• Median Age of Homes

Dispositions

This table includes the following dispositions:

Loan Type
• FHA, FSA/RHS & VA (A): Total Units = 1 through 4; Purpose of Loan = 1; Loan Type = 2, 3, 4
• Conventional (B): Total Units = 1 through 4; Purpose of Loan = 1; Loan Type = 1
• Refinancings (C): Total Units = 1 through 4; Purpose of Loan = 31, 32
• Home Improvement Loans (D): Total Units = 1 through 4; Purpose of Loan = 2
• Loans on Dwellings For 5 or More Families (E): 5+ Units
• Nonoccupant Loans from Columns A, B, C ,& D (F): All loans from columns A through @ where Occupancy Type = 2, 3
• Loans On Manufactured Home Dwellings From Columns A, B, C & D (G): Construction Method = 2

(A), (B), (C), (D) = Categorized as Loans on 1-to-4 Family and Manufactured Home Dwellings
(A), (B) = Sub-categorized as Home Purchase Loans

Action Taken
• Applications Received: Action Taken = 1, 2, 3, 4, and 5
• 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

Types of A&D Reports

Here

Sample Mockup: