ERA Programmatic Reporting_Updated 07092021.xlsx

Emergency Rental Assistance Program (ERA2)

ERA Programmatic Reporting_Updated 07092021.xlsx

OMB: 1505-0270

Document [xlsx]
Download: xlsx | pdf
Version: 2021.07.15
























Template Name: ERA Programatic Reporting
























Instructions to Reporter:
- Do not change the cell formatting
- Do not reformat the template
- All data should be as text
- Do not publish the "Field ID" row (Treasury Internal Use Only)
- Do not publish the "Dictionary ID" row (Treasury Internal Use Only)
- Questions which require a dollar value are located in Columns: J, U, V, W, X, Y, Z
- Questions that do not request a dollar value must provide a numeric value which is aligned to each of the 16 disaggregated categories in "Column B". Therefore, those questions will have 16 unique responses.























Dictionary ID: (Treasury Internal Use Only)

ERAI1 ERAI2 ERAI3 ERAI5 - Rent ERAI5 - Rental Arrears: ERAI5 - Utilities / Home Energy Bills: ERAI5 - Utilities / Home Energy Cost Arrears: ERAI5 - Other Expenses Related to Housing: ERAI5 - Housing Stability Services: ERAI6 ERAI7 ERAI8 ERAI9 ERAI10 ERAI11 ERAI13 ERAI14 ERAI15 ERAI16 ERAI17 ERAI18 ERAI19 ERAI20
Label Field Name Programmatic_Reporting_Type__c - picklist of all question names
Type_of_Assistance__c - Dependent Picklist for question: Number of unique households that received ERA assistance by type
Income_level__c - Dependent Picklist: Number of unique households at certain income levels
Number of unique households that completed and submitted an application for ERA assistance - Current Period Number of unique households that received ERA assistance of any kind - Current Period Number of unique households that received their initial ERA assistance in the current reporting period Number of unique households that received ERA assistance by type - Current Period

Assistance Type: Rent
Number of unique households that received ERA assistance by type - Current Period

Assistance Type: Rental Arrears
Number of unique households that received ERA assistance by type - Current Period

Assistance Type: Utilities/Home Engergy Bills
Number of unique households that received ERA assistance by type - Current Period

Assistance Type: Utilities/Home Energy Cost Arrears
Number of unique households that received ERA assistance by type - Current Period

Assistance Type: Other Expenses Related to Housing
Number of unique households that received ERA assistance by type - Current Period

Assistance Type: Housing Stability Services
Number of unique households that received any ERA assistance and has a household income level that is less than 30% AMI - Current Period Number of unique households that received any ERA assistance and has a household income level that is between 30 – 50% AMI - Current Period Number of unique households that received any ERA assistance and has a household income level that is between 50 – 80% AMI - Current Period Total number of recipient households whose income eligibility was determined based on their eligibility for other federal benefit programs - Current Period Total number of recipient households whose income eligibility was determined with a fact-based proxy - Current Quarter Total amount of ERA award paid to or for participating households - Current Quarter Average number of months of assistance provided by ERA rental payments (excluding arrears) - Current Quarter Average number of months of assistance provide by ERA utilities/home energy bills payments (excluding arrears) - Current Quarter Total dollar value of ERA Financial Assistance paid (expended) to or for participating households - Current Quarter Total dollar value of approved but unpaid (obligated) ERA Financial Assistance - Current Quarter Total dollar value of ERA Administrative Expenses paid (expended) to or for participating households - Current Quarter Total dollar value of approved but unpaid (obligated) ERA Administrative Expenses - Current Quarter Total dollar value of ERA Housing Stability Services paid (expended) to or for participating households - Current Quarter Total dollar value of approved but unpaid (obligated) ERA Housing Stability Services - Current Quarter
Required or Optional

Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required
Help Text

The number of unique households that submitted a complete application, as reasonably determined by the Recipient, for ERA assistance in the reporting period.

