Public Transmittal Sheet (TS) - Data Fields

activity_year

• Description: The calendar year of data collection.

  activity_year	Value
  2017	2017
  2018	2018
  2019	2019
  2020	2020
  2021	2021
  2022	2022
  2023	2023
  2024	2024

calendar_quarter

• Description: The calandar quarter to which the data refer. Quarter 4 is for the annual submission of data.
• Values:
  • 4

lei

• Description: The LEI (Legal Entity Identifier) of the filing institution.
• Values:
  • Various values

tax_id

• Description: The federal tax ID of the filing institution.
• Values:
  • Various values

agency_code

• Description: The HMDA agency code of the filing institution.

• Values:

  Value	Abbreviation	Name
  1	OCC	Office of the Comptroller of the Currency
  2	FRB	Federal Reserve System
  3	FDIC	Federal Deposit Insurance Corporation
  5	NCUA	National Credit Union Administration
  7	HUD	Department of Housing and Urban Development
  9	CFPB	Consumer Financial Protection Bureau

respondent_name

• Description: The name of the filing institution.
• Values:
  • Various values

respondent_state

• Description: The 2 letter state code for the office of the filing institution.
• Values:
  • Valid state codes

respondent_city

• Description: The city name for the office of the filing institution.
• Values:
  • Various values

respondent_zip_code

• Description: The ZIP code for the office of the filing institution.
• Values:
  • Various values

lar_count

• Description: The number of Loan Application Records (LAR) contained in the institution's LAR data file.
• Values:
  • Various values