Baselight
Sign In

General Ledger

State of Oklahoma

@usgov.state_of_oklahoma_general_ledger

Loading...
Loading...

About this Dataset

General Ledger

General Ledger
Organization: State of Oklahoma
Last updated: 2022-04-28T05:07:43.171821
Tags: gl

Tables

LEDGER FY22 QTR1

@usgov.state_of_oklahoma_general_ledger.ledger_fy22_qtr1
  • 6.47 MB
  • 310315 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy22_qtr1 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY22 QTR2

@usgov.state_of_oklahoma_general_ledger.ledger_fy22_qtr2
  • 5.24 MB
  • 248844 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy22_qtr2 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY22 QTR3

@usgov.state_of_oklahoma_general_ledger.ledger_fy22_qtr3
  • 7.59 MB
  • 398246 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy22_qtr3 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY22 QTR4

@usgov.state_of_oklahoma_general_ledger.ledger_fy22_qtr4
  • 885.96 KB
  • 39981 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy22_qtr4 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY23 QTR2

@usgov.state_of_oklahoma_general_ledger.ledger_fy23_qtr2
  • 7.54 MB
  • 399476 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy23_qtr2 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY23 QTR3

@usgov.state_of_oklahoma_general_ledger.ledger_fy23_qtr3
  • 8.36 MB
  • 463433 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy23_qtr3 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY23 QTR4

@usgov.state_of_oklahoma_general_ledger.ledger_fy23_qtr4
  • 7.32 MB
  • 388509 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy23_qtr4 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY24 QTR2

@usgov.state_of_oklahoma_general_ledger.ledger_fy24_qtr2
  • 7.69 MB
  • 413459 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy24_qtr2 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY24 QTR3

@usgov.state_of_oklahoma_general_ledger.ledger_fy24_qtr3
  • 6.26 MB
  • 322867 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy24_qtr3 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY25 QTR2

@usgov.state_of_oklahoma_general_ledger.ledger_fy25_qtr2
  • 7.33 MB
  • 382289 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy25_qtr2 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY23 QTR1

@usgov.state_of_oklahoma_general_ledger.ledger_fy23_qtr1
  • 11.38 MB
  • 537652 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy23_qtr1 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY24 QTR1

@usgov.state_of_oklahoma_general_ledger.ledger_fy24_qtr1
  • 11.25 MB
  • 533884 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy24_qtr1 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY25 QTR1

@usgov.state_of_oklahoma_general_ledger.ledger_fy25_qtr1
  • 10 MB
  • 519354 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy25_qtr1 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY25 QTR3

@usgov.state_of_oklahoma_general_ledger.ledger_fy25_qtr3
  • 7.47 MB
  • 387872 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy25_qtr3 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

LEDGER FY25 QTR4

@usgov.state_of_oklahoma_general_ledger.ledger_fy25_qtr4
  • 2.2 MB
  • 115129 rows
  • 36 columns
Loading... 

CREATE TABLE ledger_fy25_qtr4 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);

Share link

Anyone who has the link will be able to view this.