Name: General Ledger
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

General Ledger

General Ledger
Organization: State of Oklahoma
Last updated: 2025-11-15T22:34:33.195678
Tags: gl

Tables

LEDGER FY26 QTR1

@usgov.state_of_oklahoma_general_ledger.ledger_fy26_qtr1

7.23 MB
473,757 rows
36 columns

CREATE TABLE ledger_fy26_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 FY26 QTR2

@usgov.state_of_oklahoma_general_ledger.ledger_fy26_qtr2

2.94 MB
183,278 rows
36 columns

CREATE TABLE ledger_fy26_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
);