This dataset contains payment transactions recorded in the State of Iowa’s central accounting system for the Executive Branch. 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. | 264280616 264337694 264337696 264337702 264337704 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. | 2018 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. | 3 5 11 9 7 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. | SEPTEMBER NOVEMBER MAY MARCH JANUARY 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. | EDUCATION ADMINISTRATION AND REGULATION HUMAN SERVICES JUSTICE SYSTEM TRANSPORTATION view top 100 |
Department | department | text | Name of department, institution or agency making the payment | EDUCATION, VOC REHAB REVENUE TRANSPORTATION, DEPT OF TREASURER OF STATE HUMAN SERVICES COMMUNITY SERV view top 100 |
Fund Code | fund_code | text | The code designating the source of funds used to make the payment | 0394 0001 0137 0815 0811 view top 100 |
Fund Name | fund_name | text | The source of funds used to make the payment | DISABILITY DETERMINATION-SSA GENERAL FUND PRIMARY ROAD FUND LOCAL SALES & SERV TAX FUND STREET CONSTR FUND CITIES 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. | M12 A24 S44 K11 K19 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. | CHILD SUPPORT RECOVERIES HIGHWAY DIVISION COUNTY CONFINEMENT ESSENTIAL PUBLIC HEALTH SERVICES PUBLIC PROTECTION view top 100 |
Program | program | text | The organizational unit or program within a department associated with the payment | SSA DISABILITY MEDICAL COSTS PRIMARY ROAD ROAD FUND SAVE-LOCAL OPTION SALES TAX-CITIES & COUNTIES STREET CONSTR. FUND CITIES SECONDARY ROAD FUND COUNTIES view top 100 |
Expense Category | expense_category | text | Expense category assigned to the payment | AID TO INDIVIDUALS OUTSIDE SERVICES STATE AID REFUNDS-OTHER OTHER EXPENSES & OBLIGATIONS 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. | HAMILTON COUNTY HOSPITAL HAMILTON COUNTY HAMILTON CO SHERIFF HAMILTON COUNTY BOARD OF HEALTH HAMILTON COUNTY OF 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. | 00003018884 00002130860 00002130861 00002111643 00002130866 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 | GAX-645-6452018046995735-1-0 GAX-283-D180300038-1-0 GAX-283-D180680082-1-0 GAX-283-D171940120-1-0 GAX-283-D180520085-1-0 view top 100 |
Payment Issue Date | payment_date | calendar_date | Date payment was made to the vendor | 2017-09-06T00:00:00.000 2018-03-09T00:00:00.000 2018-01-30T00:00:00.000 2017-11-27T00:00:00.000 2017-07-13T00: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. | GAX-645-6452018046995735-1-0 GAX-283-D180300038-1-0 GAX-283-D180680082-1-0 GAX-283-D171940120-1-0 GAX-283-D180520085-1-0 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. | 2017-09-06T00:00:00.000 2018-01-30T00:00:00.000 2018-03-09T00:00:00.000 2017-11-27T00:00:00.000 2017-07-13T00:00:00.000 view top 100 |
Amount | amount | number | Amount of payment to the vendor | 35 40 20 200 10.25 view top 100 |
Description | description | text | A description of the type of expenditure such as travel, supplies, utilities, equipment, etc | REHAB AID 3RD PARTY NONMED SER REFUND STATE AID REAL ESTATE TAXES SHERIFF FEES view top 100 |