| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Department Code | CORE Vendor Number | Subrecipient DUNS | Subrecipient UEI (replaces DUNS) | Subrecipient TIN | Reporting Quarter | Source Allocation | Project ID | Subaward Number | Expenditure Start Date | Expenditure End Date | Expenditure Amount | Obligation Amount | Subrecipient Subaward Date | Subrecipient Period of Performance - Start Date | Subrecipient Period of Performance - End Date | Subrecipient Subaward Type | Subrecipient Primary Sector | If, Other | Subaward Description | Subrecipient Purpose of funds | Subrecipient Primary Place of Performance Address Line 1 | Subrecipient Primary Place of Performance Address Line 2 | Subrecipient Primary Place of Performance Address Line 3 | Subrecipient Primary Place of Performance City Name | Subrecipient Primary Place of Performance State Code | Subrecipient Primary Place of Performance Zip | Subrecipient Primary Place of Performance Zip +4 Extension | Program Income Earned | Program Income Expended | Notes & Comments | Entity Type | Capital Expenditures Amount |
2 | Required | Conditionally Required for CORE users | Optional | Required | Required for non CORE users | Required | Required | Required | Required, 60 character max | Required | Required | Required | Required | Required for discrete subawards | Required for discrete subawards | Required for discrete subawards | Required for discrete subawards | Conditionally Required | Conditionally Required | Required for discrete subawards | Conditionally Required | Required for discrete subawards | Optional | Optional | Required for discrete subawards | Required for discrete subawards | Required for discrete subawards | Optional | Optional | Optional | Optional | Required | Requied for subawards with capital expenditures |
3 | Please enter the Subrecipient DUNS. The DUNS unique identification number for the Sub-Recipient. Format XXXXXXXXX, 9 numeric characters. | Please enter the Subrecipient UEI for Contracts or Subawards (CORE Encumbrance Doc). Format XXXXXXXXXXXX, 12 alpha-numeric characters. Individuals/Beneficiary = "Individuals" Revenue Replacement = "Revenue Replacement" Aggregate = "Aggregate" Refinance = "Refi" | The date the reporting quarter ended or the date of the impacted reporting quarter as applicable. Format MM/DD/YYYY | Enter SLFRF funding source. See Reference sheet for more details | Recipient Project ID assigned by OSC associated the reporting. Format XXX999, 6 alphanumeric characters. | Please enter Subaward Number from SLFRF-001 Report. Format CORE Doc, Department Code, CORE Doc ID-Project ID. For example: CTGG1,GAAA,202200002555-DIG020. If not above $50,000.00 then label as Aggregate in one of the following types: "Aggregate of Contracts Awarded for less than 50000" "Aggregate of Grants Awarded for less than 50000" "Aggregate of Loans Issued for less than 50000" "Aggregate of Transfers less than 50000" "Aggregate of Direct Payments less than 50000" "Individuals - Salaries" "Individuals - Scholarships" "Individuals - Other" "Revenue Replacement - Salaries" "Revenue Replacement - Scholarships" "Revenue Replacement - Other" "Refi - Salaries" "Refi - Scholarships" "Refi - Other" | Start date for the range of time when the expenditure(s) occurred, for expensese this quarter. Date Format MM/DD/YYYY | End date for the range of time when the expenditure(s) occurred this quarter. Date Format MM/DD/YYYY | Total amount of State Local Fiscal Recovery Funds dollars on the Sub-Award. Do not enter $ Sign when entering amount. | Obligation amount during this quarter for Aggregates /Individuals OR amount of SLFRF funds newly obligated / de-obligated this quarter by the Recipient to a SubRecipient under a given SubAward. DO NOT INCLUDE $ sign when entering amount. | The date the Recipient obligated funds to a SubRecipient. Date Format MM/DD/YYYY | The date on which efforts begin or the subaward is otherwise effective. Date Format MM/DD/YYYY | The date on which all effort is completed or the subaward is otherwise ended. Date Format MM/DD/YYYY | The type of subaward. "Contract: Purchase Order" "Contract: Delivery Order" "Contract: Blanket Purchase Agreement" "Contract: Definitive Contract" "Grant: Lump Sum Payment(s)" "Grant: Reimbursable" "Direct Payment" "Transfer: Lump Sum Payment(s)" "Transfer: Reimbursable" "Loan - maturity prior to 12/31/26 with planned forgiveness" "Loan - maturity prior to 12/31/26 without planned forgiveness" "Loan - maturity past 12/31/26 with planned forgiveness" "Loan - maturity past 12/31/26 without planned forgiveness" "Interagency Agreement (IAA)" | Applicable to Expenditure Categories 1.10, 2.35 and 2.36, optional for others. Valid entries for Primary Sector. Copy and paste the entry minus the quoatations (" "). "any work performed by an employee of a State local or Tribal government" "behavioral health work" "biomedical research" "dental care work" "educational work school nutrition work and other work required to operate a school facility" "elections work" "emergency response" "family or child care" "grocery stores restaurants food production and food delivery" "health care" "home- and community-based health care or assistance with activities of daily living" "laundry work" "maintenance work" "medical testing and diagnostics" "pharmacy" "public health work" "sanitation disinfection and cleaning work" "social services work" "solid waste or hazardous materials management response and cleanup work" "transportation and warehousing" "vital services to Tribes" "production and food delivery" "work at hotel and commercial lodging facilities that are used for COVID-19 mitigation and containment" "work in a mortuary" "work in critical clinical research development and testing necessary for COVID-19 response" "work requiring physical interaction with patients " "Other" | Explanation if Primary Sector is "Other". Max Characters 100. | A description of the overall purpose and expected outputs and outcomes or results of the funded subaward, including significant deliverables and, if appropriate, associated units of measure. The purpose and outcomes or results should be stated in terms that allow an understanding that the subaward constitutes an eligible use of funds. Max Characters 750. | Required for all Discrete, otherwise Optional | United States Postal Service (USPS) twoletter abbreviation for the state or territory indicating where the predominant performance of the subaward will be accomplished. Valid responses: (AL, AK, AS, AZ, AR, CA, CO, CT, DE, DC, FM, FL, GA, GU, HI, ID, IL, IN, IA, KS, KY, LA, ME, MH, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, MP, OH, OK, OR, PW, PA, PR, RI, SC, SD, TN, TX, UT, VT, VI, VA, WA, WV, WI, WY) | United States ZIP code (five digits) identifying where the predominant performance of the subaward will be accomplished. Format XXXXX, 5 numeric characters. | Zip Plus4 (four digits) identifying where the predominant performance of the subaward will be accomplished. Format XXXX, 4 numeric characters. | Enter the amount of program income earned. Currency field with max 12 characters, 2 decimals. DO NOT include a "$" sign or commas "," when entering amounts. Cannot be a negative value. | Enter the amount of program income that was used to cover eligible project costs. Currency field with max 12 characters, 2 decimals. DO NOT include a "$" sign or commas "," when entering amounts. Cannot be a negative value. | Required to indicate criteria under with Interagency Agreement is valid (1, 2 or 3) Required to indicate confirmation that a legal agreement to a vendor(s) in a specific amount is the basis for the GAE. Agency notes can also be added in this field. | The type of entity for this subaward or direct payment. Select one of the following: "Subrecipient" "Contractor" "Beneficiary" "Interagency Agreement (IAA)" "Individuals" "Revenue Replacement" "Aggregate" | Optional: Enter the amount of captial expenditures by subaward number. If none, enter 0 (zero). Currency field with max 12 characters, 2 decimals. DO NOT include a "$" sign or commas "," when entering amounts. | |||||||
4 | |||||||||||||||||||||||||||||||||
5 | |||||||||||||||||||||||||||||||||
6 | |||||||||||||||||||||||||||||||||
7 | |||||||||||||||||||||||||||||||||
8 | |||||||||||||||||||||||||||||||||
9 | |||||||||||||||||||||||||||||||||
10 | |||||||||||||||||||||||||||||||||
11 | |||||||||||||||||||||||||||||||||
12 | |||||||||||||||||||||||||||||||||
13 | |||||||||||||||||||||||||||||||||
14 | |||||||||||||||||||||||||||||||||
15 | |||||||||||||||||||||||||||||||||
16 | |||||||||||||||||||||||||||||||||
17 | |||||||||||||||||||||||||||||||||
18 | |||||||||||||||||||||||||||||||||
19 | |||||||||||||||||||||||||||||||||
20 | |||||||||||||||||||||||||||||||||
21 | |||||||||||||||||||||||||||||||||
22 | |||||||||||||||||||||||||||||||||
23 | |||||||||||||||||||||||||||||||||
24 | |||||||||||||||||||||||||||||||||
25 | |||||||||||||||||||||||||||||||||
26 | |||||||||||||||||||||||||||||||||
27 | |||||||||||||||||||||||||||||||||
28 | |||||||||||||||||||||||||||||||||
29 | |||||||||||||||||||||||||||||||||
30 | |||||||||||||||||||||||||||||||||
31 | |||||||||||||||||||||||||||||||||
32 | |||||||||||||||||||||||||||||||||
33 | |||||||||||||||||||||||||||||||||
34 | |||||||||||||||||||||||||||||||||
35 | |||||||||||||||||||||||||||||||||
36 | |||||||||||||||||||||||||||||||||
37 | |||||||||||||||||||||||||||||||||
38 | |||||||||||||||||||||||||||||||||
39 | |||||||||||||||||||||||||||||||||
40 | |||||||||||||||||||||||||||||||||
41 | |||||||||||||||||||||||||||||||||
42 | |||||||||||||||||||||||||||||||||
43 | |||||||||||||||||||||||||||||||||
44 | |||||||||||||||||||||||||||||||||
45 | |||||||||||||||||||||||||||||||||
46 | |||||||||||||||||||||||||||||||||
47 | |||||||||||||||||||||||||||||||||
48 | |||||||||||||||||||||||||||||||||
49 | |||||||||||||||||||||||||||||||||
50 | |||||||||||||||||||||||||||||||||
51 | |||||||||||||||||||||||||||||||||
52 | |||||||||||||||||||||||||||||||||
53 | |||||||||||||||||||||||||||||||||
54 | |||||||||||||||||||||||||||||||||
55 | |||||||||||||||||||||||||||||||||
56 | |||||||||||||||||||||||||||||||||
57 | |||||||||||||||||||||||||||||||||
58 | |||||||||||||||||||||||||||||||||
59 | |||||||||||||||||||||||||||||||||
60 | |||||||||||||||||||||||||||||||||
61 | |||||||||||||||||||||||||||||||||
62 | |||||||||||||||||||||||||||||||||
63 | |||||||||||||||||||||||||||||||||
64 | |||||||||||||||||||||||||||||||||
65 | |||||||||||||||||||||||||||||||||
66 | |||||||||||||||||||||||||||||||||
67 | |||||||||||||||||||||||||||||||||
68 | |||||||||||||||||||||||||||||||||
69 | |||||||||||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||||||||
71 | |||||||||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||||||||
73 | |||||||||||||||||||||||||||||||||
74 | |||||||||||||||||||||||||||||||||
75 | |||||||||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||||||||
78 | |||||||||||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||||||||
100 |