This filtered view contains payment transactions recorded in the State of Iowa’s central accounting system for the Iowa Utilities Board.
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. | 397552380 220247870 312560080 360617014 214312098 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. | 2024 2023 2022 2017 2016 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. | 1 6 12 2 4 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. | DECEMBER JUNE OCTOBER FEBRUARY JUNE +30 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. | ADMINISTRATION AND REGULATION view top 100 |
Department | department | text | Name of department, institution or agency making the payment | UTILITIES view top 100 |
Fund Code | fund_code | text | The code designating the source of funds used to make the payment | 0019 0426 0003 view top 100 |
Fund Name | fund_name | text | The source of funds used to make the payment | COMMERCE REVOLVING FUND DUAL PARTY RELAY SERVICE PASS THROUGH FUNDS RESEARCH 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. | P58 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. | UTILITIES DIVISION view top 100 |
Program | program | text | The organizational unit or program within a department associated with the payment | DUAL PARTY RELAY SERVICE SAFETY AND ENGINEERING UTILITIES BOARD REGULATORY LAW UTILITIES BOARD STAFF view top 100 |
Expense Category | expense_category | text | Expense category assigned to the payment | IN STATE TRAVEL AID TO INDIVIDUALS OUT OF STATE TRAVEL OFFICE SUPPLIES 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. | IOWA HEARING AID CENTERS TELTEX INC US BANK CARDMEMBER SERV JOHN E WELCHER DAVID A MCCANN 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. | 00002133347 00003083586 00003113809 00000021900 00002096899 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 | TP-219-219S2522601-1-0 TP-219-219J2403003-1-0 TP-219-219M2426801-1-0 TP-219-219J2403004-1-0 TP-219-219J2430603-1-0 view top 100 |
Payment Issue Date | payment_date | calendar_date | Date payment was made to the vendor | 2023-09-14T00:00:00.000 2023-04-03T00:00:00.000 2023-04-07T00:00:00.000 2023-10-02T00:00:00.000 2015-12-15T00: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. | TP-219-219S2522601-1-0 TP-219-219J2403003-1-0 TP-219-219J2403004-1-0 TP-219-219M2426801-1-0 TP-219-219J2430603-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. | 2023-04-07T00:00:00.000 2023-09-14T00:00:00.000 2023-04-03T00:00:00.000 2023-10-02T00:00:00.000 2015-12-15T00:00:00.000 view top 100 |
Amount | amount | number | Amount of payment to the vendor | 198.72 89.60 191.84 144.03 138.05 view top 100 |
Description | description | text | A description of the type of expenditure such as travel, supplies, utilities, equipment, etc | AID TO DEAF-SUPPLIES/EQUIPMENT FOOD - IN STATE LODGING - IN STATE FOOD - OUT OF STATE LODGING - OUT OF STATE view top 100 |