Appendix C. Transaction- and Project-Level Report Data Dictionary.xlsx

GGRF Accomplishment Reporting (NEW)

Appendix C. Transaction- and Project-Level Report Data Dictionary.xlsx

OMB:

Document [xlsx]

Download: xlsx | pdf

Data Element

Inclusion Status

Title

Definition for Field

Picklist Values

Definition for Picklist Values

Data Type

Format

Unit of Measure

Range - Lower Limit

Range - Upper Limit

Flat File Name

Data Grouping(s)

Applicability

Data Source(s)

Conditional Logic

Validations

Notes

Field Source

Related fields

Related fields: Title

Longitudinal Data Element?

GGRF Calculator Input/Output

DE001

1-KEEP

GGRF Program

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.

CCIA;NCIF;SFA

CCIA Clean Communities Investment Accelerator

NCIF National Clean Investment Fund

SFA Solar for All

Picklist

Not applicable

0-Award

0-Grant Recipient

0-ALL

Recipient

Required field.

Validate against 'US EPA Grant Number'; each 'US EPA Grant Number' has one and only one GGRF Program picklist value.

GGRF

DE002

1-KEEP

Recipient Name

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

Not applicable

String

TEST ENVIRONMENTAL FOUNDATION

Not applicable

0-Award

0-Grant Recipient

0-ALL

Recipient

Required field.

Validate against NGGS

GGRF

DE003

1-KEEP

US EPA Grant Number

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.

Not applicable

String

0X00000000

Not applicable

0-Award;#1-Transaction

0-Grant Recipient

0-ALL

Recipient

Required field.

Validate against NGGS

0. NGGS will append a dash and sequential number or letter after each award amendment, for example: 5H84090301-1. The "-1" denotes amendment #1 of that award. Once 1-9 are consumed via amendments, the system switches over to letters in alphabetical order (info from Michelle Tucker).
1. This field functions as the primary key (PK) in the awards table(s) and serves as the foreign key (FK) in the transaction table(s). [The awards table will likely be one table and should be distinct from the entity table since a single legal entity may have multiple awards. Said another way, the cardinality between the entity and award is at least one, but could be many in some cases.]
2. Since a prime recipient organization can have multiple grant awards -- take Bonneville Environmental Foundation -- the foreign key in the transactions file must be the US EPA-assigned Grant Number and not the Unique Entity ID (from SAM.gov).

GGRF

2;#2;#4;#4

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

DE004

1-KEEP

Unique Entity Identifier (UEI)

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.

Not applicable

String

SAMUEIDTEST01

Not applicable

0-Award

0-Grant Recipient

0-ALL

Recipient

Required field.

Validate against NGGS

SAM.GOV

2;#2;#3;#3

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

DE005

1-KEEP

Transaction Identifier - Grantee

This field contains a value that uniquely identifies each of the grant recipient's financial instruments, like loans or lines of credit, in their financial system of record. Grant recipients should submit the unaltered value and unaltered format from their system of record to aid auditors.

Not applicable

String

GRANTEE-TEST-ID-2024-XHB09983

Not applicable

1-Transaction;#2-Project

1-Transaction

0-ALL

Recipient

Required field.

Must be unique for all rows or records in the (1) report and (2) in the permanent data store.

This field functions as the primary key (PK) in the transaction table(s) and serves as the foreign key (FK) in the project table(s). [The transaction table may be one table with extensions for each of the three priority project types and another extension for projects that do not fall into existing priority project areas or perhaps separate tables altogether.]

GGRF

DE006

1-KEEP

Transaction Identifier - Originator

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'.

Not applicable

String

EPA-TEST-GUID-2024-XBHSDL-3495S-0909340

Not applicable

1-Transaction

0-ALL

Recipient

Conditionally required if Financial Assistance Type (DE014) IS NOT N/A;

Should we strike the conditional logic: [Conditionally required if DE014 (Financial Assistance Type=not N/A); else, null.]? The reason for striking this conditional logic is that this field will likely be unknown by the prime recipient who reports the data to EPA and only known to the subrecipient.

Modified from CDFI NACA RRP TLR (December 2023)

14;#14

Financial Assistance Type;#14

DE007

1-KEEP

Counterparty Name

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

Not applicable

String

Coalition Partner "A," Inc.

Not applicable

1-Transaction

0-ALL

Recipient

Required field.

CDFI FUND (modified)

DE008

1-Keep

Counterparty TIN or EIN

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.

Not applicable

String

12-3456789

Not applicable

1-Transaction

0-ALL

Recipient

Conditionally required if Counter Party Type (DE023) != INDIVIDUAL-HOUSEHOLD.

If Counter Party Type (DE023) = BEN-INDIVIDUAL-HOUSEHOLD then NULL.

CDFI FUND (modified)

8;#8;#24;#24

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

DE009

1-KEEP

Transaction Identifier - EPA

This field contains the EPA unique identifier for the transaction record and is distinct from the grantee's unique identifier for the transaction record. This field will be provided to the grantee through the completion report upon successful creation of the record in the first reporting period when the record is reported. Any subsequent update or modification to the record will require both the grantee's unique identifier and the EPA's unique identifier to ensure data integrity.

Not applicable

String

EPA-TEST-GUID-2024-XBHSDL-3495S-0909340

Not applicable

1-Transaction

0-ALL

EPA System (TAPS) for Unique Identifier;#Recipient

Conditionally required field if the Transaction Identifier - Grantee (DE005) already exists in the permanent data store; else, null.

GGRF

DE010

1-KEEP

Date Originated

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

Not applicable

Date

YYYY-MM-DD

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Transaction Purpose (DE012) = FINANCIAL OR SUBAWARD-FINANCIAL;

Ask grantees whether this rule obtains: If Transaction Purpose = FINANCIAL, the Transaction Date and Date Originated should be the same date.

CDFI FUND

12;#12

Transaction Purpose;#12

DE011

1-KEEP

Reporting Period End Date

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.

Not applicable

Date

YYYY-MM-DD

Not applicable

0-Award

0-Grant Recipient

0-ALL

Recipient

Required field.

ReportingEndDateCalendar

CDFI FUND

DE012

1-KEEP

Transaction Purpose

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.

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

TECHNICAL Assistance includes any pre-development or market-development costs or costs for new product development. By definition, technical assistance has no repayment terms attached to the instrument and thus, no program income either.

FINANCIAL Assistance include any costs to construct or install the greenhouse gas reducing technology, including financial assistance in the form of loans. Financial Assistance is defined in 2 CFR 200.1 and in the terms and conditions;

SUBAWARD constitutes “an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a Federal award received by the pass-through entity.” Since subawards may come in other forms (i.e., loans), the term “subgrant” denotes a subaward in the form of a grant. See: 2 CFR 200.1.

SUBAWARD-TECHNICAL is a subaward for a subrecipient to use for TECHNICAL support as defined by the terms and conditions;

SUBAWARD-FINANCIAL is a subaward for a sub-recipient to use for FINANCIAL support as defined by the terms and conditions;

Picklist

Not applicable

1-Transaction

0-ALL

Recipient

Required field.

Definition and data rule are pending review with Asher and Tom on this Teams thread: https://teams.microsoft.com/l/message/19:[email protected]/1719593187343?context=%7B%22contextType%22%3A%22chat%22%7D

CDFI FUND (modified)

DE013

1-KEEP

Finance Type

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.

ASSET; PROJECT; CORPORATE; OTHER

ASSET any financial assistance that leads to the purchase, acquisition, lease of a tangible property, like a heat pump or rooftop solar array that has the intended purpose of reducing the GHG and criteria pollutant emissions.;

PROJECT any financial assistance that contributes to a multilayered 'capital stack' that together provides the financial viability for a major capital investment, like the construction or adaptive reuse or retrofitting of buildings, for example.;

CORPORATE any financial investment that leads to an ownership or equity stake in a company or for profit enterprise with the intention of driving down GHG and criteria pollutant emissions through that financial investment.;

OTHER any financial investment that is not Asset, Project or Corporate.;

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Transaction Purpose (DE012) = FINANCIAL OR SUBAWARD-FINANCIAL;
IF GGRF Program (DE001)= SFA then CORPORATE is invalid;
IF GGRF Program (DE001)= CCIA then CORPORATE is invalid;

SFA cannot have CORPORATE financing

GGRF

14;#14;#1;#1

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

DE014

1-KEEP

Financial Assistance Type

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.

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

TERM Term Loan: A term loan is a loan from the GGRF recipient/sub for a specific amount that has a specified repayment schedule and a fixed or floating interest rate.;

LOC Line of Credit (LOC): An LOC is an arrangement between the GGRF recipient/sub and a customer that establishes the maximum loan amount the customer can borrow excluding credit cards.;

SUBSIDY Used for transactions where the financial assistance has no debt service or amortization of any kind.;

OTHER-CONSUMER-DEBT Used for other consumer debt products not listed in the preceding list.;

LNGUARANTEE Loan Guarantee: A loan agreement where the GGRF recipient/sub is a guarantor.;

LNLSRESERVE Loan Loss Reserve: The GGRF recipient/sub is using the financial assistance award to provide loan loss reserve for this loan.;

CAPRESERVE Capital Reserve: The GGRF recipient/sub is using the financial assistance award to leverage this loan.;

OTHER-CREDIT-ENHANCEMENT Used for other credit enhancement products not listed in the preceding list.;

LNPURCHASE Used for loans purchased as a batch from the loan originator.;

LNSECURITIZATION Used for loans sold as a batch to a purchaser on the secondary market.;

OTHER-INSTITUTIONAL-DEBT Used for other institutional debt products not listed in the preceding list.;

EQTYINV Equity Investment: An equity investment is money that is invested in a company by the GGRF recipient/sub in exchange for the ownership shares of that company.;

DEBTEQTY Debt with Equity: The loan agreement that stipulates a loan may be converted to an equity upon meeting specified conditions.;

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

(1) This field was initially labelled "Transaction Type (FA Type)."
(2) The "CREDITCARD" option that was present from the CDFI/NACA/RRP TLR from December 2023 is eliminated in GGRF's picklist values.

Modified from CDFI NACA RRP TLR (December 2023)

DE015

1-Keep

Financial Assistance Type Description

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.

Not applicable

String

Comment field that tells a short description of the financial type. This is a catch all in case there is an assistance that is not a current picklist value

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Financial Assistance Type (DE001) or Technical Assistance Type (DE083) = OTHER;

not applicable

This field should likely be struck and added to the narrative reporting for simplicity since repetitively adding the description for a batch of like financial assistance products (or 'types') is tedious and burdensome.

GGRF

14;#14

Financial Assistance Type;#14

DE016

1-KEEP

Transaction Amount

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”.

Not applicable

Currency

1000.00

USD

1-Transaction

0-ALL

Recipient

Required field.

This field was originally called, "Original Assistance Amount."

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

DE020

1-KEEP

GGRF Recycled Funds Amount

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

Not applicable

Currency

1000.00

USD

1-Transaction

0-ALL

Recipient

Required field.

GGRF

DE021

1-KEEP

Financial Product Status

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

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

ACTIVE A loan or investment was open, on-the-books at the reporting period end.;

CLOSED A loan or line of credit that was paid in full (not refinanced) or an equity investment that has been exited at the reporting period end.;

SOLD A financial note was off-the-books but not paid in full at the reporting period end. It was done due to a transfer to another entity.;

CHARGEDOFF A financial note was off-the-books but not paid in full at the reporting period end. It was done due to delinquency of borrower.;

REFIN A financial note was off-the-books but not paid in full at the reporting period end. It was done due to changes of loan features such as interest rate or loan term.;

RESTRUCT A financial note was open, on-the-books at the reporting period end. It was done in response to or to prevent a loan default.;

N/A Financial Product Status does not apply to this transaction;

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product;#FinancialProductStatusFields

0-ALL

Recipient

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

Active, Closed, Chargedoff, Refinanced, Restructured, Sold Non-Recourse Transaction, Sold Recourse Transaction SOLD:A financial note was off-the-books but not paid in full at the reporting period end. It was done due to a transfer to another entity. Nonrecourse Transaction: The outright, irrevocable sale of assets to a third party, whereby the assets and all their rights are irrevocably and absolutely transferred from the seller to the buyer and legally separated from the assets of the seller. Recourse Transaction: A transfer of assets wherein the seller continues to assume all or a portion of the risk associated with the non-performance of the underlying financial transactions and the buyer maintains full or partial recourse to the seller.

Modified from CDFI NACA RRP TLR (December 2023)

YES

DE022

1-Keep

Technical or Financial Assistance Provider Name

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.

Not applicable

String

United States Bank of Banks

Not applicable

1-Transaction

0-ALL

Recipient

Required.

CDFI FUND

23;#23;#24;#24

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

DE023

1-Keep

Counterparty Type

Choose one of the picklist values to describe the counterparty to the transaction. Counterparties fall into two broad groups, either: (1) program beneficiaries, indicated by the picklist values with "BEN" as a prefix; or (2) subrecipients, indicated by the picklist values with "SUB" as a prefix. For individuals or households, use BEN-HOUSEHOLD. If the entity is not listed, choose BEN-OTHER or SUB-OTHER.

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

Picklist

Not applicable

1-Transaction

0-ALL

Recipient

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

Originally, this field was labelled, "Financial Provider Type."

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

1-Keep

Technical or Financial Assistance Provider TIN or EIN

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.

Not applicable

String

12-3456789

Not applicable

1-Transaction

0-ALL

Recipient

Required field.

Marc consolidated DE023 and DE024 picklist values, keeping DE023 and marking DE024 for deletion. See working file folder for the consolidated picklist values.
2024-07-26: Changed the title of this data element from "Financial Provider Entity Type" (a picklist) to "Financial Assistance Provider TIN or EIN" (a string) to better account for the movement of money from grantee to subrecipient and subrecipient to some "Financial Assistance Provider" named in DE022 and DE024 (this field). The old picklist values for this field (prior to the change in data label) are as follows: BANK; CDFI COMMUNITY DEVELOPMENT VENTURE CAPITAL FUND; CDFI CREDIT UNION; CDFI COMMUNITY DEVELOPMENT BANK; CDE

Modified from CDFI NACA RRP TLR (December 2023)

8;#8;#24;#24

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

DE026

1-KEEP

Unpaid Principal

Report the most recent unpaid principal balance of the financial instrument. This field is optional.

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product;#FinancialProductStatusFields

0-ALL

Recipient

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

We may not need to keep track of this as we will know it is charged off?
If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A all interest-related fields DE026 to DE038=N/A

CFPB

26;#26;#241;#241

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

YES

DE027

1-KEEP

Interest Rate

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”.

Not applicable

Percent

1.234

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

IF Interest Rate (DE027) <> NULL THEN must be equal or greater than zero.;

If FINANCIAL ASSISTANCE TYPE (DE014) =SUBSIDY THEN INTEREST RATE = NULL;
IF Maximum Interest Rate (DE029) is > Interest Rate (DE027) THEN ERROR.;

CDFI NACA RRP TLR (December 2023)

DE028

1-KEEP

Interest Type

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

FIXED; ADJ; OTHER

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

IF FINANCIAL ASSISTANCE TYPE (DE014) =SUBSIDY THEN NULL

Modified from CDFI NACA RRP TLR (December 2023)

DE029

1-KEEP

Maximum Interest Rate

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).

Not applicable

Percent

3.1234

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Interest Type (DE028 ) = ADJ or OTHER;

IF FINANCIAL ASSISTANCE TYPE (DE014) = SUBSIDY, then NULL.

CFPB

DE030

1-KEEP

Points

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”.

Not applicable

Number

1.25

points

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

If FINANCIAL ASSISTANCE TYPE (DE014) = SUBSIDY THEN NULL
Points must be between 0 and 100.

CDFI FUND

DE031

1-KEEP

Origination Fees

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.

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if FINANCIAL ASSISTANCE TYPE (DE014) = TERM or LOC or DEBTEQTY)

ORIGINATION FEES (DE031) must be => 0 and < TRANSACTION AMOUNT (DE016);
If FINANCIAL ASSISTANCE TYPE (DE014) =SUBSIDY THEN NULL

CDFI FUND

14;#14;#16;#16

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

DE032

1-KEEP

Amortization Type

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

FULLAMORT; PARTAMORT; NONAMORT; OTHER

FULLAMORT Fully Amortized: Amortization schedule includes both interest and principal payments throughout the life of the loan.;

PARTAMORT Partially Amortized: Amortization schedule includes some principal payments throughout the life of the loan, with a larger principal payment at maturity.;

NONAMORT Non-Amortizing: Amortization schedule includes interest only payments with a single principal payment at maturity.;

OTHER None of the above.;

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

If FINANCIAL ASSISTANCE TYPE (DE014) =SUBSIDY THEN NULL

CDFI NACA RRP TLR (December 2023)

DE033

1-KEEP

Equity-Like Features

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.

CONVDEBT; PERFINT; ROYALTIES; WARRANTS; OTHER

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Finance Type (DE013) = CORPORATE;
Conditionally required if if Financial Assistance Type (DE014) = EQTYINV or DEBTEQTY.

If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN NULL

CDFI NACA RRP TLR (December 2023)

14;#14

Financial Assistance Type;#14

DE034

1-KEEP

Debt-Equity Conversion

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.

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Finance Type (DE013) = CORPORATE;
Conditionally required if if Financial Assistance Type (DE014) = EQTYINV or DEBTEQTY.

If FINANCIAL ASSISTANCE TYPE (DE014) =SUBSIDY THEN NULL

CFPB

14;#14

Financial Assistance Type;#14

DE035

1-KEEP

Term in Months

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”.

Not applicable

Number

240

months

600

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if FINANCIAL ASSISTANCE TYPE (DE014) = TERM or LOC or DEBTEQTY;

If DE014 (FINANCIAL ASSISTANCE TYPE) = SUBSIDY, then NULL

CDFI NACA RRP TLR (December 2023)

14;#14

Financial Assistance Type;#14

DE036

1-KEEP

Guarantee by Third Party

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.

SBA; USDA; OTHERGOV; PERSONAL; OTHER; NONE

SBA Small Business Administration (SBA): The loan is guaranteed by SBA in case the borrower defaults.;

USDA US Department of Agriculture (USDA): The loan is guaranteed by USDA in case the borrower defaults.;

OTHERGOV Other Government Source: The loan is guaranteed by another governmental entity (federal, state, or local government) in case the borrower defaults.;

PERSONAL Personal Guarantee: A loan is issued by EPA to its borrower, but guaranteed by other individuals (non-government, non-business entities) in case the borrower defaults.;

OTHER The loan is guaranteed by another mechanism;

NONE None of the Above;

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if FINANCIAL ASSISTANCE TYPE (DE014) = TERM, LOC, DEBTEQTY or LNPURCHASE

If FINANCIAL ASSISTANCE TYPE (DE014) =SUBSIDY THEN NULL

CDFI NACA RRP TLR (December 2023)

14;#14

Financial Assistance Type;#14

DE037

1-KEEP

Forgivable Loan

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.

YES; YESTM; NO; DO NOT KNOW

YES The loan or the equity may be converted to a grant.;

YESTM The loan or the equity may be converted to a grant and there has been at least one payment within 12 months of the loan closing date.;

NO The loan or the equity may not be converted to a grant.;

DO NOT KNOW The information is either unknown to the lender or not applicable.;

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

If Financial Assistance Type (DE014) = SUBSIDY THEN NULL

CDFI NACA RRP TLR (December 2023)

14;#14

Financial Assistance Type;#14

DE038

1-KEEP

Amount of Forgivable Loan

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. This amount includes only the forgivable part of the loan and not the original principal. If the loan agreement notes a percentage of the original loan amount, then the percentage should be converted into the corresponding dollar amount.

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Forgivable Loan (DE037)= Yes or YesTM.

DE038 cannot be greater than or equal to DE016 (Transaction Amount) OR DE241 (PRINCIPAL) If DE014 (FINANCIAL ASSISTANCE TYPE) =SUBSIDY THEN N/A

DE037 could be eliminated in favor of DE038 to reduce the total count by one element. However, there is some benefit to having the first ("Forgivable Loan") be Boolean and the second "Amount of Forgivable Loan" be a number since this could serve as a check step to ensure data quality.

GGRF

37;#37

Forgivable Loan;#37

DE057

1-KEEP

Client ID (reported to CDFI Fund)

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.

Not applicable

String

not applicable

Not applicable

1-Transaction

2-Beneficiary-Borrower

0-ALL

Recipient

Conditionally required If Transaction Purpose (DE014) = FINANCIAL or SUBAWARD-FINANCIAL AND Counterparty Type (DE023) = SUB-CDFI OR BEN-CDFI.

CDFI NACA RRP TLR (December 2023)

6;#6;#7;#7

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

DE064

1-KEEP

NAICS

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 ”.

Not applicable

String

522298

Not applicable

1-Transaction

2-Beneficiary-Borrower

0-ALL

Recipient

Conditionally required if Counterparty Type (DE023) IN
(BEN-BUSINESS;
BEN-NOTPROFIT;
SUB-BUSINESS;
SUB-BNOTPROFIT;
) else, null.

North American Industry Classification System (NAICS)

Only required of end beneficiaries that are a business.

CDFI FUND

DE065

1-Keep

Low-Income Owned or Controlled?

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.

YES; NO; DO NOT KNOW

Picklist

Not applicable

1-Transaction

3-Project

0-ALL

Recipient

Conditionally required if Counterparty Type (DE023) IN
(BEN-BUSINESS;
SUB-BUSINESS;
SUB-CDE;
SUB-CDFI) else, null.

CDFI NACA RRP TLR (December 2023)

58;#58

Investee or Borrower or Recipient Type;#58

DE069

1-Keep

Date Created

This field is a TAPS-generated field for each record across all files submitted containing the date the data was written to the permanent data store and not the file upload date. This field should be provided back to the recipient as part of the submission confirmation once the data is committed to TAPS. Each (a) grantee-submitted field has its (b) EPA correlate to uniquely identify the records for transactions (DE005 and DE009), projects (DE070 and DE072), project sites (DE316 and DE317) and project benefits (DE325 and DE326), respectively.

Not applicable

Date

2024-05-11 04:12:57

Not applicable

0-Award;#1-Transaction;#2-Project;#3-Benefits;#5-Project Site

TAPS-Metadata

0-ALL

EPA System (TAPS)

Not applicable.

CDFI FUND

5;#5;#9;#9;#70;#70;#316;#316;#325;#325;#72;#72;#326;#326;#317;#317

Transaction Identifier - Grantee;#5;#Transaction Identifier - EPA;#9;#Project Identifier - Grantee;#70;#Project Site Identifier - Grantee;#316;#Benefit Identifier - Grantee;#325;#Project Identifier - EPA ;#72;#Benefit Identifier - EPA;#326;#Project Site Identifier - EPA;#317

DE070

1-Keep

Project Identifier - Grantee

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

Not applicable

String

GRANTEE-PROJECTID-TEST-00002

Not applicable

2-Project

3-Project

0-ALL

Recipient

Required for all records or rows on the project flat file.

Must be unique for all rows or records in the (1) report and (2) in the permanent data store.

This field functions as the primary key (PK) in the project table(s) and serves as the foreign key (FK) in the benefits table(s). [The project table may be one table with extensions for each of the three priority project types and another extension for projects that do not fall into existing priority project areas or perhaps separate tables altogether.]

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

1-Keep

Project Identifier - EPA

This field contains the EPA unique identifier for the project record and is distinct from the grantee's unique identifier for the project record. This field will be provided to the grantee through the completion report upon successful creation of the record in the first reporting period when the record is reported. Any subsequent update or modification to the record will require both the grantee's unique identifier and the EPA's unique identifier to ensure data integrity.

Not applicable

String

EPA-PROJECTID-TEST-00002

Not applicable

2-Project

3-Project

0-ALL

EPA System (TAPS) for Unique Identifier;#Recipient

Required field if the Project Identifier - Grantee (DE070) already exists in the permanent data store; else, null.

OUR system ID and EPA PRIMARY KEY

GGRF

DE074

1-Keep

Project Title

Enter a short title for the project. This field is required for project finance and optional in all other cases (asset and corporate finance).

Not applicable

String

Super Awesome Test Project Title

Not applicable

1-Transaction;#2-Project

3-Project

0-ALL

Recipient

Conditionally required if Finance Type (DE013) = PROJECT. Conditionally optional if Finance Type (DE013) = ASSET or CORPORATE.

The project title should aid in the exception reporting and error handling for the flat file and dimension file submission routes, respectively, by adding a human readable element -- in addition to the Project ID field -- to ensure that all layers (viz. transactions) in the capital stack (in project finance) or transactions for corporate finance can easy be identified.

GGRF

DE075

1-Keep

Project Description and Purpose

Enter a short description and purpose for the project.

Not applicable

String

This project leverages the financial power of money to purchase goods to reduce green house gas emissions.

Not applicable

2-Project

3-Project

0-ALL

Recipient

Optional field.

GGRF

DE076

1-KEEP

Project Type

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 Terms and Conditions for the Greenhouse Gas Reduction Fund called "priority project categories" or "areas."

CLEANENERGY; BUILDINGS; TRANSPORTATION; INDUSTRY; AGRICULTURE; OTHER

Picklist

Not applicable

2-Project

3-Project

0-ALL

Recipient

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

GGRF

DE077

1-KEEP

Project Type Detail

Choose the type of project.

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

Picklist

Not applicable

2-Project

3-Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) is NOT NULL

GGRF

DE083

1-KEEP

Technical Assistance Type

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

COMMUNITY-OUTREACH;
COMMUNITY-CAPACITY-BUILDING;
CONTRACTORS-OUTREACH;
CONTRACTORS-CAPACITY-BUILDING;
LENDERS-OUTREACH;
LENDERS-CAPACITY-BUILDING;
WORKFORCE-OUTREACH;
WORKFORCE-CAPACITY-BUILDING;
NEWPRODUCT;

Picklist

Not applicable

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

3-Project

0-ALL

Recipient

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

GGRF

12;#12

Transaction Purpose;#12

DE084

1-KEEP

Technical Assistance Description

Narratively describe the assistance activity and primary purpose.

Not applicable

String

This grant supports training 17 works on health and safety standards related to solar panel installation.

Not applicable

2-Project

3-Project

0-ALL

Recipient

Conditionally required If Project Type (DE072) = Other

GGRF

DE085

1-Keep

Project Status

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.

STARTED; COMPLETE; CANCELLED

Picklist

Not applicable

2-Project

Longitudinal-Data-Project-Status

0-ALL

Recipient

Required field.

This field was previously labelled, "Deployment Status" but changed to "Project Status" to make abundantly clear.

GGRF

86;#86

Project Status Description;#86

YES

DE086

1-Keep

Project Status Description

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).

Not applicable

String

not applicable

Not applicable

2-Project

Longitudinal-Data-Project-Status

0-ALL

Recipient

Conditionally required if Deployment Status (DE085) =CANCELLED

GGRF

85;#85

Project Status ;#85

YES

DE087

1-KEEP

Project Equipment Useful Life

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.

Not applicable

Number

months

1200

2-Project

3-Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) is NOT NULL.

This field was labelled "Project Lifetime"

GGRF

Household Savings;

DE088

1-Keep

Project Site City

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

Not applicable

String

New York

Not applicable

5-Project Site

Address-Data

0-ALL

Recipient

Required field.

US Census or USPS

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

DE089

1-Keep

Project Site State or Territory

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

Two character state or territory abbreviation used by USPS.

Picklist

Not applicable

5-Project Site

Address-Data

0-ALL

Recipient

Required field.

Census or USPS

May not need for project depending on project type

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

PP2.Retrofit;#PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE090

1-Keep

Project Site ZIP Code

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

Not applicable

Number

10005

not applicable

99999

5-Project Site

Address-Data

0-ALL

Recipient

