About this Dataset

State Of Oklahoma Vendor Payments - Fiscal Year 2009

The vendor payment dataset contains payments made by state agencies and institutions of higher education that are processed through the Office of Management and Enterprise Services. These payments reflect disbursements from a state fund for the purchase of goods received, services performed, reimbursements, and payments to other governments. Travel reimbursements include the zip code of the State Capitol and not the individual’s address. For security and privacy reasons, payments related to “confidential matters” are included in the dataset; however, the payee name is replaced with “Protected Information” and the address is changed to the State Capitol address. Also, some state agencies are authorized to make payments outside of the Office of Management and Enterprise Services from certain authorized funds. In these cases, the agency reports only the total amount of the expenditures to the Office of Management and Enterprise Services but does not report the detailed vendor payment information. Therefore, these payment details are not included in the dataset.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:55:54.464920
Tags: 2009, fiscal-year, vendor-payments

Tables

State Of Oklahoma Vendor Payments FY2009 Q3

@usgov.state_of_oklahoma_state_of_oklahoma_vendor_payments_fi_9f14c1e9.state_of_oklahoma_vendor_payments_fy2009_q3

8.09 MB
311073 rows
29 columns


CREATE TABLE state_of_oklahoma_vendor_payments_fy2009_q3 (
  "business_unit" BIGINT,
  "ocp_agncy_name" VARCHAR,
  "name1" VARCHAR,
  "state" VARCHAR,
  "postal" VARCHAR,
  "to_char_a_effdt_dd_mon_yyyy" TIMESTAMP,
  "voucher_id" VARCHAR,
  "voucher_style" VARCHAR,
  "descr1" VARCHAR,
  "voucher_id_related" VARCHAR,
  "to_char_a_invoice_dt_dd_mon_yyyy" VARCHAR,
  "transaction_type" VARCHAR,
  "to_char_a_pymnt_dt_dd_mon_yyyy" TIMESTAMP,
  "to_char_a_cancel_dt_dd_mon_yyyy" TIMESTAMP,
  "ocp_month" BIGINT,
  "fiscal_yr_tas" BIGINT,
  "to_char_a_ocp_ds_date_dd_mon_yyyy" TIMESTAMP,
  "deptid" BIGINT,
  "deptid_descr" VARCHAR,
  "account" BIGINT,
  "account_descr" VARCHAR,
  "pymnt_amt" DOUBLE,
  "city" VARCHAR,
  "fund_code" BIGINT,
  "fund_descr" VARCHAR,
  "class_fld" BIGINT,
  "class_descr" VARCHAR,
  "po_id" VARCHAR,
  "item_description" VARCHAR
);