About this Dataset

Funding Summary - Fiscal Year 2022

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-04-28T05:07:42.300515

Tables

Funding 2022

@usgov.state_of_oklahoma_funding_summary_fiscal_year_2022.funding_2022

578.21 kB
74,236 rows
11 columns

CREATE TABLE funding_2022 (
  "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)
);