3/30/2022 Version 1 | |||||||||||||||||||||
Template Name: ECIP Disaggregate Qualified Lending Data (CU) | |||||||||||||||||||||
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 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
3 | Unsecured credit card loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
4 | Payday alternative loans (PALs I and PALs II) (FCU only) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
5 | Non-federally guaranteed student loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
6 | All other unsecured loans/lines of credit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
7 | New vehicle loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
8 | Used vehicle loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
9 | Leases receivable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
10 | All other secured non-real estate loans / lines of credit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
11 | Loans / lines of credit secured by first lien on single 1-4 family res property | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
12 | Loans / lines of credit secured by junior lien on single 1-4 family res property | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
13 | All other real estate loans / lines of credit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
14 | Commercial loans / lines of credit real estate secured | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
15 | Commercial loans / lines of credit not real estate secured | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |