Public Panel - Data Fields

activity_year

• Description: The collection year of the HMDA data to which the Panel file relates

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

lei

• Description: A financial institution’s Legal Entity Identifier
• Values:
  • Varying values

tax_id

• Description: The federal tax ID of the institution
• Values:
  • Varying values

agency_code

• Description: The integer code corresponding to an institution's regulatory agency

• 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

id_2017

• Description: The 2017 HMDA Platform primary identifier for an institution. This identifier is used in the naming of 2017 Modified LAR files.
• Values:
  • Varying values

respondent_rssd

• Description: The National Information Center RSSD of the institution
• Values:
  • -1: NULL/blank
  • Varying values

respondent_name

• Description: The name of the institution as registered with GLEIF
• Values:
  • Varying values

respondent_state

• Description: Two-letter state code of the institution's headquarters
• Values:
  • Varying values

respondent_city

• Description: The headquarters city of the institution
• Values:
  • Varying values

assets

• Description: The count of assets of the institution in the 4th quarter of the HMDA collection year
• Values:
  • -1: NULL/blank
  • Varying values

other_lender_code

• Description: Derived assignment of an institution's status as, or relationship to, a depository institution
• Values:
  • 0: Depository Institution
  • 1: MBS of state member bank
  • 2: MBS of bank holding company
  • 3: Independent mortgage banking subsidiary
  • 5: Affiliate of a depository institution
  • -1: NULL/blank

parent_rssd

• Description: The National Information Center's RSSD for the parent of the institution
• Values:
  • -1: NULL/blank
  • Varying values

parent_name

• Description: The legal name of the parent institution
• Values:
  • Varying values

top_holder_rssd

• Description: The National Information Center's RSSD for the top holder of the institution
• Values:
  • -1: NULL/blank
  • Varying values

top_holder_name

• Description: The legal name of the top holder of the institution
• Values:
  • Varying values