About this Dataset

Expenditure Summary

Provides expenditure data summarized by each agency and general ledger account. The general ledger account may be viewed by major class, sub-class or detail expenditure code. Examples of the major class expenditure category include:

Personal Services
Travel Expenses
Administrative Expense
Property, Furniture, Equipment and Related Debt
General Assistance, Awards, Grants, & Other
Program-Directed Payments
Transfers and Other Disbursements
Organization: State of Oklahoma
Last updated: 2021-08-07T14:56:01.168913
Tags: 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, expenditure-summary, expenses, fiscal-year

Tables

Data - Expenditure Summary - Fiscal Year 2009

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2009

1.02 MB
110,385 rows
11 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2009 (
  "agency" BIGINT,
  "ocp_agncy_name" VARCHAR,
  "account_major_class" BIGINT  -- Account - Major Class,
  "account_description_major_class" VARCHAR  -- Account Description - Major Class,
  "account_sub_class" BIGINT  -- Account - Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description - Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period" BIGINT,
  "amount" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2010

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2010

995.46 kB
108,022 rows
11 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2010 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account - Major Class,
  "account_description_major_class" VARCHAR  -- Account Description - Major Class,
  "account_sub_class" BIGINT  -- Account - Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description - Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period" BIGINT,
  "amount" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2011

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2011

816.44 kB
87,007 rows
11 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2011 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account - Major Class,
  "account_description_major_class" VARCHAR  -- Account Description - Major Class,
  "account_sub_class" BIGINT  -- Account - Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description - Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period" BIGINT,
  "amount" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2012

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2012

1.08 MB
115,202 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2012 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account - Major Class,
  "account_description_major_class" VARCHAR  -- Account Description - Major Class,
  "account_sub_class" BIGINT  -- Account - Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description - Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period" BIGINT,
  "amount" VARCHAR,
  "fund" VARCHAR,
  "fund_code_description" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2013

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2013

1.08 MB
113,461 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2013 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account - Major Class,
  "account_description_major_class" VARCHAR  -- Account Description - Major Class,
  "account_sub_class" BIGINT  -- Account - Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description - Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period_month" BIGINT  -- Accounting Period (Month),
  "amount" VARCHAR,
  "fund" VARCHAR,
  "fund_code_description" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2014

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2014

1.09 MB
115,957 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2014 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account- Major Class,
  "account_description_major_class" VARCHAR  -- Account Description- Major Class,
  "account_sub_class" BIGINT  -- Account- Sub Class,
  "account_description_sub_class" VARCHAR  -- Account Description- Sub Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period" BIGINT,
  "amount" VARCHAR,
  "fund" VARCHAR,
  "fund_code_description" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2015

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2015

1.06 MB
114,372 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2015 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account- Major Class,
  "account_description_major_class" VARCHAR  -- Account Description- Major Class,
  "account_sub_class" BIGINT  -- Account- Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description- Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period_month" BIGINT  -- Accounting Period (Month),
  "amount" VARCHAR,
  "fund_code" BIGINT,
  "fund_code_description" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2016

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2016

907.87 kB
113,506 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2016 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account- Major Class,
  "account_description_major_class" VARCHAR  -- Account Description- Major Class,
  "account_sub_class" BIGINT  -- Account- Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description- Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period_month" BIGINT  -- Accounting Period (Month),
  "amount" DOUBLE,
  "fund_code" BIGINT,
  "fund_code_description" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2017

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2017

883.99 kB
110,802 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2017 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account- Major Class,
  "account_description_major_class" VARCHAR  -- Account Description- Major Class,
  "account_sub_class" BIGINT  -- Account- Sub-Class,
  "account_description_sub_class" VARCHAR  -- Account Description- Sub-Class,
  "account" BIGINT,
  "account_description" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period_month" BIGINT  -- Accounting Period (Month),
  "amount" DOUBLE,
  "fund_code" BIGINT,
  "fund_code_description" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2018

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2018

876.48 kB
110,485 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2018 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "account_major_class" BIGINT  -- Account- Major Class,
  "account_description" VARCHAR,
  "account_sub_class" BIGINT  -- Account- Sub- Class",
  "account_description_sub_class" VARCHAR,
  "account" BIGINT,
  "account_description_1" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period_month" BIGINT  -- Accounting Period (Month),
  "amount" DOUBLE,
  "fund_code" BIGINT,
  "fund_code_description" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2019

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2019

878.61 kB
110,696 rows
13 columns

CREATE TABLE data_expenditure_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),
  "fund_code" BIGINT,
  "funddescr" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2020

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2020

1.06 MB
108,306 rows
13 columns

CREATE TABLE data_expenditure_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),
  "fund_code" BIGINT,
  "funddescr" VARCHAR
);

Data - Expenditure Summary - Fiscal Year 2021

@usgov.state_of_oklahoma_expenditure_summary_1a209.data_expenditure_summary_fiscal_year_2021

992.38 kB
100,006 rows
13 columns

CREATE TABLE data_expenditure_summary_fiscal_year_2021 (
  "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),
  "fund_code" BIGINT,
  "funddescr" VARCHAR
);