| This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2090-NEW). Responses to this collection of information are required in order to obtain benefits under the National Clean Investment Fund (NCIF) and Clean Communities Investment Accelerator (CCIA) programs. An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The public reporting and recordkeeping burden for this collection of information is estimated to be 162.5 hours per response. Send comments on the Agency’s need for this information, the accuracy of the provided burden estimates and any suggested methods for minimizing respondent burden to the Regulatory Support Division Director, U.S. Environmental Protection Agency (2821T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed form to this address. | ||
| Color Key for Report Template Column Headers (Data Elements) | Data Dictionary | |
| Black | Indicates a data element i.e. a column header or field in the report template. Each data element has a unique identifier in the following format, "DE000" when complete, allowing for cross-reference to the data dictionary. | |
| Red | Indicates a data element that requires a longitudinal reporting since it this data will change over time, like the unpaid principal balance, for example. | "Longitudinal Data Element?" = YES |
| Green | Indicates a data element that is itself a calculated or inferred value, like many of the greenhouse gas emissions that are computed based on data input parameters like interconnection dates and geographic locations, for example. | |
| Black with Red Text | Indicates metadata that will get added to the report based on when the data gets loaded into the system. The grantee does not report this data directly. | |
| Pink | Indicates a data element that serves as the primary or foreign key among different flat files (0-AWARD; 1-TRANSACTIONS...; 4-PROJECTS; and so on) in the report template, thus linking the flat files together into a cohesive report. | |
| Blue | Indicates a field or column header included in the flat file report template for ease of reference. Such fields will *not* be included in the actual report template and only help to make the test data more human readable. | |
| # | Assumptions | |
| 1 | Each transaction must have one and only one "transaction purpose." There are five possible values for the field "Transaction Purpose": TECHNICAL; FINANCIAL; SUBAWARD-TECHNICAL; SUBAWARD-FINANCIAL; ADMIN. | |
| 2 | Each prime recipient can report transactions to end beneficiaries through direct lending financial operations on the "2-TRANSACTIONS-ENDBENEFICIARIES" tab or can report transactions to intermediaries, like subrecipients or the creation of financial products, like credit enhancements or loan loss reserves, that require the creation of reserve accounts with financial set asides. | |
| # | Business Objects | Data Element or Field Name |
| 1 | Grant award (identified by the US EPA Grant Number) | US EPA Grant Number (DE003) |
| 2 | Transactions (identified by a unique transaction number in the general or subledger) | Transaction Identifier - Grantee (DE005) |
| 3 | Contracts (identified by a unique contract identifier in the ledger or subledger) | Contract Identifier for Financial Assistance (DE310) |
| 4 | Projects (identified through a unique project identifier) | Project Identifier - Grantee (DE070) |
| 5 | Project Sites (identified through a unique site identifier) | Project Site Unique Identifier - Grantee (DE316) |
| 6 | Benefits | No identifier required. |
| Miscellaneous Notes | ||
| 1 | Tab "4-PROJECTS" has grouped columns which can be expanded or collapsed using the grey "+" and "-". These groupings correspond to the three priority project areas and make it easier to navigate that tab. | |
| GGRF Program (DE001) | Recipient Name (DE002) | US EPA Grant Number (DE003) | Unique Entity Identifier (UEI) (DE004) | Transaction Identifier - Grantee (DE005) | Transaction Identifier - EPA (DE009) | Date Reported (DE011) | Counterparty Name (DE007) | Counterparty TIN or EIN (DE008) | Counterparty Type (DE023) | NAICS (DE064) | Low-Income Owned or Controlled (DE065) | Investee or Borrower or Recipient - LIDAC Type (DE096) | Qualifies as LIDAC in CEJST? (DE263) | Transaction Amount (DE016) | Transaction Date (DE252) | Financial Assistance Provider Name (DE022) | Financial Assistance Provider TIN or EIN (DE024) | Contract Identifier for Financial Assistance (DE310) | Transaction Purpose (DE012) | Technical Assistance Type (DE083) | Finance Type (DE013) | Financial Assistance Type (DE014) | Financial Assistance Type Description (DE015) | Principal Amount (DE241) | Date Originated (DE010) | Transaction Identifier - Counterparty (DE253) | GGRF Recycled Funds Amount (DE020) | Interest Rate (DE027) | Interest Type (DE028) | Maximum Interest Rate (DE029) | Points (DE030) | Origination Fees (DE031) | Amortization Type (DE032) | Equity-Like Features (DE033) | Debt-Equity Conversion (DE034) | Term in Months (DE035) | Guarantee by Third Party (DE036) | Forgivable Loan (DE037) | Amount of Forgivable Loan (DE038) | Transaction Identifier - Originator | Client ID (reported to CDFI Fund) (DE057) | Loan-to-Value Ratio (DE215) | Loan Loss Reserve Requirement (DE217) | Investment Tax Credit (ITC) Amount (DE260) | Principal Subsidy Amount at Time of Origination (DE261) | Security Interest (DE262) | Investment Tax Credit (ITC) Direct Pay Amount (DE266) | Subsidy Type (DE268) | Project Identifier - Grantee (DE070) | Unpaid Principal (DE026) | Financial Product Status (DE021) | Delinquency - 30 Days or Less (DE270) | Delinquency - 31 to 60 Days (DE271) | Delinquency - 61 to 90 Days (DE272) | Delinquency - 91 or More Days (DE273) | Project Title (DE074) | Project Sponsor Name (DE279) | Project Sponsor Address Line 1 (DE280) | Project Sponsor Address Line 2 (DE281) | Project Sponsor City (DE282) | Project Sponsor State or Territory (DE283) | Project Sponsor ZIP Code (DE284) | Project Sponsor TIN or EIN (DE285) | Project Financing Stage (DE295) | Project Financing Source (Public) - Name (DE211) | Project Financing Source (Public) - Amount (DE212) | Project Financing (All Public Sources) - Subtotal (DE309) | Project Financing Source (Private) - Name (DE213) | Project Financing Source (Private) - Amount (DE214) | Project Financing (All Private Sources) - Subtotal (DE294) | Total Project or Development Cost (DE103) |
| DE001 | DE002 | DE003 | DE004 | DE005 | DE009 | DE011 | DE007 | DE008 | DE023 | DE064 | DE065 | DE096 | DE263 | DE016 | DE252 | DE022 | DE024 | DE310 | DE012 | DE083 | DE013 | DE014 | DE015 | DE241 | DE010 | DE253 | DE020 | DE027 | DE028 | DE029 | DE030 | DE031 | DE032 | DE033 | DE034 | DE035 | DE036 | DE037 | DE038 | DE006 | DE057 | DE215 | DE217 | DE260 | DE261 | DE262 | DE266 | DE268 | DE070 | DE026 | DE021 | DE270 | DE271 | DE272 | DE273 | DE074 | DE279 | DE280 | DE281 | DE282 | DE283 | DE284 | DE285 | DE295 | DE211 | DE212 | DE309 | DE213 | DE214 | DE294 | DE103 |
| GGRF Program (DE001) | Recipient Name (DE002) | US EPA Grant Number (DE003) | Unique Entity Identifier (UEI) (DE004) | Transaction Identifier - Grantee (DE005) | Transaction Identifier - EPA (DE009) | Date Reported (DE011) | Counterparty Name (DE007) | Counterparty TIN or EIN (DE008) | Counterparty Type (DE023) | NAICS (DE064) | Low-Income Owned or Controlled (DE065) | Investee or Borrower or Recipient - LIDAC Type (DE096) | Qualifies as LIDAC in CEJST? (DE263) | Transaction Amount (DE016) | Transaction Date (DE252) | Financial Assistance Provider Name (DE022) | Financial Assistance Provider TIN or EIN (DE024) | Contract Identifier for Financial Assistance (DE310) | Transaction Purpose (DE012) | Technical Assistance Type (DE083) | Finance Type (DE013) | Financial Assistance Type (DE014) | Financial Assistance Type Description (DE015) | Principal Amount (DE241) | Date Originated (DE010) | Transaction Identifier - Counterparty (DE253) | GGRF Recycled Funds Amount (DE020) | Interest Rate (DE027) | Interest Type (DE028) | Maximum Interest Rate (DE029) | Points (DE030) | Origination Fees (DE031) | Amortization Type (DE032) | Equity-Like Features (DE033) | Debt-Equity Conversion (DE034) | Term in Months (DE035) | Guarantee by Third Party (DE036) | Forgivable Loan (DE037) | Amount of Forgivable Loan (DE038) | Transaction Identifier - Originator | Client ID (reported to CDFI Fund) (DE057) | Loan-to-Value Ratio (DE215) | Loan Loss Reserve Requirement (DE217) | Investment Tax Credit (ITC) Amount (DE260) | Principal Subsidy Amount at Time of Origination (DE261) | Security Interest (DE262) | Investment Tax Credit (ITC) Direct Pay Amount (DE266) | Subsidy Type (DE268) | Project Identifier - Grantee (DE070) | Unpaid Principal (DE026) | Financial Product Status (DE021) | Delinquency - 30 Days or Less (DE270) | Delinquency - 31 to 60 Days (DE271) | Delinquency - 61 to 90 Days (DE272) | Delinquency - 91 or More Days (DE273) | Project Title (DE074) | Project Sponsor Name (DE279) | Project Sponsor Address Line 1 (DE280) | Project Sponsor Address Line 2 (DE281) | Project Sponsor City (DE282) | Project Sponsor State or Territory (DE283) | Project Sponsor ZIP Code (DE284) | Project Sponsor TIN or EIN (DE285) | Project Financing Stage (DE295) | Project Financing Source (Public) - Name (DE211) | Project Financing Source (Public) - Amount (DE212) | Project Financing (All Public Sources) - Subtotal (DE309) | Project Financing Source (Private) - Name (DE213) | Project Financing Source (Private) - Amount (DE214) | Project Financing (All Private Sources) - Subtotal (DE294) | Total Project or Development Cost (DE103) |
| DE001 | DE002 | DE003 | DE004 | DE005 | DE009 | DE011 | DE007 | DE008 | DE023 | DE064 | DE065 | DE096 | DE263 | DE016 | DE252 | DE022 | DE024 | DE310 | DE012 | DE083 | DE013 | DE014 | DE015 | DE241 | DE010 | DE253 | DE020 | DE027 | DE028 | DE029 | DE030 | DE031 | DE032 | DE033 | DE034 | DE035 | DE036 | DE037 | DE038 | DE006 | DE057 | DE215 | DE217 | DE260 | DE261 | DE262 | DE266 | DE268 | DE070 | DE026 | DE021 | DE270 | DE271 | DE272 | DE273 | DE074 | DE279 | DE280 | DE281 | DE282 | DE283 | DE284 | DE285 | DE295 | DE211 | DE212 | DE309 | DE213 | DE214 | DE294 | DE103 |
| GGRF Program (DE001) | Recipient Name (DE002) | US EPA Grant Number (DE003) | Unique Entity Identifier (UEI) (DE004) | Transaction Identifier - Grantee (DE005) | Transaction Identifier - EPA (DE009) | Date Reported (DE011) | Counterparty Name (DE007) | Counterparty TIN or EIN (DE008) | Counterparty Type (DE023) | NAICS (DE064) | Low-Income Owned or Controlled (DE065) | Investee or Borrower or Recipient - LIDAC Type (DE096) | Qualifies as LIDAC in CEJST? (DE263) | Transaction Amount (DE016) | Transaction Date (DE252) | Financial Assistance Provider Name (DE022) | Financial Assistance Provider TIN or EIN (DE024) | Contract Identifier for Financial Assistance (DE310) | Transaction Purpose (DE012) | Technical Assistance Type (DE083) | Finance Type (DE013) | Financial Assistance Type (DE014) | Financial Assistance Type Description (DE015) | Principal Amount (DE241) | Date Originated (DE010) | Transaction Identifier - Counterparty (DE253) | GGRF Recycled Funds Amount (DE020) | Interest Rate (DE027) | Interest Type (DE028) | Maximum Interest Rate (DE029) | Points (DE030) | Origination Fees (DE031) | Amortization Type (DE032) | Equity-Like Features (DE033) | Debt-Equity Conversion (DE034) | Term in Months (DE035) | Guarantee by Third Party (DE036) | Forgivable Loan (DE037) | Amount of Forgivable Loan (DE038) | Transaction Identifier - Originator | Client ID (reported to CDFI Fund) (DE057) | Loan-to-Value Ratio (DE215) | Loan Loss Reserve Requirement (DE217) | Investment Tax Credit (ITC) Amount (DE260) | Principal Subsidy Amount at Time of Origination (DE261) | Security Interest (DE262) | Investment Tax Credit (ITC) Direct Pay Amount (DE266) | Subsidy Type (DE268) | Project Identifier - Grantee (DE070) | Unpaid Principal (DE026) | Financial Product Status (DE021) | Delinquency - 30 Days or Less (DE270) | Delinquency - 31 to 60 Days (DE271) | Delinquency - 61 to 90 Days (DE272) | Delinquency - 91 or More Days (DE273) | Project Title (DE074) | Project Sponsor Name (DE279) | Project Sponsor Address Line 1 (DE280) | Project Sponsor Address Line 2 (DE281) | Project Sponsor City (DE282) | Project Sponsor State or Territory (DE283) | Project Sponsor ZIP Code (DE284) | Project Sponsor TIN or EIN (DE285) | Project Financing Stage (DE295) | Project Financing Source (Public) - Name (DE211) | Project Financing Source (Public) - Amount (DE212) | Project Financing (All Public Sources) - Subtotal (DE309) | Project Financing Source (Private) - Name (DE213) | Project Financing Source (Private) - Amount (DE214) | Project Financing (All Private Sources) - Subtotal (DE294) | Total Project or Development Cost (DE103) |
| DE001 | DE002 | DE003 | DE004 | DE005 | DE009 | DE011 | DE007 | DE008 | DE023 | DE064 | DE065 | DE096 | DE263 | DE016 | DE252 | DE022 | DE024 | DE310 | DE012 | DE083 | DE013 | DE014 | DE015 | DE241 | DE010 | DE253 | DE020 | DE027 | DE028 | DE029 | DE030 | DE031 | DE032 | DE033 | DE034 | DE035 | DE036 | DE037 | DE038 | DE006 | DE057 | DE215 | DE217 | DE260 | DE261 | DE262 | DE266 | DE268 | DE070 | DE026 | DE021 | DE270 | DE271 | DE272 | DE273 | DE074 | DE279 | DE280 | DE281 | DE282 | DE283 | DE284 | DE285 | DE295 | DE211 | DE212 | DE309 | DE213 | DE214 | DE294 | DE103 |
| Project Identifier - Grantee | Project Identifier - EPA | Project Site Unique Identifier - Grantee | Project Site Unique Identifier - EPA | Project Site Address Line 1 | Project Site Address Line 2 | Project Site City | Project Site State | Project Site ZIP Code | Project Site County | Project Site Census Tract Code | Project Site Census Block Group | Project Site Census Block | Project Site Census Tract and Block Group Year | Project Latitude (Y-Coordinate) | Project Longitude (X-Coordinate) | Project Location Description | Does Project Site Qualify as LIDAC in CEJST? | What date did the required project signage get posted? |
| DE070 | DE072 | DE316 | DE317 | DE254 | DE255 | DE088 | DE089 | DE090 | DE267 | DE091 | DE314 | DE315 | DE092 | DE094 | DE093 | DE095 | DE263 | DE308 |
| Transaction ID - Grantee | Transaction ID - EPA | Project Identifier - Grantee | Project Identifier - EPA | Carbon Dioxide Equivalent (CO2e) | Carbon Dioxide (CO2) | Methane (CH4) | Hydrofluorocarbons (HFCs) | Nitrous Oxide (N2O) | Perfluorocarbons (PFCs) | Sulfur Hexafluoride (SF6) | Nitrogen Trifluoride (NF3) | Primary Fine Particulate Matter (PM2.5) | Total Fine Particulate Matter (PM2.5) | Particulate Matter (PM10) | Nitrogen Dioxide (NO2) | Sulfur Dioxide (SO2) | Ground-Level Ozone (O3) | Carbon Monoxide (CO) | Lead (Pb) | Ammonia (NH3) | Volatile Organic Compounds (VOCs) |
| DE005 | DE009 | DE070 | DE072 | DE133 | DE134 | DE135 | DE136 | DE137 | DE138 | DE139 | DE140 | DE141 | DE142 | DE143 | DE144 | DE145 | DE146 | DE147 | DE148 | DE149 | DE150 |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |