Name: Recruitment: Diversity And Inclusion
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Recruitment: Diversity And Inclusion

The dataset includes HR information from XYZ fashion. Employee information, salary grid, and recruiting costs are included in the dataset.

Tables

Hrdataset V13

@kaggle.nahsaanbain_diversity_and_inclusion.hrdataset_v13

44.67 kB
401 rows
35 columns

CREATE TABLE hrdataset_v13 (
  "employee_name" VARCHAR,
  "empid" DOUBLE,
  "marriedid" DOUBLE,
  "maritalstatusid" DOUBLE,
  "genderid" DOUBLE,
  "empstatusid" DOUBLE,
  "deptid" DOUBLE,
  "perfscoreid" DOUBLE,
  "fromdiversityjobfairid" DOUBLE,
  "payrate" DOUBLE,
  "termd" DOUBLE,
  "positionid" DOUBLE,
  "position" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "dob" TIMESTAMP,
  "sex" VARCHAR,
  "maritaldesc" VARCHAR,
  "citizendesc" VARCHAR,
  "hispaniclatino" VARCHAR,
  "racedesc" VARCHAR,
  "dateofhire" TIMESTAMP,
  "dateoftermination" TIMESTAMP,
  "termreason" VARCHAR,
  "employmentstatus" VARCHAR,
  "department" VARCHAR,
  "managername" VARCHAR,
  "managerid" DOUBLE,
  "recruitmentsource" VARCHAR,
  "performancescore" VARCHAR,
  "engagementsurvey" DOUBLE,
  "empsatisfaction" DOUBLE,
  "specialprojectscount" DOUBLE,
  "lastperformancereview_date" TIMESTAMP,
  "dayslatelast30" DOUBLE
);

Production Staff

@kaggle.nahsaanbain_diversity_and_inclusion.production_staff

18.29 kB
256 rows
15 columns

CREATE TABLE production_staff (
  "employee_name" VARCHAR,
  "race_desc" VARCHAR,
  "date_of_hire" TIMESTAMP,
  "termdate" TIMESTAMP,
  "reason_for_term" VARCHAR,
  "employment_status" VARCHAR,
  "department" VARCHAR,
  "position" VARCHAR,
  "pay" VARCHAR,
  "manager_name" VARCHAR,
  "performance_score" VARCHAR,
  "abutments_hour_wk_1" DOUBLE,
  "abutments_hour_wk_2" DOUBLE,
  "daily_error_rate" DOUBLE,
  "n_90_day_complaints" DOUBLE  -- 90-day Complaints
);

Recruiting Costs

@kaggle.nahsaanbain_diversity_and_inclusion.recruiting_costs

11.16 kB
22 rows
14 columns

CREATE TABLE recruiting_costs (
  "employment_source" VARCHAR,
  "january" BIGINT,
  "february" BIGINT,
  "march" BIGINT,
  "april" BIGINT,
  "may" BIGINT,
  "june" BIGINT,
  "july" BIGINT,
  "august" BIGINT,
  "september" BIGINT,
  "october" BIGINT,
  "november" BIGINT,
  "december" BIGINT,
  "total" BIGINT
);

Salary Grid

@kaggle.nahsaanbain_diversity_and_inclusion.salary_grid

10.11 kB
30 rows
15 columns

CREATE TABLE salary_grid (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "salary" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "hourly" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" DOUBLE  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);