About this Dataset

State Of Oklahoma Vendor Payments - Fiscal Year 2022

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: 2022-02-14T23:35:25.199772

Tables

Vendor Public 202112

@usgov.state_of_oklahoma_state_of_oklahoma_vendor_payments_fi_a8eb7e96.vendor_public_202112

3.18 MB
200,000 rows
51 columns

CREATE TABLE vendor_public_202112 (
  "agency_number" DOUBLE,
  "agency_description" VARCHAR,
  "calendar_year" DOUBLE,
  "calendar_month" DOUBLE,
  "vendor_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal" VARCHAR,
  "effective_date" TIMESTAMP,
  "voucher_id" DOUBLE,
  "voucher_style" VARCHAR,
  "voucher_style_description" VARCHAR,
  "voucher_id_related" DOUBLE,
  "invoice_date" VARCHAR,
  "transaction_type" VARCHAR,
  "payment_amount" DOUBLE,
  "payment_date" TIMESTAMP,
  "cancellation_date" TIMESTAMP,
  "fund_code" DOUBLE,
  "fund_description" VARCHAR,
  "class_funding_code" VARCHAR,
  "class_fund_description" VARCHAR,
  "department_code" VARCHAR,
  "dept_description" VARCHAR,
  "account" DOUBLE,
  "account_description" VARCHAR,
  "operating_unit" VARCHAR,
  "op_unit_description" VARCHAR,
  "sub_account" VARCHAR,
  "sub_account_description" VARCHAR,
  "program_code" VARCHAR,
  "program_description" VARCHAR,
  "budget_ref" VARCHAR,
  "cfda_code" VARCHAR,
  "cfda_descr" VARCHAR,
  "cf2_code" VARCHAR,
  "cf2_name" VARCHAR,
  "project_id" VARCHAR,
  "proj_descr" VARCHAR,
  "activity" VARCHAR,
  "activity_descr" VARCHAR  -- Activity Descr.,
  "resource_type" VARCHAR,
  "resource_descr" VARCHAR  -- Resource Descr.,
  "resource_category" VARCHAR,
  "resource_category_descr" VARCHAR  -- Resource Category Descr.,
  "resource_sub_category" VARCHAR,
  "sub_category_descr" VARCHAR,
  "po_id" DOUBLE,
  "item_description" VARCHAR,
  "ocp_ds_date" TIMESTAMP,
  "row_id" VARCHAR
);