mydata-iowa-gov/iowa-pandemic-recovery-reporting-state-receipts-gw42-bpv2

  • cares act
  • coronavirus
  • covid-19
  • pandemic
  • recovery
  • + 1

Iowa Pandemic Recovery Reporting: State Receipts

Iowa Pandemic Recovery Reporting: State Receipts

This dataset provides information on receipts associated with Federal Awards considered covered funds under Section 15011 of the Coronavirus Aid, Relief, and Economic Security (CARES) Act. Covered funds are federal funds appropriated through one of the following: The Coronavirus Preparedness and Response Supplemental Appropriations Act, 2020 (Public Law 116-123); The Families First Coronavirus Response Act (Public Law 116-127); The Coronavirus Aid, Relief, and Economic Security Act (Public Law 116-136); The Paycheck Protection Program and Health Care Enhancement Act (Public Law 116-139); The Consolidated Appropriations Act, 2021 (Public Law 116-260); or The American Rescue Plan Act, 2021 (Public Law 117-2).

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Letter of Creditletter_of_creditletter_of_creditTextThis is the Letter of Credit value associated with the PPC code in the state accounting system that is unique to the federal award.
Unit Nameunit_nameunit_nameTextThe name of the organizational unit within the department that received the funds
Federal Program Titlefederal_program_titlefederal_program_titleTextName of the Federal program for which the federal funds were awarded.
Fiscal Periodfiscal_periodfiscal_periodNumberTwo digit fiscal period the funding was received (e.g., 01-15).
Record Daterecord_daterecord_dateCalendar dateEnding date for the reported period
State Departmentstate_departmentstate_departmentTextName of the State Department receiving the federal funds.
State Department Numberstate_dept_nostate_dept_noTextThe three digit code used to designate the department receiving the funds).
Federal Departmentfederal_departmentfederal_departmentTextName of the Federal Department awarding the Federal funds.
Budget FYbudget_fybudget_fyNumberThe four digit budget fiscal year (July 1 - June 30 + holdover) funding was received
FundfundfundTextThe name of the fund where receipts were deposited
Federal Agencyfederal_agencyfederal_agencyTextName of the Federal Agency overseeing the Federal funds awarded.
Fund Codefund_codefund_codeTextThe four digit code designating the fund where receipts were deposited
UnitunitunitTextThe four digit code used to designate the organizational unit within the department that received the fund
Record IDrecord_idrecord_idTextUnique identifier for the record; concatenation of budget_fy, fiscal_period, department_number, unit, letter_of_credit, fund_code, revenue_class, and record_date (YYYYMMDD format) with a dash (“-”) in between.
AmountamountamountNumberAggregate total for the budget fy, fiscal period, department number, unit, line of credit, fund code, and revenue class.
Revenue Class Namerevenue_class_namerevenue_class_nameTextName for the revenue class
Revenue Classrevenue_classrevenue_classTextThe code used to designate the type of revenue

Upstream Metadata