About this Dataset

State Of Oklahoma Payroll - Fiscal Year 2021

The payroll data represents the amount paid to an employee during the reported time period. In addition to regular pay, these amounts may include other pay types such as overtime, longevity, shift differential or terminal pay. This amount does not include any state share costs associated with the payroll i.e. FICA, state share retirement, etc. This amount may vary from an employee’s ‘salary’ due to pay adjustments or pay period timing.
Organization: State of Oklahoma
Last updated: 2022-02-28T22:58:02.004608

Tables

Data - State Of Oklahoma Payroll - Q2–2021

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_fiscal_yea_02d5f841.data_state_of_oklahoma_payroll_q2_2021

8.37 MB
520,402 rows
13 columns

CREATE TABLE data_state_of_oklahoma_payroll_q2_2021 (
  "report_date" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "middle_initial" VARCHAR,
  "hours" DOUBLE,
  "amount" DOUBLE,
  "check_date" VARCHAR,
  "account" BIGINT,
  "account_description" VARCHAR,
  "update_date" VARCHAR,
  "rowid" VARCHAR
);

Data - State Of Oklahoma Payroll - Q3–2021

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_fiscal_yea_02d5f841.data_state_of_oklahoma_payroll_q3_2021

7.28 MB
438,523 rows
13 columns

CREATE TABLE data_state_of_oklahoma_payroll_q3_2021 (
  "report_date" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "middle_initial" VARCHAR,
  "hours" DOUBLE,
  "amount" DOUBLE,
  "check_date" VARCHAR,
  "account" BIGINT,
  "account_description" VARCHAR,
  "update_date" VARCHAR,
  "rowid" VARCHAR
);

Data - State Of Oklahoma Payroll - Q4–2021

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_fiscal_yea_02d5f841.data_state_of_oklahoma_payroll_q4_2021

7.34 MB
450,547 rows
13 columns

CREATE TABLE data_state_of_oklahoma_payroll_q4_2021 (
  "report_date" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "middle_initial" VARCHAR,
  "hours" DOUBLE,
  "amount" DOUBLE,
  "check_date" VARCHAR,
  "account" BIGINT,
  "account_description" VARCHAR,
  "update_date" VARCHAR,
  "rowid" VARCHAR
);