Required field.

CENSUS

State-County FIPS

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

PP2.Electric Use Efficiency;#PP2.Smart Fridge;#PP2.Grid Controlled Appliances;#PP2.Grid Controlled HVAC;#PP2.Retrofit;#PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE091

1-KEEP

Project Site Census Tract Code

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

Not applicable

String

36061031703

Not applicable

5-Project Site

3-Project

0-ALL

Recipient

Conditionally required if Does Project Qualify as LIDAC? (DE096) = CEJST;
Conditionally required if Technical Assistance Geospatial Target (DE331) =CENSUSTRACT;

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

1-KEEP

Project Site Census Tract and Block Group Year

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

2010; 2020

Picklist

Not applicable

5-Project Site

3-Project

0-ALL

Recipient

Conditionally required if Project Site Census Tract Code (DE091) IS NOT NULL

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

1-KEEP

Project Site Longitude (X-Coordinate)

Decimal Degrees of estimated Project Longitude (-DD.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.

Not applicable

Number

-74.01506

decimal degrees

-180

180

5-Project Site

3-Project

0-ALL

Recipient

Optional field.

Must be -DDD.dddd

GGRF

DE094

1-KEEP

Project Site Latitude (Y-Coordinate)

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.

Not applicable

Number

40.71166

decimal degrees

-90

5-Project Site

3-Project

0-ALL

Recipient

Optional field.

GGRF

DE095

1-Keep

Project Site Geocoordinates Description

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

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

Picklist

Not applicable

5-Project Site

3-Project

0-ALL

Recipient

Conditionally required, if Project Latitude (DE094 ) IS NOT NULL AND Project Longitude (DE093) IS NOT NULL; else, null.

Duplicate entry with DE240. Keep DE095 and mark DE240 for deletion.

GGRF

240;#240

Project Location Description;#240

DE096

1-KEEP

Does Project Qualify as LIDAC?

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.

CEJST; EJSCREENSI; LIHOUSE; AFFHOUSE; TRIBAL; N/A

CEJST CEJST-Identified Disadvantaged Communities: All communities identified as disadvantaged through version 1.0 of the Climate and Economic Justice Screening Tool (CEJST), released on November 22, 2022, which includes census tracts that meet the thresholds for at least one of the tool’s categories of burden and land within the boundaries of Federally Recognized Tribes.;

EJSCREENSI EJScreen-Identified Disadvantaged Communities: All communities within version 2.2 of EJScreen that fall within either (a) the limited supplemental set of census block groups that are at or above the 90th percentile for any of EJScreen’s supplemental indexes when compared to the nation or state or (b) geographic areas within Tribal lands as included in EJScreen, which includes the following Tribal lands: Alaska Native Allotments, Alaska Native Villages, American Indian Reservations, American Indian Off-reservation Trust Lands, and Oklahoma Tribal Statistical Areas. https://www.epa.gov/ejscreen;

LIHOUSE Geographically Dispersed Low-Income Households as defined within the program specific terms and conditions.;

AFFHOUSE Properties providing affordable housing as defined within the program specific terms and conditions.;

TRIBAL Federally Recognized Tribal Entities: All Federally Recognized Tribal entities, which are considered disadvantaged regardless of whether a Federally Recognized Tribe has land, consistent with M-23-09 and CEJST.;

N/A Not Applicable;

Picklist

Not applicable

1-Transaction;#2-Project

3-Project

0-ALL

Recipient

Conditionally required if GGRF Program (DE001) = SFA or CCIA
or Conditionally required if DE263 (Qualifies as LIDAC in CEJST) = NO; else, null.

Note: there's a difference in data checks.
First pass - data type (red flag/stop)
Second pass - acceptable values (red or yellow flag/warning or stop)
Third pass - program rules (CCIA and SFA must be LIDAC, e.g.) (yellow flag/warning) This field was labelled "Investee or Borrower or Recipient - LIDAC Type"

GGRF

263;#263

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

DE101

1-Keep

Is the asset owner not-for-profit?

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

YES; NO

Boolean

Not applicable

2-Project

3-Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) IS NOT NULL.

#transaction-project data structure

GGRF

DE102

1-Keep

Is the asset owner a community?

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.

YES; NO

Boolean

Not applicable

2-Project

3-Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) IS NOT NULL.

GGRF

DE103

1-KEEP

Total Project or Development Cost

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.

Not applicable

Currency

1000.00

USD

1-Transaction;#2-Project

3-Project

0-ALL

Recipient

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

GGRF

287;#287

Total Development Cost;#287

DE108

1-KEEP

Community Benefits Delivered

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

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

Picklist

Not applicable

2-Project

4-Benefits-Community

0-ALL

Recipient

Required field.

J40 Resilience field

GGRF

DE109

1-KEEP

Number of Households Served by Project

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

Not applicable

Number

1000

Households

10000

2-Project

4-Benefits-Community

0-ALL

Recipient

Optional field.

GGRF

DE110

1-KEEP

Estimated Annual Household Savings Provided by Project

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

Not applicable

Currency

1000.00

USD

2-Project

4-Benefits-Community

0-ALL

Recipient

Optional field.

GGRF

DE111

1-KEEP

Description of Household Savings

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.

UTILITYBILLSAVINGS; CAPITALCOSTREDUCTION; ORIGINATIONCOSTSAVINGS

Picklist

Not applicable

2-Project

4-Benefits-Community

0-ALL

Recipient

Optional field.

GGRF

DE113

1-KEEP

Permanent Jobs Created or Retained [Non-Construction]

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"

Not applicable

Number

1000

Jobs

20000

2-Project

4-Benefits-Community

0-ALL

Recipient

Optional field.

CDFI FUND (modified)

DE114

1-KEEP

Full-Time Equivalent Jobs Created [Construction]

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.

Not applicable

Number

1000

Jobs

15000

2-Project

4-Benefits-Community

0-ALL

Recipient

Optional field.

DBRA defines the FTE work week at 40 hours per Thomas Hitz.

CDFI FUND (modified)

DE115

1-KEEP

Source of Jobs Estimates

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.;

NEWFINANCING; WAGEDATA; ECONOMICIMPACT; RULE OF THUMB; OTHER

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

Not applicable

2-Project

4-Benefits-Community

0-ALL

Recipient

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

CDFI NACA RRP TLR (December 2023)

115;#115;#116;#116

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

DE116

1-KEEP

Source of Jobs Estimates Description (if projected)

Narratively describe the source of job estimates.

Not applicable

String

not applicable

Not applicable

2-Project

4-Benefits-Community

0-ALL

Recipient

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

Modified from CDFI NACA RRP TLR (December 2023)

DE117

1-KEEP

Tools to Promote Good Jobs and Community

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.

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;

Picklist

Not applicable

2-Project

4-Benefits-Community

0-ALL

Recipient

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

1) This field can be a multi-select.
2) Solid bullet points in the definitions field are the superordinate categories whereas the hollow bullet points are the subordinate picklist values with their definitions.

GGRF

DE126

1-Keep

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

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.

YES; NO

Boolean

Not applicable

2-Project

4-Benefits-Community

0-ALL

Recipient

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

Modified from a count to a Y/N value.

GGRF

DE130

1-Keep

Average Estimated Annual Household Energy Savings

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

Not applicable

Currency

1000.00

USD

2-Project

4-Benefits-Community

0-ALL

Recipient

Optional field.

In order to be accurate, this field should be delimited by the project or project site geography and should be standardized or normalized across relevant size homes or housing units.

GGRF

DE133

1-Keep

Annual Carbon Dioxide Equivalent (CO2e)

Annual avoided Carbon Dioxide Equivalent (CO2e) emissions in metric tons

Not applicable

Number

49.25000

ton (metric)

2000

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if Project Type (DE076) IS not NULL

Carbon dioxide equivalent or CO2e means the number of metric tons of CO2 emissions with the same global warming potential as one metric ton of another greenhouse gas, and is calculated using Equation A-1 of 40 CFR Part 98.

2024-10-31: Applies for buildings and transportation

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodology, including baseline.

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

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

DE134

1-Keep

Annual Carbon Dioxide (CO2)

Annual avoided Carbon Dioxide (CO2) emissions in metric tons

Not applicable

Number

4.25000

ton (metric)

2000

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

2024-10-31: Applies for energy and transportation

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Methane (CH4)

Annual avoided Methane (CH4) emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

2024-10-31: Relevant to buildings and transportation

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Hydrofluorocarbons (HFCs)

Annual HFC emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

2024 - 10 - 30 : None of the 3 priority projects from ICF have HFCs as an output parameter

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Nitrous Oxide (N2O)

Annual avoided N2O emissions in metric tons

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

2024-10-31: Only applies for buildings

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Perfluorocarbons (PFCs)

Annual PFC emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

2024-10-31: Does not appear in any of the three program calculators

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Sulfur Hexafluoride (SF6)

Annual SF6 emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

2024-10-31: Does not appear in any of the three program calculators

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Nitrogen Trifluoride (NF3)

Annual lifetime NF3 emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

2024-10-31: Does not appear in any of the three program calculators

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Primary Fine Particulate Matter (PM2.5)

Annual avoided Primary PM2.5 emissions in metric tons. Primary particles are emitted directly from a source, such as construction sites, unpaved roads, smokestacks or fires.

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

2024-10-31: Energy and Transportation

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Total Fine Particulate Matter (PM2.5)

Annual avoided Primary and Secondary PM2.5 emissions in metric tons. Primary particles are emitted directly from a source, such as construction sites, unpaved roads, smokestacks or fires. Secondary particles form in complicated atmospheric reactions involving chemicals such as sulfur dioxides and nitrogen oxides that are emitted from power plants, industries and automobiles

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

2024-10-31: Energy and Transportation

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Particulate Matter (PM10)

Annual avoided PM10 emissions in metric tons.

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

2024-10-31: Transportation

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Nitrogen Dioxide (NO2)

Annual avoided NO2 emissions in metric tons.

Not applicable

Number

0.00450

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Sulfur Dioxide (SO2)

Annual avoided SO2 emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

2024-10-31: Energy and Buildings

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Ground-Level Ozone (O3)

Annual O3 emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Carbon Monoxide (CO)

Annual avoided CO emissions in metric tons

Not applicable

Number

4.25000

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Lead (Pb)

Annual Pb emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Ammonia (NH3)

Annual avoided NH3 emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

2024-10-31: Applies for for energy

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Annual Volatile Organic Compounds (VOCs)

Annual Avoided VOCs emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

2024-10-31: Applies for energy and transportation

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodolgy, including baseline.

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

1-Keep

Clean Energy Type

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.

SOLAR; WIND; HYDROPOWER

Picklist

Not applicable

2-Project

3-Project-1-Clean Energy Project;#3-Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) = CLEANENERGY

These are inputs to the project type-project sub-type models

GGRF

DE152

1-Keep

Nameplate Capacity

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.

Not applicable

Number

400

kilowatts (kW)

10000

2-Project

3-Project-1-Clean Energy Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) = CLEANENERGY

These are inputs to the project type-project sub-type models

GGRF

DE153

1-Keep

Capacity Factor

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.

Not applicable

Percent

0.99

0.01

0.99

2-Project

3-Project-1-Clean Energy Project

0-ALL

EPA System (TAPS)

Conditionally required if Project Type (DE076) = CLEANENERGY

These are inputs to the project type-project sub-type models. For solar PV projects, the capacity factor can be calculated based on the "Nameplate Capacity" (DE152) and "Latitude" (DE094) since it's a function of the capacity and the solar irradiance which varies with latitude. NYSERDA has been able to set their solar PV capacity factor to an empirically validated factor (13%) based on many years of data collected across distributed generation in New York state -- US EPA may not be able to use that factor for a variety of reasons, but should aim to reduce the data collection burden.

GGRF

94;#94;#152;#152

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

DE155

1-Keep

Storage Technology Type

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.

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

Picklist

Not applicable

2-Project

3-Project-1-Clean Energy Project;#3-Project

0-ALL

Recipient

Conditionally required if Project Type Detail (DE077) = STORAGE

These are inputs to the project type-project sub-type models

GGRF

DE156

1-KEEP

Storage Power Capacity [in kW]

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

Not applicable

Number

100.00

kilowatts (kW)

2-Project

3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if Project Type Detail (DE077) = STORAGE

These are inputs to the project type-project sub-type models

GGRF

DE157

1-KEEP

Storage Energy Capacity [in kWh]

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).

Not applicable

Number

100.00

kilowatt-hours (kWh)

2-Project

3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if Project Type Detail (DE077) = STORAGE

These are inputs to the project type-project sub-type models

GGRF

DE158

1-KEEP

Cycle Efficiency

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.

Not applicable

Percent

0.15

0.01

0.99

2-Project

3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = CLEANENERGY

Values expressed as a decimal must be greater than or equal to 0.01 and less than or equal to 0.99.

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

1-KEEP

Response Time (seconds)

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

Not applicable

Number

seconds

300

2-Project

3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = CLEANENERGY

GGRF

DE160

1-KEEP

Duration of Discharge

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.

Not applicable

Number

100

hour

1000

2-Project

3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = CLEANENERGY

GGRF

DE161

1-Keep

Is the power source only renewable?

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."

YES; NO

Boolean

Not applicable

2-Project

3-Project-1-Energy Storage

0-ALL

Recipient

If project type detail is Generation, then optional

GGRF

DE162

1-Keep

Transmission Project Type

Choose the transmission project type from the picklist.

RECONDUCTOR-ACSR-ACCC

RECONDUCTOR-ACSR-ACCC means replacing ACSR type electrical transmission wires with newer ACCC type electrical transmission wires to increase the efficiency of the transmission and distribution of the electrical grid (decrease "line losses").

Picklist

Not applicable

2-Project

3-Project-1-Clean Energy Project;#3-Project

0-ALL

Recipient

Conditionally required If Project Type
Detail (DE077) = TRANSMISSION

These are inputs to the project type-project sub-type models

GGRF

DE163

1-Keep

Miles of Power Lines

Estimated miles of transmission related lines upgraded or replaced.

