ECIP Disaggregate Qualified Lending Data (Banks & Holdin

3/30/2022 Version 1
Template Name: ECIP Disaggregate Qualified Lending Data (BHC)
Instructions to Reporter: a. Do not change the cell formatting. b. Do not reformat the template. c. Only input numbers (No symbols such as "$", ","). d. Only input whole dollar amounts (No fractions or decimals). Step 1 - Populate your data in the .XLSX file, starting on row 8. Step 2 - Save the fully populated file as .CSV file. Step 3 - Upload the .CSV file to the portal.
Field ID	ISR_ID__c	Lending_Plan_Category__c	Dollar_Originations_TO__c_	LMI_Borrowers__c	Other_Targeted_Populations__c	Low_Income_Borrowers__c	MTGE_Lending_Other_Targeted_Populations__c	Rural_Communities__c	Urban_Low_Income_Communities__c	Underserved_Communities__c	Minority_Communities__c	Persistent_Poverty_Counties__c	IN_Country_Indian_REZ_Native_Hawaiian__c	U_S_Territories__c	Small_Businesses_or_Farms__c	Underserved_Small_Businesses__c	Affordable_Housing__c	Public_Welfare_Comm_Dev_Investments1__c	Community_Service_Facility__c	Deeply_Affordable_Housing__c	Public_Welfare_Comm_Dev_Investments2__c
Label	ISR ID	Lending Plan Category	(Column A) Total Loan Originations	Qualified Lending Originations (including Deep Impact Lending Originations) : People : (Column B) LMI Borrowers	Qualified Lending Originations (including Deep Impact Lending Originations) : People : (Column C) Other Targeted Populations	Qualified Lending Originations (including Deep Impact Lending Originations) : People : Deep Impact Lending : (Column D) Low-Income Borrowers	Qualified Lending Originations (including Deep Impact Lending Originations) : People : Deep Impact Lending : (Column E) Mortgage Lending to Other Targeted Populations	Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column F) Rural Communities	Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column G) Urban Low-Income Communities	Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column H) Underserved Communities	Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column I) Minority Communitites	Qualified Lending Originations (including Deep Impact Lending Originations) : Places : Deep Impact Lending : (Column J) Persistent Poverty Counties	Qualified Lending Originations (including Deep Impact Lending Originations) : Places : Deep Impact Lending : (Column K) [Indian Country] / [Indian Reservations and Native Hawaiian Homelands]	Qualified Lending Originations (including Deep Impact Lending Originations) : Places : Deep Impact Lending : (Column L) U.S. Territories	Qualified Lending Originations (including Deep Impact Lending Originations) : Businesses : (Column M) Small Businesses or Farms	Qualified Lending Originations (including Deep Impact Lending Originations) : Businesses : Deep Impact Lending : (Column N) Underserved Small Businesses	Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : (Column O) Affordable Housing	Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : (Column P) Public Welfare and Community Development Investments1	Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : (Column Q) Community Service Facility	Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : Deep Impact Lending : (Column R) Deeply Affordable Housing	Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : Deep Impact Lending : (Column S) Public Welfare and Community Development Investments2
Required or Optional	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required	Required
Help Text	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
	1	Loans secured by construction land development and other land loans	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	2	Loans secured by farmland	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	3	Loans secured by 1-4 family residential properties	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	4	Loans secured by multifamily (5 or more) residential properties	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	5	Loans secured by nonfarm nonresidential properties	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	6	Loans to finance agricultural production and other loans to farmers	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	7	Commercial and industrial loans	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	8	Loans to individuals for household family and other personal expenditures	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	9	Lease financing receivables	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	10	Direct and indirect investments in real estate ventures	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	11	Equity investments without readily determinable fair values	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0