OKStateStat - Financial And Strategic Objectives Data by US Government | Finance and Economics

About this Dataset

OKStateStat - Financial And Strategic Objectives Data

No description provided
Organization: State of Oklahoma
Last updated: 2021-08-07T14:59:48.662267
Tags: budget, expenditures, performance-metrics, statestat, statewide-programs

Tables

Statewide Program Budget And Actual Expenses

@usgov.state_of_oklahoma_okstatestat_financial_and_strategic__13e678ea.statewide_program_budget_and_actual_expenses

520.68 KB
31644 rows
20 columns


CREATE TABLE statewide_program_budget_and_actual_expenses (
  "program_code" VARCHAR,
  "business_unit" BIGINT,
  "class" DOUBLE,
  "budget_reference" BIGINT,
  "accounting_period" BIGINT,
  "fiscal_year" BIGINT,
  "sum_posted_total_amt" DOUBLE,
  "budget_or_expenses" VARCHAR,
  "program_name" VARCHAR,
  "program_name_display" VARCHAR,
  "topic" VARCHAR,
  "goal" VARCHAR,
  "agency_name" VARCHAR,
  "ytd_yesor_no" VARCHAR,
  "ytd_amount" DOUBLE,
  "type_of_fund" VARCHAR,
  "regents_19x_fund" VARCHAR,
  "program_or_no_program" VARCHAR,
  "current_data_date" TIMESTAMP,
  "uid" BIGINT
);

Performance Metrics For Statewide Objectives

@usgov.state_of_oklahoma_okstatestat_financial_and_strategic__13e678ea.performance_metrics_for_statewide_objectives

32.45 KB
167 rows
13 columns


CREATE TABLE performance_metrics_for_statewide_objectives (
  "goal" VARCHAR,
  "topic" VARCHAR,
  "statewide_program" VARCHAR,
  "objective_kpi" VARCHAR,
  "objective_kpi_short_name" VARCHAR,
  "objective_kpi_owner_agency" VARCHAR,
  "n_2011" VARCHAR,
  "n_2012" VARCHAR,
  "n_2013" VARCHAR,
  "n_2014" VARCHAR,
  "n_2015" VARCHAR,
  "today" VARCHAR,
  "target" VARCHAR
);