Not applicable

Number

1000

mile

2000

2-Project

3-Project-1-Transmission

0-ALL

Recipient

Conditionally optional If Project Type
Detail (DE077) = TRANSMISSION

Positive whole numbers only.

These are inputs to the project type-project sub-type models. This is an "enabling upgrade" in SFA?

GGRF

DE164

1-Keep

Estimated Annual Reduced Energy Loss from Change in Technical Loss Rate

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.

Not applicable

Percent

0.01

0.99

2-Project

3-Project-1-Transmission

0-ALL

Recipient

Conditionally optionalIf Project Type
Detail (DE077) = TRANSMISSION

Enter

Delta needed to back calculate emissions reductions based on grid-level emissions

GGRF

DE165

1-Keep

Estimated change in electricity consumption annually

Calculate net change in electricity energy consumption in kilowatt-hours (kWh) before the project came into service versus after the project. This number could be positive or negative.

Not applicable

Number

1000

kilowatt-hours (kWh)

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

These are inputs to the project type-project sub-type models.
https://www.epa.gov/energy/greenhouse-gases-equivalencies-calculator-calculations-and-references

GGRF

PP2.Electric Use Efficiency;

DE166

1-Keep

Estimated change in natural gas consumption

Calculated net change in natural gas consumption (annually).

Not applicable

Number

1000

million cubic feet (MMcf)

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

thousand cubic feet (can be converted to/from the thermal unit of mmbtu)

GGRF

DE167

1-Keep

Estimated change in fuel oil consumption

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.

Not applicable

Number

1000

gallon

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

Positive whole integers only.

These are inputs to the project type-project sub-type models

GGRF

DE168

1-Keep

Estimated diesel equivalent fuel consumption

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.

Not applicable

Number

1000

gallon

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

Positive whole integers only.

These are inputs to the project type-project sub-type models.
This needs revision and is a placeholder. NOT FINAL.

GGRF

DE169

1-KEEP

Energy efficiency measures adopted

General description of efficiency measure adopted.

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

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

These are inputs to the project type-project sub-type models

GGRF

DE170

1-KEEP

Number of air source heat pumps installed

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

Not applicable

Number

1000

Air Source Heat Pumps

20000

2-Project

3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

GGRF

DE171

1-KEEP

Number of geothermal heat pumps installed

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

Not applicable

Number

1000

Geothermal Heat Pumps

20000

2-Project

3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

GGRF

DE172

1-KEEP

Number of induction stoves installed

The number of induction stoves installed for a project

Not applicable

Number

1000

Induction Stoves

20000

2-Project

3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

GGRF

DE173

1-KEEP

Number of electric stoves installed

The number of electric stoves installed for a project

Not applicable

Number

1000

electric stovetop

20000

2-Project

3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

GGRF

DE174

1-KEEP

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

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.

Not applicable

Number

R-value

2-Project

3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

These are inputs to the project type-project sub-type models

GGRF

DE175

1-KEEP

Building Type

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

COMMERCIAL;
MIXEDUSE;
RESIDENTIALSINGLEFAMILY;
RESIDENTIALMULTIFAMILY;

COMMERCIAL means

MIXEDUSE;

RESIDENTIALSINGLEFAMILY;
RESIDENTIALMULTIFAMILY;

Picklist

Not applicable

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS

These are inputs to the project type-project sub-type models
https://www.energystar.gov/sites/default/files/2024-04/US_PropertyTypesUseDetails_Definitions_Mar2024_508.pdf

GGRF

77;#77

Project Type Detail;#77

PP2.Building Reuse;

DE176

1-KEEP

Number of Net-Zero Buildings

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

Not applicable

Number

1000

buildings

25000

2-Project

3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = BUILDINGS

GGRF

DE177

1-KEEP

Type of Construction

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

ZERO-EMISSIONS NEW CONSTRUCTION;
ZERO-EMISSIONS RETROFITS;
ELECTRIFICATION [BUILDING SYSTEMS];
EEWEATHERIZATION;

Picklist

Not applicable

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = BUILDINGS

GGRF

DE178

1-Keep

Net-Zero Calculation Method

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 TBD

Picklist

Not applicable

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = BUILDINGS

GGRF

DE179

1-KEEP

Square Footage

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.

Not applicable

Number

5000000

square feet

999999

2-Project

3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = BUILDINGS

These are inputs to the project type-project sub-type models

GGRF

PP2.Net-Zero Housing;

DE180

1-KEEP

Number of Vehicles Deployed

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

Not applicable

Number

1000

Vehicles

25000

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

These are inputs to the project type-project sub-type models

GGRF

PP3.Onroad Vehicle;

DE181

1-KEEP

What is the Type of Existing On-Road Vehicle Being Replaced?

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)

GASOLINE PASSENGER CAR;
GASOLINE LIGHT-DUTY TRUCK (VANS, PICKUP TRUCKS, SUVS);
GASOLINE MEDIUM- AND HEAVY-DUTY TRUCK OR BUS;
DIESEL PASSENGER CAR;
DIESEL LIGHT-DUTY TRUCK (VANS, PICKUP TRUCKS, SUVS);
DIESEL MEDIUM- AND HEAVY-DUTY TRUCK OR BUS;
GASOLINE MOTORCYCLE;

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

https://nepis.epa.gov/Exe/ZyPDF.cgi?Dockey=P100O7VJ.pdf

GGRF

PP3.Onroad Vehicle;

DE182

1-KEEP

Baseline On-Road Vehicle Fuel Type

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

BEV;PHEV;FCEV

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

Should be compression ignition or spark ignition (gas vs. diesel)

These are inputs to the project type-project sub-type models

GGRF

PP3.Onroad Vehicle;

DE183

1-KEEP

New On-Road Vehicle Fuel Type

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

BEV; PHEV; FCEV

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

GGRF

PP3.Onroad Vehicle;

DE184

1-KEEP

Average On-Road Baseline Model Year

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.

Not applicable

Date

1990

Not applicable

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

GGRF

PP3.Onroad Vehicle;

DE185

1-KEEP

Will the Old On-Road Vehicles be Destroyed?

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."

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

GGRF

PP3.Onroad Vehicle;

DE186

1-KEEP

Type of non-road equipment

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

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

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

These are inputs to the project type-project sub-type models

GGRF

DE187

1-KEEP

Baseline Non-Road Equipment Fuel Type

Type of fuel used

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

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

These are inputs to the project type-project sub-type models

GGRF

DE188

1-KEEP

Baseline non-road equipment horsepower

Horsepower range of equipment (based on EPA standards)

<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

Picklist

Not applicable

horsepower

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

These are inputs to the project type-project sub-type models

GGRF

DE189

1-KEEP

New Non-Road Equipment Fuel Type

Type of fuel used

BEV; PHEV; FCEV

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

These are inputs to the project type-project sub-type models

GGRF

DE190

1-KEEP

New non-road equipment horsepower

Horsepower range of equipment (based on EPA standards)

<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

Picklist

Not applicable

horsepower

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

These are inputs to the project type-project sub-type models

GGRF

DE191

1-KEEP

Average Non-Road Baseline Model Year

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.

Not applicable

Date

1990

Not applicable

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

GGRF

DE192

1-KEEP

Will the old off-road vehicles be destroyed?

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

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION

GGRF

DE193

1-KEEP

Number of charging ports deployed

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

Not applicable

Number

100

EVSE ports

25000

2-Project

3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = VEHICLECHARGING-REFUELING

These are inputs to the project type-project sub-type models

GGRF

DE194

1-KEEP

Number of Level 1 Ports

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

Not applicable

Number

100

EVSE ports

25000

2-Project

3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = VEHICLECHARGING-REFUELING

Number of 120V ports

GGRF

DE195

1-KEEP

Number of Level 2 Ports

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

Not applicable

Number

100

EVSE ports

25000

2-Project

3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = VEHICLECHARGING-REFUELING

Number of J1772 or similar ports

GGRF

DE196

1-KEEP

Number of DC Fast Ports

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

Not applicable

Number

100

EVSE ports

25000

2-Project

3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = VEHICLECHARGING-REFUELING

Number of J3400 (NACS), CCS, CHAdeMO ports

GGRF

DE197

1-KEEP

Estimated Load Factor

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

Not applicable

Percent

0.99

0.01

0.99

2-Project

3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = VEHICLECHARGING-REFUELING

GGRF

DE198

1-KEEP

Is the charger publicly accessible?

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

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = VEHICLECHARGING-REFUELING

GGRF

DE199

1-KEEP

Baseline Fuel Type

Type of fuel replaced prior to implementing fuel switching technology.

GASOLINE; DIESEL;

Not applicable

Picklist

Not applicable

2-Project

3-Project-3-Fuel Switching

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = FUEL SWITCHING; else, null.

These are inputs to the project type-project sub-type models.

GGRF

200;#200

Baseline Annual Fuel Consumption;#200

PP3.Fuel Switch;

DE200

1-KEEP

Baseline Annual Fuel Consumption

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

Not applicable

Number

1000

gallon

10000

2-Project

3-Project-3-Fuel Switching

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = FUEL SWITCHING; else, null.

These are inputs to the project type-project sub-type models

GGRF

199;#199

Baseline Fuel Type;#199

PP3.Fuel Switch;

DE201

1-Keep

Baseline annual CO2e

CO2e emissions from baseline system/fuel

Not applicable

Number

ton (metric)

2-Project

3-Project-3-Fuel Switching

1-GLIA (CCIA & NCIF)

Recipient

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

2024-10-31: I think this should apply for building water and heat projects as well. - Brent

These are inputs to the project type-project sub-type models
https://www.eia.gov/environment/emissions/co2_vol_mass.php
https://www.epa.gov/energy/greenhouse-gases-equivalencies-calculator-calculations-and-references

GGRF

PP2.HVAC Update;

DE202

1-KEEP

Alternative fuel type

Type of alternative fuel switched to.

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

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = FUEL SWITCHING

These are inputs to the project type-project sub-type models
https://www.epa.gov/renewable-fuel-standard-program/alternative-fuels
https://afdc.energy.gov/
ENERGY ACT OF 1992
Biodiesel (B100)
Natural gas and liquid fuels domestically produced from natural gas
Propane (liquefied petroleum gas)
Electricity
Hydrogen
Blends of 85% or more of methanol, denatured ethanol, and other alcohols with gasoline or other fuels
Methanol, denatured ethanol, and other alcohols
Coal-derived, domestically produced liquid fuels
Fuels (other than alcohol) derived from biological materials
P-Series fuels

GGRF

PP3.Fuel Switch;

DE203

1-KEEP

Alternative fuel consumption annually

Estimated annualized fuel consumption.

Not applicable

Number

multi-unit

2-Project

3-Project-3-Fuel Switching

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = FUEL SWITCHING

These are inputs to the project type-project sub-type models

GGRF

PP3.Fuel Switch;

DE204

1-KEEP

New annual CO2e

2024-10-31: I think this should apply for building water and heat projects as well. - Brent

Projected annual emissions from new fuel/system

Not applicable

Number

ton (metric)

2-Project

3-Project-3-Fuel Switching

1-GLIA (CCIA & NCIF)

Recipient

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

These are inputs to the project type-project sub-type models

GGRF

PP2.HVAC Update;

DE205

1-KEEP

Fuel consumption unit

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

TBD

Picklist

Not applicable

2-Project

3-Project;#3-Project-3-Fuel Switching;#3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

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

GGRF

PP3.Fuel Switch;

DE206

1-KEEP

Renewable Natural Gas (RNG) production per year

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)

Not applicable

Number

1000

million cubic feet (MMcf)

2-Project

3-Project-Other-Methane Recovery

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = METHANE RECOVERY

https://www.epa.gov/agstar/agstar-project-development-handbook

GGRF

DE207

1-KEEP

Renewable Natural Gas (RNG) Source

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 TBD

Picklist

Not applicable

2-Project

3-Project-Other-Methane Recovery

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = METHANE RECOVERY

https://www.epa.gov/agstar/agstar-project-development-handbook

GGRF

DE208

1-KEEP

Renewable Natural Gas (RNG) Use

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)

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

Picklist

Not applicable

2-Project

3-Project-Other-Methane Recovery

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Detail (DE077) = METHANE RECOVERY

https://www.epa.gov/agstar/agstar-project-development-handbook

GGRF

DE209

1-KEEP

Acres of Forest

Acres of forest new or conserved.

Not applicable

Number

100000

acre

1000000

2-Project

3-Project-Other-Foresty

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional.

Enter whole positive integers only. Round up or down to the next whole number.

AVERT high-level value for calculating carbon sink of a forest project.
https://www.epa.gov/energy/greenhouse-gases-equivalencies-calculator-calculations-and-references#pineforests

GGRF

DE210

1-KEEP

New or Conserved?

Are forests new or conserved.

NEW; CONSERVED

Picklist

Not applicable

2-Project

3-Project-Other-Foresty

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional.

AVERT high-level value for calculating carbon sink of a forest project

GGRF

DE211

1-KEEP

Project Financing Source (Public) - Name

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

FEDERAL; STATE; LOCAL; OTHER-GOVERNMENT

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

CDFI FUND (modified)

DE212

1-KEEP

Project Financing Source (Public) - Amount

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

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

CDFI FUND (modified)

DE213

1-KEEP

Project Financing Source (Private) - Name

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

TBD

Picklist

1000.00

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

Must contain a dollar value equal or greater to $0. No negative values are allowed.

Switched the data element titles for DE213 and DE294 to allow numbering to flow sequentially.

GGRF

13;#13

Finance Type;#13

DE214

1-KEEP

Project Financing Source (Private) - Amount

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

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

CDFI FUND (modified)

DE215

1-Keep

Loan-to-Value Ratio

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."

Not applicable

Percent

150

1-Transaction

1-Transaction-Financial Product;#FinancialProductStatusFields

0-ALL

Recipient

Conditionally required if Security Interest (DE262) = FIRST MORTGAGE or JUNIOR MORTGAGE; else null.

This field has no meaning unless tied to a security interest which itself is tied to the financial assistance product.

