This dataset contains payment transactions recorded in the State’s central accounting system. Please visit Iowa's Open Checkbook at http://checkbook.iowa.gov to explore this dataset more extensively.
This dataset has the following 22 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Record Number | rec_no | text | This is the journal record number which is a unique ID for the record. | 303358662 405022564 392971910 209993644 236697868 view top 100 |
Fiscal Year | fiscal_year | number | Identifies the fiscal year (July 1 - June 30, numbered for the calendar year it ends) the payment was assigned. The fiscal year includes a hold-over period for payments made after year end for good and services received on or before June 30. | 2015 2023 2016 2024 2017 view top 100 |
Fiscal Year Period | fiscal_year_period | number | Reflects twelve periods with July being period 1 and June being period 12. Hold-over payments are reflected in period 12. | 2 5 4 12 11 view top 100 |
Accounting Period | accounting_period | text | Accounting periods as reflected in the State's accounting system. Reflects hold-over periods for payments made after year end. | NOVEMBER OCTOBER MAY DECEMBER JUNE view top 100 |
Service | service | text | Service reference functions in the state budget, which represent groups of agencies that make expenditures for similar programs and purposes. | HUMAN SERVICES view top 100 |
Department | department | text | Name of department, institution or agency making the payment | IOWA DEPARTMENT ON AGING view top 100 |
Fund Code | fund_code | text | The code designating the source of funds used to make the payment | 0001 view top 100 |
Fund Name | fund_name | text | The source of funds used to make the payment | GENERAL FUND view top 100 |
Appropriation Code | appropriation_code | text | The code designating the legislative authorization for the payment. Some payments are authorized by Iowa Code and do not require an appropriation. | J42 J43 J44 view top 100 |
Appropriation Name | appropriation_name | text | The legislative authorization for the payment. Some payments are authorized by Iowa Code and do not require an appropriation. | AGING PROGRAMS OFFICE OF LONG-TERM CARE OMBUDSMAN OFFICE OF LONG-TERM CARE RESIDENT'S ADVOCATE FOOD SECURITY FOR OLDER INDIVIDUALS view top 100 |
Program | program | text | The organizational unit or program within a department associated with the payment | SUA SUPPORTIVE SERVICES LTC OMBUDSMAN SUA HEALTHY AGING RETIRED SENIOR VOLUNTEER PROGRAM AGING/DISABILITY RESOURCE CENTER view top 100 |
Expense Category | expense_category | text | Expense category assigned to the payment | STATE AID IN STATE TRAVEL OFFICE SUPPLIES OUT OF STATE TRAVEL OUTSIDE SERVICES view top 100 |
Vendor | vendor | text | Name of vendor receiving the payment. Some data will be noted as "RESTRICTED" if removed from data for confidentiality purposes. | US BANK CARDMEMBER SERV INSIGHT PUBLIC SECTOR NORTHEAST IOWA AREA AGENCY ON AGING CONNECTIONS AREA AGENCY ON AGING INC AGING RESOURCES OF CENTRAL IOWA view top 100 |
Vendor Number | vendor_id | text | Lists number assigned to vendor. Data removed for confidentiality purposes will be noted as "RESTRICTED" and the vendor number for state employees have been altered to remove the portion of the vendor number based on their Social Security Number. | 00003018109 00002100702 00002137237 00002114088 00002115045 view top 100 |
Payment Number | payment_id | text | Unique code for the payment based on a concatenation of the doc code, dept number, doc ID, vendor line number and commodity line number from the accounting system | PRC-297-297WD16063001-1-1 PRC-297-297WD15092001-1-1 PRC-297-297WD16154001-1-1 PRC-297-297WD15063001-1-1 PRC-297-297WD16056002-1-1 view top 100 |
Payment Issue Date | payment_date | calendar_date | Date payment was made to the vendor | 2015-08-28T00:00:00.000 2015-03-10T00:00:00.000 2015-12-08T00:00:00.000 2023-10-10T00:00:00.000 2015-05-08T00:00:00.000 view top 100 |
Invoice Number | invoice_id | text | Invoice number provided by the vendor where available. If invoice is not available, same as payment number. | PRC-297-297WD16063001-1-1 PRC-297-297WD15092001-1-1 PRC-297-297WD16056002-1-1 PRC-297-297WD15063001-1-1 PRC-297-297WD16154001-1-1 view top 100 |
Invoice Line Number | invoice_line | number | Placeholder number | 1 2 3 4 5 view top 100 |
Invoice Line Distribution Number | invoice_distribution_line | number | Placeholder number | 1 view top 100 |
Invoice Date | invoice_date | calendar_date | Date of invoice where available, otherwise same as payment date. | 2015-08-28T00:00:00.000 2015-03-10T00:00:00.000 2015-12-08T00:00:00.000 2015-05-08T00:00:00.000 2015-07-28T00:00:00.000 view top 100 |
Amount | amount | number | Amount of payment to the vendor | 10.33 36.49 8 61.6 10 view top 100 |
Description | description | text | A description of the type of expenditure such as travel, supplies, utilities, equipment, etc | FEDERAL PASS THROUGH OTHER OFFICE SUPPLIES CURRENT PERS MILEAGE RATE - IN-STATE SUB GRANT PYMT-PASS THRU FUNDS STATE AID view top 100 |