Note: the phrase “unique households” means that a household that received or applied for assistance more than once since the Recipient received the ERA award should only be counted one time for reporting purposes.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The number of unique households whose rent and/or utility/home energy payments were fully or partially paid by the ERA Recipient under the federal ERA program plus the number of households that received housing stability services administered by the ERA Recipient in the reporting period.





NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The sum of the number of unique participant households whose rent and/or utility/ home energy payments were fully or partially paid for the first time under the subject ERA award during the reporting period plus the number that only received housing stability services for the first time during the current reporting period.




NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The non-mutually exclusive number of unique households that received each type of assistance under the ERA program.

i.Rent: The number of unique participant households that were paid (or whose landlord was paid) at least one rent payment of any dollar amount under the subject ERA award in the reporting period; and cumulatively since the Recipient received the ERA award.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".






The non-mutually exclusive number of unique households that received each type of assistance under the ERA program.

ii.Rental Arrears (#): The number of unique participant households that were paid (or whose landlords were paid) a payment of any dollar amount for rental arrears under the subject ERA award in the reporting period and the cumulative number of unique households that have been paid rental arrears since the Recipient received the ERA award.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The non-mutually exclusive number of unique households that received each type of assistance under the ERA program.

iii.Utilities/Home Energy Bills (#): The number of unique participant households that were paid (or whose utility or home energy provider was paid) a payment of any dollar amount for any portion of at least one utility or home energy bill under the subject ERA award in the reporting period and the cumulative number of unique households that have been paid utility or home energy bills since the Recipient received its ERA award.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The non-mutually exclusive number of unique households that received each type of assistance under the ERA program.

iv.Utilities/Home Energy Costs Arrears (#): The number of unique participant households that were paid (or whose utility/energy provider was paid) a payment of any dollar amount for utility/home energy bill arrears under the subject ERA award in the reporting period and the cumulative number of unique households that have been paid utility/home energy bill arrears since the Recipient received the ERA award.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The non-mutually exclusive number of unique households that received each type of assistance under the ERA program.

v.Other Expenses Related to Housing (#): The number of unique participant households that were paid any dollar amount for other approved housing expenses (including eviction prevention/diversion) under the ERA award during the reporting period as identified in Treasury’s FAQ No. 7 at https://home.treasury.gov/system/files/136/ERA2FAQs%205-6-21.pdf.
Other housing expenses incurred due to Covid-19 does not include rent, rent arrears, utility or home energy costs and home energy costs arrears.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The non-mutually exclusive number of unique households that received each type of assistance under the ERA program.

vi.Housing Stability Services (#): The number of unique participant households that received any housing stability services provided under the ERA award: during the reporting period; and cumulatively, since the Recipient received the ERA award. This includes housing stability services provided directly by the Recipient or by any Subrecipients or Contractors.


NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The number of households with incomes was less than 30% of the area median income as defined by the US Department of Housing and Urban Development that received ERA program assistance in the reporting period.


NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The number of households with incomes of at least 30% but not greater than 50% of the area median income as defined by the US Department of Housing and Urban Development that received ERA program assistance in the reporting period.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The number of households that received ERA program assistance in the reporting period and whose income was more than 50% but less than 80% of the area median income as defined by the US Department of Housing and Urban Development.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
Total number of households that were deemed categorically eligible to receive ERA assistance based on prior enrollment in other income-based federal benefit programs.


NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
Total number of recipient households whose income eligibility was determined with one of the fact-based proxies described in the Program Overview.


NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The total dollar amount of ERA award funds paid under the ERA award to or for participating households during the reporting period including payments for Financial Assistance, such as rent, rental arrears, utility and home energy costs, utility and home energy cost arrears, other housing services and eligible expenses, and Housing Stability Services (including eviction prevention services).

Format is a numeric value. DO NOT include a "$" sign when entering the amount.
The total number of rental payments paid by the ERA Recipient to or for participating households during the reporting period. Count each month’s payment to the same household individually. Do not count payments for rental arrears.


NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The total number of utility/ home energy bill payments paid by the ERA Recipient to or for participating households during the reporting period. Count each month’s payment to the same household individually. Do not count payments for utility or home energy bill arrears.

NOTE: A numeric value is required for each disaggregated category in Column B. Enter the numeric value in the below cells which correspond to each category. For any categories that do not apply, please enter a value of "0".
The total dollar amount of ERA Financial Assistance, as defined in the ERA1 and ERA2 statutes, paid (expended) to or for participating households during the reporting period. The figure includes payments for rent; rental arrears; utility and home energy costs; utility and home energy cost arrears; and other housing expenses.

This does not include amounts paid for Administrative Costs or Housing Stability Services.

Format is a numeric value. DO NOT include a "$" sign when entering the amount
The total dollar amount of ERA Financial Assistance, as defined in the ERA1 and ERA2 statutes, approved but unpaid (obligated) to or for households during the reporting period. This figure includes payments for rent, rent arrears, utility and home energy bills, utility and home energy arrears, and other housing expenses.

This amount does not include amounts approved and expected to pay for Housing Stability Services.

Format is a numeric value. DO NOT include a "$" sign when entering the amount
The total dollar amount of ERA Administrative Expenses, as defined in the ERA1 and ERA2 statutes, paid (expended) to or for participating households during the reporting period. The figure includes payments for rent; rental arrears; utility and home energy costs; utility and home energy cost arrears; and other housing expenses.

This does not include amounts paid for Financial Assistance or Housing Stability Services.

Format is a numeric value. DO NOT include a "$" sign when entering the amount
The total dollar amount of ERA Administrative Expenses, as defined in the ERA1 and ERA2 statutes, approved but unpaid (obligated) to or for households during the reporting period. This figure includes payments for rent, rent arrears, utility and home energy bills, utility and home energy arrears, and other housing expenses.

This amount does not include amounts approved and expected to pay for Financial Assistance or Housing Stability Services.

Format is a numeric value. DO NOT include a "$" sign when entering the amount
The total dollar amount of ERA Housing Stability Services, as defined in the ERA1 and ERA2 statutes, paid (expended) to or for participating households for the reporting period. The figure includes payments for rent; rental arrears; utility and home energy costs; utility and home energy cost arrears; and other housing expenses.

This amount does not include amounts approved and expected to pay for Financial Assistance or Housing Stability Services.

Format is a numeric value. DO NOT include a "$" sign when entering the amount
The total dollar amount of ERA Housing Stability Services, as defined in the ERA1 and ERA2 statutes, approved but unpaid (obligated) to or for households during the reporting period. This figure includes payments for rent, rent arrears, utility and home energy bills, utility and home energy arrears, and other housing expenses.

This amount does not include amounts approved and expected to pay for Financial Assistance or Housing Stability Services.

Format is a numeric value. DO NOT include a "$" sign when entering the amount

NOTE: Enter dollar amounts in this row (without "$") for questions which request monetary values.
Those questions are located in Columns: J, U, V, W, X, Y, Z























Disaggregated Categories Field ID (Treasury Internal Use Only)






















Race American Indian or Alaska Native Race_American_Indian_or_Alaska_Native__c















Asian Race_Asian__c















Black or African American Race_Black_or_African_American__c















Native Hawaiian or Other Pacific Islander Race_Native_Hawaiian_Pacific_Islander__c















White Race_White__c















Declined to Answer Race_Declined_to_Answer__c















Data Not Collected Race_Data_Not_Collected__c















Ethnicity Hispanic or Latino Ethnicity_Hispanic_or_Latino__c















Not Hispanic or Latino Ethnicity_Not_Hispanic_or_Latino__c















Declined to Answer Ethnicity_Declined_to_Answer__c















Data Not Collected Ethnicity_Data_Not_Collected__c















Gender Male Gender_Male__c















Female Gender_Female__c















Non-binary Gender_Non_binary__c















Declined to Answer Gender_Declined_to_Answer__c















Data Not Collected Gender_Data_Not_Collected__c















File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy