About this Dataset

Quick Action Closing Funds

The Oklahoma Quick Action Closing Fund can be expended by the Governor and is to be used for economic development and related infrastructure development when expenditure of funds is likely a determining factor in locating or retaining a high impact business location in Oklahoma. This important job creation tool will help Oklahoma recruit new businesses and retain existing businesses. Funds are appropriated by the Oklahoma Legislature and the Oklahoma Department of Commerce is responsible for the administration of the Oklahoma Quick Action Closing Fund.
Organization: State of Oklahoma
Last updated: 2021-08-07T15:00:00.719400
Tags: business, closing-funds, economic-development, job-creation, quick-action

Tables

Quick Action Closing Funds

@usgov.state_of_oklahoma_quick_action_closing_funds.quick_action_closing_funds

22.56 kB
4 rows
30 columns

CREATE TABLE quick_action_closing_funds (
  "business_unit" BIGINT,
  "ocp_agncy_name" VARCHAR,
  "name1" VARCHAR,
  "state" VARCHAR,
  "postal" VARCHAR,
  "to_char_a_effdt_dd_mon_yyyy" TIMESTAMP  -- TO CHAR(A.EFFDT,'DD-MON-YYYY'),
  "voucher_id" BIGINT,
  "voucher_style" VARCHAR,
  "descr1" VARCHAR,
  "voucher_id_related" VARCHAR,
  "invoice_id" VARCHAR,
  "to_char_a_invoice_dt_dd_mon_yyyy" TIMESTAMP  -- TO CHAR(A.INVOICE DT,'DD-MON-YYYY'),
  "transaction_type" VARCHAR,
  "to_char_a_pymnt_dt_dd_mon_yyyy" TIMESTAMP  -- TO CHAR(A.PYMNT DT,'DD-MON-YYYY'),
  "to_char_a_cancel_dt_dd_mon_yyyy" VARCHAR  -- TO CHAR(A.CANCEL DT,'DD-MON-YYYY'),
  "ocp_month" BIGINT,
  "fiscal_yr_tas" BIGINT,
  "to_char_a_ocp_ds_date_dd_mon_yyyy" TIMESTAMP  -- TO CHAR(A.OCP DS DATE,'DD-MON-YYYY'),
  "deptid" BIGINT,
  "deptid_descr" VARCHAR,
  "account" BIGINT,
  "account_descr" VARCHAR,
  "pymnt_amt" BIGINT,
  "city" VARCHAR,
  "fund_code" BIGINT,
  "fund_descr" VARCHAR,
  "class_fld" BIGINT,
  "class_descr" VARCHAR,
  "po_id" DOUBLE,
  "item_description" VARCHAR
);