Icon for Socrata external plugin
Updated 9 days ago
Indexed 1 hour ago

State of Iowa Consumer Fraud Refund Transactions

This dataset contains payment transactions recorded in the State of Iowa’s central accounting system for the Consumer Fraud Refunds fund.


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.
Invoice Numberinvoice_idinvoice_idTextInvoice number provided by the vendor where available. If invoice is not available, same as payment number.
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.
Accounting Periodaccounting_periodaccounting_periodTextAccounting periods as reflected in the State's accounting system. Reflects hold-over periods for payments made after year end.
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.
AmountamountamountNumberAmount of payment to the vendor
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.
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.
ServiceserviceserviceTextService reference functions in the state budget, which represent groups of agencies that make expenditures for similar programs and purposes.
Invoice Line Distribution Numberinvoice_distribution_lineinvoice_distribution_lineNumberPlaceholder number
Fund Namefund_namefund_nameTextThe source of funds used to make the payment
Fund Codefund_codefund_codeTextThe code designating the source of funds used to make the payment
Invoice Line Numberinvoice_lineinvoice_lineNumberPlaceholder number
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.
DepartmentdepartmentdepartmentTextName of department, institution or agency making the payment
  • state_of_iowa_consumer_fraud_refund_transactions
Upstream Metadata