| 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 Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |