About this Dataset

State Of Oklahoma Revolving Funds - 2021

A detailed listing of all State of Oklahoma revolving funds and the amount for the calendar year.
Organization: State of Oklahoma
Last updated: 2022-02-14T23:35:25.305245

Tables

Revolving 2021

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_2021

103.31 kB
8,275 rows
8 columns

CREATE TABLE revolving_2021 (
  "business_unit" BIGINT,
  "agency_name" VARCHAR,
  "class_fld" BIGINT,
  "class_description" VARCHAR,
  "statutory_reference" VARCHAR,
  "fiscal_year" BIGINT,
  "accounting_period" BIGINT,
  "posted_total_amount" DOUBLE
);

Revolving Funds 202102

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_funds_202102

43.44 kB
1,112 rows
8 columns

CREATE TABLE revolving_funds_202102 (
  "business_unit" BIGINT,
  "ocp_agncy_name" VARCHAR,
  "substr_a_class_fld_1_3" BIGINT  -- SUBSTR(A.CLASS FLD,1,3),
  "ocp_class_descr" VARCHAR,
  "ocp_statutory_ref" VARCHAR,
  "n__2021" BIGINT  -- '2021',
  "n__02" BIGINT  -- '02',
  "sum_a_posted_total_amt" DOUBLE  -- SUM(A.POSTED TOTAL AMT)
);

Revolving Funds 202103

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_funds_202103

43.43 kB
1,112 rows
8 columns

CREATE TABLE revolving_funds_202103 (
  "business_unit" BIGINT,
  "ocp_agncy_name" VARCHAR,
  "substr_a_class_fld_1_3" BIGINT  -- SUBSTR(A.CLASS FLD,1,3),
  "ocp_class_descr" VARCHAR,
  "ocp_statutory_ref" VARCHAR,
  "n__2021" BIGINT  -- '2021',
  "n__03" BIGINT  -- '03',
  "sum_a_posted_total_amt" DOUBLE  -- SUM(A.POSTED TOTAL AMT)
);

Revolving Funds 202104

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_funds_202104

48.8 kB
1,234 rows
8 columns

CREATE TABLE revolving_funds_202104 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "class_fund_number" BIGINT,
  "class_fund_description" VARCHAR,
  "statutory_reference" VARCHAR,
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "balance" DOUBLE
);

Revolving Funds 202105

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_funds_202105

48.89 kB
1,239 rows
8 columns

CREATE TABLE revolving_funds_202105 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "class_fund_number" BIGINT,
  "class_fund_description" VARCHAR,
  "statutory_reference" VARCHAR,
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "balance" DOUBLE
);

Revolving Funds 202106

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_funds_202106

48.87 kB
1,239 rows
8 columns

CREATE TABLE revolving_funds_202106 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "class_fund_number" BIGINT,
  "class_fund_description" VARCHAR,
  "statutory_reference" VARCHAR,
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "balance" DOUBLE
);

Revolving Funds 202107

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_funds_202107

48.9 kB
1,239 rows
8 columns

CREATE TABLE revolving_funds_202107 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "class_fund_number" BIGINT,
  "class_fund_description" VARCHAR,
  "statutory_reference" VARCHAR,
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "balance" DOUBLE
);

Revolving Funds 202108

@usgov.state_of_oklahoma_state_of_oklahoma_revolving_funds_2021.revolving_funds_202108

48.97 kB
1,241 rows
8 columns

CREATE TABLE revolving_funds_202108 (
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "class_fund_number" BIGINT,
  "class_fund_description" VARCHAR,
  "statutory_reference" VARCHAR,
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "balance" DOUBLE
);