Data Employee CodeLast NameFirst NamesLocationDivision DescriptionGenderEmployee Status CodePosition DescriptionYearToJoinDate of...

here I attached two files for assignment requirement please read it.


Data Employee CodeLast NameFirst NamesLocationDivision DescriptionGenderEmployee Status CodePosition DescriptionYearToJoinDate of BirthWorkExperienceYearOFeducationTimeToFillSalaryHireingCostPerformance90SpeedToCompetencySponsorSatisfaction90HighPotentialAssessmentScore90EngagementProductivityBradfordFactorProfitability 1001AbelZoeVictoriaCommunity OutingsMalePMPTSr. Carer20132/24/8521026811208362026030232641020154 1002AhmedAmeenaVictoriaCommunity OutingsFemalePMPTSr. Carer20133/2/84111430790408154032730343241026560 1003AndersonGinaVictoriaCommunity OutingsFemalePMFTSr. Carer20135/16/8741225790408124023840332912018240 1004YatesYvetteVictoriaCommunity OutingsFemalePMPTSr. Carer20138/10/8541226769607896035530222648020154 1005BalgeraMimiBrightonCommunity OutingsFemalePMPTCarer20138/13/6831310499205212026220122340026560 1006BastianWilliamBrightonCommunity OutingsMaleCASSr. Carer20137/3/8731021790408154025920322524018240 1007BaulchStephenDenverHome CaresMalePMFTTeam Leader20153/30/869174110238510488592441443442612000 1008BenvinBettyDenverHome CaresFemaleCASCarer20133/30/8931123457604776035520222625011253 1009VedVeenaEatonHome CaresFemalePMPTSr. Carer20136/24/9021018790408124026610222447216160 1010BoseValVictoriaCommunity OutingsFemalePMPTSr. Carer20138/16/8211014748807708026820222548030720 1011BracewellUnaVictoriaCommunity OutingsMalePMPTSr. Carer20138/16/7071435832008540062740443310014080 1012BurrowsAbbyVictoriaCommunity OutingsFemalePMPTSr. Carer20131/17/6781645811208362072550553527012000 1013BurrowsTsengVictoriaCommunity OutingsMalePMPTSr. Carer201312/15/856133379040815405293033315012000 1014ButlerTomVictoriaCommunity OutingsMaleCASCarer20139/28/7111023540805521036820222546026560 1015ButlerTinaDenverCommunity OutingsFemaleCASSr. Carer20136/4/6521222790408154035020332821033852 1016CarlosStephen MartinDenverCommunity OutingsMalePMPTCarer20139/5/8013163554080562809274155359026560 1017CheemaSattiDenverCommunity OutingsFemalePMPTCarer20131/10/8761431520005420064030343112814080 1018CholaSonnyVictoriaCommunity OutingsMaleCASCarer20139/23/8841226561605816036230322548016160 1019ChuangChongBrightonCommunity OutingsFemalePMFTSr. Carer20139/12/6915163989440910569225155359030720 1020ColomboSoniaVictoriaCommunity OutingsFemalePMPTCarer20138/18/8631218499205212036620222447224480 1021DaySimarpreetDenverCommunity OutingsFemalePMPTCarer201312/1/7281435520005420042730433218018240 1022DouglasShaynneVictoriaCommunity OutingsFemalePMPTCarer20138/17/7331226499205212035830332619028640 1023D'SilvaSharonEatonCommunity OutingsFemalePMPTCarer20139/6/8821021520005420026020232746014080 1024EdmondsSharonDenverCommunity OutingsFemaleCASCarer201312/19/8811319540805628046620222721028640 1025EleshinnlaShannenVictoriaHome CaresFemalePMFTSr. Carer20149/14/5425173583200857009244144349034683 1026ElvinesSarahVictoriaCommunity OutingsFemaleCASCarer20147/4/9031525520005420065530332812816160 1027EvanEmmaVictoriaCommunity OutingsFemaleCASCarer201412/29/64151518540805628042620122548018240 1028SomasSaminaBrightonCommunity OutingsFemalePMPTCarer201412/21/891142452000542005702042269016160 1029FalconSabyVictoriaCommunity OutingsFemalePMPTCarer20148/23/7431322499205212046620222547212000 1030FaraoneRyanEatonCommunity OutingsMalePMPTCarer20143/16/74161634520005420092251453518028640 1031FernandezRoseBrightonHome CaresFemalePMPTCarer20147/28/7231223499205212034910232719014080 1032HolmanRachelDenverCommunity OutingsFemalePMPTCarer20141/28/88101438520005420063040333146024480 1033ForcevilleReginaVictoriaCommunity OutingsFemaleCASCarer20148/9/7931221499205212034420222721012000 1034GharibiRobertVictoriaCommunity OutingsMaleCASCarer20149/28/8115154149920521208294154348032800 1035PaullRitaVictoriaCommunity OutingsFemaleCASCarer20141/13/70131542499205212083051343437030720 1036GillRebeccaVictoriaHome CaresFemaleCASCarer201412/15/79181640499205212092441253543030720 1037GlassonGeorginaEatonCommunity OutingsFemalePMPTCarer20148/25/8921225499205212035820232846212000 1038GouldRoryBrightonCommunity OutingsFemalePMPTCarer20146/2/8611223499205212036620122665014080 1039GraetzRachelBrightonCommunity OutingsMalePMPTSr. Carer20145/23/6851625832008520095531222550014080 1040GrayChloeBrightonCommunity OutingsFemalePMPTCarer201410/6/8541326520005420055840332736514080 1041GregoryGraceBrightonCommunity OutingsFemalePMPTCarer201412/13/8831220499205212036530132841614080 1042GregoryPeterBrightonCommunity OutingsMalePMPTCarer20142/24/9081437520005420063030443252010231 1043GwillimJessicaDenverCommunity OutingsFemalePMPTCarer201410/10/8911214520005420047420222658022400 1044HakinPaulaBrightonCommunity OutingsFemalePMPTCarer201311/6/8641425499205212065530322648014080 1045HansenOprahVictoriaHome CaresFemalePMPTCarer201410/19/83101437499205212052940443452012000 1046HarrowerOliviaVictoriaCommunity OutingsFemalePMFTTeam Leader201412/17/641716501024121038988255155359030720 1047HengNinaVictoriaCommunity OutingsFemalePMPTCarer20146/30/884121449920521205662052268034325 1048HerawanNikkiVictoriaCommunity OutingsFemalePMPTCarer20131/16/8651426478404984045530222637010100 1049HondaEmilyVictoriaCommunity OutingsFemalePMPTCarer20143/14/8491428499205212073020433021022400 1050HoweMariaBrightonCommunity OutingsFemalePMPTCarer20143/31/87121633520005420082541443415024480 1051IgnatiusPaulDenverCommunity OutingsMalePMPTCarer20148/24/86111436520005420063540443412030720 1052JacobSusanEatonHome CaresFemaleCASSr. Carer20145/6/6451218769607916035820222645028640 1053JamesMichelleEatonHome CaresFemalePMPTSr. Carer20145/17/7111018748807708038510112368014080 1054JansenLindaBrightonHome CaresFemalePMPTSr. Carer20139/4/6321224790408124047010222740514080 1055JohnstonSheilaVictoriaCommunity OutingsFemalePMPTCarer20142/16/8561424499205212043120222645516160 1056JordanCherylBrightonCommunity OutingsFemalePMPTCarer201410/6/63141538520005420072840443412830720 1057JoseMellisahEatonHome CaresFemalePMPTCarer20147/13/5421025520005420067230243245824480 1058JosephCarlVictoriaCommunity OutingsMaleCASCarer201411/6/9271420624006460034430222641618240 1059KalaAndrewVictoriaCommunity OutingsMaleCASCarer20145/16/59131439499205212083940443414030720 1060KaurDeanVictoriaCommunity OutingsMalePMPTCarer20145/23/7931426478404984043230333028024480 1061KayaMargaretVictoriaHome CaresFemalePMPTCarer20137/3/7612143649920521208294144349032800 1062KeaneDonVictoriaHome CaresMalePMPTCarer20131/16/86101544499205212083541443410033524 1063KingLuciaEatonCommunity OutingsFemalePMPTCarer201410/29/8961434520005420063040333315030720 1064KingLouiseDenverCommunity OutingsFemalePMPTCarer20148/12/8971434520005420063140543414030720 1065LachenichtLouiseEatonHome CaresFemalePMPTCarer20149/6/8921225499205212036920322558014080 1066LettermanLornaVictoriaHome CaresFemaleCASCarer20147/5/8521220603206252026830232745514080 1067LiddellLizVictoriaCommunity OutingsFemaleCASCarer20142/25/87111440499205212082841443412032800 1068LogueLivingstoneVictoriaCommunity OutingsFemaleCASCarer20152/25/8881538499205212073040443413533524 1069LogueMarshVictoriaCommunity OutingsMalePMPTCarer20145/9/9011021478404984027020222646030720 1070LogueLeslieEatonCommunity OutingsMaleCASCarer201512/24/6710155049920521206314053337830720 1071MathaisKirkBrightonCommunity OutingsMaleCASSr. Carer20156/27/8216163683200857008284144348014080 1072MayBillBrightonCommunity OutingsMalePMPTCarer20157/29/8821011499205212037220222451014080 1073McGeoughKerryEatonHome CaresFemalePMPTCarer20157/10/85141436520005420083351443411030720 1074MillerBretVictoriaCommunity OutingsMalePMPTCarer20143/13/61131629499205212093921333010032800 1075MogomboVinceBrightonCommunity OutingsMalePMPTCarer20158/15/69101536499205212073220233227018240 1076MurrayKatieDenverCommunity OutingsFemalePMPTCarer20151/19/81121436540805628062940443413528640 1077MutaiKatherineEatonCommunity OutingsFemalePMFTSr. Carer201511/5/8213144074880770809293154347832800 1078NassKandyEatonCommunity OutingsFemaleCASCarer20151/25/77141444520005420073040243441212000 1079NeedhamKalebEatonHome CaresFemalePMFTTeam Leader20147/21/8710153710210810410873150443412830720 1080NguyenJulietEatonHome CaresFemalePMPTSr. Carer20154/30/68121533832008540053330333015026560 1081OkondoJulietDenverCommunity OutingsFemalePMPTCarer20153/1/8991122499205212056820122850026560 1082O'SullivanJosephineEatonCommunity OutingsFemalePMPTCarer20154/14/9031226499205212026510222647232800 1083O'SullivanKarenBrightonHome CaresFemalePMFTSr. Carer20152/24/9531734790408154094041443410530720 1084ParmerJoeVictoriaCommunity OutingsMalePMPTCarer20147/11/76111434499205212073130443118026560 1085PatelJoanneVictoriaCommunity OutingsFemalePMPTCarer20155/9/8291433499205212053450333025022400 1086PaulGertBrightonCommunity OutingsMaleCASCarer201512/23/8821218561605836036520322642614080 1087PendleburyBarbaraBrightonCommunity OutingsFemalePMPTCarer20155/22/8991425499205212064020333020022400 1088PoiAvaEatonCommunity OutingsFemalePMFTSr. Carer20152/5/9341552832008570074130243435030720 1089RajSeanVictoriaCommunity OutingsMalePMPTCarer20149/18/9081435721457414573050443414030720 1090RaymondSofiaBrightonHome CaresFemalePMPTSr. Carer20156/30/7571528769607916053830333121022400 1091RichardsonHulyaDenverCommunity OutingsFemalePMPTSr. Carer20154/14/8481634811208362062940333313530720 1092RobertsHenryEatonHome CaresMalePMFTSr. Carer20153/2/8491636811208362063140333310230720 1093RowHeatherEatonHome CaresFemalePMPTCarer20154/5/8471437520005420072840443412028640 1094SavageWalterEatonCommunity OutingsMaleCASCarer20141/26/8861531582406044064020333029022400 1095SequerahLaurenBrightonCommunity OutingsFemaleCASCarer20153/23/8141226540805628046520242643014080 1096ShaeGlinBrightonCommunity OutingsMaleCASCarer20154/6/8631225520005420046640222743014080 1097SharmaGlenBrightonHome CaresFemalePMFTSr. Carer20151/12/8291635811208362073140333310530720 1098SidhuSandeshBrightonCommunity OutingsMalePMPTSr. Carer201411/17/9031321790408124036620222547016160 1099SindenGailEatonCommunity OutingsFemalePMPTCarer20153/20/8741427499205192065830332621020320 1100SinghNicoleBrightonCommunity OutingsFemalePMPTSr. Carer20158/23/8551327769607916075530332822226560 1101SinghFayBrightonCommunity OutingsFemalePMPTSr. Carer20145/9/8241326748807688065220332638012000 1102SinghJatinBrightonCommunity OutingsMalePMPTCarer20157/24/7531537499205212056840423216028640 1103SlompMikeBrightonCommunity OutingsMalePMPTCarer20137/3/8741426745217652175520322833520320 1104SmithEstherBrightonCommunity OutingsFemalePMPTSr. Carer20151/6/87111432851248712483341543412828640 1105SmithEmmaEatonCommunity OutingsFemalePMPTSr. Carer201510/5/6118143785412874128304133336030720 1106SmithEllyEatonCommunity OutingsFemalePMPTCarer20151/7/8621022499205212067020222446214080 1107SmithEllaEatonCommunity OutingsFemalePMPTCarer20154/7/811810499205212039020212252012412 1108StrongElizabethBrightonCommunity OutingsFemalePMFTTeam Leader20159/20/671617371019201039207285044349030720 1109TandukarDonDenverCommunity OutingsFemalePMFTSr. Carer20153/13/6615174183200838966314044348632800 1110BoscoDomDenverCommunity OutingsMalePMFTSr. Carer20151/1/8310184076960794607254055358230720 1111ThomasDevDenverCommunity OutingsMaleCASSr. Carer20153/11/907153789875918759293144348730720 1112TurnbullPetraDenverCommunity OutingsFemaleCASCarer20158/5/838153652000540006334034338930720 1113TuthillPaulaDenverHome CaresFemaleCASCarer20148/23/7715153852000542008304144349028640 1114TuthillJackieDenverHome CaresFemalePMFTSr. Carer20155/29/8115173874880773806214044348330720 1115DenverDavidDenverCommunity OutingsMalePMPTCarer201510/1/85101432499205212053830333016024480 1116Van Der PoelDanaDenverCommunity OutingsFemalePMFTSr. Carer20132/25/8415134281120836208314144348328640 1117CecilJerryDenverCommunity OutingsMaleCASCarer20154/20/7710144052000545007305045348530720 1118Vesga BoadaChristyDenverHome CaresFemaleCASCarer20145/28/848153652000542008244135338830720 1119Vesga BoadaFredDenverCommunity OutingsMalePMPTCarer20141/12/8621430499205212057130223258022400 1120VictorDannyDenverCommunity OutingsMalePMPTCarer201512/31/8811514499205212037120352558010254 1121WallaceChanDenverCommunity OutingsFemalePMPTCarer201512/8/8641414499205212046020232272011012 1122WatkinsAlexEatonHome CaresMalePMFTSr. Carer20151/16/6818173881120833208244144348232800 1123WatsonCaseyEatonHome CaresFemalePMPTCarer201311/21/88101426499205212045830222925022400 1124WatsonCarolEatonCommunity OutingsFemalePMPTCarer201411/14/7881436587896078963330333212028640 1125WhiteAndreaEatonCommunity OutingsFemalePMPTCarer201312/2/5941430499205212042830553126026560 1126WilliamsGeraldineBrightonCommunity OutingsFemalePMPTCarer20142/22/7991436587896078963340333317030720 1127WilliamsonBonnieBrightonCommunity OutingsFemalePMPTCarer201412/11/8341421499205212036820222445012000 1128YadavFrankDenverCommunity OutingsMalePMFTSr. Carer20152/13/7717153781120831208314144348430720 1129YorkshireBeckDenverHome CaresMalePMFTSr. Carer20155/30/8214174081120833207244044347830720 1130YuBabyDenverHome CaresMalePMFTSr. Carer20158/4/7116153979040812408255144347930720 1131ZachariahAnnaDenverHome CaresFemalePMPTCarer20155/27/7851421499205192036630142748016160 1132WilliamsAnnaEatonHome CaresFemalePMPTSr. Carer201511/23/7018154179040812408225155358030720 1133SlocumAndrew JonesEatonCommunity OutingsMalePMPTCarer201512/15/83121426598756187566220332568024222 1134CullenDavidEatonCommunity OutingsMalePMPTCarer20145/9/9081226499205192023510422658020320 1135VictorAbelBrightonCommunity OutingsMalePMPTCarer20146/14/86111435689547095473030333312030720 1136BlairAmyEatonHome CaresFemalePMFTSr. Carer20159/3/81171635769607916092941443411030720 1137CraigAmitaBrightonCommunity OutingsFemalePMPTCarer20152/15/8751426499205192054130332938514080 1138TurnbullCatherineEatonCommunity OutingsFemalePMPTCarer201512/21/9041427499205192055520322745014080 Variable Employee ID Last Name First Names Location4 locational Branches: Brighton, Denver, Eaton, Victoria Division DescriptionTwo business divisions: Community-outing, Home care Gender Employee Status CodePMFT = Permanent Full Time; PMPT = Permanent Part Time; CAS= Casual Position Description3 levels: Team Leader; Senior Carer; Carer YearToJoinYear to Join the organization Date of Birth WorkExperienceNumber of years of working in this industry YearOFeducationNumber of year in school or university TimeToFillDays spent to fill the employee's position after advertisement SalaryAnnual salary HireingCostAnnual salary plus administrative costs of hire Performance90Performance appraisal scores 90 days after joining the organizaiton. It ranks from 1 to 9. A higher score indicates better performance. SpeedToCompetencyNumber of days before reaching competency after joining the organization SponsorSatisfaction90Sponsor satisfaction score ranges from 1 to 5. A higher score indicate a higher level of satisfaction. HighPotentialA dichotomous variable. 1 = 8 & 9 for Performance90, and zero otherwise. AssessmentScore90Test score 90 days after joining the organizaiton. It ranges from 1 to 5. A higher score indicates better assessment result EngagementEngagement score ranges from 1 to 5. A higher score indicates a higher level of engagement. ProductivityAn employee's average number of billable hours per week BradfordFactorB=SxSxD or B = S2 x D ProfitabilityAverage revenue minus the employee's costs including salary costs