CDFI Fund

YES

DE217

1-KEEP

Loan Loss Reserve Requirement

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).

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Project Type Detail (DE077) = ZERO-EMISSIONS NEW CONSTRUCTION or ZERO-EMISSIONS RETROFITS; else, null

Validations: • Conditionally required if one or more financial notes associated with this project has a Transaction Type = Term Loan • Enter the percentage as a whole number (i.e. if response is 25%, enter 25) • The Loan Loss Reserve Requirement must be => 0 AND <=100 Response must be numeric up to 3 decimal places OR NA

CDFI Fund

14;#14

Financial Assistance Type;#14

DE218

1-Keep

Grant Recipient Fiscal Year End Date

Enter the end date for the grantee's or subgrantee's fiscal year.

Not applicable

Date

YYYY-MM-DD

Not applicable

0-Award

0-Grant Recipient

0-ALL

Compass Data Warehouse (CDW);#SAM.GOV

Required field.

CDFI FUND (modified)

1;#1

GGRF Program;#1

DE241

1-Keep

Principal Amount

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

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required if Financial Assistance Type (DE014) IS NOT NULL

Must be a whole number greater than zero.

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

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

DE242

1-Keep

Is Project Subject to BABA Requirements?

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

YES; NO

Boolean

Not applicable

2-Project

4-Benefits-BABA

0-ALL

Recipient

Conditionally required if Financial Assistance Type (DE014) IS NOT NULL

GGRF

DE243

1-Keep

Is Project Covered by an EPA-Approved BABA Waiver?

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.

YES; NO

Boolean

Not applicable

2-Project

4-Benefits-BABA

0-ALL

Recipient

Conditionally required if Is Project Subject to BABA Requirements (DE243) IS TRUE (or Yes)

GGRF

DE244

1-Keep

BABA Waiver Type

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.

PROGRAM-WIDE WAIVER; PROJECT-SPECIFIC WAIVER

Picklist

Not applicable

2-Project

4-Benefits-BABA

0-ALL

Recipient

Conditionally required if Is Project Covered by an EPA-Approved BABA Waiver (DE243)

GGRF

DE245

1-Keep

BABA Program-wide Waiver

Select the specific BABA EPA Program level waiver.

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

Picklist

Not applicable

2-Project

4-Benefits-BABA

0-ALL

Recipient

Conditionally required if Is Project Covered by an EPA-Approved BABA Waiver (DE244) = PROGRAM-WIDE WAIVER

GGRF

DE246

1-Keep

BABA Project-specific Waiver

Enter the title of the granted waiver.

Not applicable

String

not applicable

Not applicable

2-Project

4-Benefits-BABA

0-ALL

Recipient

Conditionally required If BABA Waiver type (DE244) is PROJECT-SPECIFIC WAIVER

DE247

1-Keep

Date EPA Project Officer Provided BABA Waiver Approval

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

Not applicable

Date

YYYY-MM-DD

Not applicable

2-Project

4-Benefits-BABA

0-ALL

Recipient

Conditionally Required if BABA Project-specific Waiver (DE243)
= PROJECT-SPECIFIC WAIVER

GGRF

DE248

1-Keep

Name of EPA Project Officer Providing BABA Waiver Approval

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

Not applicable

String

not applicable

Not applicable

2-Project

4-Benefits-BABA

0-ALL

Recipient

Conditionally Required if BABA Project-specific Waiver (DE243)
= PROJECT-SPECIFIC WAIVER

GGRF

DE249

1-Keep

Is Project Subject to DBRA Requirements?

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

YES; NO

Boolean

Not applicable

2-Project

4-Benefits-DBRA

0-ALL

Recipient

Conditionally required if Financial Assistance Type (DE014) IS NOT NULL

GGRF

250;#250

DBRA Construction Category;#250

DE250

1-Keep

DBRA Construction Category

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

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.

Picklist

Not applicable

2-Project

4-Benefits-DBRA

0-ALL

Recipient

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

The Davis-Bacon Act (DBA) applies to each federal government or District of Columbia contract in excess of $2,000 for the construction, alteration, or repair (including painting and decorating) of public buildings or public works and requires that contractors and subcontractors pay their laborers and mechanics employed under such contracts no less than the locally prevailing wages and fringe benefits for corresponding work on similar projects in the area.
https://www.dol.gov/agencies/whd/government-contracts/construction/faq/conformance

GGRF

249;#249

Is Project Subject to DBRA Requirements?;#249

DE251

1-Keep

Asset owner is

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

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.

Picklist

Not applicable

2-Project

3-Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) IS IN (CLEANENERGY; BUILDINGS; TRANSPORTATION; INDUSTRY; AGRICULTURE);

https://www.nrel.gov/docs/fy23osti/86210.pdf
n 2 CFR § 200.1

GGRF

DE252

1-Keep

Transaction Date

Enter the date the financial transaction occurred.

Not applicable

Date

YYYY-MM-DD

Not applicable

1-Transaction

0-ALL

Recipient

Required field.

We do not want settlement date. Some product types and transaction types will likely have a settlement date.

GGRF

5;#5

Transaction Identifier - Grantee;#5

DE253

1-Keep

Transaction Identifier - Counterparty

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

Not applicable

String

not applicable

Not applicable

1-Transaction

0-ALL

Recipient

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

GGRF

DE254

1-Keep

Project Site Address Line 1

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.

Not applicable

String

123 North Street

Not applicable

5-Project Site

Address-Data

0-ALL

Recipient

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

If this is a record related to an individual, we should not collect address.

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

1-Keep

Project Site Address Line 2

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.

Not applicable

String

PO 51

Not applicable

5-Project Site

Address-Data

0-ALL

Recipient

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

If this is a project related to an individual's transaction we do not track it.

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

1-Keep

Solar PV Project Type Usage

Choose the end beneficiary of the solar photovoltaic system.

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.

Picklist

Not applicable

2-Project

3-Project

0-ALL

Recipient

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

DE078 is currently marked as questionable.
Name of field is too close to other project field names.

GGRF

DE257

1-Keep

Grant Title

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

Not applicable

String

NEBRASKA SOLAR FOR ALL

Not applicable

0-Award

0-Grant Recipient

0-ALL

Recipient

Not applicable

GGRF

DE258

1-Keep

Enabling Upgrades

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.

PANELUPGRADES; ROOFUPGRADES; GRIDUPGRADES; OTHER; 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 infrastructureOTHER includes costs like site preparation by cutting trees and so on.
N/A Enabling upgrades not applicable

Picklist

Not applicable

2-Project

3-Project;#3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage;#3-Project-1-Transmission

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

GGRF

258;#258;#311;#311

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

Household Savings;

DE259

1-Keep

Is household electrified for the first time?

Is the household being electrified for the first time?

YES; NO

Boolean

Not applicable

2-Project

4-Benefits-SFA

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

Household Savings;

DE260

1-Keep

Investment Tax Credit (ITC) Amount

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

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Optional field.

GGRF

DE261

1-Keep

Principal Subsidy Amount at Time of Origination

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.

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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).

This field was labelled, "Upfront Subsidy on Outstanding Principal."

GGRF

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

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

DE262

1-Keep

Security Interest

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.

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

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

Added on 6/25/2024 in response to Ted Toon's request to track security interest that backs or secures the financial assistance product.
Field for assets of real value (real estate)

GGRF

14;#14

Financial Assistance Type;#14

DE263

1-Keep

Does Project Site Qualify as LIDAC in CEJST?

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/

YES; NO

Boolean

Not applicable

5-Project Site

3-Project

0-ALL

Recipient

Required field.

Since this field refers to a geospatial purpose, we will not include it in the 1-Transactions file and only include it in the 2-Project file.

GGRF

96;#96

Does Project Qualify as LIDAC?;#96

DE264

1-Keep

Date of Project Completion (Actual)

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

Not applicable

Date

YYYY-MM-DD

Not applicable

2-Project

Longitudinal-Data-Project-Status

0-ALL

Recipient

Conditionally required if DE085 (Project Status) = COMPLETE.

This date must be after the origination date (DE010)

GGRF

85;#85

Project Status ;#85

YES

DE265

1-Keep

Project Interconnection Date

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

Not applicable

Date

YYYY-MM-DD

Not applicable

2-Project

Longitudinal-Data-Project-Status

0-ALL

Recipient

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

GGRF

264;#264

Date of Project Completion (Actual);#264

YES

DE266

1-Keep

Investment Tax Credit (ITC) Direct Pay Amount

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

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally optional if Counterparty Type (DE023) in (
BEN-NONPROFIT;SUB-NONPROFIT;
SUB-GOV-COUNTY;
SUB-GOV-MUNICIPALITY;
SUB-GOV-STATE;
SUB-GOV-TRIBAL;
)

Relates to DE260.

GGRF

260;#260

Investment Tax Credit (ITC) Amount;#260

DE267

1-Keep

Project Site County

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

Picklist

Not applicable

5-Project Site

Address-Data

0-ALL

Recipient

Required 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

DE268

1-Keep

Subsidy Type

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".

UPFRONT;REBATE;SUBSCRIPTION SUBSIDY

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.

SUBSCRIPTION options means the beneficiary receives financial compensation for some duration of the subscription.

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

Monisha Shah and Liz Gill requested this field which is similar to DE261 (Upfront Subsidy on Outstanding Principal) but actually tracks the different types of subsidy.

GGRF

261;#261

Principal Subsidy Amount at Time of Origination;#261

DE269

1-Keep

Project Resiliency Measures

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

STORAGEABOVEFLOODZONE;

Picklist

Not applicable

2-Project

3-Project

0-ALL

Recipient

Required field.

GGRF

DE270

1-Keep

Solar Lease Monthly Amount

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

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if Clean Energy Type (DE151) = SOLAR

Value must be a positive real number.

GGRF

DE270

1-Keep

Delinquency - 30 Days or Less

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

YES; NO

Boolean

YES

Not applicable

1-Transaction

1-Transaction-Financial Product;#FinancialProductStatusFields

0-ALL

Recipient

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

Only one or none of the fields in DE270 through DE273 may be indicated.

These four bands and their Boolean indicators standardize, unlike the "Financial Product Status" field which is at the discretion of the lender, the number of days of delinquency in payment agreed upon between the borrower and lender. If grantees and community lenders receiving subaward find it easier, OGGRF could transform these fields into a simple delinquency day count.

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

YES

DE271

1-Keep

Delinquency - 31 to 60 Days

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

YES; NO

Boolean

YES

Not applicable

1-Transaction

1-Transaction-Financial Product;#FinancialProductStatusFields

0-ALL

Recipient

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

Only one or none of the fields in DE270 through DE273 may be indicated.

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

YES

DE272

1-Keep

Delinquency - 61 to 90 Days

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

YES; NO

Boolean

YES

Not applicable

1-Transaction

1-Transaction-Financial Product;#FinancialProductStatusFields

0-ALL

Recipient

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

Only one or none of the fields in DE270 through DE273 may be indicated.

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

YES

DE273

1-Keep

Delinquency - 91 or More Days

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

YES; NO

Boolean

YES

Not applicable

1-Transaction

1-Transaction-Financial Product;#FinancialProductStatusFields

0-ALL

Recipient

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

Only one or none of the fields in DE270 through DE273 may be indicated.

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

YES

DE274

1-Keep

Micromobility Vehicle Project

This field indicates whether a project is financing micromobility options as a simple Boolean value (yes or no). Micromobility projects provide alternatives to traditional transportation (cars, trains, buses) in communities.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if PROJECT TYPE (DE076) = TRANSPORTATION

GGRF

275;#275

Micromobility Number of Vehicles Deployed;#275

PP3.Charging-Walk-Bike;

DE275

1-Keep

Micromobility Number of Vehicles Deployed

Number of micromobility vehicles deployed as part of a micromobility project.

Not applicable

Number

567

vehicles

5000

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Micromobility Vehicle Project (DE274) = YES

Whole positive non-zero integers only!

GGRF

274;#274

Micromobility Vehicle Project;#274

PP3.Charging-Walk-Bike;

DE277

1-Keep

Solar Lease Term

Enter the duration in months for the solar lease.

Not applicable

Number

360

months

600

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if Clean Energy Type (DE151) = SOLAR

GGRF

DE278

1-Keep

Solar Lease - Fixed or Variable Monthly Lease Amount

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.

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.

Picklist

Not applicable

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if Clean Energy Type (DE151) = SOLAR

GGRF

DE279

1-Keep

Project Sponsor Name

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.

Not applicable

String

not applicable

Not applicable

1-Transaction

3-Project;#Project-Sponsor-Fields

0-ALL

Recipient

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

Brett Theodos recommends adding this field (2024-07-17).

GGRF

DE280

1-Keep

Project Sponsor Address Line 1

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.

Not applicable

String

not applicable

Not applicable

1-Transaction

Address-Data

0-ALL

Recipient

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

Brett Theodos from Urban Institute recommended adding these fields to identify the project sponsor or developer.

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

1-Keep

Project Sponsor Address Line 2

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.

Not applicable

String

not applicable

Not applicable

1-Transaction

Address-Data

0-ALL

Recipient

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

Brett Theodos from Urban Institute recommended adding these fields to identify the project sponsor or developer.

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

1-Keep

Project Sponsor City

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

Not applicable

String

not applicable

Not applicable

1-Transaction

Address-Data

0-ALL

Recipient

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

Brett Theodos from Urban Institute recommended adding these fields to identify the project sponsor or developer.

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

1-Keep

Project Sponsor State or Territory

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

Picklist

Not applicable

1-Transaction

Address-Data

0-ALL

Recipient

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

Brett Theodos from Urban Institute recommended adding these fields to identify the project sponsor or developer.

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

1-Keep

Project Sponsor ZIP Code

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

Not applicable

Number

12345

Not applicable

99999

1-Transaction

Address-Data

0-ALL

Recipient

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

Brett Theodos from Urban Institute recommended adding these fields to identify the project sponsor or developer.

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

1-Keep

Project Sponsor TIN or EIN

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.

Not applicable

String

