About this Dataset

Funding Summary - Fiscal Year 2021

The Funding dataset provides information for the current fiscal year (to-date) and the three prior fiscal years. The funding information is first presented by high-level funding categories including: •Assets Held for Others •Taxes and Interest Income •Licenses, Permits, Tuition, Fees and Other •Federal Grants •Appropriations Each Funding category (class) may be further viewed by sub-class and detail funding type.
Organization: State of Oklahoma
Last updated: 2022-02-14T23:35:25.579362

Tables

Funding2021

@usgov.state_of_oklahoma_funding_summary_fiscal_year_2021.funding2021

232.86 kB
18,938 rows
11 columns

CREATE TABLE funding2021 (
  "business_unit" BIGINT,
  "ocp_agncy_name" VARCHAR,
  "major_class" BIGINT,
  "descr" VARCHAR,
  "sub_class" BIGINT,
  "upper_c_descr" VARCHAR  -- UPPER(C.DESCR),
  "account" BIGINT,
  "upper_b_descr" VARCHAR  -- UPPER(B.DESCR),
  "fiscal_year" BIGINT,
  "accounting_period" BIGINT,
  "sum_a_posted_total_amt" DOUBLE  -- SUM(A.POSTED TOTAL AMT)
);