About this Dataset

State Of Oklahoma Payroll - Fiscal Year 2022

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. The payroll information will be updated monthly after the end of the month. For example, July information will be added in August after the 15th of the month.
Organization: State of Oklahoma
Last updated: 2022-07-28T02:55:28.706876
Tags: paycheck

Tables

Payroll Public 202206

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_fiscal_year_2022.payroll_public_202206

6.31 MB
374,380 rows
13 columns

CREATE TABLE payroll_public_202206 (
  "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
);