12-3456789

Not applicable

1-Transaction

3-Project;#Project-Sponsor-Fields

0-ALL

Recipient

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

1-Keep

Project Placed in Service Date

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

Not applicable

Date

YYYY-MM-DD

Not applicable

2-Project

Longitudinal-Data-Project-Status

0-ALL

Recipient

Conditionally required if Finance Type (DE013) = PROJECT; else, null AND Project Funding Source (DE211) = IS NOT NULL

Originally asked if Project Funding Source (DE211) = Tax Credit Equity

GGRF

85;#85;#264;#264

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

YES

DE288

1-Keep

Number of newly built units

Enter the number of newly constructed housing units or apartments.

Not applicable

Number

1000

housing unit

25000

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

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

Value must be zero or a positive integer

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

1-Keep

Number of rehabilitated or adaptively reused units

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

Not applicable

Number

housing unit

25000

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

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

1-Keep

Number of rental units

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

Not applicable

Number

1000

housing unit

25000

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Must be zero or a positive integer and must equal total unit count.

GGRF

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

DE291

1-Keep

Number of units for ownership

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

Not applicable

Number

100

housing unit

25000

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

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

DE292

1-Keep

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

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

Not applicable

Number

housing unit

25000

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

GGRF

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

DE293

1-Keep

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

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

Not applicable

Number

150

housing unit

2-Project

3-Project;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

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

Must be zero or positive integer.

GGRF

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

DE294

1-Keep

Project Financing (All Private Sources) - Subtotal

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.

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

GGRF

DE295

1-Keep

Project Financing Stage

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

PREDEVELOPEMENT; ACQUISITION; CONSTRUCTION; PERMANENT

Picklist

Not applicable

1-Transaction

0-ALL

Recipient

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

1-Keep

Total Photovoltaic System Cost

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

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Must be a whole number greater than zero and must sum to the same number as the component fields.

https://usepa.sharepoint.com/:x:/r/sites/GGRF/_layouts/15/Doc.aspx?sourcedoc=%7BBFB4C453-4F48-4EAC-9222-7EF85202DEED%7D&file=SFA%20Requested%20Fields%20(Check%20Versus%20GGRF%20Data%20Dictionary).xlsx&wdLOR=cAFA300A9-9373-4D5A-80A3-E6BFE08FA782&action=default&mobileredirect=true

GGRF

DE297

1-Keep

Photovoltaic Panels Cost (Materials)

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.

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if DE076 = CLEANENERGY

GGRF

296;#296

Total Photovoltaic System Cost;#296

DE298

1-Keep

Inverter Cost (Materials)

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.

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if DE076 = CLEAN ENERGY

Enter whole numbers greater than 0.

GGRF

296;#296

Total Photovoltaic System Cost;#296

DE299

1-Keep

Remainder of System Cost

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).

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if DE076 =

Must be a whole number greater than 0.

GGRF

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

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

DE300

1-Keep

Interconnection Cost

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

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Energy Storage;#3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if DE076 = CLEANENERGY PROJECT

Enter whole numbers greater than 0.

GGRF

DE301

1-Keep

Permitting Fees Cost

Enter the permitting fees for the clean energy generation project.

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

0-ALL

Recipient

Conditionally required if DE076 = CLEANENERGY PROJECT

Enter a whole number greater than 0.

GGRF

DE302

1-Keep

Solar Panel Type

Choose the solar panel type from the picklist values.

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;

Picklist

Not applicable

2-Project

3-Project-1-Clean Energy Project

0-ALL

Recipient

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

Added on 2024-07-23 due to ICF's recommendation to include this field.

GGRF

76;#76

Project Type;#76

DE303

1-Keep

Baseline On-Road Vehicle Annual Idling Hours

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

Not applicable

Number

1000

hour

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

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

Value must be a whole number between 0 and 8,760 (the number of hours in a year).

GGRF

PP3.Onroad Vehicle;

DE304

1-Keep

Baseline On-Road Vehicle Annual Hoteling Hours

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

Not applicable

Number

1000

hour

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = TRANSPORTATION

Value must be a whole number between 0 and 8,760 (the number of hours in a year).

GGRF

PP3.Onroad Vehicle;

DE305

1-Keep

New On-Road Vehicle Model Year

Enter the model year for the on-road vehicles.

Not applicable

Date

YYYY

Not applicable

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = TRANSPORATION.

Year must be after the year 2000.

GGRF

PP3.Onroad Vehicle;

DE306

1-Keep

New Non-Road Vehicle Model Year

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

Not applicable

Date

YYYY

Not applicable

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = TRANSPORATION.

Year must be after the year 2000.

GGRF

PP3.Charging-Walk-Bike;

DE307

1-Keep

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

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

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Non-Road Equipment;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

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

GGRF

PP3.Charging-Walk-Bike;

DE309

1-Keep

Project Financing (All Public Sources) - Subtotal

Enter the total dollars of public funding.

Not applicable

Currency

1000.00

USD

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

GGRF

294;#294

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

DE310

1-Keep

Contract Identifier for Financial Assistance

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.

Not applicable

String

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

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

DE311

1-Keep

Enabling Upgrades Cost

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

Not applicable

Currency

1000.00

USD

2-Project

3-Project-1-Clean Energy Project;#3-Project-1-Energy Storage

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

GGRF

258;#258;#311;#311

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

Household Savings;

DE312

1-Keep

Soft Cost Subtotal for Total Project or Development Cost

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.

Not applicable

Currency

1000.00

USD

2-Project

3-Project

0-ALL

Recipient

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

1-Keep

Hard Cost Subtotal for Total Project or Development Cost

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.

Not applicable

Currency

1000.00

USD

2-Project

3-Project

0-ALL

Recipient

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

1-Keep

Project Site Census Block Group

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.

Not applicable

Number

3000

Not applicable

5-Project Site

5-Geospatial-Data;#Census-Data

0-ALL

Recipient

Conditionally required if Technical Assistance Geospatial Target (DE331) =CENSUSBLOCKGROUP

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

1-Keep

Project Site Census Block

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).

Not applicable

Number

1000

Not applicable

5-Project Site

5-Geospatial-Data;#Census-Data

0-ALL

Recipient

Optional field.

Values must fall between 0000 to 9999.

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

1-Keep

Project Site Identifier - Grantee

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

Not applicable

String

SITEIDENTIFIER

Not applicable

5-Project Site

Unique-Identifiers

0-ALL

Recipient

Required for all records or rows on the project site flat file.

Must be unique for all rows or records in the (1) report and (2) in the permanent data store.

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

1-Keep

Project Site Identifier - EPA

This field contains the EPA unique identifier for the project site record and is distinct from the grantee's unique identifier for the project site record. This field will be provided to the grantee through the completion report upon successful creation of the record in the first reporting period when the record is reported. Any subsequent update or modification to the record will require both the grantee's unique identifier and the EPA's unique identifier to ensure data integrity.

Not applicable

String

EPA-SITE-GUID

Not applicable

5-Project Site

Unique-Identifiers

0-ALL

EPA System (TAPS) for Unique Identifier;#Recipient

Required field if the Project Site Identifier - Grantee (DE316) already exists in the permanent data store; else, null.

GGRF

316;#316

Project Site Identifier - Grantee;#316

DE325

1-Keep

Benefit Identifier - Grantee

The grantee's unique identifier used to record benefits calculations for greenhouse gas emissions reductions, jobs benefits or household savings, among others and to tie the benefits record to the project or project site record that stores the data used to

Not applicable

String

Not applicable

3-Benefits

4-Benefits

0-ALL

Recipient

Required for all records or rows on the benefit flat file.

Must be unique for all rows or records in the (1) report and (2) in the permanent data store.

GGRF

DE326

1-Keep

Benefit Identifier - EPA

This field contains the EPA unique identifier for the benefit record for a particular project and is distinct from the grantee's unique identifier for the benefit record. This field will be provided to the grantee through the completion report upon successful creation of the record in the reporting period when the record is first reported. Any subsequent update or modification to the record will require both the grantee's unique identifier and the EPA's unique identifier to ensure data integrity.

Not applicable

String

Not applicable

3-Benefits

4-Benefits

0-ALL

EPA System (TAPS) for Unique Identifier;#Recipient

Required field if the Benefit Identifier - Grantee (DE325) already exists in the permanent data store; else, null.

DE327

1-Keep

Apex Transaction Identifier

This optional data element data element serves to link projects for program beneficiaries that have multiple enabling transactions, like a collateral account for one of the government-sponsored entities or GSEs, another transaction like a bulk or flow loan purchase program and a third for any secondary market sale, for example.

Not applicable

String

Not applicable

1-Transaction

1-Transaction;#1-Transaction-Financial Product

0-ALL

Recipient

Optional field. Available if grantees request access to submit using this data structure.

DE328

1-Keep

Parent Transaction Identifier

The unique identifier for the parent transaction of the child transaction.

Not applicable

String

Not applicable

1-Transaction

1-Transaction;#1-Transaction-Financial Product

0-ALL

Recipient

Optional field.

DE330

1-Keep

Unique Building Identifier (UBID)

Enter the unique building identifier (UBID) generated by the US EPA's Portfolio Manager system for buildings to track energy use and expenditures for benchmarking purposes. This value will be used to integrate between GGRF's systems and Portfolio Manager.

Not applicable

String

Not applicable

5-Project Site

3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if DE076 = Buildings and DEXYZ = retrofit, new construction, then optional.

Ted Toon mentioned that grantees are clamoring to use Portfolio Manager. We need a unique identifier to make this work. Email out to Katy Hatcher from EPA's Portfolio Manager team.

GGRF

DE332

1-Keep

Number of Vehicles Replaced

List the number of vehicles that will be replaced.

Not applicable

Number

425

vehicles

5000

2-Project

3-Project-3-On-Road Vehicles;#3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

PP3.Onroad Vehicle;;#PP3.Nonroad Vehicle-Equipment;

DE333

1-Keep

Will a managed charging strategy be utilized for the new onroad vehicles?

Choose yes or no for whether the vehicle will use a managed charging strategy. Managed EV charging refers to the strategic control of when and how vehicles are charged without compromising the fleets' operational needs. Managed charging balances energy needs among EVs, buildings, and grids through sophisticated communication and defined control objectives.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

PP3.Onroad Vehicle;

DE334

1-Keep

Are the replaced onroad vehicles a result of shared mobility (e.g., carsharing, ridesourcing, carpooling, bikesharing)?

Enter the Boolean value for whether the replaced onroad vehicle is a result of shared mobility. Shared mobility is defined as any of the options defined by the Federal Transit Administration at the URL: https://www.transit.dot.gov/regulations-and-guidance/shared-mobility-definitions

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

optional

PP3.Onroad Vehicle;;#PP3.Nonroad Vehicle-Equipment;

DE335

1-Keep

Is the battery storage dispatchable as a electrical grid resource?

Choose yes or no. Dispatchable batteries are sources of electricity that can respond to grid demands and release energy at times of peak grid demand to improve grid stability and reduce the risk of brownouts or blackouts or simply reduce the need for peak energy generation and thus reduce marginal carbon emissions rates.

YES; NO

Boolean

Not applicable

2-Project

3-Project-1-Energy Storage

0-ALL

Recipient

PP3.Onroad Vehicle;

DE336

1-Keep

Annual Nitrogen Oxides (NOx)

Annual avoided NOx emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

EPA System (TAPS);#Recipient

This field is an estimate of emissions reductions calculated. Grantee specifies model and methodology, including baseline.

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

DE337

1-Keep

Annual Sulfur Oxides (SOx)

Annual avoided SOx emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

EPA System (TAPS);#Recipient

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;#336;#336

PP2.HVAC Update;

DE338

1-Keep

Does the project have battery storage?

YES;NO

Boolean

Not applicable

2-Project

3-Project-1-Clean Energy Project

0-ALL

Recipient

Conditionally required if Clean Energy Type (DE151)= SOLAR

GGRF

PP1.Distrbuted Solar;

DE339

1-Keep

Lifetime Carbon Dioxide Equivalent (CO2e)

Lifetime avoided Carbon Dioxide Equivalent (CO2e) emissions in metric tons

Not applicable

Number

4925.00000

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

EPA System (TAPS);#Recipient

Conditionally required if Project Type (DE076) IS not NULL

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;#336;#336

DE340

1-Keep

Lifetime Carbon Dioxide (CO2)

Lifetime avoided Carbon Dioxide (CO2) emissions in metric tons

Not applicable

Number

492.50000

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

EPA System (TAPS);#Recipient

Conditionally required if Project Type (DE076) IS not NULL

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;#336;#336

DE341

1-Keep

Lifetime Methane (CH4)

Lifetime avoided Methane (CH4) emissions in metric tons

Not applicable

Number

4.92500

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

EPA System (TAPS);#Recipient

Conditionally required if Project Type (DE076) IS not NULL

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;#336;#336

DE342

1-Keep

Lifetime Nitrous Oxide (N2O)

Annual avoided N2O emissions in metric tons

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

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

DE343

1-Keep

Lifetime Total Fine Particulate Matter (PM2.5)

Lifetime avoided Primary and Secondary PM2.5 emissions in metric tons. Primary particles are emitted directly from a source, such as construction sites, unpaved roads, smokestacks or fires. Secondary particles form in complicated atmospheric reactions involving chemicals such as sulfur dioxides and nitrogen oxides that are emitted from power plants, industries and automobiles

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

DE344

1-Keep

Lifetime Particulate Matter (PM10)

Lifetime avoided PM10 emissions in metric tons.

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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;#336;#336

DE345

1-Keep

Lifetime Nitrogen Dioxide (NO2)

Lifetime avoided NO2 emissions in metric tons.

Not applicable

Number

0.00450

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

DE346

1-Keep

Lifetime Sulfur Dioxide (SO2)

Lifetime avoided SO2 emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

DE347

1-Keep

Lifetime Carbon Monoxide (CO)

Lifetime avoided CO emissions in metric tons

Not applicable

Number

4.25000

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

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

DE348

1-Keep

Lead (Pb)

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE349

