mydata-iowa-gov/iowa-pandemic-recovery-reporting-payments-to-cgm6-jbzf

 
External

Iowa Pandemic Recovery Reporting: Payments to Non-State Organizations

  • cares act
  • covid-19
  • pandemic
  • recovery
  • vendor payments

Iowa Pandemic Recovery Reporting: Payments to Non-State Organizations

This dataset provides information on payments to non-state organizations made by the State of Iowa using funds from 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
Record IDrecord_idrecord_idTextJournal record number from the State Accounting System, or other unique identifier created for the record.
State Department Numberstate_dept_nostate_dept_noTextThe three digit code used to designate the department associated with the payment (e.g., 413).
State Departmentstate_departmentstate_departmentTextName of the State Department making the payment.
UnitunitunitTextThe four digit code used to designate the organizational unit within the department associated with the payment.
Unit Nameunit_nameunit_nameTextThe name of the organizational unit within the department associated with the payment.
Fund Codefund_codefund_codeTextThe four digit code designating the fund expenses were paid from.
FundfundfundTextThe name of the fund where payment was made.
Object Class Nameobject_class_nameobject_class_nameTextA description of the type of expenditure.
Object Classobject_classobject_classTextThe three digit code used in the state accounting system to designate the type of expenditure.
Iowa Regional Zip Codes:@computed_region_g8ff_h7ce:@computed_region_g8ff_h7ceNumber
County Boundaries of Iowa:@computed_region_y683_txed:@computed_region_y683_txedNumber
Rating Areas for Iowa Individual Affordable Care Act Premiums:@computed_region_hhz5_dst4:@computed_region_hhz5_dst4Number
Vendor Numbervendor_numbervendor_numberTextUnique identifier used in the State Accounting System for the vendor.
Legal Namevendor_legalvendor_legalTextLegal name for the organization.
Doing Business Asvendor_dbavendor_dbaTextName organization is doing business as.
Zipvendor_zipvendor_zipTextZip code associated with the physical address of the organization.
Payment Issue Datepayment_issue_datepayment_issue_dateCalendar dateDate payment was made.
Locationgeocoded_columngeocoded_columnPointGeocoded location is based on the city, state and zip.
PaymentamountamountNumberAmount paid to the organization.
Statevendor_statevendor_stateTextState associated with the physical address of the organization.
Federal Departmentfederal_departmentfederal_departmentTextName of the Federal Department who awarded the federal funds associated with the payment.
Budget FYbudget_fybudget_fyNumberThe four digit budget fiscal year (July 1 - June 30 + holdover) associated with the payment.
Cityvendor_cityvendor_cityTextCity associated with the physical address of the organization.
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.
Fiscal Periodfiscal_periodfiscal_periodNumberTwo digit fiscal period associated with the payment (i.e., 1-15).
Federal Program Titlefederal_program_titlefederal_program_titleTextName of the Federal program that provided the federal funds that supported the payment.
Federal Agencyfederal_agencyfederal_agencyTextName of the Federal Agency responsible for overseeing the Federal funds associated with this payment.
Vendor IDvendor_idvendor_idTextField is a concatenation of the vendor number and vendor legal name without spaces.

Upstream Metadata