About this Dataset

Funding Summary - Fiscal Year 2019

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-22T00:42:55.758712
Tags: 2019, funding-summary

Tables

Data - Funding Summary - Fiscal Year 2019

@usgov.state_of_oklahoma_funding_summary_fiscal_year_2019.data_funding_summary_fiscal_year_2019

197.55 kB
20,376 rows
11 columns

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