Dataset: Recruitment: Diversity And Inclusion

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

43.62 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

17.86 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
);

Recruiting Costs

@kaggle.nahsaanbain_diversity_and_inclusion.recruiting_costs

10.9 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

9.87 KB
30 rows
15 columns


CREATE TABLE salary_grid (
  "unnamed_0" VARCHAR,
  "salary" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "hourly" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" DOUBLE,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR
);