jcomeau1
commented
1 year ago Added to Input Template v20221106
For Not Started projects, only the following fields are available by each category. Note: [req] means required, [opt] means optional; the column letter appears in parenthesis. Also, if the response to a field triggers additional fields, they will appear as required, but are not listed below. EC 1 – Public Health [req] Project Name (C) [req] Project Identification Number (D) [req] Status of Completion (E) [req] Adopted Budget (F) [req] Total Cumulative Obligations (G) [req] Total Cumulative Expenditures (H) [req] Current Period Obligations (I) [req] Current Period Expenditures (J) [req] Project Description (K) [opt] Program Income Earned (L) [opt] Program Income Expended (M) [req] Does this project include a capital expenditure? (Z)
EC 2 – Negative Economic Impact [req] Project Name (C) [req] Project Identification Number (D) [req] Status of Completion (E) [req] Adopted Budget (F) [req] Total Cumulative Obligations (G) [req] Total Cumulative Expenditures (H) [req] Current Period Obligations (I) [req] Current Period Expenditures (J) [req] Project Description (K) [opt] Program Income Earned (L) [opt] Program Income Expended (M) [req] Does this project include a capital expenditure? (AC)
EC 3 – Public Sector Capacity [req] Project Name (C) [req] Project Identification Number (D) [req] Status of Completion (E) [req] Adopted Budget (F) [req] Total Cumulative Obligations (G) [req] Total Cumulative Expenditures (H) [req] Current Period Obligations (I) [req] Current Period Expenditures (J) [req] Project Description (K) [opt] Program Income Earned (L) [opt] Program Income Expended (M) [req] Does this project include a capital expenditure? (R)
EC 4 – Premium Pay & EC 5 – Infrastructure (5.1 - 5.18) [req] Project Name (C) [req] Project Identification Number (D) [req] Status of Completion (E) [req] Adopted Budget (F) [req] Total Cumulative Obligations (G) [req] Total Cumulative Expenditures (H) [req] Current Period Obligations (I) [req] Current Period Expenditures (J) [req] Project Description (K) [opt] Program Income Earned (L) [opt] Program Income Expended (M)
EC 5 – Infrastructure (5.19 - 5.21) [req] Project Name (C) [req] Project Identification Number (D) [req] Status of Completion (E) [req] Adopted Budget (F) [req] Total Cumulative Obligations (G) [req] Total Cumulative Expenditures (H) [req] Current Period Obligations (I) [req] Current Period Expenditures (J) [req] Project Description (K) [opt] Program Income Earned (L) [opt] Program Income Expended (M) [req] Projected/actual construction start date (N) [req] Projected/actual initiation of operations date (O) [req] Confirm that the project is designed to, upon completion, reliably meet or exceed symmetrical 100 Mbps download and upload speeds (AH) [req] Is project designed to provide service to households? (AM) [req] Technology Type Planned (AN) [req] Total Miles of Fiber Deployed Planned (AR) [req] Total Number of Funded Locations Served Planned (AT) [req] Planned Total Number of Funded Locations Served, broken out by speeds (Pre-SLFRF investment, Number receiving 25/3 Mbps or below) (AV) [req] Planned Total Number of Funded Locations Served, broken out by speeds (Pre-SLFRF investment, Number receiving between 25/3 Mbps and 100/20 Mbps) (AW) [req] Planned Total Number of Funded Locations Served, broken out by speeds (Post-SLFRF investment, Number receiving minimum 100/100 Mbps) (AZ) [req] Planned Total Number of Funded Locations Served, broken out by speeds (Post-SLFRF investment, Number receiving minimum 100/20 Mbps and scalable to minimum 100/100 Mbps) (BB) [req] Planned Total Number of Funded Locations Served, Residential (BD) [req] Planned Total Number of Funded Locations Served, Total Housing (BF) [req] Planned Total Number of Funded Locations Served, Business (BH) [req] Planned Total Number of Funded Locations Served, Community Anchor Institution (BJ)
EC 7 – Admin [req] Project Name (C) [req] Project Identification Number (D) [req] Status of Completion (E) [req] Adopted Budget (F) [req] Total Cumulative Obligations (G) [req] Total Cumulative Expenditures (H) [req] Current Period Obligations (I) [req] Current Period Expenditures (J) [req] Project Description (P) [opt] Program Income Earned (Q) [opt] Program Income Expended (R)
Add conditional logic for all expenditure categories to not show programmatic data for Not Started projects EXCEPT for EC 5.19 - 5.21 (broadband) which must always require planned programmatic data (Treasury User Guide, page 119).