Appendix C: Transaction and Project System Data Dictionary

Appendix C. Transaction and Project System Data Dictionary.xlsx

GGRF Accomplishment Reporting (NEW)

Appendix C: Transaction and Project System Data Dictionary

OMB:

Document [xlsx]

Download: xlsx | pdf

Data Element

Title

Report Flat File Name

Definition for Field

Data Type

Picklist Values

Definition for Picklist Values

Unit of Measure

Format

Applicability

Longitudinal Data Element?

Conditional Logic

Field Source

CDFI/NACA/RRP TLR Object - Data Point Name

Related fields

Related fields: Title

DE001

GGRF Program

0-Award

This field identifies the specific GGRF program -- either Clean Communities Investment Accelerator (CCIA), National Clean Investment Fund (NCIF) or Solar for All (SFA) -- that the recipient is reporting to EPA for a particular award. A single grant award can have one and only one GGRF program.

Picklist

CCIA;
NCIF;
SFA

CCIA Clean Communities Investment Accelerator

NCIF National Clean Investment Fund

SFA Solar for All

not applicable

0-ALL

Mandatory field.

GGRF

DE002

Recipient Name

0-Award

This field contains the legal name of the GGRF award recipient.

String

not applicable

0-ALL

Mandatory field.

GGRF

DE003

US EPA Grant Number

0-Award;#1-Transaction

This field contains the system-generated unique identifier for the grant award. This number is created by US EPA and is stated on the award letter(?)

String

not applicable

0-ALL

Mandatory field.

GGRF

2;#2;#4;#4

Recipient Name;#2;#Unique Entity Identifier (UEI);#4

DE004

Unique Entity Identifier (UEI)

0-Award

This field contains the system-generated unique identifier that all federal grant recipients must obtain from SAM.gov. It is also known by the acronym UEID. Every legal entity receiving a Federal grant should have one and only one UEID.

String

not applicable

0-ALL

Mandatory field.

SAM.GOV

2;#2;#3;#3

Recipient Name;#2;#US EPA Grant Number;#3

DE005

Transaction Identifier - Grantee

1-Transaction;#2-Project

This field contains a value that uniquely identifies each of the grant recipient's transactions in their financial system of record. Grant recipients should submit the unaltered value and unaltered format from their system of record.

String

not applicable

0-ALL

Mandatory field.

GGRF

DE006

Transaction Identifier - Originator

1-Transaction

This field contains the unique identifier for any technical or financial assistance transaction in the originating entity's system of record. The originating entity could be the grant (prime) recipient or a subrecipient (coalition member). If the value is created and stored in a subrecipient or even contractor's system of record, then the prime recipient should report that the unique identifier "as is" to US EPA. The identifier can be a combination of both letters and numbers and should start with a letter. It should not contain any special characters such as, but not limited to, commas and exclamation points. Do not use names, social security numbers or any other personally identifying information in creating Transaction ID - Originator. This field should contain a unique identifier that persists through any lifecycle status changes of a financial assistance product (see DE014), like a term loan. Changes in status for the financial assistance product should be stored and reported separately in DE021 labelled, 'Financial Product Status'.

String

not applicable

0-ALL

Conditionally required if DE014 (Financial Assistance Type=not N/A); else, null.

Modified from CDFI NACA RRP TLR (December 2023)

Originator Transaction ID

14;#14

Financial Assistance Type;#14

DE007

Counterparty Name

1-Transaction

This field captures the legal name of the counterparty to any business-to-business transaction that the recipient or subrecipient or contractor makes.

String

not applicable

0-ALL

Mandatory field.

CDFI FUND (modified)

DE008

Counterparty TIN or EIN

1-Transaction

Enter the federal tax identification number or TIN (sometimes called an EIN) for the counterparty to transactions the prime recipient makes. Recipients, subrecipients or contractors should never under any circumstance whatsoever send EPA Social Security Numbers (SSNs) also known as Individual Tax Identification Numbers (ITINs) for data security and privacy reasons.

String

12-3456789

0-ALL

Mandatory field.

CDFI FUND (modified)

8;#8;#24;#24

Counterparty TIN or EIN;#8;#Financial Assistance Provider TIN or EIN;#24

DE009

Transaction Identifier - EPA

1-Transaction

This field will uniquely identify the rolled up transaction and, likely, project identifiers for the grant recipient, their subrecipients (if any), and their contractors. The field will likely contain data that the recipient reports to EPA and will be tied to a global unique identifier (GUID) or universal unique identifier (UUID) to accommodate for modifying or, in limited circumstances, deleting of records that were created in prior reporting periods.

String

not applicable

0-ALL

Mandatory field.

GGRF

DE010

Date Originated

1-Transaction

The date that the financial assistance product was originated; say, a loan origination date, for example.

Date

YYYY-MM-DD

0-ALL

Required if DE012 "Transaction Purpose" = FINANCIAL; else, null. If Transaction Purpose = FINANCIAL, the Transaction Date and Date Originated should be the same date.

CDFI FUND

12;#12

Transaction Purpose;#12

DE011

Date Reported

0-Award;#1-Transaction

Enter the last date of the reporting period covered by this report. For quarterly reports, this will be the last date of the reporting quarter. For annual reports, this will be the last date of the reporting year .

Date

YYYY-MM-DD

0-ALL

Mandatory field.

CDFI FUND

DE012

Transaction Purpose

1-Transaction

A single transaction may have one and only one "transaction purpose" and a single "counterparty." This rule extends down to the subaward itself. A subaward transaction may only serve for either technical or financial assistance or administrative costs, but not two or more purposes and cannot lead to another subaward.

Picklist

TECHNICAL; FINANCIAL; SUBAWARD-TECHNICAL; SUBAWARD-FINANCIAL; ADMIN

not applicable

0-ALL

Mandatory field.

CDFI FUND (modified)

DE013

Finance Type

1-Transaction

If the transaction type in DE012 is "finance," please use one of the three picklist values to identify the type of finance involved: (1) ASSET is used for asset finance of any kind, such as financing the purchase and installation of a heat pump or rooftop solar, for example; (2) PROJECT is used for project finance of any kind where multiple lenders or financial agents participate in a structured project each contributing a layer in the capital stack; (3) CORPORATE is used exclusively for debt-equity or equity type transactions (defined in DE014 - Financial Assistance Type) that provide an ownership stake in the organization receiving the financial assistance.

Picklist

ASSET; PROJECT; CORPORATE; N/A

not applicable

0-ALL

Conditionally required if DE012 (Transaction Purpose = FINANCIAL); else, N/A. IF DE001 (GGRF Program= SFA) then CORPORATE IS NOT VALID

GGRF

Not applicable

14;#14;#1;#1

Financial Assistance Type;#14;#GGRF Program;#1

DE014

Financial Assistance Type

1-Transaction

Choose one of the pre-defined values below and report the type of financial assistance provided in this transaction. For Loan Guarantee, the GGRF recipient or subrecipient is a guarantor of this loan. For Loan Loss Reserve, the GGRF recipient or subrecipient is using the financial assistance award to provide loan loss reserve for this loan. For Capital Reserve, the GGRF recipient or subrecipient is using the financial assistance to leverage this loan.

Picklist

TERM; LOC; SUBSIDY; OTHER-CONSUMER-DEBT; LNGUARANTEE; LNLSRESERVE; OTHER-CREDIT-ENHANCEMENT; CAPRESERVE; LNPURCHASE; LNSECURITIZATION; OTHER-INSTITUTIONAL-DEBT; EQTYINV; DEBTEQTY; N/A

not applicable

0-ALL

Conditionally required if Transaction Purpose (DE012) = "FINANCIAL"; else, null.

Modified from CDFI NACA RRP TLR (December 2023)

Transaction Type

DE015

Financial Assistance Type Description

1-Transaction

If the "Financial Assistance Type" = OTHER, then please provide a simple description of the financial assistance type to help US EPA better understand the nature of the financial instrument.

String

not applicable

0-ALL

Conditionally required if DE014 (Financial Assistance Type) or DE083 (Technical Assistance Type) = OTHER; else, null.

GGRF

Not applicable.

14;#14

Financial Assistance Type;#14

DE016

Transaction Amount

1-Transaction

Report the amount of the loan original investment. The amount should be a non-zero positive whole number. For LOC such as credit cards, report the credit limit amount. If the credit limit amount is unknown, enter “1”.

Currency

USD

$1,000.00

0-ALL

Mandatory field.

CDFI FUND;#Modified from CDFI NACA RRP TLR (December 2023)

Original Loan/Investment Amount

DE020

GGRF Recycled Funds Amount

1-Transaction

Report the dollar amount of the recycled funds. The value of this field must be a positive number.

Currency

$1,000.00

0-ALL

Mandatory field.

GGRF

DE021

Financial Product Status

1-Transaction

This field captures the status of the transaction and the financial assistance product from the perspective of the lender whose asset it is.

Picklist

ACTIVE; PAIDOFF; SOLD; CHARGEDOFF; REFIN; RESTRUCT; N/A

not applicable

0-ALL

YES

Conditionally required if DE014 (Financial Assistance Type)=TERM or LOC or LNGUARANTEE; else, null.

Modified from CDFI NACA RRP TLR (December 2023)

DE022

Financial Assistance Provider Name

1-Transaction

Enter the legal name of the organization providing the financial assistance in this transaction -- as the lender, for example -- to the end beneficiary or recipient, like a household or small business or faith community.

String

not applicable

0-ALL

Conditionally required if the financial assistance provider is not the prime or lead grant recipient; else null.

CDFI FUND

23;#23;#24;#24

Counterparty Type;#23;#Financial Assistance Provider TIN or EIN;#24

DE023

Counterparty Type

1-Transaction

Choose one of the picklist values to describe the counterparty to the transaction. For individuals or households, use INDIVIDUAL-HOUSEHOLD. If the entity is not listed, choose OTHER.

Picklist

BANK; BUSINESS; CDE; CDFI; CDFI COMMUNITY DEVELOPMENT BANK; CDFI COMMUNITY DEVELOPMENT VENTURE CAPITAL FUND; CDFI CREDIT UNION; GOV-COUNTY; GOV-MUNICIPALITY; GOV-STATE; GOV-TRIBAL; GREEN BANK; NONPROFIT; INDIVIDUAL-HOUSEHOLD; OTHER

not applicable

0-ALL

Conditionally required if DE012 (TRANSACTION PURPOSE= FINANCIAL or TECHNICAL or SUBAWARD; else N/A.

CDFI FUND

23;#23;#58;#58;#62;#62;#63;#63

Counterparty Type;#23;#Investee or Borrower or Recipient Type;#58;#Entity Structure;#62;#Entity Structure Description;#63

DE024

Financial Assistance Provider TIN or EIN

1-Transaction

Enter the federal tax identification number or TIN (sometimes called an EIN) of the organization providing the financial assistance in this transaction -- as the lender, for example -- to the end beneficiary or recipient, like a household or small business or faith community. Recipients, subrecipients or contractors should never under any circumstance whatsoever send EPA Social Security Numbers (SSNs) also known as Individual Tax Identification Numbers (ITINs) for data security and privacy reasons.

String

not applicable

0-ALL

Conditionally required if the financial assistance provider is not the prime or lead grant recipient; else null.

Modified from CDFI NACA RRP TLR (December 2023)

8;#8;#24;#24

Counterparty TIN or EIN;#8;#Financial Assistance Provider TIN or EIN;#24

DE026

Unpaid Principal

1-Transaction

Report the unpaid principal balance of the loan as of the end of the most recent reporting period.

Currency

US dollars

0-ALL

YES

Conditionally required if If DE014 (Financial Assistance Type) = SUBSIDY, then N/A

CFPB

26;#26;#241;#241

Unpaid Principal;#26;#Principal Amount;#241

DE027

Interest Rate

1-Transaction

Report the interest rate charged to the borrower at origination. Enter the percentage as a decimal number (i.e. if the Interest Rate is 2.5%, enter 2.5). If the interest rate is unknown or not applicable, enter “99”.

Percent

0.000

0-ALL

Conditionally required if DE014 (Financial Assistance Type) = TERM or LOC or DEBTEQTY <other products?>; else, null. DE027 must be equal or greater than zero AND DE027 must be less than or equal to DE029 (Maximum Interest Rate) OR If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

CDFI NACA RRP TLR (December 2023)

DE028

Interest Type

1-Transaction

Choose one of the pre-defined values below and report the type of interest at origination.

Picklist

FIXED; ADJ; OTHER

00.000000

0-ALL

Conditionally required if DE014 (Financial Assistance Type) = TERM or LOC or DEBTEQTY <other products?> OR If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

Modified from CDFI NACA RRP TLR (December 2023)

DE029

Maximum Interest Rate

1-Transaction

For adjustable interest rate loans, report the maximum interest rate. Enter the percentage as a whole number (i.e., if the Interest Rate is 2.5%, enter 2.5).

Percent

0-ALL

Conditionally Required if DE028 (Interest Type) = ADJ or OTHER; else null. Or, if DE014 (FINANCIAL ASSISTANCE TYPE) = SUBSIDY, then N/A.

CFPB

DE030

Points

1-Transaction

Report the points charged to the borrower at origination. Exclude origination fees (do not report origination fees here). Report the points as a percentage of the original loan amount. Report it as a number rather than with the percentage sign (i.e. if the point at origination is 2.5%, enter 2.5). If the Points is unknown or not applicable, enter “99”.

Number

0-ALL

Conditionally required if DE014 (FINANCIAL ASSISTANCE TYPE = TERM) or LOC or DEBTEQTY. If DE014 (FINANCIAL ASSISTANCE TYPE =SUBSIDY) THEN N/A

CDFI FUND

DE031

Origination Fees

1-Transaction

Report the total loan origination fees, including processing, credit report, and other fees that borrowers have to either directly or indirectly pay at origination. Exclude points (do not report points here). “Origination Fees” should be a positive whole number. However, if there are no fees charged, enter zeros.

Currency

USD

$1,000.00

0-ALL

Conditionally required if DE014 (FINANCIAL ASSISTANCE TYPE = TERM or LOC or DEBTEQTY) AND DE031 (ORIGINATION FEES must be equal or greater than zero and less than DE016 (TRANSACTION AMOUNT) OR If DE014 (FINANCIAL ASSISTANCE TYPE =SUBSIDY) THEN N/A

CDFI FUND

Origination Fees

14;#14;#16;#16

Financial Assistance Type;#14;#Transaction Amount;#16

DE032

Amortization Type

1-Transaction

Choose one of the pre-defined values below and report how the financial note is amortized at origination.

Picklist

FULLAMORT; PARTAMORT; NONAMORT; OTHER

not applicable

0-ALL

Conditionally required if DE014 (FINANCIAL ASSISTANCE TYPE) = TERM or LOC or DEBTEQTY. If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

CDFI NACA RRP TLR (December 2023)

Amortization Type

DE033

Equity-Like Features

1-Transaction

Choose one of the pre-defined values below and report the type of equity-like feature. If a loan has more than one equity-like features, choose the one appearing first in the loan agreement.

Picklist

CONVDEBT; PERFINT; ROYALTIES; WARRANTS; OTHER

not applicable

0-ALL

Conditionally required if DE014 (FINANCIAL ASSISTANCE TYPE= DEBTEQTY. If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

CDFI NACA RRP TLR (December 2023)

Equity-Like Features

14;#14

Financial Assistance Type;#14

DE034

Debt-Equity Conversion

1-Transaction

For financial transactions where debt may be converted to equity, report the amount of the equity investment after the debt has been converted to equity.

Currency

not applicable

$1,000.00

0-ALL

Conditionally required If DE014 (FINANCIAL ASSISTANCE TYPE) = DEBTEQT.
OR If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

CFPB

Not applicable

14;#14

Financial Assistance Type;#14

DE035

Term in Months

1-Transaction

Report the term of a loan at origination in months. Enter the full term, not the remaining term of the financial note. “Term” must be a non-zero positive number and likely between 1 and 360 months. If the term is in days rather than months, report as a portion of the month. For example, if the term is 15 days, report as 0.5 month. If the Term is unknown or not applicable, enter “999”.

Number

months

240

0-ALL

Conditionally required if DE014 (FINANCIAL ASSISTANCE TYPE) = TERM or LOC or DEBTEQTY <other products?>; else, null. If DE014 (FINANCIAL ASSISTANCE TYPE) = SUBSIDY, then N/A

CDFI NACA RRP TLR (December 2023)

Term (in months)

14;#14

Financial Assistance Type;#14

DE036

Guarantee by Third Party

1-Transaction

If any portion of the loan is guaranteed by a third party, choose one of the pre-defined values below and report the source. Exclude performance guarantees.

Picklist

SBA; USDA; OTHERGOV; PERSONAL; OTHER; NONE

not applicable

0-ALL

Conditionally required if DE014 (FINANCIAL ASSISTANCE TYPE = TERM, LOC, DEBTEQTY or LNPURCHASE) else null. If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

CDFI NACA RRP TLR (December 2023)

Guarantee by Third Party

14;#14

Financial Assistance Type;#14

DE037

Forgivable Loan

1-Transaction

Report whether the loan or investment agreement stipulates that some or all of the outstanding balance of the loan or the equity may be forgiven upon meeting specified conditions. Enter “Do Not Know” if the information is either unknown or not applicable.

Picklist

YES; YESTM; NO; DO NOT KNOW

not applicable

0-ALL

Conditionally required If DE014 (FINANCIAL ASSISTANCE TYPE = TERM or LOC)
If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

CDFI NACA RRP TLR (December 2023)

Forgivable Loan

14;#14

Financial Assistance Type;#14

DE038

Amount of Forgivable Loan

1-Transaction

If the loan allows borrowers to have the balance of their loan either partially or totally forgiven if they meet certain conditions, note the amount rounded to the next whole dollar in this field.

Currency

USD

$1,000.00

0-ALL

Conditionally required if DE037 (Forgivable Loan = Yes). DE038 cannot be greater than or equal to DE016 (Transaction Amount) OR DE241 (PRINCIPAL) If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

GGRF

37;#37

Forgivable Loan;#37

DE057

Client ID (reported to CDFI Fund)

1-Transaction

The grant recipient or subrecipient can report the Client ID field that CDFIs use to uniquely identify their customers when reporting to the CDFI Fund. This data element helps to distinguish which clients/projects (investees, borrowers, or projects) are associated with which loans or investments. A client/project ID can be associated with one or more loans/investments. The identifier can be a combination of both letters and numbers and should start with a letter. It should not contain any special characters such as, but not limited to, commas and exclamation points. Do not use names, social security numbers or any other personal identifying information in creating Client ID. Please report the Client ID only if it matches the Client ID used when reporting to CDFI Fund via AMIS; otherwise, please leave blank.

String

not applicable

0-ALL

If transaction type is FINANCIAL AND financial Provider type is CDFI, the this field is required

CDFI NACA RRP TLR (December 2023)

Client ID

6;#6;#7;#7

Transaction Identifier - Originator;#6;#Counterparty Name;#7

DE064

NAICS

1-Transaction

Report the 6-digit North American Industry Classification (NAICS) Code that reflects investee’s/borrower’s/recipient’s nature of business/activity. Currently, NAICS Version 2017 is used. To determine the NAICS code for the business financed, go to http://www.census.gov/eos/www/naics/ and use the keyword search. If the NAICS is unknown or not applicable, enter “999999 ”.

String

MISSING

0-ALL

Conditionally required if DE058 (Investee or Borrower or Recipient Type) = BUS; else, null.

CDFI FUND

NAICS

DE065

Low-Income Owned or Controlled

1-Transaction

Report whether the investee/borrower is more than 50% owned or controlled by one or more low-income persons. If the business is a for-profit entity, report whether more than 50% of the owners are low-income persons. If the business is a nonprofit entity, report whether more than 50% of its Board of Directors are low- income persons. “Low- Income” is defined as having family income is equal or less than 80 percent of the Area Median Family Income. Enter “Do Not Know” if the information is either unknown or not applicable.

Picklist

YES; NO; DO NOT KNOW

not applicable

0-ALL

Conditionally required if "Counterparty Type" (DE023) = BUS or CDFI or CDE; else, null.

CDFI NACA RRP TLR (December 2023)

Low-Income Owned or Controlled

58;#58

Investee or Borrower or Recipient Type;#58

DE070

Project Identifier - Grantee

1-Transaction;#2-Project;#5-Project Site

This system-generated unique identifier serves to identify the relationship between financial transactions and actual projects.

String

not applicable

0-ALL

Mandatory field. If this field -- the grantee-created Project ID -- is not unique because it matches a previously submitted value, then the existing record must also have an Project ID (from EPA) and the EPA-created Project ID in the updated record must match the EPA-created ID from the original record when it was first created.

GGRF

72;#72

Project Identifier - EPA ;#72

DE072

Project Identifier - EPA

1-Transaction;#2-Project;#5-Project Site

EPA Applied project ID

String

not applicable

0-ALL

GGRF

DE074

Project Title

1-Transaction;#2-Project

Short title

String

not applicable

0-ALL

Optional field.

GGRF

DE075

Project Description and Purpose

2-Project

Enter a short description and purpose for the project.

String

not applicable

0-ALL

GGRF

DE076

Project Type

2-Project

Choose one of the pre-defined picklist values to define the project's target sector for greenhouse gas reductions. These are the same sector designations that the Notice of Funding Opportunities for the Greenhouse Gas Reduction Fund called "priority project categories" or sometimes "areas."

Picklist

CLEANENERGY; BUILDINGS; TRANSPORTATION; INDUSTRY; AGRICULTURE; OTHER

not applicable

0-ALL

Mandatory field.

GGRF

Not applicable

DE077

Project Type Detail

2-Project

Intentionally blank, each line below lists the details related to the project type

Picklist

GENERATION; STORAGE; MICROGRID; TRANSMISSION; WEATHERIZATION; ELECTRIFICATION; ZERO-EMISSIONS NEW CONSTRUCTION; ZERO-EMISSIONS RETROFITS; ENERGY EFFICIENCY; METHANE RECOVERY; FUEL SWITCHING; VEHICLECHARGING-REFUELING; OTHER

not applicable

0-ALL

Mandatory field.

GGRF

DE083

Technical Assistance Type

1-Transaction;#2-Project

Choose one of the pre-defined values to indicate the technical assistance project type.

Picklist

WORKFORCE-TRAINING; CONTRACTOR-CAPACITY-BUILDING; NEWPRODUCT; PROJECT-PREDEV; PROJECT-IMPLEMENTATION; LENDER-CAPACITY-BUILDING; COMMUNITY-OUTREACH; CONTRACTOR-OUTREACH; SITINGASSISTANCE; INTERCONNECTIONASSISTANCE

not applicable

0-ALL

Conditionally required if DE012 (Transaction Purpose) = TECHNICAL or SUBAWARD-TECHNICAL; else, null.

GGRF

12;#12

Transaction Purpose;#12

DE084

Technical Assistance Description

2-Project

Narratively describe the assistance activity and primary purpose.

String

not applicable

0-ALL

If Project type is Other then required

GGRF

DE085

Project Status

2-Project

Choose one of the pre-defined picklist values that defines the status of the physical asset receiving financial assistance. Do not use this field for reporting the status of the financial assistance product.

Picklist

STARTED; COMPLETE; CANCELLED

not applicable

0-ALL

YES

IF there is an 'Origination Date' THEN the 'Project Status' must equal Started, Complete or Cancelled. IF 'Deployment Status' = 'Cancelled,' THEN require 'Deployment Status Description'

GGRF

86;#86

Project Status Description;#86

DE086

Project Status Description

2-Project

If the project is cancelled, the field "Project Status" should indicate "CANCELLED." Include a brief description of the reason for cancellation to understand how to improve the likelihood of positive outcomes and decrease the likelihood of negative outcomes (no greenhouse gas reducing investment).

String

not applicable

0-ALL

YES

IF 'Deployment Status'='Cancelled' THEN this field becomes required.

GGRF

85;#85

Project Status ;#85

DE087

Project Equipment Useful Life

2-Project

Enter the useful life of the equipment (in months) that was installed through the use of the financial assistance product (in DE014). If there are multiple pieces of equipment on a site, then enter the shortest lifespan of the system in question.

Number

months

0-ALL

Mandatory field.

GGRF

DE088

Project Site City

5-Project Site

Enter the municipality or the city for the physical address of the property or location that is receiving technical or financial assistance.

String

not applicable

0-ALL

Mandatory field.

GGRF

Not applicable

254;#254;#255;#255;#88;#88;#89;#89;#90;#90;#267;#267

Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site County;#267

DE089

Project Site State or Territory

5-Project Site

Enter the two-character abbreviation used by the USPS to identify the US state or territory for the project's location.

Picklist

Two character state or territory abbreviation used by USPS.

not applicable

0-ALL

Mandatory field.

GGRF

254;#254;#255;#255;#88;#88;#89;#89;#90;#90;#267;#267

Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site County;#267

DE090

Project Site ZIP Code

5-Project Site

Enter the five-digit USPS ZIP Code for the project receiving technical or financial assistance.

Number

not applicable

12345

0-ALL

Optional

GGRF

254;#254;#255;#255;#88;#88;#89;#89;#90;#90;#267;#267

Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site County;#267

DE091

Project Site Census Tract Code

5-Project Site

Enter the unique 11 digit numeric Census Tract Code that represents the location of the project.
https://www.census.gov/programs-surveys/geography/guidance/geo-identifiers.html

String

MISSING

0-ALL

IF LIDAC type IS CEJEST or EJSCREENI or EJSCREENTL then required

GGRF

91;#91;#92;#92;#314;#314

Project Site Census Tract Code;#91;#Project Site Census Tract and Block Group Year;#92;#Project Site Census Block Group;#314

DE092

Project Site Census Tract and Block Group Year

5-Project Site

Enter the year of census tract and block group for the project site.

String

2010, 2020

YYYY

0-ALL

IF LIDAC type IS CEJEST or EJSCREENI or EJSCREENTL then required

GGRF

91;#91;#92;#92;#314;#314

Project Site Census Tract Code;#91;#Project Site Census Tract and Block Group Year;#92;#Project Site Census Block Group;#314

DE093

Project Site Longitude (X-Coordinate)

5-Project Site

Decimal Degrees of estimated Project Longitude (DDD.dddd) in World Geodetic System of 1984 (WGS84).
North American longitudes are normally negative.
The measure of the angular distance on a meridian north or south of the equator.
For example, the estimate location of the White House is 38.8979 latitude and -77.0365 longitude.
Accuracy should meet or exceed EPA Tier 5 (100-200m) - more information available in the National Geospatial Data Policy available at https://www.epa.gov/geospatial/geospatial-policies-and-standards.

Number

0-ALL

If project latitude is valid then require project longitude

GGRF

DE094

Project Site Latitude (Y-Coordinate)

5-Project Site

Decimal Degrees of estimated Project Latitude (DD.dddd) in World Geodetic System of 1984 (WGS84).
The measure of the angular distance on a meridian east or west of the equator.
For example, the estimate location of the White House is 38.8979 latitude and -77.0365 longitude.
Accuracy should meet or exceed EPA Tier 5 (100-200m) - more information available in the National Geospatial Data Policy available at https://www.epa.gov/geospatial/geospatial-policies-and-standards.

Number

0-ALL

If project latitude is valid then require project longitude

GGRF

DE095

Project Site Geocoordinates Description

5-Project Site

Description of what the latitude and longitude represents, such as the site centroid, geographic centroid, or line, for example.

Picklist

BUILDING-CENTROID;SITE-CENTROID;CENTROID-OF-TRANSIT-DEPOT

not applicable

0-ALL

Conditionally required, if both DE094 (Project Latitude) and DE093 (Project Longitude) are not null; else, null.

GGRF

240;#240

Project Location Description;#240

DE096

Does Project Qualify as LIDAC?

1-Transaction;#2-Project

Choose one of the pre-defined picklist values that identifies how the project targets a low-income or disadvantaged community (or LIDAC). CEJST is the only qualification applicable for the Justice40 or "J40" initiative.

Picklist

EJSCREENSI; EJSCREENTL; LIHOUSE; AFFHOUSE; N/A

not applicable

0-ALL

If DE001 (GGRF Program) = SFA or CCIA then N/A is not allowed. This field could be multiple select.
Conditionally required if DE263 (Qualifies as LIDAC in CEJST) = NO; else, null.

GGRF

263;#263

Does Project Site Qualify as LIDAC in CEJST?;#263

DE101

Is the asset owner not-for-profit?

2-Project

Select YES if the asset owner is a not for profit entity as defined in 2 CFR § 200.1

Boolean

Yes, No

not applicable

0-ALL

If Project Type is not Assistance then required

GGRF

DE102

Is the asset owner a community?

2-Project

Select YES if the asset is owned by a public or private nonprofit organization that supports and/or represents a community and/or certain populations within a community through engagement, education, and other related.

Boolean

Yes, No

not applicable

0-ALL

If Project Type is not Assistance then required

GGRF

DE103

Total Project or Development Cost

1-Transaction;#2-Project

Report the total cost of the project being funded by the reported loans or investments. The amount should be non-zero positive whole number and sum to the total value of all layers in the project's capital stack, including the value of in-kind donations, like land, which should be entered as a layer in the capital stack using the assessed value.

Currency

USD

$1,000.00

0-ALL

Conditionally required if Finance Type (DE013) = PROJECT; else, null.

GGRF

287;#287

Total Development Cost;#287

DE108

Community Benefits Delivered

2-Project

CEEE Clean Energy, Electrification, and/or Energy Efficiency; TRANSP Clean Transportation; ZERO-E Zero Emissions Housing; HOUSING New Affordable and Sustainable Housing; CCMIT Climate Change mitigation-GHG emissions reductions/avoided; CCRES Climate Change resilience- resilience hub construction; households receiving climate change resilience benefits, etc.; REMED Remediation and Reduction of Legacy Pollution; WORKDEV Training and Workforce Development; FINMARKDEV Financial Market Development; NEWJOBS New jobs created and filled; PROJECT deployed in LIDAC(s); MEANINGFULCOMENGAGE Meaningful community engagement with community input influencing decisions

Picklist

CEEE; TRANSP; ZERO-E; HOUSING; CCMIT; CCRES; REMED; WORKDEV; FINMARKDEV; REMED; NEWJOBS; PROJECT DEPLOYED LIDAC; MEANINGFULCOMENGAGE

not applicable

0-ALL

Check all that apply

GGRF

DE109

Number of Households Served by Project

2-Project

Report the number of households receiving resiliency benefits from the project.

Number

1,000

0-ALL

Choose if projected or actual value

GGRF

DE110

Estimated Annual Household Savings Provided by Project

2-Project

Report the dollar value of the cost savings provided by the project on an annual basis.

Currency

US dollars

1,000

0-ALL

Choose if projected or actual value

GGRF

DE111

Description of Household Savings

2-Project

Clarify what is included in "costs savings" (e.g., utility bill savings; loan origination costs borne by financial assistance provider or other) and beneficiary who is receiving the savings.

Picklist

UTILITYBILLSAVINGS; CAPITALCOSTREDUCTION; ORIGINATIONCOSTSAVINGS

not applicable

0-ALL

GGRF

DE113

Permanent Jobs Created or Retained [Non-Construction]

2-Project

Report the number of permanent full-time equivalent (FTE) jobs using a standard 35-hour work week projected (at date originated) to be created and/or retained in the business due to this financing, non-construction. "Report the number of permanent full-time equivalent (FTE) jobs, both created and retained, projected to be
created in the business due to this financing. The job number should be a non-zero positive number. However, if
there are no jobs created or not applicable, enter zeros. Exclude construction jobs. Include direct and indirect
jobs. If “DIRECT” was selected above, then only report direct jobs. If “DWINDIRECT” was selected above,
then report both direct and indirect jobs. Convert both temporary and/or part-time jobs into permanent and/or
full-time jobs before reporting"

Number

1,000

0-ALL

CDFI FUND (modified)

DE114

Full-Time Equivalent Jobs Created [Construction]

2-Project

Report the number full-time equivalent (FTE) construction jobs (using a standard 40-hour work week) projected (at date originated) to be created in the project due to this financial assistance transaction.

Number

1,000

0-ALL

Choose if projected or actual value

CDFI FUND (modified)

DE115

Source of Jobs Estimates

2-Project

NEWFINANCING
Estimates based on actual or projected payroll data
WAGEDATA
Estimates based on state or local wage data and projected wage and salary expenditures attributable to project financing
ECONOMICIMPACT
Estimates based on economic impact modeling systems such as IMPLAN, RIMSII, or REMI
RULEOFTHUMB
Estimates based on developers “rules of thumb” about jobs created by type of business and square-footage built.
OTHER
None of the above. Add the description in the following field.

Picklist

NEWFINANCING; WAGEDATA; ECONOMICIMPACT; RULE OF THUMB; OTHER

not applicable

0-ALL

Conditionally required if DE012 (Transaction Purpose) = FINANCIAL; else, null.

CDFI NACA RRP TLR (December 2023)

Source of Job Estimates

115;#115;#116;#116

Source of Jobs Estimates ;#115;#Source of Jobs Estimates Description (if projected);#116

DE116

Source of Jobs Estimates Description (if projected)

2-Project

Narratively describe the source of job estimates.

String

not applicable

0-ALL

Conditionally required if DE115 (Source of Job Estimates) = OTHER; else, null.

Modified from CDFI NACA RRP TLR (December 2023)

DE117

Tools to Promote Good Jobs and Community

2-Project

Select one or more applicable tools for promoting workforce development for projects above $10,000,000.
•Project is covered by a Project Labor Agreement or Community Workforce Agreement:
oA “Project Labor Agreement (PLA)” is a pre-hire collective bargaining agreement used in the construction industry, negotiated between one or more construction unions and one or more construction employers that establishes the terms and conditions of employment for a specific construction project.
oA “Community Workforce Agreement (CWA)” is a type of PLA that includes community-oriented commitments related to equitable workforce development, social justice, small business support, or other issues. Communities around the country have used these types of agreements to ensure that construction projects are effectively completed with a skilled workforce drawing on workers from all backgrounds.
•Project is covered by a Community Benefits Agreement:
oA “Community Benefits Agreement” is an agreement signed by community groups or coalitions and a project developer, identifying the community or labor benefits a developer agrees to deliver in return for community support or workforce availability for a project. Community coalitions can comprise stakeholder groups that would be impacted by a project, including neighborhood associations, faith-based organizations, worker-serving organizations, environmental groups, labor unions, child care providers, and others. Community Benefit Agreements help ensure that measurable local benefits will be given to a community. They are enforceable, legally binding contracts for all parties. They typically specify responsibilities, reporting, and remedies.
•Workers on project are represented by a collective bargaining agreement (i.e., unionized)
oA “Collective Bargaining Agreement (CBA)” is a written legal contract between an employer and a union representing the employees to determine the terms of employment, including pay, benefits, hours, leave, job health and safety policies, ways to balance work and family, and more.
•Project includes specific goals and efforts to recruit workers from low-income and disadvantaged community(s):
oThe Recipient has specific objectives for the hiring and retention of individuals from low-income and disadvantaged communities, with an emphasis on populations with barriers to employment. This may include public hiring and retention goals, training initiatives, targeted hiring policies, and/or partnerships with organizations to recruit workers from LIDACs.
•Project employer provides supportive services for workers with barriers to employment:
oExamples of supportive services include childcare; housing; counseling; health services; legal services; financial and budgeting resources; emergency cash assistance for items such as tools, work clothing, application fees, and other costs of apprenticeship or required pre-employment training; transportation and travel to training and work sites; car repair; and services aimed at helping to develop and retain underrepresented groups like mentoring, support groups, and peer networking and eligibility requirements.

Picklist

PROJECT IS COVERED BY A PROJECT LABOR AGREEMENT OR COMMUNITY WORKFORCE AGREEMENT;
PROJECT IS COVERED BY A COMMUNITY BENEFITS AGREEMENT;
WORKERS ON PROJECT ARE REPRESENTED BY A COLLECTIVE BARGAINING AGREEMENT (I.E., UNIONIZED);
PROJECT INCLUDES SPECIFIC GOALS AND EFFORTS TO RECRUIT WORKERS FROM LOW-INCOME AND DISADVANTAGED COMMUNITY(S);
PROJECT EMPLOYER PROVIDES SUPPORTIVE SERVICES FOR WORKERS WITH BARRIERS TO EMPLOYMENT

not applicable

0-ALL

Conditionally required if Total Project Cost is greater than $10,000,000, then required; else, null.
And Conditionally required if Transaction Purpose (DE012) = TECHNICAL or FINANCIAL; else, null.

GGRF

DE121

Rate of Pay per Worker Median for New Hires [Construction]

2-Project

Currency

US dollars

100

0-ALL

Choose if projected or actual value

GGRF

DE122

Rate of Pay per Worker Median for New Hires [Non-Construction]

2-Project

Number

0-ALL

Choose if projected or actual value

DE126

Does Project Set Goal for Labor Hours Completed Under a Registered Apprenticeship Program?

2-Project

Select YES if the project has goals for the percentage of labor hours to be completed by a participant in a Registered Apprenticeship program with ApprenticeshipUSA (e.g., 15% of labor hours per craft): https://www.apprenticeship.gov/employers/registered-apprenticeship-program. A Registered Apprenticeship is an industry-driven, high-quality career pathway where employers can develop and prepare their future workforce, and individuals can obtain paid work experience, receive progressive wage increases, classroom instruction, and a portable, nationally-recognized credential. Registered Apprenticeships are industry-vetted and approved and validated by the U.S. Department of Labor or a State Apprenticeship Agency.

Picklist

YES; NO

not applicable

0-ALL

Conditionally required if Transaction Purpose (DE012) = TECHNICAL, else, null.

GGRF

DE130

Average Estimated Annual Household Energy Savings

2-Project

This field is a computed value and the output of the household savings calculator. Do not enter data into this field.

Currency

US dollars

1,000

0-ALL

Choose if projected or actual value

GGRF

DE133

Carbon Dioxide Equivalent (CO2e)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

Carbon Dioxide Equivalent (CO2e);#133;#Carbon Dioxide (CO2);#134;#Methane (CH4);#135;#Hydrofluorocarbons (HFCs);#136;#Nitrous Oxide (N2O);#137;#Perfluorocarbons (PFCs);#138;#Sulfur Hexafluoride (SF6);#139;#Nitrogen Trifluoride (NF3);#140;#Primary Fine Particulate Matter (PM2.5);#141;#Total Fine Particulate Matter (PM2.5);#142;#Particulate Matter (PM10);#143;#Nitrogen Dioxide (NO2);#144;#Sulfur Dioxide (SO2);#145;#Ground-Level Ozone (O3);#146;#Carbon Monoxide (CO);#147;#Lead (Pb);#148;#Ammonia (NH3);#149;#Volatile Organic Compounds (VOCs);#150

DE134

Carbon Dioxide (CO2)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE135

Methane (CH4)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE136

Hydrofluorocarbons (HFCs)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE137

Nitrous Oxide (N2O)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE138

Perfluorocarbons (PFCs)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE139

Sulfur Hexafluoride (SF6)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE140

Nitrogen Trifluoride (NF3)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE141

Primary Fine Particulate Matter (PM2.5)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE142

Total Fine Particulate Matter (PM2.5)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE143

Particulate Matter (PM10)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE144

Nitrogen Dioxide (NO2)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE145

Sulfur Dioxide (SO2)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE146

Ground-Level Ozone (O3)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE147

Carbon Monoxide (CO)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE148

Lead (Pb)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE149

Ammonia (NH3)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE150

Volatile Organic Compounds (VOCs)

3-Benefits

Number

ton (metric)

0-ALL

required if GGRF Program = NCIF or CCIA Optional if GGRF Program = SFA.

GGRF

133;#133;#134;#134;#135;#135;#136;#136;#137;#137;#138;#138;#139;#139;#140;#140;#141;#141;#142;#142;#143;#143;#144;#144;#145;#145;#146;#146;#147;#147;#148;#148;#149;#149;#150;#150

DE151

Clean Energy Type

2-Project

Clean energy is energy from renewable natural resources that are replenished on a human timescale. Choose the picklist value that describes the clean energy source for the clean energy project in question.

Picklist

SOLAR; WIND; HYDROPOWER

not applicable

0-ALL

if project type is clean energy then optional

GGRF

DE152

Nameplate Capacity

2-Project

The nameplate capacity, sometimes also known as the "rated capacity" or "installed capacity," is the maximum output measured in kWac of an installed and grid-connected distributed electrical generation plant. The nameplate capacity can be contrasted with the capacity factor or the actual generation of the plant over a given time due to real-world conditions and factors such as downtime for maintenance or prevailing weather conditions, like cloudiness for solar photovoltaics or windiness for electric turbines.

Number

kilowatts (kW)

0-ALL

if project type is clean energy then required

GGRF

DE153

Capacity Factor

2-Project

A ratio of the expected generation of electricity as compared to the maximum possible generation expressed as a percentage. The capacity factor can be contrasted with the nameplate capacity or the theoretical maximum capacity measured in kWac.

Percent

0-ALL

if project type is clean energy then optional

GGRF

Not applicable

94;#94;#152;#152

Project Site Latitude (Y-Coordinate);#94;#Nameplate Capacity;#152

DE154

Were some or all of the emissions reductions achieved through an installed emissions reduction system?

2-Project

Boolean

Yes, No

not applicable

0-ALL

IF 'Project Type' = Buildings, Industry, Transportation, Agriculture, Assistance, Other, THEN Field 154 field is required.

GGRF

DE155

Storage Technology Type

2-Project

Clean energy storage is the storing of energy as electricity or heat and using it at a later time when clean energy is not being actively generated or to supplement needs when demand for electricity exceeds supply. Choose the storage technology type that describes the storage in the project.

Picklist

BATTERIES; FLYWHEEL; COMPRESSED AIR; PUMPED HYDRO; HYDROGEN; THERMAL ENERGY STORAGE; MECHANICAL ENERGY STORAGE

not applicable

0-ALL

If project type detail is Generation, then optional

GGRF

DE156

Storage Power Capacity [in kW]

2-Project

The maximum output of the energy storage device in kilowatts (or kW).

Number

kilowatts (kW)

100.00

0-ALL

IF 'Project Type" (DE076) = CLEANENERGY

GGRF

DE157

Storage Energy Capacity [in kWh]

2-Project

Enter the maximum volumetric energy output of the storage device measured in kilowatt-hours. One kilowatt-hour (kWh) is equal to 1,000 watt-hours (or Wh).

Number

kilowatt-hours (kWh)

100.00

0-ALL

If project type detail is Generation, then optional

GGRF

DE158

Cycle Efficiency

2-Project

Cycle efficiency is the ratio of the electricity output to the electricity input into an energy storage device. If the energy storage device outputs 80 kWh, but took 100 kWh to charge, then the cycle efficiency is 80 divided by 100 or 0.80 or 80%. Enter values as a decimal between 0.01 and 0.99.

Percent

0-ALL

If project type detail is Generation, then optional

GGRF

155;#155;#156;#156;#157;#157;#159;#159

Storage Technology Type;#155;#Storage Power Capacity [in kW];#156;#Storage Energy Capacity [in kWh];#157;#Response Time (seconds);#159

DE159

Response Time (seconds)

2-Project

The time in seconds between when power is demanded from the energy storage project until it reaches an output at its rated power capacity

Number

seconds

0-ALL

If project type detail is Generation, then optional

GGRF

DE160

Duration of Discharge

2-Project

The length of time (in hours) that an energy storage project can deploy power to the grid before depletion exclusive of any buffer periods to ensure the right functioning of the equipment over time.

Number

hour

100

0-ALL

If project type detail is Generation, then optional

GGRF

DE161

Is the power source only renewable?

2-Project

Projects that are directly connected to and draw all their power from renewable energy sources can answer this question as "Yes." Projects that store energy from the grid, in part or whole, should answer this question as "No."

Boolean

Yes, No

not applicable

0-ALL

If project type detail is Generation, then optional

GGRF

DE162

Transmission Project type

2-Project

Picklist

Picklist TBD

not applicable

0-ALL

Conditionally required If DE077 (project type detail is Transmission)

GGRF

DE163

Miles of Power Lines

2-Project

Estimated miles of transmission related lines upgraded or replaced.

Number

mile

1,000

0-ALL

If project type detail is Transmission, then optional

GGRF

DE164

Estimated Annual Reduced Energy Loss from Change in Technical Loss Rate

2-Project

The absolute percentage of change (e.g., 30% to 25% reported as 5%) resulting from the reduction of energy lost as a result of supplying energy to consumers.

Number

megawatt-hours (MWh)

1,000

0-ALL

If project type detail is Transmission, then optional

GGRF

DE165

Estimated change in electricity consumption annually

2-Project

Calculated net change in electricity energy consumption.

Number

kilowatt-hours (kWh)

1,000

0-ALL

if Project Type is Buildings, the optional

GGRF

DE166

Estimated change in natural gas consumption

2-Project

Calculated net change in natural gas consumption (annually).

Number

million cubic feet (MMcf)

1,000

0-ALL

if Project Type is Buildings, the optional

GGRF

DE167

Estimated change in fuel oil consumption

2-Project

Net gallons/year of oil consumption changed by the energy efficiency technology deployed. Report a positive number for net savings. Enter 0 for no change.

Number

gallon

1,000

0-ALL

if Project Type is Buildings, the optional

GGRF

DE168

Estimated diesel equivalent fuel consumption

2-Project

Estimated diesel gallon equivalence of fuel replaced as a measure of gallons. The number of gallons of diesel fuel equivalent to the replaced fuel to produce the same amount of energy.

Number

gallon

1,000

0-ALL

if Project Type is Buildings, the optional

GGRF

DE169

Energy efficiency measures adopted

2-Project

General description of efficiency measure adopted.

Picklist

INSULATION; NEW WINDOWS; ENERGY-EFFICIENT EQUIPMENT; EQUIPMENT OPERATIONS IMPROVEMENT

not applicable

0-ALL

Conditionally required if DE079 (Project Type detail is Energy Efficiency/Weatherization)

GGRF

DE170

Number of air source heat pumps installed

2-Project

The number of stand alone air source heat pumps installed for a project.

Number

1,000

0-ALL

if Project Type detail is Energy Efficiency/Weatherization then optional

GGRF

DE171

Number of geothermal heat pumps installed

2-Project

The number of stand alone geothermal heat pumps installed for a project

Number

1,000

0-ALL

if Project Type detail is Energy Efficiency/Weatherization then optional

GGRF

DE172

Number of induction stoves installed

2-Project

The number of induction stoves installed for a project

Number

1,000

0-ALL

if Project Type detail is Energy Efficiency/Weatherization then optional

GGRF

DE173

Number of electric stoves installed

2-Project

The number of electric stoves installed for a project

Number

1,000

0-ALL

if Project Type detail is Energy Efficiency/Weatherization then optional

GGRF

DE174

Average Estimated Change in Insulation Value Change (R-Value)

2-Project

The change in the average insulating material's resistance to conducting heat, represented as an R-factor, for a given project. For example, the change in the average R-value for improving insulation on a house.

Number

0-ALL

if Project Type detail is Energy Efficiency/Weatherization then optional

GGRF

DE175

Building Type

2-Project

Choose the picklist value that corresponds to the EnergyStar building category for this project record.

Picklist

Adult Education;
Bank Branch;
Bar/Nightclub;
College/University;
Convenience Store without Gas Station;
Convention Center;
Data Center;
Distribution Center;
Drinking Water Treatment & Distribution;
Fast Food Restaurant;
Financial Office;
Fire Station;
Fitness Center/Health Club/Gym;
Food Sales;
Food Service;
Hotel;
K-12 School;
Library;
Lifestyle Center;
Medical Office;
Multifamily Housing;
Non-Refrigerated Warehouse;
Office;
Other;
Other - Education;
Other - Entertainment/Public Assembly;
Other - Lodging/Residential;
Other - Public Services;
Other - Recreation;
Other - Restaurant/Bar;
Other - Services;
Other - Specialty Hospital;
Other - Technology/Science;
Outpatient Rehabilitation/Physical Therapy;
Performing Arts;
Personal Services (Health/Beauty, Dry Cleaning, etc.);
Police Station;
Pre-school/Daycare;
Repair Services (Vehicle, Shoe, Locksmith, etc.);
Residence Hall/Dormitory;
Residential Care Facility;
Restaurant;
Retail Store;
Senior Living Community;
Single Family Home;
Social/Meeting Hall;
Strip Mall;
Supermarket/ Grocery Store;
Swimming Pool;
Transportation Terminal/Station;
Urgent Care/Clinic/Other Outpatient;
Vocational School;
Wastewater Treatment Plant;
Worship Facility;

not applicable

0-ALL

if Project Type detail is Energy Efficiency/Weatherization then optional

GGRF

77;#77

Project Type Detail;#77

DE176

Number of Net-Zero Buildings

2-Project

Number of new net-zero buildings that meet the definition of Executive Order 14057. https://www.sustainability.gov/pdfs/EO_14057_Implementing_Instructions.pdf

Number

1,000

0-ALL

if project type is buildings then required

GGRF

DE177

Type of Construction

2-Project

Type of construction project such as new build, adaptive reuse, or refurbish.

Picklist

NEW; REDEVELOPED; ADAPTIVE REUSE

not applicable

0-ALL

if project type is buildings then required

GGRF

DE178

Net-Zero Calculation Method

2-Project

The defined calculation methodology used to determine if the project meets the net-zero standards for the Greenhouse Gas Reduction Fund as defined in Executive Order 14057. This could be published methodology, reference to internal methodology, or other accessible documentation.

Picklist

Picklist TBD

not applicable

0-ALL

if project type is buildings then required

GGRF

DE179

Square Footage

2-Project

The total square footage of the property or properties impacted by the construction project. Square footage should include the gross area and not only the livable space.

Number

square feet

0-ALL

if project type is buildings then required

GGRF

DE180

Number of Vehicles Deployed

2-Project

Count of vehicles deployed in a project that are of the same vehicle type.

Number

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE181

Vehicle Type (Low-, Medium- or Heavy-Duty On-Road or Off-Road Vehicle)

2-Project

Type of vehicle as defined by the Gross Vehicle Weight Rating of the vehicle type and/or its purpose-built operation (e.g., school bus)

Picklist

MOVES Vehicle Classes

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE182

Baseline On-Road Vehicle Fuel Type

2-Project

TBD - we are deciding how to handle tracking vehicle emissions - rolled up by class or by individial vehicle

Picklist

BEV;PHEV;FCEV

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE183

New On-Road Vehicle Fuel Type

2-Project

Battery Electric Vehicle (BEV); Plugin-Hybrid Electric Vehicle (PHEV); Zero Emissions Vehicle (ZEV); Gaseous Hydrogen Fuel Cell Electric Vehicle (FCEV)
https://www.epa.gov/greenvehicles/electric-plug-hybrid-electric-vehicles

Picklist

BEV; PHEV; FCEV

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE184

Average On-Road Baseline Model Year

2-Project

Enter the 4 digit year (2014) of the baseline model replaced.
The model year of the vehicle replaced or the arithmetic average model year if multiple vehicles replaced.

Date

not applicable

YYYY

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE185

Will the old on-road vehicles be destroyed?

2-Project

If the old vehicles were demonstrably removed from all future operation (e.g., salvage, permanent destruction), select "Yes." If unknown or the old vehicle could be resold, select "No."

Boolean

Yes, No

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE186

Type of non-road equipment

2-Project

Type of equipment (e.g., agricultural tractors)

Picklist

AERIAL LIFTS; AGRICULTURAL EQUIPMENT (OTHER); AGRICULTURAL TRACTORS; AIR COMPRESSORS; AIRPORT EQUIPMENT; BALERS; CHIPPERS/GRINDERS; COMBINES; CONTAINER HANDLERS; CRANES; CRAWLER TRACTORS/DOZERS; EXCAVATORS; FOREST EQUIPMENT; GAS COMPRESSORS; GRADERS; IRRIGATION SETS; LAWN & GARDEN EQUIPMENT; LEAF BLOWERS; MATERIAL HANDLING EQUIPMENT (OTHER); MOBILE GENERATORS; NON-ROAD TERMINAL TRACTORS/YARD TRUCKS; PUMPS; ROLLERS; ROUGH TERRAIN FORKLIFTS; RUBBER TIRE LOADERS; SKID STEER LOADERS; SPRAYERS; SWATHERS; SWEEPERS/SCRUBBERS; TRACTOR/BACKHOE/LOADERS; WELDERS; CONSTRUCTION EQUIPMENT (OTHER); COMMERCIAL MOWERS

not applicable

1-GLIA (CCIA & NCIF)

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE187

Baseline Non-Road Equipment Fuel Type

2-Project

Type of fuel used

Picklist

DIESEL; GASOLINE; NATURAL GAS (CNG, LPG, LNG)

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE188

Baseline non-road equipment horsepower

2-Project

Horsepower range of equipment (based on EPA standards)

Picklist

<11 hp; 11-25 hp; 26-50 hp; 51-75 hp; 76-100 hp; 101-174 hp; 175-300 hp; 301-602 hp; 603-750 hp; 751-1206 hp; 1206+ hp

horsepower

100

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE189

New Non-Road Equipment Fuel Type

2-Project

Type of fuel used

Picklist

BEV; PHEV; FCEV

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE190

New non-road equipment horsepower

2-Project

Horsepower range of equipment (based on EPA standards)

Picklist

<11 hp; 11-25 hp; 26-50 hp; 51-75 hp; 76-100 hp; 101-174 hp; 175-300 hp; 301-602 hp; 603-750 hp; 751-1206 hp; 1206+ hp

horsepower

100

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE191

Average Non-Road Baseline Model Year

2-Project

Enter the 4 digit year (2014) of the baseline model replaced.
The model year of the equipment replaced or the arithmetic average model year if multiple pieces of non-road equipment were replaced.

Date

not applicable

YYYY

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE192

Will the old off-road vehicles be destroyed?

2-Project

Select Yes if the old pieces of equipment were destroyed or permanently removed from operation.

Boolean

Yes, No

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = Electrification & Fuel Switching then optional

GGRF

DE193

Number of charging ports deployed

2-Project

Alternative Fuels Data Center: Electric Vehicle Charging Stations (energy.gov)

Number

0-ALL

Project Type=Transportation and Project Type Detail = EV Charing Infrastructure

GGRF

DE194

Number of Level 1 Ports

2-Project

Number of installed Level 1 Ports, where ports are defined as each connector with the ability to charge one vehicle at a time. The Alternative Fuels Data Center provides further define ports and power levels. https://afdc.energy.gov/fuels/electricity-stations

Number

0-ALL

if Project Type=Transportation and Project Type Detail = EV Charging Infrastructure then required

GGRF

DE195

Number of Level 2 Ports

2-Project

Number of installed Level 2 Ports, where ports are defined as each connector with the ability to charge one vehicle at a time. The Alternative Fuels Data Center provides further define ports and power levels. https://afdc.energy.gov/fuels/electricity-stations

Number

0-ALL

if Project Type=Transportation and Project Type Detail = EV Charging Infrastructure then required

GGRF

DE196

Number of DC Fast Ports

2-Project

Number of installed DC Fast Charge Ports, where ports are defined as each connector with the ability to charge one vehicle at a time. The Alternative Fuels Data Center provides further define ports and power levels. https://afdc.energy.gov/fuels/electricity-stations

Number

0-ALL

if Project Type=Transportation and Project Type Detail = EV Charging Infrastructure then required

GGRF

DE197

Estimated Load Factor

2-Project

Ratio of estimated total power output for vehicle charging versus maximum total power output for charging,

Number

0-ALL

if Project Type=Transportation and Project Type Detail = EV Charging Infrastructure then required

GGRF

DE198

Is the charger publicly accessible?

2-Project

Select Yes if the station is accessible to the public without restrictions such as physical barriers, fees, required memberships, limited property access.

Boolean

Yes, No

not applicable

0-ALL

if Project Type=Transportation and Project Type Detail = EV Charging Infrastructure then required

GGRF

DE199

Baseline fuel type

2-Project

Type of fuel replaced prior to implementing fuel switching technology.

Number

0-ALL

conditional required if DE076 (Project Type=Transportation) and DE077 (Project Type Detail = Fuel Switching)

GGRF

DE200

Baseline Annual Fuel Consumption

2-Project

Amount (in gallons/year) of baseline fuel consumed prior to implementing fuel switching technology.

Number

gallon

multi-unit

0-ALL

Conditionally required if DE076 (Project Type=Transportation) and DE077 (Project Type Detail = Fuel Switching) and DE199 (baseline fuel type is not null)

GGRF

DE201

Baseline fuel CO2e emissions factor

2-Project

C02 emissions factor used for calculation emissions reductions.
DRAFT

Number

0-ALL

Conditionally required if DE076 (Project Type=Transportation) and DE077 (Project Type Detail = Fuel Switching) and DE199 (baseline fuel type is not null)

GGRF

DE202

Alternative fuel type

2-Project

Type of alternative fuel switched to.

Number

BIODIESEL;ELECTRICITY;ETHANOL;HYDROGEN;NATURAL GAS;PROPANE;REWENEWABLE DIESEL

0-ALL

Conditionally required if DE076 (Project Type=Transportation) and DE077 (Project Type Detail = Fuel Switching)

GGRF

DE203

Alternative fuel consumption annually

2-Project

Estimated annualized fuel consumption.

Number

multi-unit

0-ALL

Conditionally required if DE076 (Project Type=Transportation) and DE077 (Project Type Detail = Fuel Switching) and DE202 (alternative fuel type is not null)

GGRF

DE204

Alternative fuel CO2e emissions factor

2-Project

CO2e factor used for calculation emissions reductions.

Number

0-ALL

Conditionally required if DE076 (Project Type=Transportation) and DE077 (Project Type Detail = Fuel Switching) and DE202 (alternative fuel type is not null)

GGRF

DE205

Fuel consumption unit

2-Project

Unit of measure based on the type of alternative fuel adopted.

Picklist

TBD

not applicable

0-ALL

Conditionally required if DE076 (Project Type=Transportation) and DE077 (Project Type Detail = Fuel Switching) and DE202 (Alternative Fuel Type is not null)

GGRF

DE206

Renewable Natural Gas (RNG) production per year

2-Project

Enter the estimated Renewable Natural Gas production per year in MMcf. Consult the EPA/AGSTAR handbook (https://www.epa.gov/agstar/agstar-project-development-handbook)

Number

million cubic feet (MMcf)

1,000

0-ALL

Conditionally required if Project Type=Agriculture AND Project Type Detail = Methane Recovery

GGRF

DE207

Renewable Natural Gas (RNG) Source

2-Project

Choose the value which best represents the SOURCE methods to generate Renewable Natural Gas. See the EPA AGSTAR handbook for detailed discussion of potential uses (https://www.epa.gov/agstar/agstar-project-development-handbook)

Picklist

Picklist TBD

not applicable

0-ALL

Conditionally required if Project Type=Agriculture AND Project Type Detail = Methane Recovery

GGRF

DE208

Renewable Natural Gas (RNG) Use

2-Project

Choose the value which best represents the intended use of the Renewable Natural Gas. See the EPA AGSTAR handbook for detailed discussion of potential uses (https://www.epa.gov/agstar/agstar-project-development-handbook)

Picklist

BOILER-FURNACE FUEL; CNG; COGENERATION; ELECTRICITY; FLARED FULL-TIME; PIPELINE GAS; PIPELINE TO ELECTRICITY

not applicable

0-ALL

Conditionally required if Project Type=Agriculture AND Project Type Detail = Methane Recovery

GGRF

DE209

Acres of Forest

2-Project

Acres of forest new or conserved.

Number

acre

1,000

0-ALL

optional

GGRF

DE210

New or Conserved?

2-Project

Are forests new or conserved.

Picklist

NEW; CONSERVED

not applicable

0-ALL

optional

GGRF

DE211

Project Financing Source (Public) - Name

1-Transaction

Choose the public funding source for this transaction within the project finance capital stack.

Picklist

FEDERAL; STATE; LOCAL; OTHER-GOVERNMENT

not applicable

0-ALL

Conditionally required if Finance Type (DE013) = PROJECT; else, null.

CDFI FUND (modified)

DE212

Project Financing Source (Public) - Amount

1-Transaction

Define brightline between PUBLIC and PRIVATE funds; what about foundation grants, e.g.?

Currency

USD

$1,000.00

0-ALL

required 0 - 100

CDFI FUND (modified)

DE213

Project Financing Source (Private) - Name

1-Transaction

Define brightline between PUBLIC and PRIVATE funds; what about foundation grants, e.g.?

Currency

USD

$1,000.00

0-ALL

Conditionally required if "Finance Type" (DE013) = PROJECT; else, blank.

GGRF

13;#13

Finance Type;#13

DE214

Project Financing Source (Private) - Amount

1-Transaction

Define brightline between PUBLIC and PRIVATE funds; what about foundation grants, e.g.?

Currency

USD

$1,000.00

0-ALL

required 0 - 100

CDFI FUND (modified)

DE215

Loan-to-Value Ratio

1-Transaction

The loan-to-value metric highlights lending risk by calculating the ratio of two values: the numerator contains the loan amount whereas the denominator contains the appraised property value. Report the percentage resulting from this ratio as a whole number. So, for example, a $9,000 loan for a $10,000 appraised property value should render as 90% and be reported as "90."

Percent

0-ALL

Conditionally required if DE079 (Buildings Subtype) = ZERO-EMISSIONS NEW CONSTRUCTION or ZERO-EMISSIONS RETROFITS; else, null. [The line above completely replaces the old line of conditional logic that said: "Conditionally required if DE262 (Secured Loan/Security Interest) = FIRSTMORTGAGE or SECONDMORTGAGE".]

CDFI Fund

DE217

Loan Loss Reserve Requirement

1-Transaction

Report the loan loss reserve requirement for the project finance transaction. Note that this field is only for project finance. This field should not be confused with transactions which capital loan loss reserves as a financial instrument in the form of a financial assistance type (see Financial Assistance Type in DE014).

Currency

0-ALL

Conditionally required if DE079 (Buildings Subtype) = ZERO-EMISSIONS NEW CONSTRUCTION or ZERO-EMISSIONS RETROFITS; else, null. [This line completely replaces the old conditional logic, which said: "If Transaction Purpose=Asset Finance OR Project Finance then required" but this leaves out DSCR for project finance deals for community solar -- F/U with Brooke Pine and Liz Gill.]

CDFI Fund

14;#14

Financial Assistance Type;#14

DE218

Fiscal Year Start Date

0-Award

Enter the date of the start of the fiscal year for the grant recipient organization.

Date

not applicable

YYYY-MM-DD

0-ALL

IF "GGRF Program" (DE001) = NCIF, THEN use quarterly timeframe AND IF "GGRF Program" (DE001) = CCIA or SFA, THEN use semiannual timeframe.

CDFI FUND (modified)

1;#1

GGRF Program;#1

DE241

Principal Amount

1-Transaction

Report the amount (dollar value) of the original loan principal provided in this transaction.

Currency

0-ALL

Conditionally required if Financial Assistance Type (DE014) = any value.

14;#14;#26;#26;#241;#241

Financial Assistance Type;#14;#Unpaid Principal;#26;#Principal Amount;#241

DE242

Is Project Subject to BABA Requirements?

2-Project

Select Yes if the project Is Subject to BABA Requirements as required in Pub. L. No. 117-58, §§ 70901

Picklist

YES; NO

not applicable

0-ALL

GGRF

DE243

Is Project Covered by an EPA-Approved BABA Waiver?

2-Project

Select Yes if the project is covered by an EPA-Approved Waiver for the Build America, Buy America Act ("the Act"). Pub. L. No. 117-58, §§ 70901-52.

Picklist

YES; NO

not applicable

0-ALL

GGRF

DE244

BABA Waiver Type

2-Project

Select Program-wide for general EPA waivers (select waiver) or if a waiver is granted for a specific project, select project-specific and submit project specific waiver name, date of approval, and email of EPA approver.

Picklist

PROGRAM-WIDE WAIVER; PROJECT-SPECIFIC WAIVER

not applicable

0-ALL

If Project is covered by an EPA-Approved Waiver (DE243) then required.

GGRF

DE245

BABA Program-wide Waiver

2-Project

Select the specific BABA EPA Program level waiver.

Picklist

EPA DE-MINIMIS GENERAL APPLICABILITY WAIVER; EPA ELECTRIC VEHICLE CHARGERS PRODUCT WAIVER; MINOR (FERROUS) COMPONENTS OF IRON AND STEEL PRODUCTS GENERAL APPLICABILITY WAIVER; PACIFIC ISLAND TERRITORIES PUBLIC INTEREST GENERAL APPLICABILITY WAIVER; SMALL PROJECT GENERAL APPLICABILITY WAIVER

not applicable

0-ALL

If Waiver Type (DE243) is Program-Wide Waiver, then require.

GGRF

DE246

BABA Project-specific Waiver

2-Project

Enter the title of the granted waiver.

String

not applicable

0-ALL

If Waiver type (DE244) is project-specific waiver, then require.

DE247

Date EPA Project Officer Provided BABA Waiver Approval

2-Project

Enter the date you received confirmation from and EPA project officer of waiver approval.

Date

YYYY-MM-DD

0-ALL

If project is covered by an epa approved waiver (DE243) then require.

GGRF

DE248

Name of EPA Project Officer Providing BABA Waiver Approval

2-Project

Enter the email of the EPA project officer who provided confirmation of waiver approval.

String

not applicable

0-ALL

If project is covered by an EPA approved waiver (DE243) then require.

GGRF

DE249

Is Project Subject to DBRA Requirements?

2-Project

Select Yes if the project is subject to Davis-Bacon and Related Acts (DBRA) reporting.
https://www.epa.gov/grants/davis-bacon-and-related-acts-dbra

Picklist

YES; NO

not applicable

0-ALL

GGRF

250;#250

DBRA Construction Category;#250

DE250

DBRA Construction Category

2-Project

Select the type of construction represented in the wage determination.
Building Construction includes the construction, alteration, or repair of sheltered enclosures with walk-in access for the purpose of housing persons, machinery, equipment, or supplies and the associated installation of utilities and equipment, as well as incidental grading and paving.

Residential Construction includes the construction, alteration, or repair of single family houses, townhouses, and apartment buildings of no more than four stories in height and all incidental work, such as site work, parking areas, utilities, streets, and sidewalks.

https://www.dol.gov/agencies/whd/government-contracts/construction/faq/conformance

Picklist

BUILDING CONSTRUCTION; RESIDENTIAL CONSTRUCTION

BUILDING CONSTRUCTION Building Construction includes the construction, alteration, or repair of sheltered enclosures with walk-in access for the purpose of housing persons, machinery, equipment, or supplies and the associated installation of utilities and equipment, as well as incidental grading and paving.

RESIDENTIAL CONSTRUCTION Residential Construction includes the construction, alteration, or repair of single family houses, townhouses, and apartment buildings of no more than four stories in height and all incidental work, such as site work, parking areas, utilities, streets, and sidewalks.

not applicable

0-ALL

Conditionally required if project is subject to DBRA requirements (DE249); else, null.

GGRF

249;#249

Is Project Subject to DBRA Requirements?;#249

DE251

Asset owner is

2-Project

Select the ownership arrangement of asset. Refer to n 2 CFR § 200.1 and
https://www.nrel.gov/docs/fy23osti/86210.pdf

Picklist

UTILITY-OWNED; THIRD-PARTY-OWNED; COMMUNITY-OWNED; HOUSEHOLD-OWNED

UTILITY-OWNED Asset is owned by a utility company.

THIRD-PARTY-OWNED Asset is owned by a third party.

COMMUNITY-OWNED Asset is owned by the community using the asset.
HOUSEHOLD-OWNED Asset is owned by the single household using the asset.

not applicable

0-ALL

If Project Type is not Assistance then required

GGRF

DE252

Transaction Date

1-Transaction

Enter the date the financial transaction occurred.

Date

not applicable

0-ALL

GGRF

5;#5

Transaction Identifier - Grantee;#5

DE253

Transaction Identifier - Counterparty

1-Transaction

Optionally report the transaction ID that your organization's counterparty uses as its transaction ID.

String

not applicable

0-ALL

Optional; allowed only if DE014 does NOT = TERM <investigate other use cases with other products>

GGRF

DE254

Project Site Address Line 1

5-Project Site

Enter the project site address in the following fields. This field, Address Line 1, captures the primary data for an address and should include the street number (building or house number), street name, and the cardinal direction (N, S, E, or W) for the street.

String

not applicable

0-ALL

If DE058 (Investee or Borrower Type = "IND") this field must be null

GGRF

254;#254;#255;#255;#88;#88;#89;#89;#90;#90;#267;#267

Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site County;#267

DE255

Project Site Address Line 2

5-Project Site

Enter the project address in the following fields. This field, Address Line 2, captures the secondary data for an address usually within the building, such as the apartment or suite number or any special delivery instructions.

String

not applicable

0-ALL

If DE058 (Investee or Borrower Type = "IND") this field must be null

GGRF

254;#254;#255;#255;#88;#88;#89;#89;#90;#90;#267;#267

Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site County;#267

DE256

Solar PV Project Type Usage

2-Project

Choose the end beneficiary of the solar photovoltaic system.

Picklist

SINGLEFAMILY; MULTIFAMILY; COMMUNITY SOLAR;

SINGLEFAMILY means a 1-4 unit dwelling.MULTIFAMILY means a dwelling with five or more units.
COMMUNITY SOLAR means any facility that serves the community, but may not necessarily be at the same site as the housing or population that it serves.

not applicable

0-ALL

Conditionally required if DE078 (Project Type Detail - Clean Energy) is recorded.

GGRF

DE257

Grant Title

0-Award

This is the grant title from the grant application and the terms and conditions.

String

Not applicable

not applicable

Not applicable

0-ALL

Not applicable

GGRF

Not applicable

DE258

Enabling Upgrades

2-Project

Enabling upgrades refer to infrastructure that are required to facilitate the installation of distributed generation or storage per the Solar for All terms and conditions.

Picklist

PANELUPGRADES; ROOFUPGRADES; GRIDUPGRADES; N/A

PANELUPGRADES Infrastructure upgrades for existing or new solar panels

ROOFUPGRADES Roof related upgrades to infrastructure for supporting solar panels

GRIDUPGRADES Energy grid related upgrades to infrastructure
N/A Enabling upgrades not applicable

not applicable

2-ZETG (SFA)

Conditionally required if GGRF Program (DE001) = SFA

GGRF

258;#258;#311;#311

Enabling Upgrades;#258;#Enabling Upgrades Cost;#311

DE259

Is household electrified for the first time?

2-Project

Is the household being electrified for the first time?

Picklist

YES; NO;

not applicable

2-ZETG (SFA)

Conditionally required if DE001 (GGRF Program = Solar for All)

DE260

Investment Tax Credit (ITC) Amount

1-Transaction

Enter the dollar value of the expected Investment Tax Credit (ITC) into this field. See the DOE's website for more information on this tax credit for homeowners: https://www.energy.gov/eere/solar/homeowners-guide-federal-tax-credit-solar-photovoltaics

Currency

US dollars

$1,000.00

0-ALL

GGRF

DE261

Principal Subsidy Amount at Time of Origination

1-Transaction

This field records the upfront subsidy that reduces the upfront or starting principal balance and forms one type of subsidy on a financial product that is not a full subsidy or cash grant to the end beneficiary.

Currency

Not applicable

USD

$1,000.00

0-ALL

Conditionally required if Financial Assistance Type (DE014) = TERM, LOC or DEBTEQTY; else null. This field must be less than or equal to the transaction amount (DE016).

GGRF

Not applicable

14;#14;#16;#16;#268;#268

Financial Assistance Type;#14;#Transaction Amount;#16;#Subsidy Type;#268

DE262

Security Interest

1-Transaction

Choose the picklist value for the collateral pledged that secures the loan or other financial assistance product in the event of borrower default or non-performance on the loan terms.

Picklist

ASSET; FIRSTMORTGAGE; JUNIOR MORTGAGE; COLLATERAL; N/A

not applicable

0-ALL

Conditionally required if DE014 (Financial Assistance Type) = TERM or LOC or DEBTEQTY or OTHER; else, null.

GGRF

Not applicable

14;#14

Financial Assistance Type;#14

DE263

Does Project Site Qualify as LIDAC in CEJST?

5-Project Site

EPA will count the project towards the Justice40 or "J40" initiative reporting only if the project site qualifies in CEJST. Additionally, if this field is marked "NO," then please select a picklist value from Does Project Qualify as LIDAC (DE096). CEJST's website can be found at: https://screeningtool.geoplatform.gov/

Boolean

YES; NO

not applicable

0-ALL

GGRF

96;#96

Does Project Qualify as LIDAC?;#96

DE264

Date of Project Completion (Actual)

2-Project

This is the date the project is placed in service or connected to the grid.

Date

Not applicable

not applicable

0-ALL

YES

Conditionally required if DE085 (Project Status) = COMPLETE. This date must be after the origination date.

GGRF

85;#85

Project Status ;#85

DE265

Project Interconnection Date

2-Project

This field records the interconnection date or the date that the distributed generation or storage system was connected to the utility grid.

Date

Not applicable

not applicable

YYYY-MM-DD

0-ALL

Conditionally required if Project Type (DE076) = GENERATION or STORAGE; else, null.

GGRF

264;#264

Date of Project Completion (Actual);#264

DE266

Investment Tax Credit (ITC) Direct Pay Amount

1-Transaction

Enter the expected amount of "elective pay" often times called "direct pay" as a result of qualifying for the tax credit. Please note that this field should be used only if the organization or legal entity is tax exempt. Under the Inflation Reduction Act, tax-exempt and governmental entities will be able to receive a payment equal to the full value of tax credits for building IRS-qualifying clean energy projects. See this website for more detail: https://www.irs.gov/credits-deductions/elective-pay-and-transferability

Currency

US dollars

$1,000.00

0-ALL

Available only if Counterparty Type (DE023) or Investee or Borrower or Recipient Type (DE058) = TRIBE or STATE or LOCALGOV or NONPROFIT.

GGRF

260;#260

Investment Tax Credit (ITC) Amount;#260

DE267

Project Site County

5-Project Site

Enter the name of the county where the project site is located.

String

not applicable

0-ALL

GGRF

Not applicable

254;#254;#255;#255;#88;#88;#89;#89;#90;#90;#267;#267

Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site County;#267

DE268

Subsidy Type

1-Transaction

Choose which type of subsidy applies in the case of the financial assistance reported in this record (or row). If the subsidy is offered to the end recipient or beneficiary prior to the installation of the project, select "UPFRONT". If the subsidy is offered to the end recipient or beneficiary after the installation of the project, select "REBATE".

Picklist

UPFRONT; REBATE

REBATE option means that the beneficiary receives a financial compensation after some proof of project completion is submitted to the grantee (for example, a statement of work with interconnection certification).
UPFRONT option means that the beneficiary receives financial compensation before the project is completed.

not applicable

0-ALL

Conditionally required if Financial Assistance Type (DE014) = SUBSIDY; else, null.

GGRF

261;#261

Principal Subsidy Amount at Time of Origination;#261

DE269

Project Resiliency Measures

2-Project

Choose the resiliency measures implemented at the project site to ensure continuity of operations in case of emergency or disaster.

Picklist

STORAGEABOVEFLOODZONE;

not applicable

0-ALL

GGRF

DE270

Delinquency - 30 Days or Less

1-Transaction

Indicate (Y/N) whether the financial assistance instrument, like a term loan, is delinquent by 30 days or less.

Boolean

not applicable

0-ALL

YES

Conditionally required if Financial Assistance Type (DE014) = TERM or LOC or DEBTEQTY

GGRF

270;#270;#271;#271;#272;#272;#273;#273

Delinquency - 30 Days or Less;#270;#Delinquency - 31 to 60 Days;#271;#Delinquency - 61 to 90 Days;#272;#Delinquency - 91 or More Days;#273

DE271

Delinquency - 31 to 60 Days

1-Transaction

Indicate (Y/N) whether the financial assistance instrument, like a term loan, is delinquent by 31 to 60 days.

Boolean

not applicable

0-ALL

YES

Conditionally required if Financial Assistance Type (DE014) = TERM or LOC or DEBTEQTY

GGRF

270;#270;#271;#271;#272;#272;#273;#273

Delinquency - 30 Days or Less;#270;#Delinquency - 31 to 60 Days;#271;#Delinquency - 61 to 90 Days;#272;#Delinquency - 91 or More Days;#273

DE272

Delinquency - 61 to 90 Days

1-Transaction

Indicate (Y/N) whether the financial assistance instrument, like a term loan, is delinquent by 61 to 90 days.

Boolean

not applicable

0-ALL

YES

Conditionally required if Financial Assistance Type (DE014) = TERM or LOC or DEBTEQTY

GGRF

270;#270;#271;#271;#272;#272;#273;#273

Delinquency - 30 Days or Less;#270;#Delinquency - 31 to 60 Days;#271;#Delinquency - 61 to 90 Days;#272;#Delinquency - 91 or More Days;#273

DE273

Delinquency - 91 or More Days

1-Transaction

Indicate (Y/N) whether the financial assistance instrument, like a term loan, is delinquent by 91 days or more.

Boolean

not applicable

0-ALL

YES

Conditionally required if Financial Assistance Type (DE014) = TERM or LOC or DEBTEQTY

GGRF

270;#270;#271;#271;#272;#272;#273;#273

Delinquency - 30 Days or Less;#270;#Delinquency - 31 to 60 Days;#271;#Delinquency - 61 to 90 Days;#272;#Delinquency - 91 or More Days;#273

DE274

Micromobility vehicle project

2-Project

This field indicates whether a project is financing micromobility options as a simple Boolean value (yes or no).

Boolean

not applicable

1-GLIA (CCIA & NCIF)

Conditionally required if "Project Type" (DE076) = TRANSPORTATION and "Project Type Detail" (DE077) = OTHER; else, null.

GGRF

275;#275

Micromobility number of vehicles deployed;#275

DE275

Micromobility number of vehicles deployed

2-Project

Number

1-GLIA (CCIA & NCIF)

GGRF

274;#274

Micromobility vehicle project;#274

DE270

Solar Lease Monthly Amount

2-Project

Enter the total monthly amount for the solar lease contract with the end recipient (the household which has the solar PV array).

Currency

US dollars

$1,000.00

0-ALL

GGRF

DE277

Solar Lease Term

2-Project

Enter the duration in months for the solar lease.

Number

months

0-ALL

DE076 = SOLAR ** FIX THIS

GGRF

DE278

Solar Lease - Fixed or Variable Monthly Lease Amount

2-Project

Choose whether the solar lease contract described in "Solar Lease Monthly Amount" field is a fixed amount which does not vary over term of the lease contract or whether the amount is variable over the term of the contract.

Picklist

FIXED MONTHLY LEASE AMOUNT;
VARIABLE MONTHLY LEASE AMOUNT

FIXEDMONTHLY LEASE AMOUNT indicates that the monthly amount the end beneficiary pays is fixed by contract at the beginning of the contract for the entire duration of the contract.VARIABLE MONTHLY LEASE AMOUNT indicates that the monthly amount the end beneficiary pays is variable and may change over the life of the contract.

not applicable

0-ALL

GGRF

DE279

Project Sponsor Name

1-Transaction

Enter the legal name of the lead project sponsor or developer. This name should match the subsequent field with the lead project sponsor or developer's TIN/EIN. If the sponsor or developer is a person or sole proprietorship, do not enter the Social Security Number.

String

not applicable

0-ALL

Conditionally required if DE013 (Finance Type) = PROJECT; else, null.

GGRF

DE280

Project Sponsor Address Line 1

1-Transaction

Enter the first line of the legal address, including the house or building number and the street name, for the project sponsor or developer. Use this and the following fields only for project finance and not for any other type of transaction or finance type.

String

not applicable

0-ALL

Conditionally required if DE013 (Finance Type) = PROJECT; else, null.

GGRF

280;#280;#281;#281;#282;#282;#283;#283;#284;#284

Project Sponsor Address Line 1;#280;#Project Sponsor Address Line 2;#281;#Project Sponsor City;#282;#Project Sponsor State or Territory;#283;#Project Sponsor ZIP Code;#284

DE281

Project Sponsor Address Line 2

1-Transaction

Enter the project sponsor or developer's legal address, including the interior numbering for a building, like a suite or unit number in this field.

String

not applicable

0-ALL

Conditionally required if DE013 (Finance Type) = PROJECT; else, null.

GGRF

280;#280;#281;#281;#282;#282;#283;#283;#284;#284

Project Sponsor Address Line 1;#280;#Project Sponsor Address Line 2;#281;#Project Sponsor City;#282;#Project Sponsor State or Territory;#283;#Project Sponsor ZIP Code;#284

DE282

Project Sponsor City

1-Transaction

Enter the city for the project sponsor or developer's legal address.

String

not applicable

0-ALL

Conditionally required if DE013 (Finance Type) = PROJECT; else, null.

GGRF

280;#280;#281;#281;#282;#282;#283;#283;#284;#284

Project Sponsor Address Line 1;#280;#Project Sponsor Address Line 2;#281;#Project Sponsor City;#282;#Project Sponsor State or Territory;#283;#Project Sponsor ZIP Code;#284

DE283

Project Sponsor State or Territory

1-Transaction

Enter the state or territory for the project sponsor or developer's legal address.

Picklist

not applicable

0-ALL

Conditionally required if DE013 (Finance Type) = PROJECT; else, null.

GGRF

280;#280;#281;#281;#282;#282;#283;#283;#284;#284

Project Sponsor Address Line 1;#280;#Project Sponsor Address Line 2;#281;#Project Sponsor City;#282;#Project Sponsor State or Territory;#283;#Project Sponsor ZIP Code;#284

DE284

Project Sponsor ZIP Code

1-Transaction

Enter the ZIP Code for the project sponsor or developer's legal address.

Number

not applicable

12345

0-ALL

Conditionally required if DE013 (Finance Type) = PROJECT; else, null.

GGRF

254;#254;#255;#255;#88;#88;#89;#89;#90;#90;#267;#267

Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site County;#267

DE285

Project Sponsor TIN or EIN

1-Transaction

Enter the project sponsor or developer's tax identification number (or TIN) or the employer identification number (or EIN) issued by the US Treasury's Internal Revenue Service (IRS). If the project sponsor or developer is an individual, do not enter their Social Security Number.

Number

Not applicable

not applicable

12-3456789

0-ALL

Conditionally required if DE013 (Finance Type) = PROJECT; else, null.

GGRF

8;#8;#285;#285

Counterparty TIN or EIN;#8;#Project Sponsor TIN or EIN;#285

DE286

Project Placed in Service Date

2-Project

Enter the date the project is placed in service for the purposes of tax credit compliance with the US Treasury's Internal Revenue Service.

Date

Not applicable

not applicable

0-ALL

YES

Conditionally required if DE013 (Finance Type) = PROJECT and DEXXX for Project Funding Source = Tax Credit Equity.

GGRF

85;#85;#264;#264

Project Status ;#85;#Date of Project Completion (Actual);#264

DE288

Number of newly built units

2-Project

Enter the number of newly constructed housing units or apartments.

Number

Not applicable

not applicable

1,000

1-GLIA (CCIA & NCIF)

Conditionally required if Finance Type (DE013) = PROJECT and DE076 (Priority Project Type) = BUILDINGS and Project Type Detail (DE077) = ZERO-EMISSIONS NEW CONSTRUCTION

GGRF

288;#288;#289;#289;#290;#290;#291;#291;#292;#292;#293;#293

Number of newly built units;#288;#Number of rehabilitated or adaptively reused units;#289;#Number of rental units;#290;#Number of units for ownership;#291;#Number of housing units available to households at 80 percent of AMI or less;#292;#Number of housing units available to households at 81 percent of AMI or above;#293

DE289

Number of rehabilitated or adaptively reused units

2-Project

Enter the number of rehabilitated or adaptively reused units into this field.

Number

1-GLIA (CCIA & NCIF)

Conditionally required if (see preceding logic but change the picklist value in DE077)

GGRF

288;#288;#289;#289;#290;#290;#291;#291;#292;#292;#293;#293

DE290

Number of rental units

2-Project

Enter the total number of rental units that the building contains that received EPA funding through the Greenhouse Gas Reduction Fund.

Number

Not applicable

not applicable

1,000

1-GLIA (CCIA & NCIF)

GGRF

288;#288;#289;#289;#290;#290;#291;#291;#292;#292;#293;#293

DE291

Number of units for ownership

2-Project

Enter the total number of housing units available for ownership, including cooperative housing units and land trust housing units.

Number

1-GLIA (CCIA & NCIF)

288;#288;#289;#289;#290;#290;#291;#291;#292;#292;#293;#293

DE292

Number of housing units available to households at 80 percent of AMI or less

2-Project

Enter the number of housing units affordable to households with income at or less than 80 percent of Area Median Income.

Number

Not applicable

1-GLIA (CCIA & NCIF)

GGRF

288;#288;#289;#289;#290;#290;#291;#291;#292;#292;#293;#293

DE293

Number of housing units available to households at 81 percent of AMI or above

2-Project

Enter the number of housing units available to households at 81 percent of AMI or above.

Number

1-GLIA (CCIA & NCIF)

Together with the preceding field, must equal the total unit count for the project.

GGRF

288;#288;#289;#289;#290;#290;#291;#291;#292;#292;#293;#293

DE294

Project Financing (All Private Sources) - Subtotal

1-Transaction

Enter the sum of all private financing source for the project into this field. The sum of all private sources constitutes a subtotal of the total development cost for the project. The sum of this field with all private sources and the sum of all public financing sources should equal the total development cost for the project.

Currency

not applicable

$1,000.00

0-ALL

GGRF

DE295

Project Financing Stage

1-Transaction

Choose the value from the picklist for this field that best describes the project financing stage.

Picklist

PREDEVELOPEMENT; ACQUISITION; CONSTRUCTION; PERMANENT

not applicable

0-ALL

Conditionally required if Finance Type (DE013) = PROJECT and Financial Assistance Type or Technical Assistance Type = {FIX THIS BY ADDING ALL OPTIONS}; else, null.

GGRF

DE296

Total Photovoltaic System Cost

2-Project

Enter the total cost for the photovoltaic system, including all soft costs, like labor, licensing or permitting fees, and all hard costs for materials.

Currency

not applicable

US dollars

$1,000.00

0-ALL

GGRF

DE297

Photovoltaic Panels Cost (Materials)

2-Project

Enter the total cost of the photovoltaic panels (or modules) for the project, including any shipping and taxes paid to deliver them to the worksite. Do not include any installation or labor costs.

Currency

not applicable

0-ALL

Conditionally required if DE076 = CLEANENERGY

GGRF

296;#296

Total Photovoltaic System Cost;#296

DE298

Inverter Cost (Materials)

2-Project

Enter the cost for the inverter that is required to convert the current from the photovoltaic panels (direct current) to alternating current ("AC") in order to connect the generation source to the electrical grid.

Currency

not applicable

US dollars

$1,000

0-ALL

Conditionally required if DE076 = CLEAN ENERGY

GGRF

296;#296

Total Photovoltaic System Cost;#296

DE299

Remainder of System Cost

2-Project

Enter the remainder of the systems cost excluding the Photovoltaic Module Cost (DE297), the Inverter Cost (DE298), the Interconnection Cost () and Permitting Fees () into this field. Summing those four fields and this field must equal the Total Photovoltaic System Cost (DE296).

Currency

not applicable

US dollars

$1,000

0-ALL

Conditionally required if DE076 =

GGRF

296;#296;#297;#297;#298;#298

Total Photovoltaic System Cost;#296;#Photovoltaic Panels Cost (Materials);#297;#Inverter Cost (Materials);#298

DE300

Interconnection Cost

2-Project

Enter the interconnection costs for the photovoltaic or clean energy generation project.

Currency

not applicable

US dollars

$1,000

0-ALL

Conditionally required if DE076 = CLEANENERGY PROJECT

GGRF

DE301

Permitting Fees Cost

2-Project

Enter the permitting fees for the clean energy generation project.

Currency

US dollars

$1,000

0-ALL

Conditionally required if DE076 = CLEANENERGY PROJECT

GGRF

DE302

Solar Panel Type

2-Project

Choose the solar panel type from the picklist values.

Picklist

PERC; Monocrystalline; Polycrystalline; Thin-film; CIGS; CdTe;

PERC Passivated emitter and rear cell;

MONOCRYSTALLINE Monocrystalline Solar Panels (Mono-SI);

POLYCRYSTALLINE Polycrystalline Solar Panels (p-Si);

THIN-FILM thin-Film: Amorphous Silicon Solar Panels (A-SI);

CIGS Copper indium gallium selenide;

CDTE Cadmium Telluride;
OTHER Other not listed;

not applicable

0-ALL

Conditionally required if Project Type (DE076) = CLEANENERGY; else, null.

GGRF

76;#76

Project Type;#76

DE303

Baseline On-Road Vehicle Annual Idling Hours

2-Project

Enter the average annual idling hours per vehicle class in the fleet.

Number

not applicable

hour

1,000

1-GLIA (CCIA & NCIF)

Conditionally optional if Project Type (DE076) = TRANSPORTATION; else, null.

GGRF

DE304

Baseline On-Road Vehicle Annual Hoteling Hours

2-Project

Enter the average annual hoteling hours per vehicle class in the fleet.

Number

hour

1,000

1-GLIA (CCIA & NCIF)

Conditionally required if Project Type (DE076) = TRANSPORTATION

GGRF

DE305

New On-Road Vehicle Model Year

2-Project

Enter the model year for the on-road vehicles.

Date

not applicable

YYYY

1-GLIA (CCIA & NCIF)

Conditionally required if Project Type (DE076) = TRANSPORATION.

GGRF

DE306

New Non-Road Vehicle Model Year

2-Project

Enter the model year of the new non-road vehicle or equipment.

Date

not applicable

YYYY

1-GLIA (CCIA & NCIF)

Conditionally required if Project Type (DE076) = TRANSPORATION.

GGRF

DE307

For Baseline Diesel Vehicles, Does the Vehicle Use Diesel Exhaust Fluid?

2-Project

If the existing diesel equipment uses a diesel exhaust fluid (DEF), indicate so in this field.

Boolean

not applicable

1-GLIA (CCIA & NCIF)

Conditionally required if Project Type (DE076) = TRANSPORTATION; else, null.

GGRF

DE308

What date did the required project signage get posted?

5-Project Site

Enter the date that the required signage was posted at the project site, if the project received $250,000 or more in EPA funding through the GGRF as per the Terms and Conditions.

Date

not applicable

YYYY-MM-DD

0-ALL

Conditionally required if Transaction Amount (DE016) or Principal Amount (DE241) is greater than or equal to $250,000 and Transaction Purpose (DE012) = FINANCIAL; else, null.

GGRF

241;#241

Principal Amount;#241

DE309

Project Financing (All Public Sources) - Subtotal

1-Transaction

Enter the

Currency

US dollars

GGRF

294;#294

Project Financing (All Private Sources) - Subtotal;#294

DE310

Contract Identifier for Financial Assistance

1-Transaction

Enter the unique identifier for the financial assistance contract that the recipient (typically, the borrower) will use to identify its repayments to the prime recipient or the subrecipient.

String

not applicable

Conditionally required if Transaction Purpose (DE012) = FINANCIAL; else, null.

DE311

Enabling Upgrades Cost

2-Project

Enter the total cost for the enabling upgrades for the project.

Currency

US dollars

$1,000.00

2-ZETG (SFA)

GGRF

258;#258;#311;#311

Enabling Upgrades;#258;#Enabling Upgrades Cost;#311

DE312

Soft Cost Subtotal for Total Project or Development Cost

2-Project

Enter the total cost of all intangible and labor costs, including permitting and fees, into this field for project financed through a project finance agreement. The value in this field when added to the Hard Costs Subtotal for Total Project or Development Costs should sum to 100% of the value of the field labelled Total Project or Development Costs.

Currency

US dollars

$1,000

0-ALL

Conditionally required if Finance Type (DE013) = PROJECT; else, null.

GGRF

103;#103;#312;#312;#313;#313

Total Project or Development Cost;#103;#Soft Cost Subtotal for Total Project or Development Cost;#312;#Hard Cost Subtotal for Total Project or Development Cost;#313

DE313

Hard Cost Subtotal for Total Project or Development Cost

2-Project

Enter the subtotal for all tangible materials costs, including the cost or the assessed value of in-kind materials donations to the project. These costs include the site acquisition costs. The value in this field when added to the Soft Costs Subtotal for Total Project or Development Costs should sum to 100% of the value of the field labelled Total Project or Development Costs.

Currency

US dollars

$1,000

0-ALL

Conditionally required if Finance Type (DE013) = PROJECT; else, null.

103;#103;#312;#312;#313;#313

Total Project or Development Cost;#103;#Soft Cost Subtotal for Total Project or Development Cost;#312;#Hard Cost Subtotal for Total Project or Development Cost;#313

DE314

Project Site Census Block Group

5-Project Site

Enter the census block group for the project site. Block groups (BGs) are statistical divisions of census tracts, are generally defined to contain between 600 and 3,000 people, and are used to present data and control block numbering. A block group consists of clusters of blocks within the same census tract that have the same first digit of their four-digit census block number. For example, blocks 3001, 3002, 3003, . . . , 3999 in census tract 1210.02 belong to BG 3 in that census tract.

Number

3000

0-ALL

GGRF

91;#91;#92;#92;#314;#314

Project Site Census Tract Code;#91;#Project Site Census Tract and Block Group Year;#92;#Project Site Census Block Group;#314

DE315

Project Site Census Block

5-Project Site

Enter the project site census block. The census block is the smallest bounded area of the decennial census that includes demographic data. Census blocks are bounded by visible features (such as roads, streams, and railroad tracks) and by nonvisible boundaries (such as property lines, city, township, school district, county limits).

Number

0-ALL

91;#91;#92;#92;#314;#314

Project Site Census Tract Code;#91;#Project Site Census Tract and Block Group Year;#92;#Project Site Census Block Group;#314

DE316

Project Site Unique Identifier - Grantee

5-Project Site

Enter the unique identifier for the project site. This field exists to cover projects with scattered sites.

String

0-ALL

Required field.

GGRF

70;#70;#72;#72;#88;#88;#89;#89;#90;#90;#91;#91;#92;#92;#93;#93;#94;#94;#95;#95;#254;#254;#255;#255;#263;#263;#267;#267;#314;#314;#315;#315

Project Identifier - Grantee;#70;#Project Identifier - EPA ;#72;#Project Site City;#88;#Project Site State or Territory;#89;#Project Site ZIP Code;#90;#Project Site Census Tract Code;#91;#Project Site Census Tract and Block Group Year;#92;#Project Site Longitude (X-Coordinate);#93;#Project Site Latitude (Y-Coordinate);#94;#Project Site Geocoordinates Description;#95;#Project Site Address Line 1;#254;#Project Site Address Line 2;#255;#Does Project Site Qualify as LIDAC in CEJST?;#263;#Project Site County;#267;#Project Site Census Block Group;#314;#Project Site Census Block;#315

DE317

Project Site Unique Identifier - EPA

5-Project Site

This is a read-only field and contains the unique identifier that EPA will use to uniquely identify project sites among grantees.

String

0-ALL

GGRF

316;#316

Project Site Unique Identifier - Grantee;#316

File Type	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified	0000-00-00
File Created	0000-00-00