mydata-iowa-gov/state-of-iowa-checkbook-cyqb-8ina
Icon for Socrata external plugin
 
Readme
Updated 9 days ago
Indexed 3 hours ago

State of Iowa Checkbook

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
DescriptiondescriptiondescriptionTextA description of the type of expenditure such as travel, supplies, utilities, equipment, etc
Invoice Dateinvoice_dateinvoice_dateCalendar dateDate of invoice where available, otherwise same as payment date.
Payment Issue Datepayment_datepayment_dateCalendar dateDate payment was made to the vendor
Payment Numberpayment_idpayment_idTextUnique 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
Vendor Numbervendor_idvendor_idTextLists 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.
VendorvendorvendorTextName of vendor receiving the payment. Some data will be noted as "RESTRICTED" if removed from data for confidentiality purposes.
Expense Categoryexpense_categoryexpense_categoryTextExpense category assigned to the payment
ProgramprogramprogramTextThe organizational unit or program within a department associated with the payment
Appropriation Nameappropriation_nameappropriation_nameTextThe legislative authorization for the payment. Some payments are authorized by Iowa Code and do not require an appropriation.
Fund Namefund_namefund_nameTextThe source of funds used to make the payment
DepartmentdepartmentdepartmentTextName of department, institution or agency making the payment
ServiceserviceserviceTextService reference functions in the state budget, which represent groups of agencies that make expenditures for similar programs and purposes.
Fiscal Yearfiscal_yearfiscal_yearNumberIdentifies 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.
Record Numberrec_norec_noTextThis is the journal record number which is a unique ID for the record.
Invoice Numberinvoice_idinvoice_idTextInvoice number provided by the vendor where available. If invoice is not available, same as payment number.
Appropriation Codeappropriation_codeappropriation_codeTextThe code designating the legislative authorization for the payment. Some payments are authorized by Iowa Code and do not require an appropriation.
Fund Codefund_codefund_codeTextThe code designating the source of funds used to make the payment
Accounting Periodaccounting_periodaccounting_periodTextAccounting periods as reflected in the State's accounting system. Reflects hold-over periods for payments made after year end.
Fiscal Year Periodfiscal_year_periodfiscal_year_periodNumberReflects twelve periods with July being period 1 and June being period 12. Hold-over payments are reflected in period 12.
Invoice Line Numberinvoice_lineinvoice_lineNumberPlaceholder number
AmountamountamountNumberAmount of payment to the vendor
Invoice Line Distribution Numberinvoice_distribution_lineinvoice_distribution_lineNumberPlaceholder number
 
Preview
  • state_of_iowa_checkbook
     
Upstream Metadata