About this Dataset

Funding Summary - Fiscal Year 2020

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: 2021-08-07T14:55:57.026124

Tables

Funding Summary Fiscal Year 2020

@usgov.state_of_oklahoma_funding_summary_fiscal_year_2020_b7260.funding_summary_fiscal_year_2020

249.12 kB
19,699 rows
11 columns

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