1-Keep

Lifetime Ammonia (NH3)

Lifetime avoided NH3 emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE350

1-Keep

Lifetime Volatile Organic Compounds (VOCs)

Lifetime Avoided VOCs emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

Conditionally required if GGRF Program (DE001) = NCIF or CCIA AND Optional if GGRF Program (DE001) = SFA.

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

DE351

1-Keep

Lifetime Nitrogen Oxides (NOx)

Lifetime avoided NOx emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

EPA System (TAPS);#Recipient

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

DE352

1-Keep

Lifetime Sulfur Oxides (SOx)

Lifetime avoided SOx emissions in metric tons

Not applicable

Number

0.00425

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

EPA System (TAPS);#Recipient

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;#336;#336

DE353

1-Keep

Lifetime Hydrofluorocarbons (HFCs)

Lifetime HFC emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE354

1-Keep

Lifetime Perfluorocarbons (PFCs)

Lifetime PFC emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE355

1-Keep

Lifetime Sulfur Hexafluoride (SF6)

Lifetime SF6 emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE356

1-Keep

Lifetime Nitrogen Trifluoride (NF3)

Lifetime NF3 emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE357

1-Keep

Lifetime Annual Primary Fine Particulate Matter (PM2.5)

Lifetime avoided Primary PM2.5 emissions in metric tons. Primary particles are emitted directly from a source, such as construction sites, unpaved roads, smokestacks or fires.

Not applicable

Number

1000.12345

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE358

1-Keep

Lifetime Ground-Level Ozone (O3)

Lifetime O3 emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE359

1-Keep

Lifetime Lead (Pb)

Lifetime Pb emissions from baseline system/fuel

Not applicable

Number

ton (metric)

3-Benefits

4-Benefits-Emissions

0-ALL

Recipient;#EPA System (TAPS)

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

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

DE360

1-Keep

Meter Type

Utility meters are devices to measure and record the consumption of utilities such as electricity, water, natural gas, and steam. Master or main utility meters measure the total consumption for an entire building or property. Submeters are additional meters installed to measure utility consumption in more detail, whether for a specific area, system or device, and are often used in multi-tenant buildings, commercial spaces and industrial facilities to allocate utility costs accurately and fairly among different users.

MASTERMETER; SUBMETER

MASTERMETER A utility-owned meter that measures the total electricity or water usage for a building. The building owner pays the utility company for the total usage, and then includes the cost in the rent or common charges for the building. This method simplifies the billing process, but it doesn't allow for accurate billing of individual tenants.;SUBMETER building-owned meter that measures the electricity or water usage for a specific area of a building, such as a unit, department, or piece of equipment. The building owner can then bill tenants based on their actual usage. Submeters can help ensure that tenants are only responsible for their own usage, and that the building owner can accurately address water usage

Picklist

Not applicable

2-Project

4-Benefits-SFA;#4-Benefits-Household-Savings

0-ALL

Recipient

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

DE363

1-Keep

Date Modified

This is the system-generated date for all record modifications that occur.

Not applicable

Date

2024-05-11 04:12:57

Not applicable

0-Award;#1-Transaction;#2-Project;#3-Benefits;#5-Project Site

TAPS-Metadata

0-ALL

EPA System (TAPS)

Not applicable.

69;#69;#5;#5;#9;#9;#70;#70;#72;#72;#316;#316;#317;#317;#325;#325;#326;#326

Date Created;#69;#Transaction Identifier - Grantee;#5;#Transaction Identifier - EPA;#9;#Project Identifier - Grantee;#70;#Project Identifier - EPA ;#72;#Project Site Identifier - Grantee;#316;#Project Site Identifier - EPA;#317;#Benefit Identifier - Grantee;#325;#Benefit Identifier - EPA;#326

DE364

1-Keep

End Beneficiary 12-month Historical Utility Costs

The utility cost is the all-in end beneficiary bill including fixed and variable charges of all types.

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE365

1-Keep

End Beneficiary 12-month Historical Utility Energy Consumption

This is the total energy (kWh) consumption that the end beneficiary is billed for

Not applicable

Number

kilowatt-hours (kWh)

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE366

1-Keep

End Beneficiary Net Cost of Solar

The total (all-in) cost that the end beneficiary will pay for having solar (on a monthly or annual basis)
n.b. If the end beneficiary costs and benefits are fixed for project, net them in this row, and then do not enter any values in the two rows below.

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE367

1-Keep

End Beneficiary Allocated Solar Generation

Data source could include contractor models/estimates or PVWatts (qaulified industry standard solar model)

Not applicable

Number

kilowatt-hours (kWh)

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE368

1-Keep

End Beneficiary Solar Generation Compensation Rate

Solar compensation rate can be set at at the known net metering compensation rate if known, however the default assumption will be that the solar is true compensated under a true net metering rate where the costs are offset 1-1 for all costs

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE369

1-Keep

Utility Provider Name

Enter the name of the utility provider for the end beneficiary, which can be done manually or using a prepopulated drop down based on the state selection.

TBD

Not applicable

Picklist

Not applicable

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE370

1-Keep

Baseline Utility Rate

The all in (fixed and variable charges) utility rate for the end beneficiary will either be pulled based on the state and utility selection or will be entered manually by the user if using an external source or data is not available in EIA

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE371

1-Keep

Baseline Energy Consumption

The baseline energy consumption for the end beneficiary will either be pulled based on the state and locality selected or will be entered manually by the user.

Not applicable

Number

kilowatt-hours (kWh)

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE372

1-Keep

Customer Net Cost of Solar

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE373

1-Keep

Customers Allocated Generation

Data source could include contractor models/estimates or PVWatts (qaulified industry standard solar model)

Not applicable

Number

kilowatt-hours (kWh)

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE374

1-Keep

Solar Generation Compensation Rate

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE375

1-Keep

Utility bill escalation rate

The rate at which utility energy costs are expected to rise year over year using either EIA Annual Energy outlook/Historical data, or a user set input that is defensible

Not applicable

Percent

0.14

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE376

1-Keep

Solar degradation rate per year

The rate at which the solar production of the system that services the end beneficiary will degrade year over year reducing the generation received by the end beneficiary

Not applicable

Percent

0.59

0.01

0.1

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE377

1-Keep

End Beneficiary Year 1 Expected Allocated Solar Generation

The amount of energy (kWh) generated from solar in year 1 of operation. This will be used to estimate future year energy if the user does not manually enter a yearly generation profile.

Not applicable

Number

kilowatt-hours (kWh)

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE378

1-Keep

Upfront End Beneficiary Solar Cost

This would inclue loan principle, down payment, financial transaction costs, closing costs, etc. We assume that tax benefits are built into total project beneficiary costs, therefore tax incentives should be removed from beneficiary's upfront and annual costs

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE379

1-Keep

Annual Solar Incentive(s) Received by End Beneficiary

Incentives provided to the beneficiary on a regular schedule that is expected to be offered for multiple years up to the life of the project such as Renewable Energy Certificates (RECs) or program payments to the customer

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE380

1-Keep

End Beneficiary Solar Generation Absolute Compensation

Not applicable

Currency

1000.00

USD

3-Benefits

4-Benefits-SFA;#4-Benefits-Household-Savings

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

1;#1

GGRF Program;#1

Household Savings;

DE381

1-Keep

Household Savings Calculation Methdology

Choose the picklist value that corresponds to the calculation method for the household utility bill savings.

Average Year Savings Model (amortized) - Representative
Average Year Savings Model (amortized) - Empirical
Single Year Savings Model - Representative
Single Year Savings Model - Empirical

Picklist

Not applicable

3-Benefits

4-Benefits-SFA

2-ZETG (SFA)

Recipient

Conditionally required if GGRF Program (DE001) = SFA; else, null.

GGRF

Household Savings;

DE382

1-Keep

Region as defined by Avoided Emissions Generation Tool (AVERT)

Select the AVERT region from picklist. For more information on AVERT regions, see here: https://www.epa.gov/avert/avert-tutorial-getting-started-identify-your-avert-regions

CALIFORNIA REGION; CENTRAL; FLORIDA; MID-ATLANTIC; MIDWEST; CAROLINAS; NEW ENGLAND; NEW YORK; NORTHWEST; ROCKY MOUNTAINS; SOUTHEAST; SOUTHWEST; TENNESSEE; TEXAS; AK; HI; PR

For a definition of each region please see here: https://www.epa.gov/avert/avert-tutorial-getting-started-identify-your-avert-regions

Picklist

Not applicable

2-Project

3-Project-1-Clean Energy Project

0-ALL

Recipient

Conditionally required if Project Type (DE076) = CLEANENERGY or BUILDINGS;

PP1.Distrbuted Solar;;#PP1.Distrbuted Wind;

DE383

1-Keep

Expected Energy Efficiency Improvement

Projected percentage in energy efficiency improvement. Positive value corresponds to an energy efficiency improvement.

Not applicable

Percent

0.04

-0.99

0.99

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally required if Project Type (DE076) = BUILDINGS;

PP2.Electric Use Efficiency;#PP2.Grid Controlled HVAC;;#PP2.Grid Controlled Appliances;

DE384

1-Keep

Average Annual Energy Consumption

Baseline Average Annual Energy Consumption in kWh

Not applicable

Number

11000

kilowatt-hours (kWh)

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Electric Use Efficiency;#PP2.Grid Controlled HVAC;;#PP2.Grid Controlled Appliances;

DE385

1-Keep

Efficiency Unit for New HVAC System

Input of EPA GGRF Calculator.

SEER; HSPF; EER; EF - ELECTRIC; AFUE - ELECTRIC RESISTANCE HEATING

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.HVAC Update;

DE386

1-Keep

Efficiency of New HVAC System

Input of EPA GGRF Calculator.

Not applicable

Number

BTU/watt-hr

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.HVAC Update;

DE387

1-Keep

Efficiency Unit for HVAC System being replaced

Input of EPA GGRF Calculator.

SEER; HSPF; EER; EF – ELECTRIC; AFUE - ELECTRIC RESISTANCE HEATING; EF – OIL; EF – GAS; AFUE - OIL FURNACE; AFUE - GAS/PROPANE BOILER; AFUE - OIL BOILER; AFUE - GAS/PROPANE FURNACE

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Geothermal;#PP2.HVAC Update;

DE388

1-Keep

Do you have efficiency of old HVAC System available?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Geothermal;#PP2.HVAC Update;

DE389

1-Keep

Efficiency of Old HVAC system?

Input of EPA GGRF Calculator.

Not applicable

Number

BTU/watt-hr

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.HVAC Update;

DE390

1-Keep

Average Annual usage of air conditioning

Input of EPA GGRF Calculator.

Not applicable

Number

2000

hour

2-Project

3-Project-2-Home Efficiency;#3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Geothermal;;#PP2.HVAC Update;

DE391

1-Keep

Electricity usage of old air conditioning unit

Input of EPA GGRF Calculator.

Not applicable

Number

500

watts (W)

2-Project

3-Project-2-Home Efficiency;#3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Geothermal;;#PP2.HVAC Update;

DE392

1-Keep

Average annual energy consumption of old HVAC system

Input of EPA GGRF Calculator.

Not applicable

Number

6000

kilowatt-hours (kWh)

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Geothermal;;#PP2.HVAC Update;

DE393

1-Keep

Old HVAC Efficiency Rating

Input of EPA GGRF Calculator.

SEER - ENERGY STAR Sept 2015 to present;
SEER - ENERGY STAR 2006 thru Aug 2015;
SEER - 2015 or newer (South);
SEER - 2015 or newer (North);
SEER - 2006 to 2014;
SEER - 1992 through 2005;
SEER - Prior to 1992;
SEER - Mini-split / Ductless (All years);
HSPF - ENERGY STAR Sept 2015 to present;
HSPF - ENERGY STAR 2006 thru Aug 2015;
HSPF - 2015 or newer;
HSPF - 2006 to 2014;
HSPF - 1992 through 2005;
HSPF - Prior to 1992;
HSPF - Mini-split / Ductless (All years);
EER - Window A/C;
AFUE - Gas/Propane Furnace - Condensing Prior to 2015;
AFUE - Gas/Propane Furnace - Natural Draft (All Years);
AFUE - Gas/Propane Furnace - Induced Draft (All Years);
AFUE - Gas/Propane Furnace - North;
AFUE - Gas/Propane Furnace - South;
AFUE - Gas/Propane Boiler - ENERGY STAR after Oct 2014;
AFUE - Gas/Propane Boiler - ENERGY STAR after Oct 2004;
AFUE - Gas/Propane Boiler - Condensing;
AFUE - Gas/Propane Boiler - Induced Draft;
AFUE - Gas/Propane Boiler - Natural Draft;
AFUE - Oil Furnace - Condensing;
AFUE - Oil Furnace - ENERGY STAR after Feb 2003;
AFUE - Oil Furnace - Retention Head Burner;
AFUE - Oil Furnace - Conventional Burner;
AFUE - Oil Boiler - ENERGY STAR after Oct 2014;
AFUE - Oil Boiler - ENERGY STAR after April 2002;
AFUE - Oil Boiler - After Sept. 2012 (All except ES);
AFUE - Oil Boiler - Induced Draft;
AFUE - Oil Boiler - Natural Draft;
AFUE - Electric Resistance Heating - Electric Furnace;
AFUE - Electric Resistance Heating - Baseboard Furnace;
AFUE - Electric Resistance Heating - Electric Boiler;
EF - Gas - Standard Storage;
EF - Gas - ENERGY STAR Storage;
EF - Gas - Tankless/On-Demand;
EF - Oil - Standard Storage;
EF - Electric - Standard Storage;
EF - Electric - ENERGY STAR Storage (rare);
EF - Electric - Tankless/On-Demand;
EF - Electric - Heat Pump;

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Geothermal;;#PP2.HVAC Update;

DE394

1-Keep

What is the fuel used for the old HVAC system?

Input of EPA GGRF Calculator.

GAS; PROPANE; OIL; FURNACE OIL

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.HVAC Update;

DE395

1-Keep

