State Of Oklahoma Payroll - 2019 by US Government | Demographics and Population Studies

About this Dataset

State Of Oklahoma Payroll - 2019

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.
Organization: State of Oklahoma
Last updated: 2022-02-07T23:35:15.096075
Tags: 2019, payroll

Tables

Data - State Of Oklahoma Payroll - Q1–2019

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_2019.data_state_of_oklahoma_payroll_q1_2019

4.76 MB
428313 rows
12 columns


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

Data - State Of Oklahoma Payroll - Q2–2019

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_2019.data_state_of_oklahoma_payroll_q2_2019

4.44 MB
408781 rows
12 columns


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

Data - State Of Oklahoma Payroll - Q3–2019

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_2019.data_state_of_oklahoma_payroll_q3_2019

6.53 MB
392177 rows
13 columns


CREATE TABLE data_state_of_oklahoma_payroll_q3_2019 (
  "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–2019

@usgov.state_of_oklahoma_state_of_oklahoma_payroll_2019.data_state_of_oklahoma_payroll_q4_2019

7.34 MB
443257 rows
13 columns


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