Recruitment: Diversity And Inclusion

Data about XYZ Fashion Company Diversity Recruitment within the workplace

@kaggle.nahsaanbain_diversity_and_inclusion

Table List

4 tables(82.25 KB)

Hrdataset V13

@kaggle.nahsaanbain_diversity_and_inclusion.hrdataset_v13

43.62 KB
401 rows
35 columns

employee_name Employee Name	empid EmpID	marriedid MarriedID	maritalstatusid MaritalStatusID	genderid GenderID	empstatusid EmpStatusID	deptid DeptID	perfscoreid PerfScoreID	fromdiversityjobfairid FromDiversityJobFairID	payrate PayRate	termd Termd	positionid PositionID	position Position	state State	zip Zip	dob DOB	sex Sex	maritaldesc MaritalDesc	citizendesc CitizenDesc	hispaniclatino HispanicLatino	racedesc RaceDesc	dateofhire DateofHire	dateoftermination DateofTermination	termreason TermReason	employmentstatus EmploymentStatus	department Department	managername ManagerName	managerid ManagerID	recruitmentsource RecruitmentSource	performancescore PerformanceScore	engagementsurvey EngagementSurvey	empsatisfaction EmpSatisfaction	specialprojectscount SpecialProjectsCount	lastperformancereview_date LastPerformanceReview Date
Brown, Mia	1103024456	1	1		1	1	3	1	28.5		1	Accountant I	MA	1450	Tue Nov 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	F	Married	US Citizen	No	Black or African American	Mon Oct 27 2008 00:00:00 GMT+0000 (Coordinated Universal Time)		N/A - still employed	Active	Admin Offices	Brandon R. LeBlanc	1	Diversity Job Fair	Fully Meets	2.04	2	6	Tue Jan 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
LaRotonda, William	1106026572		2	1	1	1	3		23		1	Accountant I	MA	1460	Thu Apr 26 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	M	Divorced	US Citizen	No	Black or African American	Mon Jan 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)		N/A - still employed	Active	Admin Offices	Brandon R. LeBlanc	1	Website Banner Ads	Fully Meets	5	4	4	Thu Jan 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
Steans, Tyrone	1302053333			1	1	1	3		29		1	Accountant I	MA	2703	Mon Sep 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	M	Single	US Citizen	No	White	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)		N/A - still employed	Active	Admin Offices	Brandon R. LeBlanc	1	Internet Search	Fully Meets	3.9	5	5	Fri Jan 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
Howard, Estelle	1211050782	1	1		1	1	3		21.5	1	2	Administrative Assistant	MA	2170	Mon Sep 16 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	F	Married	US Citizen	No	White	Mon Feb 16 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Apr 15 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Terminated for Cause	Admin Offices	Brandon R. LeBlanc	1	Pay Per Click - Google	Fully Meets	3.24	3	4
Singh, Nan	1307059817				1	1	3		16.56		2	Administrative Assistant	MA	2330	Thu May 19 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	F	Single	US Citizen	No	White	Fri May 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)		N/A - still employed	Active	Admin Offices	Brandon R. LeBlanc	1	Website Banner Ads	Fully Meets	5	3	5	Tue Jan 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
Smith, Leigh Ann	711007713	1	1		5	1	3	1	20.5	1	2	Administrative Assistant	MA	1844	Sun Jun 14 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	F	Married	US Citizen	No	Asian	Mon Sep 26 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	career change	Voluntarily Terminated	Admin Offices	Brandon R. LeBlanc	1	Diversity Job Fair	Fully Meets	3.8	4	4
Bunbury, Jessica	1504073368	1	1		5	6	3		55	1	3	Area Sales Manager	VA	21851	Sun Jun 01 2064 00:00:00 GMT+0000 (Coordinated Universal Time)	F	Married	Eligible NonCitizen	No	Black or African American	Mon Aug 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Aug 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Another position	Voluntarily Terminated	Sales	John Smith	17	Social Networks - Facebook Twitter etc	Fully Meets	3.14	5
Carter, Michelle	1403065721				1	6	3		55		3	Area Sales Manager	VT	5664	Tue May 15 2063 00:00:00 GMT+0000 (Coordinated Universal Time)	F	Single	US Citizen	No	White	Mon Aug 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)		N/A - still employed	Active	Sales	John Smith	17	Billboard	Fully Meets	5	5		Mon Jan 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
Dietrich, Jenna	1408069481				1	6	1		55		3	Area Sales Manager	WA	98052	Thu May 14 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	F	Single	US Citizen	Yes	White	Mon Feb 20 2012 00:00:00 GMT+0000 (Coordinated Universal Time)		N/A - still employed	Active	Sales	John Smith	17	Website Banner Ads	PIP	2.3	1		Tue Jan 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
Digitale, Alfred	1306059197	1	1	1	1	6	3		56		3	Area Sales Manager	NH	3062	Wed Sep 14 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	M	Married	US Citizen	No	American Indian or Alaska Native	Mon Aug 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)		N/A - still employed	Active	Sales	John Smith	17	Pay Per Click - Google	Fully Meets	3.6	5		Wed Jan 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)


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