Efficiency of New Water Heater System

Input of EPA GGRF Calculator.

Not applicable

Number

BTU/watt-hr

2-Project

3-Project-2-Energy Efficiency;#Water-Heater-Data

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE396

1-Keep

Efficiency Unit for Water Heater System being Replaced

Input of EPA GGRF Calculator.

EF – ELECTRIC; EF – GAS; EF – OIL

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency;#Water-Heater-Data

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE397

1-Keep

Efficiency Improvement of New Water Use Fixture

Input of EPA GGRF Calculator. A positive value indicates improved efficiency.

Not applicable

Percent

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE398

1-Keep

Do you have efficiency of old Water Heater System available?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-2-Energy Efficiency;#Water-Heater-Data

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE399

1-Keep

Efficiency of Old Water Heater System

Input of EPA GGRF Calculator.

Not applicable

Number

BTU/watt-hr

2-Project

3-Project-2-Energy Efficiency;#Water-Heater-Data

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE400

1-Keep

Average annual energy consumption of old water heater system

Input of EPA GGRF Calculator.

Not applicable

Number

6000

kilowatt-hours (kWh)

2-Project

3-Project-2-Energy Efficiency;#Water-Heater-Data

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE401

1-Keep

Old Water Heater System Model

Input of EPA GGRF Calculator.

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency;#Water-Heater-Data

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE402

1-Keep

What fuel is used in old water heater?

Input of EPA GGRF Calculator.

GAS; PROPANE; OIL

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency;#Water-Heater-Data

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Water Fixtures and Heat;

DE403

1-Keep

EER of the geothermal system

Input of EPA GGRF Calculator.

Not applicable

Number

BTU/watt-hr

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Geothermal;

DE404

1-Keep

Number of fridge units installed

Input of EPA GGRF Calculator.

Not applicable

Number

refrigerators

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Smart Fridge;

DE405

1-Keep

Electricity usuage of each fridge unit

Input of EPA GGRF Calculator.

Not applicable

Number

kilowatt-hours (kWh)

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Smart Fridge;

DE406

1-Keep

Do you have expected efficiency improvement from grid interactive system?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Grid Controlled HVAC;

DE407

1-Keep

What is the expected efficiency improvement from grid interactive system?

Input of EPA GGRF Calculator.

Not applicable

Percent

2-Project

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Grid Controlled HVAC;

DE408

1-Keep

Is the system heating, cooling, or both?

Input of EPA GGRF Calculator.

HEATING; COOLING; BOTH

Picklist

Not applicable

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Grid Controlled HVAC;

DE409

1-Keep

Will the building wall insulation R value be higher than 10 after retrofit?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Retrofit;

DE410

1-Keep

Does the building have an ENERGY STAR Target Score of 85 or higher?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-2-Energy Efficiency;#3-Project-2-Home Efficiency

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = BUILDINGS;

PP2.Retrofit;

DE411

1-Keep

What is the combined city/highway fuel efficiency of the onroad vehicle being replaced?

Input of EPA GGRF Calculator.

Not applicable

Number

miles per gallon

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Onroad Vehicle;

DE412

1-Keep

Do you know the annual miles driven per existing onroad vehicle being replaced?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

PP3.Onroad Vehicle;

DE413

1-Keep

Annual miles driven per vehicle

Input of EPA GGRF Calculator.

Not applicable

Number

mile

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Onroad Vehicle;

DE414

1-Keep

Will the existing onroad vehicles be destroyed or permanently removed from operation (by any owner); OR will the vehicles be resold for continued operational use?

Input of EPA GGRF Calculator.

RESOLD FOR CONTINUED OPERATION USE; DESTROYED OR PERMANENTLY REMOVED FROM OPERATION

Picklist

Not applicable

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Onroad Vehicle;

DE415

1-Keep

What is the new onroad vehicle model year

Input of EPA GGRF Calculator.

Not applicable

Number

Year

2019

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Onroad Vehicle;

DE416

1-Keep

Will a managed charging strategy be utilized for the new onroad vehicles?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Onroad Vehicle;

DE417

1-Keep

Are the replaced onroad vehicles a result of shared mobility (e.g., carsharing, ridesourcing, carpooling, bikesharing)?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Onroad Vehicle;

DE418

1-Keep

Will a dispatchable battery system be utilized (battery swapping) for the new onroad vehicles?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Onroad Vehicle;

DE419

1-Keep

What is the existing nonroad vehicle/equipment model year?

Input of EPA GGRF Calculator.

Not applicable

Number

Year

1955

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Nonroad Vehicle-Equipment;

DE420

1-Keep

How many nonroad vehicles/equipment of this type are being replaced?

Input of EPA GGRF Calculator.

Not applicable

Number

Quantity

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Nonroad Vehicle-Equipment;

DE421

1-Keep

What is the new nonroad vehicle/equipment rated horsepower?

Input of EPA GGRF Calculator.

Not applicable

Number

horsepower

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Nonroad Vehicle-Equipment;

DE422

1-Keep

What is the new nonroad vehicle/equipment model year?

Input of EPA GGRF Calculator.

Not applicable

Number

Year

2019

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Nonroad Vehicle-Equipment;

DE423

1-Keep

IF BEV, what is the primary location (ZIP Code) for charging?

Input of EPA GGRF Calculator.

Not applicable

Number

ZIP Code

99999

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE424

1-Keep

Will the existing nonroad vehicles/equipment be destroyed or permanently removed from operation (by any owner); OR will the vehicles be resold for continued operational use?

Input of EPA GGRF Calculator.

RESOLD FOR CONTINUED OPERATION USE; DESTROYED OR PERMANENTLY REMOVED FROM OPERATION

Picklist

Not applicable

2-Project

3-Project-3-Non-Road Equipment

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Nonroad Vehicle-Equipment;

DE425

1-Keep

Does the project include vehicle charging infrastructure, walkability/bikability infrastructure, or both?

Input of EPA GGRF Calculator.

CHARGING ONLY; WALKABILITY-BIKABILITY INFRASTRUCTURE; BOTH

Picklist

Not applicable

2-Project

3-Project-2-Building Details

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE426

1-Keep

Level 1 EVSE - Low Utilization

Enter the count of EVSE chargers for the charger type and utilization level (i.e. the charger's expected load factor). "Load factor" is expressed as a percentage or ratio of the actual number of kilowatt-hours (kWh) delivered or utilized in one year divided by the total possible kWh over one year.

Not applicable

Number

EV Chargers

1000

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE427

1-Keep

Level 1 EVSE - Moderate Utilization

Not applicable

Number

EV Chargers

1000

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE428

1-Keep

Level 1 EVSE - High Utilization

Not applicable

Number

EV Chargers

1000

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE429

1-Keep

Level 2 EVSE - Low Utilization

Not applicable

Number

EV Chargers

1000

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE430

1-Keep

Level 2 EVSE - Moderate Utilization

Not applicable

Number

EV Chargers

1000

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE431

1-Keep

Level 2 EVSE - High Utilization

Not applicable

Number

EV Chargers

1000

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE432

1-Keep

DCFC EVSE - Low Utilization

Input of EPA GGRF Calculator.

Not applicable

Number

Quantity

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE433

1-Keep

DCFC EVSE - Moderate Utilization

Input of EPA GGRF Calculator.

Not applicable

Number

Quantity

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE434

1-Keep

DCFC EVSE - High Utilization

Input of EPA GGRF Calculator.

Not applicable

Number

Quantity

2-Project

3-Project-3-Charging Infrastructure;#3-Project-3-On-Road Vehicles

1-GLIA (CCIA & NCIF)

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE435

1-Keep

Do you know the total annual emissions from all vehicles that are being replaced by walking and/or biking?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Micromobility

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE436

1-Keep

What are the total annual emissions from all vehicles that are being replaced by walking and/or biking?

Input of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

2-Project

3-Project-3-Micromobility

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE437

1-Keep

How many people are expected to shift from vehicle usage to walking and/or biking?

Input of EPA GGRF Calculator.

Not applicable

Number

Quantity

2-Project

3-Project-3-Micromobility

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE438

1-Keep

Do you know the average distance (miles/week/person) that would be covered by walking and/or biking instead of driving?

Input of EPA GGRF Calculator.

YES; NO

Boolean

Not applicable

2-Project

3-Project-3-Micromobility

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE439

1-Keep

What is the average distance (miles/week/person) that would be covered by walking and/or biking instead of driving?

Input of EPA GGRF Calculator.

Not applicable

Number

miles/week/person

2-Project

3-Project-3-Micromobility

0-ALL

Recipient

Conditionally optional if Project Type (DE076) = TRANSPORTATION;

PP3.Charging-Walk-Bike;

DE440

1-Keep

Transfer of existing unit annual emissions to new owner, CO2e

Output of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

3-Benefits

3-Project-3-On-Road Vehicles;#3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

GGRF

PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE441

1-Keep

Transfer of existing unit annual emissions to new owner, CO

Output of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

3-Benefits

3-Project-3-On-Road Vehicles;#3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

GGRF

PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE442

1-Keep

Transfer of existing unit annual emissions to new owner, NOx

Output of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

3-Benefits

3-Project-3-On-Road Vehicles;#3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

GGRF

PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE443

1-Keep

Transfer of existing unit annual emissions to new owner, PM10

Output of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

3-Benefits

3-Project-3-On-Road Vehicles;#3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

GGRF

PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE444

1-Keep

Transfer of existing unit annual emissions to new owner, PM2.5

Output of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

3-Benefits

3-Project-3-On-Road Vehicles;#3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

GGRF

PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE445

1-Keep

Transfer of existing unit annual emissions to new owner, VOC

Output of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

3-Benefits

3-Project-3-On-Road Vehicles;#3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

GGRF

PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE446

1-Keep

Transfer of existing unit annual emissions to new owner, SOx

Output of EPA GGRF Calculator.

Not applicable

Number

ton (metric)

3-Benefits

3-Project-3-On-Road Vehicles;#3-Project-3-Charging Infrastructure

1-GLIA (CCIA & NCIF)

Recipient

GGRF

PP3.Nonroad Vehicle-Equipment;;#PP3.Onroad Vehicle;

DE447

1-Keep

Old Building Type

Chose the best description of the old building type prior to reuse.

COMMERCIAL;
MIXEDUSE;
RESIDENTIALSINGLEFAMILY;
RESIDENTIALMULTIFAMILY;

Picklist

Not applicable

2-Project

3-Project-2-Building Details

0-ALL

Recipient

Conditionally required if Project type (DE076) is BUILDINGS and Project type detail (DE077) is ZERO-EMISSIONS RETROFITS else null

added for pp2 building reuse

GGRF

76;#76;#77;#77

Project Type;#76;#Project Type Detail;#77

PP2.Building Reuse;

DE448

1-Keep

Buying or Selling Financial Instrument

Choose whether the prime or subrecipient has bought ("BUY") or sold ("SELL") a financial instrument or instruments through the reported transaction record. This includes individual loans or loan portfolios (in asset or project finance) or equity (in corporate finance). If the prime or subrecipient has not bought or sold the instrument, but is holding the instrument or note, simply enter "NA".

BUY; SELL; NA

Picklist

Not applicable

1-Transaction

1-Transaction-Financial Product

0-ALL

Recipient

Conditionally required only if the loan, loan portfolio or equity stake is bought ("BUY") or sold ("SELL"). Otherwise, this field does not apply to any financial instrument or note if held by the prime or subrecipient (use "NA").

DE449

1-Keep

Factor 1 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

Factor 1 for Priority Project #2 (Buildings);#449;#Factor 2 for Priority Project #2 (Buildings);#450;#Factor 3 for Priority Project #2 (Buildings);#451;#Factor 4 for Priority Project #2 (Buildings);#452;#Factor 5 for Priority Project #2 (Buildings);#453;#Factor 6 for Priority Project #2 (Buildings);#454;#Factor 7 for Priority Project #2 (Buildings);#455;#Factor 8 for Priority Project #2 (Buildings);#456;#Factor 9 for Priority Project #2 (Buildings);#457;#Factor 10 for Priority Project #2 (Buildings);#458

DE450

1-Keep

Factor 2 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE451

1-Keep

Factor 3 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE452

1-Keep

Factor 4 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE453

1-Keep

Factor 5 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE454

1-Keep

Factor 6 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE455

1-Keep

Factor 7 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE456

1-Keep

Factor 8 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE457

1-Keep

Factor 9 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE458

1-Keep

Factor 10 for Priority Project #2 (Buildings)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

449;#449;#450;#450;#451;#451;#452;#452;#453;#453;#454;#454;#455;#455;#456;#456;#457;#457;#458;#458

DE459

1-Keep

Factor 1 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

Factor 1 for Priority Project #3 (Transportation);#459;#Factor 2 for Priority Project #3 (Transportation);#460;#Factor 3 for Priority Project #3 (Transportation);#461;#Factor 4 for Priority Project #3 (Transportation);#462;#Factor 5 for Priority Project #3 (Transportation);#463;#Factor 6 for Priority Project #3 (Transportation);#464;#Factor 7 for Priority Project #3 (Transportation);#465;#Factor 8 for Priority Project #3 (Transportation);#466;#Factor 9 for Priority Project #3 (Transportation);#467;#Factor 10 for Priority Project #3 (Transportation);#468

DE460

1-Keep

Factor 2 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE461

1-Keep

Factor 3 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE462

1-Keep

Factor 4 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE463

1-Keep

Factor 5 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE464

1-Keep

Factor 6 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE465

1-Keep

Factor 7 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE466

1-Keep

Factor 8 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE467

1-Keep

Factor 9 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

DE468

1-Keep

Factor 10 for Priority Project #3 (Transportation)

Placeholder for a factors-based approach for Household Savings and GHG Calculators.

Picklist

Not applicable

5-Project Site

GHGCalculatorFactors

1-GLIA (CCIA & NCIF)

Recipient

GGRF

459;#459;#460;#460;#461;#461;#462;#462;#463;#463;#464;#464;#465;#465;#466;#466;#467;#467;#468;#468

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