{"@odata.context":"https://demodata.grapecity.com/contoso/odata/v1/$metadata#DimEmployees","value":[{"EmployeeKey":1,"ParentEmployeeKey":18,"FirstName":"Kieth","LastName":"Moreno","MiddleName":null,"Title":"Regional Manager","HireDate":"1996-07-31","BirthDate":"1972-05-15","EmailAddress":"KiethMoreno@contoso.com","Phone":"320-555-0195","MaritalStatus":"M","EmergencyContactName":"Hazem Abolrous","EmergencyContactPhone":"320-555-0195","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":72.4500,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1996-07-31","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee1.jpg"},{"EmployeeKey":2,"ParentEmployeeKey":18,"FirstName":"Denis","LastName":"Rivers","MiddleName":null,"Title":"Regional Manager","HireDate":"1997-02-26","BirthDate":"1977-06-03","EmailAddress":"DenisRivers@contoso.com","Phone":"150-555-0189","MaritalStatus":"S","EmergencyContactName":"Kevin Cook","EmergencyContactPhone":"150-555-0189","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":72.4500,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1997-02-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee2.jpg"},{"EmployeeKey":3,"ParentEmployeeKey":18,"FirstName":"Henry","LastName":"Vane","MiddleName":null,"Title":"Regional Manager","HireDate":"1997-12-12","BirthDate":"1964-12-13","EmailAddress":"HenryVane@contoso.com","Phone":"212-555-0187","MaritalStatus":"M","EmergencyContactName":"Ahmad Abu-Dayah","EmergencyContactPhone":"212-555-0187","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":72.4500,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Engineering","StartDate":"1997-12-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee3.jpg"},{"EmployeeKey":4,"ParentEmployeeKey":18,"FirstName":"Nathan","LastName":"Wade","MiddleName":"J.","Title":"Regional Manager","HireDate":"1998-01-05","BirthDate":"1965-01-23","EmailAddress":"NathanWade@contoso.com","Phone":"612-555-0100","MaritalStatus":"S","EmergencyContactName":"Mrina Natarajan","EmergencyContactPhone":"612-555-0100","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":72.4500,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Tool Design","StartDate":"1998-01-05","EndDate":"2000-06-30","Status":"NULL","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee4.jpg"},{"EmployeeKey":5,"ParentEmployeeKey":18,"FirstName":"Javier","LastName":"Reid","MiddleName":null,"Title":"Regional Manager","HireDate":"1998-01-05","BirthDate":"1965-01-23","EmailAddress":"JavierReid@contoso.com","Phone":"612-555-0100","MaritalStatus":"S","EmergencyContactName":"Gustavo Achong","EmergencyContactPhone":"612-555-0100","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":72.4500,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Tool Design","StartDate":"2000-06-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee5.jpg"},{"EmployeeKey":6,"ParentEmployeeKey":1,"FirstName":"Benny","LastName":"Dobson","MiddleName":null,"Title":"Marketing Specialist","HireDate":"1998-01-11","BirthDate":"1949-08-29","EmailAddress":"BennyDobson@contoso.com","Phone":"168-555-0183","MaritalStatus":"M","EmergencyContactName":"Gerwald Oberleitner","EmergencyContactPhone":"168-555-0183","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1998-01-11","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee6.jpg"},{"EmployeeKey":7,"ParentEmployeeKey":2,"FirstName":"Aiden","LastName":"Taylor","MiddleName":null,"Title":"Marketing Consultant","HireDate":"1998-01-20","BirthDate":"1965-04-19","EmailAddress":"AidenTaylor@contoso.com","Phone":"913-555-0172","MaritalStatus":"S","EmergencyContactName":"Gudmundur Adalsteinsson","EmergencyContactPhone":"913-555-0172","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1998-01-20","EndDate":"1999-08-15","Status":"NULL","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee7.jpg"},{"EmployeeKey":8,"ParentEmployeeKey":3,"FirstName":"Erick","LastName":"Benfield","MiddleName":"M.","Title":"Marketing Director","HireDate":"1998-01-20","BirthDate":"1965-04-19","EmailAddress":"ErickBenfield@contoso.com","Phone":"913-555-0172","MaritalStatus":"S","EmergencyContactName":"Dominik Paiha","EmergencyContactPhone":"913-555-0172","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1999-08-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee8.jpg"},{"EmployeeKey":9,"ParentEmployeeKey":4,"FirstName":"Thea","LastName":"John","MiddleName":null,"Title":"Payroll Assistant","HireDate":"1998-01-26","BirthDate":"1946-02-16","EmailAddress":"TheaJohn@contoso.com","Phone":"903-555-0145","MaritalStatus":"S","EmergencyContactName":"Michael Affronti","EmergencyContactPhone":"903-555-0145","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1998-01-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee9.jpg"},{"EmployeeKey":10,"ParentEmployeeKey":5,"FirstName":"Stella","LastName":"Grant","MiddleName":null,"Title":"Financial Advisor Assistant","HireDate":"1998-02-06","BirthDate":"1946-07-06","EmailAddress":"StellaGrant@contoso.com","Phone":"145-555-0130","MaritalStatus":"M","EmergencyContactName":"Jim Ptaszynski","EmergencyContactPhone":"145-555-0130","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1998-02-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee10.jpg"},{"EmployeeKey":11,"ParentEmployeeKey":1,"FirstName":"Aeris","LastName":"Heaton","MiddleName":null,"Title":"Product Manager","HireDate":"1998-02-06","BirthDate":"1942-10-29","EmailAddress":"AerisHeaton@contoso.com","Phone":"849-555-0139","MaritalStatus":"M","EmergencyContactName":"Nupur Agarwal","EmergencyContactPhone":"849-555-0139","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Engineering","StartDate":"1998-02-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee11.jpg"},{"EmployeeKey":12,"ParentEmployeeKey":2,"FirstName":"Nick","LastName":"Savage","MiddleName":null,"Title":"Executive Compensation Manager","HireDate":"1998-02-07","BirthDate":"1946-04-27","EmailAddress":"NickSavage@contoso.com","Phone":"206-555-0180","MaritalStatus":"S","EmergencyContactName":"Amritansh Raghav","EmergencyContactPhone":"206-555-0180","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1998-02-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee12.jpg"},{"EmployeeKey":13,"ParentEmployeeKey":3,"FirstName":"Rufus","LastName":"Wilkinson","MiddleName":null,"Title":"Senior Software Engineer","HireDate":"1998-02-24","BirthDate":"1949-04-11","EmailAddress":"RufusWilkinson@contoso.com","Phone":"122-555-0189","MaritalStatus":"M","EmergencyContactName":"Hatim Aiad","EmergencyContactPhone":"122-555-0189","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Engineering","StartDate":"1998-02-24","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee13.jpg"},{"EmployeeKey":14,"ParentEmployeeKey":8,"FirstName":"Marigold","LastName":"Cartwright","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1998-03-03","BirthDate":"1961-09-01","EmailAddress":"MarigoldCartwright@contoso.com","Phone":"819-555-0175","MaritalStatus":"S","EmergencyContactName":"Peter Saddow","EmergencyContactPhone":"819-555-0175","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Engineering","StartDate":"1998-03-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee14.jpg"},{"EmployeeKey":15,"ParentEmployeeKey":9,"FirstName":"Wade","LastName":"Dyson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1998-03-05","BirthDate":"1946-10-01","EmailAddress":"WadeDyson@contoso.com","Phone":"424-555-0189","MaritalStatus":"M","EmergencyContactName":"Cigdem Akin","EmergencyContactPhone":"424-555-0189","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1998-03-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee15.jpg"},{"EmployeeKey":16,"ParentEmployeeKey":1,"FirstName":"Henry","LastName":"Chappell","MiddleName":null,"Title":"Solution Architect","HireDate":"1998-03-11","BirthDate":"1946-05-03","EmailAddress":"HenryChappell@contoso.com","Phone":"508-555-0165","MaritalStatus":"M","EmergencyContactName":"Roberto Tamburello","EmergencyContactPhone":"508-555-0165","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Engineering","StartDate":"1998-03-11","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee16.jpg"},{"EmployeeKey":17,"ParentEmployeeKey":2,"FirstName":"Tom","LastName":"Bell","MiddleName":null,"Title":"Credit Analyst","HireDate":"1998-03-23","BirthDate":"1946-08-12","EmailAddress":"TomBell@contoso.com","Phone":"984-555-0185","MaritalStatus":"S","EmergencyContactName":"Michael Alexander","EmergencyContactPhone":"984-555-0185","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1998-03-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee17.jpg"},{"EmployeeKey":18,"ParentEmployeeKey":null,"FirstName":"Marigold","LastName":"Oliver","MiddleName":null,"Title":"Group Manager","HireDate":"1998-03-30","BirthDate":"1946-11-09","EmailAddress":"MarigoldOliver@contoso.com","Phone":"632-555-0129","MaritalStatus":"S","EmergencyContactName":"Sairaj Uddin","EmergencyContactPhone":"632-555-0129","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":125.0000,"VacationHours":80,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1998-03-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee18.jpg"},{"EmployeeKey":19,"ParentEmployeeKey":4,"FirstName":"Kamila","LastName":"Knott","MiddleName":null,"Title":"Budget Analyst","HireDate":"1998-04-11","BirthDate":"1946-05-06","EmailAddress":"KamilaKnott@contoso.com","Phone":"328-555-0150","MaritalStatus":"M","EmergencyContactName":"Mark Alexieff","EmergencyContactPhone":"328-555-0150","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1998-04-11","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee19.jpg"},{"EmployeeKey":20,"ParentEmployeeKey":5,"FirstName":"Matthew","LastName":"Mooney","MiddleName":null,"Title":"Employment Equity Manager","HireDate":"1998-04-18","BirthDate":"1946-09-08","EmailAddress":"MatthewMooney@contoso.com","Phone":"435-555-0113","MaritalStatus":"M","EmergencyContactName":"Szabolcs Vajda","EmergencyContactPhone":"435-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1998-04-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee20.jpg"},{"EmployeeKey":21,"ParentEmployeeKey":1,"FirstName":"Noemi","LastName":"Hopkinson","MiddleName":null,"Title":"Director of Operations","HireDate":"1998-04-29","BirthDate":"1946-04-30","EmailAddress":"NoemiHopkinson@contoso.com","Phone":"202-555-0151","MaritalStatus":"M","EmergencyContactName":"Gilead Almosnino","EmergencyContactPhone":"202-555-0151","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Operations","StartDate":"1998-04-29","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee21.jpg"},{"EmployeeKey":22,"ParentEmployeeKey":2,"FirstName":"Lucas","LastName":"Owens","MiddleName":null,"Title":"Operations Coordinator","HireDate":"1999-01-02","BirthDate":"1967-06-15","EmailAddress":"LucasOwens@contoso.com","Phone":"925-555-0114","MaritalStatus":"M","EmergencyContactName":"Roland Wacker","EmergencyContactPhone":"925-555-0114","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Operations","StartDate":"1999-01-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee22.jpg"},{"EmployeeKey":23,"ParentEmployeeKey":3,"FirstName":"Carter","LastName":"Smith","MiddleName":null,"Title":"IT Manager","HireDate":"1999-01-02","BirthDate":"1972-12-04","EmailAddress":"CarterSmith@contoso.com","Phone":"913-555-0196","MaritalStatus":"M","EmergencyContactName":"James Alvord","EmergencyContactPhone":"913-555-0196","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-01-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee23.jpg"},{"EmployeeKey":24,"ParentEmployeeKey":9,"FirstName":"Barney","LastName":"Webster","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-03","BirthDate":"1952-10-14","EmailAddress":"BarneyWebster@contoso.com","Phone":"413-555-0136","MaritalStatus":"S","EmergencyContactName":"Stig Panduro","EmergencyContactPhone":"413-555-0136","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee24.jpg"},{"EmployeeKey":25,"ParentEmployeeKey":10,"FirstName":"Alexander","LastName":"Clarkson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-03","BirthDate":"1960-11-18","EmailAddress":"AlexanderClarkson@contoso.com","Phone":"332-555-0150","MaritalStatus":"S","EmergencyContactName":"Kamil Amireh","EmergencyContactPhone":"332-555-0150","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee25.jpg"},{"EmployeeKey":26,"ParentEmployeeKey":1,"FirstName":"Doug","LastName":"Cooper","MiddleName":null,"Title":"Cloud Architect","HireDate":"1999-01-03","BirthDate":"1969-12-03","EmailAddress":"DougCooper@contoso.com","Phone":"166-555-0162","MaritalStatus":"S","EmergencyContactName":"Shmuel Yair","EmergencyContactPhone":"166-555-0162","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-01-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee26.jpg"},{"EmployeeKey":27,"ParentEmployeeKey":2,"FirstName":"Carter","LastName":"Tyrrell","MiddleName":null,"Title":"Finance Assistant","HireDate":"1999-01-04","BirthDate":"1973-11-26","EmailAddress":"CarterTyrrell@contoso.com","Phone":"113-555-0173","MaritalStatus":"S","EmergencyContactName":"Thomas Andersen","EmergencyContactPhone":"113-555-0173","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-01-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee27.jpg"},{"EmployeeKey":28,"ParentEmployeeKey":3,"FirstName":"Carter","LastName":"John","MiddleName":null,"Title":"Personal Finance Advisor","HireDate":"1999-01-05","BirthDate":"1972-02-04","EmailAddress":"CarterJohn@contoso.com","Phone":"115-555-0179","MaritalStatus":"M","EmergencyContactName":"Eugene Zabokritski","EmergencyContactPhone":"115-555-0179","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-01-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee28.jpg"},{"EmployeeKey":29,"ParentEmployeeKey":4,"FirstName":"Danny","LastName":"Nicholls","MiddleName":null,"Title":"HR Safety Manager","HireDate":"1999-01-05","BirthDate":"1970-12-15","EmailAddress":"DannyNicholls@contoso.com","Phone":"147-555-0160","MaritalStatus":"S","EmergencyContactName":"Nancy Anderson","EmergencyContactPhone":"147-555-0160","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-01-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee29.jpg"},{"EmployeeKey":30,"ParentEmployeeKey":5,"FirstName":"Denis","LastName":"Bailey","MiddleName":null,"Title":"Junior Data Analyst","HireDate":"1999-01-05","BirthDate":"1967-04-28","EmailAddress":"DenisBailey@contoso.com","Phone":"656-555-0119","MaritalStatus":"S","EmergencyContactName":"Ranjith Narayanan","EmergencyContactPhone":"656-555-0119","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-01-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee30.jpg"},{"EmployeeKey":31,"ParentEmployeeKey":1,"FirstName":"Michael","LastName":"Robinson","MiddleName":null,"Title":"Industrial Relations Manager","HireDate":"1999-01-06","BirthDate":"1976-06-30","EmailAddress":"MichaelRobinson@contoso.com","Phone":"138-555-0128","MaritalStatus":"M","EmergencyContactName":"Joe Andreshak","EmergencyContactPhone":"138-555-0128","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-01-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee31.jpg"},{"EmployeeKey":32,"ParentEmployeeKey":2,"FirstName":"Maddison","LastName":"Osman","MiddleName":null,"Title":"Employer Brand Manager","HireDate":"1999-01-07","BirthDate":"1966-03-14","EmailAddress":"MaddisonOsman@contoso.com","Phone":"523-555-0175","MaritalStatus":"M","EmergencyContactName":"Preeda Ola","EmergencyContactPhone":"523-555-0175","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-01-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee32.jpg"},{"EmployeeKey":33,"ParentEmployeeKey":3,"FirstName":"Benjamin","LastName":"Wise","MiddleName":null,"Title":"Operations Coordinator","HireDate":"1999-01-07","BirthDate":"1979-01-06","EmailAddress":"BenjaminWise@contoso.com","Phone":"668-555-0130","MaritalStatus":"S","EmergencyContactName":"Lisa Andrews","EmergencyContactPhone":"668-555-0130","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":55.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Operations","StartDate":"1999-01-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee33.jpg"},{"EmployeeKey":34,"ParentEmployeeKey":7,"FirstName":"Erick","LastName":"Maxwell","MiddleName":"B.","Title":"Sales Store Manager","HireDate":"1999-01-08","BirthDate":"1974-09-26","EmailAddress":"ErickMaxwell@contoso.com","Phone":"609-555-0179","MaritalStatus":"S","EmergencyContactName":"Wilson Pais","EmergencyContactPhone":"609-555-0179","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee34.jpg"},{"EmployeeKey":35,"ParentEmployeeKey":10,"FirstName":"Ramon","LastName":"Daniells","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-08","BirthDate":"1973-08-27","EmailAddress":"RamonDaniells@contoso.com","Phone":"952-555-0178","MaritalStatus":"S","EmergencyContactName":"Johnson Apacible","EmergencyContactPhone":"952-555-0178","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":38,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee35.jpg"},{"EmployeeKey":36,"ParentEmployeeKey":6,"FirstName":"Christine","LastName":"Khan","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-08","BirthDate":"1968-03-20","EmailAddress":"ChristineKhan@contoso.com","Phone":"943-555-0196","MaritalStatus":"S","EmergencyContactName":"Stuart Railson","EmergencyContactPhone":"943-555-0196","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Shipping and Receiving","StartDate":"1999-01-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee36.jpg"},{"EmployeeKey":37,"ParentEmployeeKey":6,"FirstName":"Bart","LastName":"Amstead","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-08","BirthDate":"1967-04-19","EmailAddress":"BartAmstead@contoso.com","Phone":"937-555-0137","MaritalStatus":"M","EmergencyContactName":"NeKeta Argrow","EmergencyContactPhone":"937-555-0137","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Shipping and Receiving","StartDate":"1999-01-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee37.jpg"},{"EmployeeKey":38,"ParentEmployeeKey":6,"FirstName":"Anne","LastName":"Huggins","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-08","BirthDate":"1968-02-27","EmailAddress":"AnneHuggins@contoso.com","Phone":"333-555-0173","MaritalStatus":"M","EmergencyContactName":"Malvin Seale","EmergencyContactPhone":"333-555-0173","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee38.jpg"},{"EmployeeKey":39,"ParentEmployeeKey":6,"FirstName":"Chadwick","LastName":"Rigg","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-09","BirthDate":"1980-06-17","EmailAddress":"ChadwickRigg@contoso.com","Phone":"963-555-0134","MaritalStatus":"S","EmergencyContactName":"Ravital Artman","EmergencyContactPhone":"963-555-0134","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee39.jpg"},{"EmployeeKey":40,"ParentEmployeeKey":6,"FirstName":"Benjamin","LastName":"Locke","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-09","BirthDate":"1979-03-09","EmailAddress":"BenjaminLocke@contoso.com","Phone":"794-555-0159","MaritalStatus":"S","EmergencyContactName":"Anne-Mette Stoltze","EmergencyContactPhone":"794-555-0159","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee40.jpg"},{"EmployeeKey":41,"ParentEmployeeKey":6,"FirstName":"Ronald","LastName":"Mccormick","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-10","BirthDate":"1974-12-19","EmailAddress":"RonaldMccormick@contoso.com","Phone":"218-555-0126","MaritalStatus":"S","EmergencyContactName":"Dimple Arya","EmergencyContactPhone":"218-555-0126","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-10","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee41.jpg"},{"EmployeeKey":42,"ParentEmployeeKey":6,"FirstName":"Carina","LastName":"Bailey","MiddleName":"P.","Title":"Sales Store Manager","HireDate":"1999-01-10","BirthDate":"1979-05-17","EmailAddress":"CarinaBailey@contoso.com","Phone":"286-555-0189","MaritalStatus":"M","EmergencyContactName":"Maurice Taylor","EmergencyContactPhone":"286-555-0189","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-10","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee42.jpg"},{"EmployeeKey":43,"ParentEmployeeKey":6,"FirstName":"Daron","LastName":"Bullock","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-10","BirthDate":"1966-04-19","EmailAddress":"DaronBullock@contoso.com","Phone":"164-555-0164","MaritalStatus":"M","EmergencyContactName":"Roya Asbari","EmergencyContactPhone":"164-555-0164","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Quality Assurance","StartDate":"1999-01-10","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee43.jpg"},{"EmployeeKey":44,"ParentEmployeeKey":6,"FirstName":"Amy","LastName":"Shelton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-12","BirthDate":"1966-01-13","EmailAddress":"AmyShelton@contoso.com","Phone":"685-555-0120","MaritalStatus":"S","EmergencyContactName":"Sunil Uppal","EmergencyContactPhone":"685-555-0120","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-01-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee44.jpg"},{"EmployeeKey":45,"ParentEmployeeKey":6,"FirstName":"Alan","LastName":"Vince","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-13","BirthDate":"1962-12-27","EmailAddress":"AlanVince@contoso.com","Phone":"786-555-0144","MaritalStatus":"M","EmergencyContactName":"Sameer Athalye","EmergencyContactPhone":"786-555-0144","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee45.jpg"},{"EmployeeKey":46,"ParentEmployeeKey":6,"FirstName":"Javier","LastName":"Reyes","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-13","BirthDate":"1958-10-19","EmailAddress":"JavierReyes@contoso.com","Phone":"992-555-0194","MaritalStatus":"S","EmergencyContactName":"Esther Valle","EmergencyContactPhone":"992-555-0194","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production Control","StartDate":"1999-01-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee46.jpg"},{"EmployeeKey":47,"ParentEmployeeKey":6,"FirstName":"Clint","LastName":"Moss","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-13","BirthDate":"1979-07-27","EmailAddress":"ClintMoss@contoso.com","Phone":"818-555-0192","MaritalStatus":"S","EmergencyContactName":"Kai Axford","EmergencyContactPhone":"818-555-0192","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee47.jpg"},{"EmployeeKey":48,"ParentEmployeeKey":6,"FirstName":"Chadwick","LastName":"Eastwood","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-13","BirthDate":"1977-06-21","EmailAddress":"ChadwickEastwood@contoso.com","Phone":"399-555-0176","MaritalStatus":"S","EmergencyContactName":"Darren Waite","EmergencyContactPhone":"399-555-0176","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1999-01-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee48.jpg"},{"EmployeeKey":49,"ParentEmployeeKey":6,"FirstName":"Clint","LastName":"Matthews","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-14","BirthDate":"1968-08-18","EmailAddress":"ClintMatthews@contoso.com","Phone":"778-555-0141","MaritalStatus":"S","EmergencyContactName":"Josh Bailey","EmergencyContactPhone":"778-555-0141","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-01-14","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee49.jpg"},{"EmployeeKey":50,"ParentEmployeeKey":6,"FirstName":"Fred","LastName":"Wright","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-15","BirthDate":"1969-08-06","EmailAddress":"FredWright@contoso.com","Phone":"299-555-0113","MaritalStatus":"S","EmergencyContactName":"David Wright","EmergencyContactPhone":"299-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee50.jpg"},{"EmployeeKey":51,"ParentEmployeeKey":6,"FirstName":"Rocco","LastName":"Palmer","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-15","BirthDate":"1966-02-18","EmailAddress":"RoccoPalmer@contoso.com","Phone":"846-555-0157","MaritalStatus":"M","EmergencyContactName":"Yossi Banai","EmergencyContactPhone":"846-555-0157","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Facilities and Maintenance","StartDate":"1999-01-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee51.jpg"},{"EmployeeKey":52,"ParentEmployeeKey":6,"FirstName":"Monica","LastName":"Neville","MiddleName":"M.","Title":"Sales Store Manager","HireDate":"1999-01-15","BirthDate":"1973-05-03","EmailAddress":"MonicaNeville@contoso.com","Phone":"639-555-0164","MaritalStatus":"S","EmergencyContactName":"Makoto Yamagishi","EmergencyContactPhone":"639-555-0164","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee52.jpg"},{"EmployeeKey":54,"ParentEmployeeKey":6,"FirstName":"Erick","LastName":"Herbert","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-16","BirthDate":"1975-03-10","EmailAddress":"ErickHerbert@contoso.com","Phone":"669-555-0150","MaritalStatus":"S","EmergencyContactName":"Arthur Yasinski","EmergencyContactPhone":"669-555-0150","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee54.jpg"},{"EmployeeKey":55,"ParentEmployeeKey":6,"FirstName":"Aiden","LastName":"Foxley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-16","BirthDate":"1975-01-30","EmailAddress":"AidenFoxley@contoso.com","Phone":"712-555-0119","MaritalStatus":"M","EmergencyContactName":"Evan Basalik","EmergencyContactPhone":"712-555-0119","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":33,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee55.jpg"},{"EmployeeKey":56,"ParentEmployeeKey":6,"FirstName":"Chadwick","LastName":"Emmott","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-17","BirthDate":"1980-05-29","EmailAddress":"ChadwickEmmott@contoso.com","Phone":"910-555-0116","MaritalStatus":"S","EmergencyContactName":"Kirk J. Nason","EmergencyContactPhone":"910-555-0116","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":76,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Document Control","StartDate":"1999-01-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee56.jpg"},{"EmployeeKey":57,"ParentEmployeeKey":6,"FirstName":"Caleb","LastName":"Neville","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-17","BirthDate":"1964-11-16","EmailAddress":"CalebNeville@contoso.com","Phone":"319-555-0139","MaritalStatus":"S","EmergencyContactName":"Josh Barnhill","EmergencyContactPhone":"319-555-0139","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":15,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee57.jpg"},{"EmployeeKey":58,"ParentEmployeeKey":6,"FirstName":"Henry","LastName":"Paterson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-18","BirthDate":"1976-01-26","EmailAddress":"HenryPaterson@contoso.com","Phone":"714-555-0138","MaritalStatus":"S","EmergencyContactName":"Neil Orint","EmergencyContactPhone":"714-555-0138","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":58,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee58.jpg"},{"EmployeeKey":59,"ParentEmployeeKey":6,"FirstName":"Rocco","LastName":"Walker","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-18","BirthDate":"1967-01-27","EmailAddress":"RoccoWalker@contoso.com","Phone":"499-555-0125","MaritalStatus":"M","EmergencyContactName":"Chris Barry","EmergencyContactPhone":"499-555-0125","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":17,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee59.jpg"},{"EmployeeKey":60,"ParentEmployeeKey":7,"FirstName":"Elijah","LastName":"Needham","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-18","BirthDate":"1968-03-28","EmailAddress":"ElijahNeedham@contoso.com","Phone":"932-555-0161","MaritalStatus":"S","EmergencyContactName":"Ian Palangio","EmergencyContactPhone":"932-555-0161","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":93,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee60.jpg"},{"EmployeeKey":61,"ParentEmployeeKey":7,"FirstName":"Evelynn","LastName":"Palmer","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-19","BirthDate":"1966-04-07","EmailAddress":"EvelynnPalmer@contoso.com","Phone":"602-555-0194","MaritalStatus":"M","EmergencyContactName":"Deborah Baumfeld","EmergencyContactPhone":"602-555-0194","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":60,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-01-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee61.jpg"},{"EmployeeKey":62,"ParentEmployeeKey":7,"FirstName":"Roger","LastName":"Wright","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-20","BirthDate":"1976-10-09","EmailAddress":"RogerWright@contoso.com","Phone":"679-555-0113","MaritalStatus":"M","EmergencyContactName":"Rajesh Ramanathan","EmergencyContactPhone":"679-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":1,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-20","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee62.jpg"},{"EmployeeKey":63,"ParentEmployeeKey":7,"FirstName":"Marina","LastName":"Robertson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-20","BirthDate":"1973-11-19","EmailAddress":"MarinaRobertson@contoso.com","Phone":"688-555-0192","MaritalStatus":"M","EmergencyContactName":"Mark Bebbington","EmergencyContactPhone":"688-555-0192","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":42,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-20","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee63.jpg"},{"EmployeeKey":64,"ParentEmployeeKey":7,"FirstName":"William","LastName":"Collins","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-22","BirthDate":"1967-05-18","EmailAddress":"WilliamCollins@contoso.com","Phone":"518-555-0199","MaritalStatus":"M","EmergencyContactName":"Tamer Salah","EmergencyContactPhone":"518-555-0199","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":26,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-22","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee64.jpg"},{"EmployeeKey":65,"ParentEmployeeKey":7,"FirstName":"Jayden","LastName":"Hobson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-23","BirthDate":"1978-06-17","EmailAddress":"JaydenHobson@contoso.com","Phone":"901-555-0125","MaritalStatus":"S","EmergencyContactName":"Parry Bedi","EmergencyContactPhone":"901-555-0125","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":69,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee65.jpg"},{"EmployeeKey":66,"ParentEmployeeKey":7,"FirstName":"Barry","LastName":"Slater","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-23","BirthDate":"1974-05-13","EmailAddress":"BarrySlater@contoso.com","Phone":"434-555-0133","MaritalStatus":"M","EmergencyContactName":"Radoslaw Szymczak","EmergencyContactPhone":"434-555-0133","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":67,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee66.jpg"},{"EmployeeKey":67,"ParentEmployeeKey":7,"FirstName":"Carl","LastName":"Saunders","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-24","BirthDate":"1957-04-02","EmailAddress":"CarlSaunders@contoso.com","Phone":"226-555-0197","MaritalStatus":"M","EmergencyContactName":"Kostadin Belishky","EmergencyContactPhone":"226-555-0197","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":10,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-24","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee67.jpg"},{"EmployeeKey":68,"ParentEmployeeKey":7,"FirstName":"Ema","LastName":"Wilson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-24","BirthDate":"1975-03-03","EmailAddress":"EmaWilson@contoso.com","Phone":"623-555-0155","MaritalStatus":"M","EmergencyContactName":"Rakesh Tangirala","EmergencyContactPhone":"623-555-0155","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":71,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-01-24","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee68.jpg"},{"EmployeeKey":69,"ParentEmployeeKey":7,"FirstName":"Harry","LastName":"Redden","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-25","BirthDate":"1969-09-16","EmailAddress":"HarryRedden@contoso.com","Phone":"611-555-0116","MaritalStatus":"S","EmergencyContactName":"Almudena Benito","EmergencyContactPhone":"611-555-0116","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":12,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee69.jpg"},{"EmployeeKey":70,"ParentEmployeeKey":7,"FirstName":"Gil","LastName":"Rose","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-25","BirthDate":"1970-11-05","EmailAddress":"GilRose@contoso.com","Phone":"793-555-0179","MaritalStatus":"M","EmergencyContactName":"Garrett Vargas","EmergencyContactPhone":"793-555-0179","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":66,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee70.jpg"},{"EmployeeKey":71,"ParentEmployeeKey":7,"FirstName":"Parker","LastName":"Norman","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-26","BirthDate":"1977-08-17","EmailAddress":"ParkerNorman@contoso.com","Phone":"612-555-0171","MaritalStatus":"M","EmergencyContactName":"Karen Berg","EmergencyContactPhone":"612-555-0171","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":96,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee71.jpg"},{"EmployeeKey":72,"ParentEmployeeKey":7,"FirstName":"Camellia","LastName":"King","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-26","BirthDate":"1974-12-22","EmailAddress":"CamelliaKing@contoso.com","Phone":"522-555-0147","MaritalStatus":"M","EmergencyContactName":"Larry Waldman","EmergencyContactPhone":"522-555-0147","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":51,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-01-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee72.jpg"},{"EmployeeKey":73,"ParentEmployeeKey":7,"FirstName":"Adina","LastName":"Wright","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-26","BirthDate":"1974-11-12","EmailAddress":"AdinaWright@contoso.com","Phone":"248-555-0134","MaritalStatus":"S","EmergencyContactName":"Martin Berka","EmergencyContactPhone":"248-555-0134","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":55,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-01-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee73.jpg"},{"EmployeeKey":74,"ParentEmployeeKey":7,"FirstName":"Dakota","LastName":"Weatcroft","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-27","BirthDate":"1974-06-01","EmailAddress":"DakotaWeatcroft@contoso.com","Phone":"309-555-0129","MaritalStatus":"S","EmergencyContactName":"Norimichi Yonekura","EmergencyContactPhone":"309-555-0129","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":98,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Shipping and Receiving","StartDate":"1999-01-27","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee74.jpg"},{"EmployeeKey":75,"ParentEmployeeKey":7,"FirstName":"Moira","LastName":"Wood","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-27","BirthDate":"1965-12-06","EmailAddress":"MoiraWood@contoso.com","Phone":"896-555-0168","MaritalStatus":"M","EmergencyContactName":"Matthias Berndt","EmergencyContactPhone":"896-555-0168","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":37,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-27","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee75.jpg"},{"EmployeeKey":76,"ParentEmployeeKey":7,"FirstName":"Anthony","LastName":"Long","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-28","BirthDate":"1970-05-30","EmailAddress":"AnthonyLong@contoso.com","Phone":"999-555-0155","MaritalStatus":"S","EmergencyContactName":"Amr Zaki","EmergencyContactPhone":"999-555-0155","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":78,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-28","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee76.jpg"},{"EmployeeKey":77,"ParentEmployeeKey":8,"FirstName":"Mark","LastName":"Carson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-28","BirthDate":"1975-12-26","EmailAddress":"MarkCarson@contoso.com","Phone":"808-555-0172","MaritalStatus":"M","EmergencyContactName":"Dana Birkby","EmergencyContactPhone":"808-555-0172","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":80,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-28","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee77.jpg"},{"EmployeeKey":79,"ParentEmployeeKey":8,"FirstName":"Abdul","LastName":"Turner","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-29","BirthDate":"1966-04-07","EmailAddress":"AbdulTurner@contoso.com","Phone":"420-555-0173","MaritalStatus":"S","EmergencyContactName":"Scott Bishop","EmergencyContactPhone":"420-555-0173","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":82,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Quality Assurance","StartDate":"1999-01-29","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee79.jpg"},{"EmployeeKey":80,"ParentEmployeeKey":8,"FirstName":"Matthew","LastName":"Woods","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-29","BirthDate":"1977-01-01","EmailAddress":"MatthewWoods@contoso.com","Phone":"143-555-0173","MaritalStatus":"S","EmergencyContactName":"Jeremy Nelson","EmergencyContactPhone":"143-555-0173","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":21,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-29","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee80.jpg"},{"EmployeeKey":81,"ParentEmployeeKey":8,"FirstName":"Aileen","LastName":"Rivers","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-30","BirthDate":"1976-07-06","EmailAddress":"AileenRivers@contoso.com","Phone":"815-555-0138","MaritalStatus":"S","EmergencyContactName":"Neil Black","EmergencyContactPhone":"815-555-0138","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":62,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Research and Development","StartDate":"1999-01-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee81.jpg"},{"EmployeeKey":82,"ParentEmployeeKey":8,"FirstName":"Allison","LastName":"Wigley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-01-30","BirthDate":"1967-08-11","EmailAddress":"AllisonWigley@contoso.com","Phone":"314-555-0113","MaritalStatus":"M","EmergencyContactName":"Belinda Newman","EmergencyContactPhone":"314-555-0113","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":23,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-01-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee82.jpg"},{"EmployeeKey":83,"ParentEmployeeKey":8,"FirstName":"Matthew","LastName":"Victor","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-01","BirthDate":"1967-11-05","EmailAddress":"MatthewVictor@contoso.com","Phone":"373-555-0137","MaritalStatus":"M","EmergencyContactName":"Nikhil Bobde","EmergencyContactPhone":"373-555-0137","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":48,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee83.jpg"},{"EmployeeKey":84,"ParentEmployeeKey":8,"FirstName":"Nicholas","LastName":"Gray","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-02","BirthDate":"1974-09-02","EmailAddress":"NicholasGray@contoso.com","Phone":"153-555-0186","MaritalStatus":"S","EmergencyContactName":"Chad Niswonger","EmergencyContactPhone":"153-555-0186","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":50,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-02-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee84.jpg"},{"EmployeeKey":85,"ParentEmployeeKey":8,"FirstName":"Percy","LastName":"Ashwell","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-02","BirthDate":"1968-07-01","EmailAddress":"PercyAshwell@contoso.com","Phone":"172-555-0130","MaritalStatus":"S","EmergencyContactName":"Catherine Boeger","EmergencyContactPhone":"172-555-0130","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":91,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee85.jpg"},{"EmployeeKey":86,"ParentEmployeeKey":8,"FirstName":"Candice","LastName":"Fox","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-03","BirthDate":"1978-12-21","EmailAddress":"CandiceFox@contoso.com","Phone":"970-555-0118","MaritalStatus":"M","EmergencyContactName":"Elly Nkya","EmergencyContactPhone":"970-555-0118","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":34,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee86.jpg"},{"EmployeeKey":87,"ParentEmployeeKey":8,"FirstName":"Harry","LastName":"Thomson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-03","BirthDate":"1962-10-11","EmailAddress":"HarryThomson@contoso.com","Phone":"577-555-0185","MaritalStatus":"S","EmergencyContactName":"Srikanth Bolisetty","EmergencyContactPhone":"577-555-0185","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":93,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Shipping and Receiving","StartDate":"1999-02-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee87.jpg"},{"EmployeeKey":88,"ParentEmployeeKey":8,"FirstName":"Boris","LastName":"Jarrett","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-03","BirthDate":"1971-09-04","EmailAddress":"BorisJarrett@contoso.com","Phone":"373-555-0142","MaritalStatus":"S","EmergencyContactName":"Chris Norred","EmergencyContactPhone":"373-555-0142","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":32,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee88.jpg"},{"EmployeeKey":89,"ParentEmployeeKey":8,"FirstName":"Rocco","LastName":"Sheldon","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-04","BirthDate":"1973-08-02","EmailAddress":"RoccoSheldon@contoso.com","Phone":"986-555-0177","MaritalStatus":"S","EmergencyContactName":"Luis Bonifaz","EmergencyContactPhone":"986-555-0177","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":73,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee89.jpg"},{"EmployeeKey":90,"ParentEmployeeKey":8,"FirstName":"Margaret","LastName":"Shaw","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-04","BirthDate":"1971-01-26","EmailAddress":"MargaretShaw@contoso.com","Phone":"777-555-0141","MaritalStatus":"S","EmergencyContactName":"Tad Orman","EmergencyContactPhone":"777-555-0141","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":75,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee90.jpg"},{"EmployeeKey":91,"ParentEmployeeKey":8,"FirstName":"Karla","LastName":"Clarke","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-05","BirthDate":"1976-06-20","EmailAddress":"KarlaClarke@contoso.com","Phone":"818-555-0128","MaritalStatus":"M","EmergencyContactName":"Randall Boseman","EmergencyContactPhone":"818-555-0128","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":18,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee91.jpg"},{"EmployeeKey":92,"ParentEmployeeKey":8,"FirstName":"Hank","LastName":"Patel","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-05","BirthDate":"1966-03-02","EmailAddress":"HankPatel@contoso.com","Phone":"204-555-0115","MaritalStatus":"M","EmergencyContactName":"Jon Orton","EmergencyContactPhone":"204-555-0115","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":77,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Document Control","StartDate":"1999-02-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee92.jpg"},{"EmployeeKey":93,"ParentEmployeeKey":8,"FirstName":"Andrea","LastName":"Donnelly","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-05","BirthDate":"1978-12-28","EmailAddress":"AndreaDonnelly@contoso.com","Phone":"845-555-0184","MaritalStatus":"M","EmergencyContactName":"Eli Bowen","EmergencyContactPhone":"845-555-0184","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":49,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee93.jpg"},{"EmployeeKey":94,"ParentEmployeeKey":8,"FirstName":"Jack","LastName":"Walsh","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-05","BirthDate":"1979-03-19","EmailAddress":"JackWalsh@contoso.com","Phone":"935-555-0116","MaritalStatus":"S","EmergencyContactName":"Inna Ozhogina","EmergencyContactPhone":"935-555-0116","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":16,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee94.jpg"},{"EmployeeKey":95,"ParentEmployeeKey":8,"FirstName":"Tony","LastName":"Nielson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-06","BirthDate":"1962-07-15","EmailAddress":"TonyNielson@contoso.com","Phone":"208-555-0114","MaritalStatus":"M","EmergencyContactName":"Jonas Brandel","EmergencyContactPhone":"208-555-0114","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":59,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee95.jpg"},{"EmployeeKey":96,"ParentEmployeeKey":8,"FirstName":"Ellen","LastName":"Cox","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-07","BirthDate":"1966-03-26","EmailAddress":"EllenCox@contoso.com","Phone":"920-555-0177","MaritalStatus":"S","EmergencyContactName":"Prakash Paramasivam","EmergencyContactPhone":"920-555-0177","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":61,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-02-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee96.jpg"},{"EmployeeKey":97,"ParentEmployeeKey":8,"FirstName":"Tom","LastName":"Selby","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-07","BirthDate":"1969-04-29","EmailAddress":"TomSelby@contoso.com","Phone":"913-555-0184","MaritalStatus":"S","EmergencyContactName":"Dushyant Bansal","EmergencyContactPhone":"913-555-0184","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":2,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee97.jpg"},{"EmployeeKey":98,"ParentEmployeeKey":8,"FirstName":"Tom","LastName":"Addley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-08","BirthDate":"1971-12-08","EmailAddress":"TomAddley@contoso.com","Phone":"148-555-0145","MaritalStatus":"M","EmergencyContactName":"Darren Parker","EmergencyContactPhone":"148-555-0145","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":45,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production Control","StartDate":"1999-02-08","EndDate":"2001-10-01","Status":"NULL","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee98.jpg"},{"EmployeeKey":99,"ParentEmployeeKey":8,"FirstName":"Mike","LastName":"Eyres","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-08","BirthDate":"1971-12-08","EmailAddress":"MikeEyres@contoso.com","Phone":"148-555-0145","MaritalStatus":"M","EmergencyContactName":"Peter Brehm","EmergencyContactPhone":"148-555-0145","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":45,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production Control","StartDate":"2001-10-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee99.jpg"},{"EmployeeKey":100,"ParentEmployeeKey":8,"FirstName":"Chester","LastName":"Parker","MiddleName":"M.","Title":"Sales Store Manager","HireDate":"1999-02-08","BirthDate":"1979-12-08","EmailAddress":"ChesterParker@contoso.com","Phone":"199-555-0117","MaritalStatus":"S","EmergencyContactName":"Sanjay Patel","EmergencyContactPhone":"199-555-0117","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":43,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":"/images/contoso/EmployeePhotos/Employee100.jpg"},{"EmployeeKey":101,"ParentEmployeeKey":8,"FirstName":"Chester","LastName":"Griffiths","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-09","BirthDate":"1977-03-13","EmailAddress":"ChesterGriffiths@contoso.com","Phone":"391-555-0138","MaritalStatus":"M","EmergencyContactName":"Markus Breyer","EmergencyContactPhone":"391-555-0138","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":86,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":102,"ParentEmployeeKey":8,"FirstName":"Barney","LastName":"Grey","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-11","BirthDate":"1981-02-04","EmailAddress":"BarneyGrey@contoso.com","Phone":"454-555-0119","MaritalStatus":"S","EmergencyContactName":"Michael Patten","EmergencyContactPhone":"454-555-0119","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":70,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-11","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":103,"ParentEmployeeKey":8,"FirstName":"Tom","LastName":"Shaw","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-12","BirthDate":"1964-10-24","EmailAddress":"TomShaw@contoso.com","Phone":"200-555-0117","MaritalStatus":"M","EmergencyContactName":"David Bristol","EmergencyContactPhone":"200-555-0117","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":11,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":104,"ParentEmployeeKey":8,"FirstName":"Danny","LastName":"Patel","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-12","BirthDate":"1967-03-07","EmailAddress":"DannyPatel@contoso.com","Phone":"768-555-0123","MaritalStatus":"S","EmergencyContactName":"Flemming Pedersen","EmergencyContactPhone":"768-555-0123","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":13,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":105,"ParentEmployeeKey":8,"FirstName":"Mark","LastName":"Huggins","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-12","BirthDate":"1971-07-28","EmailAddress":"MarkHuggins@contoso.com","Phone":"166-555-0159","MaritalStatus":"M","EmergencyContactName":"Jed Brown","EmergencyContactPhone":"166-555-0159","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":72,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-02-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":106,"ParentEmployeeKey":8,"FirstName":"Rocco","LastName":"Hopkins","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-13","BirthDate":"1954-07-23","EmailAddress":"RoccoHopkins@contoso.com","Phone":"477-555-0132","MaritalStatus":"S","EmergencyContactName":"Laurent Penisson","EmergencyContactPhone":"477-555-0132","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":56,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-02-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":107,"ParentEmployeeKey":8,"FirstName":"Eduardo","LastName":"Uddin","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-13","BirthDate":"1963-02-25","EmailAddress":"EduardoUddin@contoso.com","Phone":"582-555-0178","MaritalStatus":"M","EmergencyContactName":"Scott Brown","EmergencyContactPhone":"582-555-0178","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":7,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":108,"ParentEmployeeKey":8,"FirstName":"Kaylee","LastName":"Abbey","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-13","BirthDate":"1977-03-13","EmailAddress":"KayleeAbbey@contoso.com","Phone":"476-555-0119","MaritalStatus":"M","EmergencyContactName":"Lionel Penuchot","EmergencyContactPhone":"476-555-0119","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":54,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":109,"ParentEmployeeKey":8,"FirstName":"Bethany","LastName":"Thatcher","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-13","BirthDate":"1952-10-14","EmailAddress":"BethanyThatcher@contoso.com","Phone":"531-555-0183","MaritalStatus":"M","EmergencyContactName":"Chloe Brussard","EmergencyContactPhone":"531-555-0183","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":46,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1999-02-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":110,"ParentEmployeeKey":9,"FirstName":"Barney","LastName":"Jones","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-14","BirthDate":"1968-06-07","EmailAddress":"BarneyJones@contoso.com","Phone":"637-555-0120","MaritalStatus":"M","EmergencyContactName":"Tom Perham","EmergencyContactPhone":"637-555-0120","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":97,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-14","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":111,"ParentEmployeeKey":9,"FirstName":"Chuck","LastName":"Hamilton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-15","BirthDate":"1975-02-20","EmailAddress":"ChuckHamilton@contoso.com","Phone":"260-555-0119","MaritalStatus":"M","EmergencyContactName":"Susan Burk","EmergencyContactPhone":"260-555-0119","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":112,"ParentEmployeeKey":9,"FirstName":"Danny","LastName":"Terry","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-15","BirthDate":"1959-03-02","EmailAddress":"DannyTerry@contoso.com","Phone":"697-555-0142","MaritalStatus":"S","EmergencyContactName":"Cristian Petculescu","EmergencyContactPhone":"697-555-0142","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":99,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Executive","StartDate":"1999-02-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":113,"ParentEmployeeKey":9,"FirstName":"Benny","LastName":"Lakey","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-15","BirthDate":"1979-01-08","EmailAddress":"BennyLakey@contoso.com","Phone":"571-555-0179","MaritalStatus":"S","EmergencyContactName":"Ovidiu Burlacu","EmergencyContactPhone":"571-555-0179","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":38,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":114,"ParentEmployeeKey":9,"FirstName":"Oliver","LastName":"Wilkinson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-16","BirthDate":"1976-05-31","EmailAddress":"OliverWilkinson@contoso.com","Phone":"147-555-0179","MaritalStatus":"S","EmergencyContactName":"Pierangela Pezzini","EmergencyContactPhone":"147-555-0179","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":83,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Quality Assurance","StartDate":"1999-02-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":115,"ParentEmployeeKey":9,"FirstName":"Marjorie","LastName":"Nicolas","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-16","BirthDate":"1962-08-25","EmailAddress":"MarjorieNicolas@contoso.com","Phone":"540-555-0191","MaritalStatus":"S","EmergencyContactName":"Dennis Bye","EmergencyContactPhone":"540-555-0191","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":81,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":116,"ParentEmployeeKey":9,"FirstName":"Phillip","LastName":"Hall","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-17","BirthDate":"1976-11-24","EmailAddress":"PhillipHall@contoso.com","Phone":"234-555-0169","MaritalStatus":"M","EmergencyContactName":"Jeff Phillips","EmergencyContactPhone":"234-555-0169","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":22,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":117,"ParentEmployeeKey":9,"FirstName":"Paula","LastName":"Davies","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-17","BirthDate":"1969-02-21","EmailAddress":"PaulaDavies@contoso.com","Phone":"185-555-0186","MaritalStatus":"M","EmergencyContactName":"Randy Byrne","EmergencyContactPhone":"185-555-0186","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":63,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Research and Development","StartDate":"1999-02-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":118,"ParentEmployeeKey":9,"FirstName":"Julius","LastName":"Ellison","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-18","BirthDate":"1980-12-05","EmailAddress":"JuliusEllison@contoso.com","Phone":"727-555-0112","MaritalStatus":"M","EmergencyContactName":"Guido Pica","EmergencyContactPhone":"727-555-0112","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":6,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":119,"ParentEmployeeKey":9,"FirstName":"Barry","LastName":"Rivers","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-18","BirthDate":"1977-10-07","EmailAddress":"BarryRivers@contoso.com","Phone":"158-555-0191","MaritalStatus":"M","EmergencyContactName":"Ryan Calafato","EmergencyContactPhone":"158-555-0191","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":56,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":120,"ParentEmployeeKey":9,"FirstName":"Ryan","LastName":"Mitchell","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-18","BirthDate":"1965-06-17","EmailAddress":"RyanMitchell@contoso.com","Phone":"785-555-0110","MaritalStatus":"S","EmergencyContactName":"Armando Pinto","EmergencyContactPhone":"785-555-0110","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":67,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-02-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":121,"ParentEmployeeKey":9,"FirstName":"Emely","LastName":"Pratt","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-19","BirthDate":"1979-09-10","EmailAddress":"EmelyPratt@contoso.com","Phone":"361-555-0180","MaritalStatus":"S","EmergencyContactName":"Geert Camelbeke","EmergencyContactPhone":"361-555-0180","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":8,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":122,"ParentEmployeeKey":9,"FirstName":"Melanie","LastName":"Ogilvy","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-19","BirthDate":"1969-07-19","EmailAddress":"MelanieOgilvy@contoso.com","Phone":"510-555-0121","MaritalStatus":"M","EmergencyContactName":"Idan Plonsky","EmergencyContactPhone":"510-555-0121","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":47,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1999-02-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":123,"ParentEmployeeKey":9,"FirstName":"Luna","LastName":"Brett","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-21","BirthDate":"1981-07-01","EmailAddress":"LunaBrett@contoso.com","Phone":"150-555-0194","MaritalStatus":"S","EmergencyContactName":"David Campbell","EmergencyContactPhone":"150-555-0194","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":92,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-21","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":124,"ParentEmployeeKey":9,"FirstName":"Harry","LastName":"Lloyd","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-21","BirthDate":"1963-12-13","EmailAddress":"HarryLloyd@contoso.com","Phone":"139-555-0120","MaritalStatus":"M","EmergencyContactName":"Toni Poe","EmergencyContactPhone":"139-555-0120","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":94,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Shipping and Receiving","StartDate":"1999-02-21","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":125,"ParentEmployeeKey":9,"FirstName":"Martin","LastName":"Cunningham","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-22","BirthDate":"1963-09-28","EmailAddress":"MartinCunningham@contoso.com","Phone":"712-555-0113","MaritalStatus":"S","EmergencyContactName":"Fabrice Canel","EmergencyContactPhone":"712-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":35,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-22","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":126,"ParentEmployeeKey":9,"FirstName":"Javier","LastName":"Scott","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-22","BirthDate":"1967-02-16","EmailAddress":"JavierScott@contoso.com","Phone":"350-555-0167","MaritalStatus":"M","EmergencyContactName":"Carole Poland","EmergencyContactPhone":"350-555-0167","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":74,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-22","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":127,"ParentEmployeeKey":9,"FirstName":"Leroy","LastName":"Roberts","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-22","BirthDate":"1977-08-15","EmailAddress":"LeroyRoberts@contoso.com","Phone":"241-555-0191","MaritalStatus":"S","EmergencyContactName":"Jon Cantrell","EmergencyContactPhone":"241-555-0191","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":33,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-22","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":128,"ParentEmployeeKey":9,"FirstName":"Stacy","LastName":"Knight","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-23","BirthDate":"1969-08-02","EmailAddress":"StacyKnight@contoso.com","Phone":"119-555-0192","MaritalStatus":"M","EmergencyContactName":"Laura Steele Polly","EmergencyContactPhone":"119-555-0192","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":17,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":129,"ParentEmployeeKey":9,"FirstName":"Caleb","LastName":"Burge","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-23","BirthDate":"1979-01-17","EmailAddress":"CalebBurge@contoso.com","Phone":"200-555-0112","MaritalStatus":"M","EmergencyContactName":"Richard Carey","EmergencyContactPhone":"200-555-0112","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":76,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":130,"ParentEmployeeKey":9,"FirstName":"Daniel","LastName":"Davies","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-23","BirthDate":"1977-04-12","EmailAddress":"DanielDavies@contoso.com","Phone":"205-555-0132","MaritalStatus":"S","EmergencyContactName":"Houman Pournasseh","EmergencyContactPhone":"205-555-0132","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":78,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Document Control","StartDate":"1999-02-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":131,"ParentEmployeeKey":9,"FirstName":"David","LastName":"Gibbons","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-23","BirthDate":"1966-02-06","EmailAddress":"DavidGibbons@contoso.com","Phone":"653-555-0144","MaritalStatus":"M","EmergencyContactName":"Ty Carlson","EmergencyContactPhone":"653-555-0144","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":66,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-02-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":132,"ParentEmployeeKey":9,"FirstName":"Alexander","LastName":"Hepburn","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-24","BirthDate":"1969-10-26","EmailAddress":"AlexanderHepburn@contoso.com","Phone":"417-555-0154","MaritalStatus":"S","EmergencyContactName":"Jeff Price","EmergencyContactPhone":"417-555-0154","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":19,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-24","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":133,"ParentEmployeeKey":9,"FirstName":"Ron","LastName":"Appleton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-25","BirthDate":"1974-10-22","EmailAddress":"RonAppleton@contoso.com","Phone":"935-555-0199","MaritalStatus":"S","EmergencyContactName":"Rob Caron","EmergencyContactPhone":"935-555-0199","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":62,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-02-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":134,"ParentEmployeeKey":9,"FirstName":"Wade","LastName":"Wooldridge","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-26","BirthDate":"1961-09-30","EmailAddress":"WadeWooldridge@contoso.com","Phone":"180-555-0136","MaritalStatus":"M","EmergencyContactName":"Markus Rankenburg","EmergencyContactPhone":"180-555-0136","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":3,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":135,"ParentEmployeeKey":9,"FirstName":"Hayden","LastName":"Fox","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-27","BirthDate":"1978-01-22","EmailAddress":"HaydenFox@contoso.com","Phone":"500-555-0159","MaritalStatus":"M","EmergencyContactName":"Adam Carter","EmergencyContactPhone":"500-555-0159","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":46,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production Control","StartDate":"1999-02-27","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":136,"ParentEmployeeKey":9,"FirstName":"Gil","LastName":"Woodcock","MiddleName":"B.","Title":"Sales Store Manager","HireDate":"1999-02-27","BirthDate":"1972-07-28","EmailAddress":"GilWoodcock@contoso.com","Phone":"984-555-0148","MaritalStatus":"S","EmergencyContactName":"Rui Raposo","EmergencyContactPhone":"984-555-0148","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":44,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-27","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":137,"ParentEmployeeKey":9,"FirstName":"Nicholas","LastName":"Downing","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-28","BirthDate":"1976-02-06","EmailAddress":"NicholasDowning@contoso.com","Phone":"533-555-0111","MaritalStatus":"S","EmergencyContactName":"Rob Cason","EmergencyContactPhone":"533-555-0111","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":28,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-28","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":138,"ParentEmployeeKey":9,"FirstName":"Charlotte","LastName":"Douglas","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-28","BirthDate":"1971-09-19","EmailAddress":"CharlotteDouglas@contoso.com","Phone":"352-555-0138","MaritalStatus":"S","EmergencyContactName":"Andrew Rath","EmergencyContactPhone":"352-555-0138","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":69,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-28","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":139,"ParentEmployeeKey":9,"FirstName":"Vanessa","LastName":"Ross","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-02-28","BirthDate":"1980-12-02","EmailAddress":"VanessaRoss@contoso.com","Phone":"446-555-0118","MaritalStatus":"M","EmergencyContactName":"Joao Casqueiro","EmergencyContactPhone":"446-555-0118","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":87,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-02-28","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":140,"ParentEmployeeKey":9,"FirstName":"Aurelia","LastName":"Driscoll","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-02","BirthDate":"1979-10-30","EmailAddress":"AureliaDriscoll@contoso.com","Phone":"955-555-0169","MaritalStatus":"M","EmergencyContactName":"Rodrigo Ready","EmergencyContactPhone":"955-555-0169","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":14,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":141,"ParentEmployeeKey":9,"FirstName":"Nicholas","LastName":"Varley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-02","BirthDate":"1967-03-14","EmailAddress":"NicholasVarley@contoso.com","Phone":"110-555-0182","MaritalStatus":"S","EmergencyContactName":"Matt Cavallari","EmergencyContactPhone":"110-555-0182","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":55,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":142,"ParentEmployeeKey":9,"FirstName":"Nicholas","LastName":"Douglas","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-03","BirthDate":"1973-08-08","EmailAddress":"NicholasDouglas@contoso.com","Phone":"646-555-0185","MaritalStatus":"M","EmergencyContactName":"Jamie Reding","EmergencyContactPhone":"646-555-0185","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":57,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-03-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":143,"ParentEmployeeKey":9,"FirstName":"Jenna","LastName":"Tyler","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-04","BirthDate":"1966-02-06","EmailAddress":"JennaTyler@contoso.com","Phone":"615-555-0110","MaritalStatus":"M","EmergencyContactName":"Ural Cebeci","EmergencyContactPhone":"615-555-0110","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":0,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Executive","StartDate":"1999-03-04","EndDate":"2003-12-15","Status":"NULL","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":144,"ParentEmployeeKey":9,"FirstName":"Florence","LastName":"Ross","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-04","BirthDate":"1966-02-06","EmailAddress":"FlorenceRoss@contoso.com","Phone":"615-555-0110","MaritalStatus":"M","EmergencyContactName":"Miles Reid","EmergencyContactPhone":"615-555-0110","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":0,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Executive","StartDate":"2003-12-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":145,"ParentEmployeeKey":9,"FirstName":"Danny","LastName":"Lee","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-04","BirthDate":"1964-06-03","EmailAddress":"DannyLee@contoso.com","Phone":"441-555-0195","MaritalStatus":"S","EmergencyContactName":"Gareth Chan","EmergencyContactPhone":"441-555-0195","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":98,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":146,"ParentEmployeeKey":9,"FirstName":"Danny","LastName":"Kelly","MiddleName":"T.","Title":"Sales Store Manager","HireDate":"1999-03-04","BirthDate":"1973-11-20","EmailAddress":"DannyKelly@contoso.com","Phone":"118-555-0110","MaritalStatus":"M","EmergencyContactName":"Olivier Renaud","EmergencyContactPhone":"118-555-0110","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":39,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":147,"ParentEmployeeKey":9,"FirstName":"Nathan","LastName":"Walsh","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-05","BirthDate":"1967-05-08","EmailAddress":"NathanWalsh@contoso.com","Phone":"965-555-0155","MaritalStatus":"M","EmergencyContactName":"Mathew Charles","EmergencyContactPhone":"965-555-0155","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":41,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":148,"ParentEmployeeKey":9,"FirstName":"Owen","LastName":"Leigh","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-06","BirthDate":"1975-04-01","EmailAddress":"OwenLeigh@contoso.com","Phone":"589-555-0147","MaritalStatus":"S","EmergencyContactName":"Delphine Ribaute","EmergencyContactPhone":"589-555-0147","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":82,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":149,"ParentEmployeeKey":9,"FirstName":"Benny","LastName":"Greenwood","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-06","BirthDate":"1979-04-29","EmailAddress":"BennyGreenwood@contoso.com","Phone":"181-555-0124","MaritalStatus":"M","EmergencyContactName":"Mohammad Chami","EmergencyContactPhone":"181-555-0124","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":84,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Quality Assurance","StartDate":"1999-03-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":150,"ParentEmployeeKey":9,"FirstName":"Denny","LastName":"Speed","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-06","BirthDate":"1979-02-09","EmailAddress":"DennySpeed@contoso.com","Phone":"678-555-0110","MaritalStatus":"M","EmergencyContactName":"Shawn Richardson","EmergencyContactPhone":"678-555-0110","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":23,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":151,"ParentEmployeeKey":9,"FirstName":"Marigold","LastName":"Williams","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-07","BirthDate":"1967-11-06","EmailAddress":"MarigoldWilliams@contoso.com","Phone":"696-555-0157","MaritalStatus":"S","EmergencyContactName":"Francisco Chaves","EmergencyContactPhone":"696-555-0157","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":12,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":152,"ParentEmployeeKey":9,"FirstName":"Cedrick","LastName":"Morris","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-07","BirthDate":"1973-02-07","EmailAddress":"CedrickMorris@contoso.com","Phone":"870-555-0122","MaritalStatus":"S","EmergencyContactName":"Jack S. Richins","EmergencyContactPhone":"870-555-0122","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":64,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":153,"ParentEmployeeKey":9,"FirstName":"Josh","LastName":"Kirby","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-07","BirthDate":"1978-04-14","EmailAddress":"JoshKirby@contoso.com","Phone":"182-555-0134","MaritalStatus":"S","EmergencyContactName":"Jacky Chen","EmergencyContactPhone":"182-555-0134","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":73,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-03-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":154,"ParentEmployeeKey":9,"FirstName":"Chanelle","LastName":"Rehman","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-08","BirthDate":"1974-04-26","EmailAddress":"ChanelleRehman@contoso.com","Phone":"594-555-0110","MaritalStatus":"S","EmergencyContactName":"Bjarne Riis","EmergencyContactPhone":"594-555-0110","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":68,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-03-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":155,"ParentEmployeeKey":9,"FirstName":"Sofie","LastName":"Gaynor","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-08","BirthDate":"1977-12-23","EmailAddress":"SofieGaynor@contoso.com","Phone":"587-555-0114","MaritalStatus":"M","EmergencyContactName":"Martin Chisholm","EmergencyContactPhone":"587-555-0114","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":7,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":156,"ParentEmployeeKey":9,"FirstName":"Domenic","LastName":"Rose","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-09","BirthDate":"1979-12-12","EmailAddress":"DomenicRose@contoso.com","Phone":"368-555-0113","MaritalStatus":"S","EmergencyContactName":"Juan-Carlos Rivas","EmergencyContactPhone":"368-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":50,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":157,"ParentEmployeeKey":9,"FirstName":"Tania","LastName":"Middleton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-09","BirthDate":"1978-08-07","EmailAddress":"TaniaMiddleton@contoso.com","Phone":"869-555-0119","MaritalStatus":"M","EmergencyContactName":"Manish Chopra","EmergencyContactPhone":"869-555-0119","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":9,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":158,"ParentEmployeeKey":9,"FirstName":"Bryon","LastName":"Roman","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-10","BirthDate":"1967-05-19","EmailAddress":"BryonRoman@contoso.com","Phone":"806-555-0136","MaritalStatus":"S","EmergencyContactName":"Scott Rockfeld","EmergencyContactPhone":"806-555-0136","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":52,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-03-10","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":159,"ParentEmployeeKey":9,"FirstName":"Mason","LastName":"Waterson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-12","BirthDate":"1980-05-14","EmailAddress":"MasonWaterson@contoso.com","Phone":"819-555-0198","MaritalStatus":"M","EmergencyContactName":"Terri Chudzik","EmergencyContactPhone":"819-555-0198","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":77,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":160,"ParentEmployeeKey":9,"FirstName":"Ethan","LastName":"Addis","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-12","BirthDate":"1966-03-13","EmailAddress":"EthanAddis@contoso.com","Phone":"173-555-0179","MaritalStatus":"S","EmergencyContactName":"Marek Rolecki","EmergencyContactPhone":"173-555-0179","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":36,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":161,"ParentEmployeeKey":9,"FirstName":"Matthew","LastName":"Varley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-12","BirthDate":"1967-02-11","EmailAddress":"MatthewVarley@contoso.com","Phone":"429-555-0137","MaritalStatus":"M","EmergencyContactName":"Ken Circeo","EmergencyContactPhone":"429-555-0137","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":22,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":162,"ParentEmployeeKey":9,"FirstName":"Jayden","LastName":"Attwood","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-12","BirthDate":"1977-03-27","EmailAddress":"JaydenAttwood@contoso.com","Phone":"181-555-0156","MaritalStatus":"M","EmergencyContactName":"Daniel Roman","EmergencyContactPhone":"181-555-0156","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":61,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Research and Development","StartDate":"1999-03-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":163,"ParentEmployeeKey":9,"FirstName":"Kurt","LastName":"Jeffery","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-12","BirthDate":"1980-06-24","EmailAddress":"KurtJeffery@contoso.com","Phone":"810-555-0178","MaritalStatus":"S","EmergencyContactName":"Pat Coleman","EmergencyContactPhone":"810-555-0178","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":75,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":164,"ParentEmployeeKey":9,"FirstName":"Harry","LastName":"Bennett","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-13","BirthDate":"1976-05-06","EmailAddress":"HarryBennett@contoso.com","Phone":"201-555-0163","MaritalStatus":"M","EmergencyContactName":"Tali Roth","EmergencyContactPhone":"201-555-0163","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":18,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":165,"ParentEmployeeKey":9,"FirstName":"Phoebe","LastName":"Ross","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-13","BirthDate":"1966-01-25","EmailAddress":"PhoebeRoss@contoso.com","Phone":"746-555-0164","MaritalStatus":"M","EmergencyContactName":"Peter Connelly","EmergencyContactPhone":"746-555-0164","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":79,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Document Control","StartDate":"1999-03-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":166,"ParentEmployeeKey":9,"FirstName":"Chadwick","LastName":"Coates","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-14","BirthDate":"1974-09-01","EmailAddress":"ChadwickCoates@contoso.com","Phone":"587-555-0115","MaritalStatus":"M","EmergencyContactName":"Todd Rowe","EmergencyContactPhone":"587-555-0115","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":20,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-14","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":167,"ParentEmployeeKey":9,"FirstName":"Chadwick","LastName":"Phillips","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-14","BirthDate":"1976-04-21","EmailAddress":"ChadwickPhillips@contoso.com","Phone":"140-555-0132","MaritalStatus":"S","EmergencyContactName":"Jeroen Cool","EmergencyContactPhone":"140-555-0132","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":0,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-14","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":168,"ParentEmployeeKey":9,"FirstName":"Alan","LastName":"Farrant","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-14","BirthDate":"1974-09-18","EmailAddress":"AlanFarrant@contoso.com","Phone":"309-555-0170","MaritalStatus":"S","EmergencyContactName":"Raimonds Rudmanis","EmergencyContactPhone":"309-555-0170","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":59,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"1999-03-14","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":169,"ParentEmployeeKey":9,"FirstName":"Tony","LastName":"Garner","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-15","BirthDate":"1968-07-27","EmailAddress":"TonyGarner@contoso.com","Phone":"990-555-0172","MaritalStatus":"M","EmergencyContactName":"Michel Cordani","EmergencyContactPhone":"990-555-0172","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":4,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":170,"ParentEmployeeKey":9,"FirstName":"Erick","LastName":"Craig","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-15","BirthDate":"1967-03-18","EmailAddress":"ErickCraig@contoso.com","Phone":"117-555-0185","MaritalStatus":"M","EmergencyContactName":"Christian Rytt","EmergencyContactPhone":"117-555-0185","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":63,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-03-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":171,"ParentEmployeeKey":9,"FirstName":"Mya","LastName":"Howard","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-16","BirthDate":"1978-11-18","EmailAddress":"MyaHoward@contoso.com","Phone":"609-555-0153","MaritalStatus":"M","EmergencyContactName":"Eva Corets","EmergencyContactPhone":"609-555-0153","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":45,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":172,"ParentEmployeeKey":9,"FirstName":"Matthew","LastName":"Attwood","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-17","BirthDate":"1963-09-05","EmailAddress":"MatthewAttwood@contoso.com","Phone":"238-555-0116","MaritalStatus":"S","EmergencyContactName":"Raymond Sam","EmergencyContactPhone":"238-555-0116","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":71,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":173,"ParentEmployeeKey":9,"FirstName":"Aiden","LastName":"Lakey","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-17","BirthDate":"1961-07-14","EmailAddress":"AidenLakey@contoso.com","Phone":"100-555-0174","MaritalStatus":"M","EmergencyContactName":"Jack Creasey","EmergencyContactPhone":"100-555-0174","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":88,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":174,"ParentEmployeeKey":9,"FirstName":"Lucas","LastName":"Taylor","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-17","BirthDate":"1974-04-30","EmailAddress":"LucasTaylor@contoso.com","Phone":"438-555-0172","MaritalStatus":"M","EmergencyContactName":"Yolanda S\u00e1nchez","EmergencyContactPhone":"438-555-0172","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":47,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production Control","StartDate":"1999-03-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":175,"ParentEmployeeKey":9,"FirstName":"Martin","LastName":"Crawford","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-18","BirthDate":"1975-10-25","EmailAddress":"MartinCrawford@contoso.com","Phone":"118-555-0177","MaritalStatus":"M","EmergencyContactName":"Grant Culbertson","EmergencyContactPhone":"118-555-0177","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":29,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":176,"ParentEmployeeKey":9,"FirstName":"Tom","LastName":"Fowler","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-19","BirthDate":"1980-11-07","EmailAddress":"TomFowler@contoso.com","Phone":"164-555-0114","MaritalStatus":"S","EmergencyContactName":"Prasanna Samarawickrama","EmergencyContactPhone":"164-555-0114","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":72,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":177,"ParentEmployeeKey":9,"FirstName":"Mark","LastName":"Gilmour","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-19","BirthDate":"1979-03-02","EmailAddress":"MarkGilmour@contoso.com","Phone":"156-555-0199","MaritalStatus":"S","EmergencyContactName":"Conor Cunningham","EmergencyContactPhone":"156-555-0199","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":70,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":178,"ParentEmployeeKey":9,"FirstName":"Johnathan","LastName":"Crawley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-19","BirthDate":"1981-05-07","EmailAddress":"JohnathanCrawley@contoso.com","Phone":"712-555-0170","MaritalStatus":"S","EmergencyContactName":"Dubravka Salopek","EmergencyContactPhone":"712-555-0170","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":31,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":179,"ParentEmployeeKey":9,"FirstName":"Parker","LastName":"Burnley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-20","BirthDate":"1977-07-11","EmailAddress":"ParkerBurnley@contoso.com","Phone":"753-555-0129","MaritalStatus":"M","EmergencyContactName":"Wojciech Czupta","EmergencyContactPhone":"753-555-0129","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":15,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-20","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":180,"ParentEmployeeKey":9,"FirstName":"Adalie","LastName":"Nash","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-20","BirthDate":"1968-06-19","EmailAddress":"AdalieNash@contoso.com","Phone":"654-555-0177","MaritalStatus":"S","EmergencyContactName":"Esko Sario","EmergencyContactPhone":"654-555-0177","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":74,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-03-20","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":181,"ParentEmployeeKey":9,"FirstName":"Denny","LastName":"Tait","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-20","BirthDate":"1975-01-09","EmailAddress":"DennyTait@contoso.com","Phone":"110-555-0115","MaritalStatus":"S","EmergencyContactName":"Ofer Daliot","EmergencyContactPhone":"110-555-0115","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":13,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-20","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":182,"ParentEmployeeKey":9,"FirstName":"Kaylee","LastName":"Corbett","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-22","BirthDate":"1966-02-04","EmailAddress":"KayleeCorbett@contoso.com","Phone":"822-555-0145","MaritalStatus":"M","EmergencyContactName":"Raman Sarin","EmergencyContactPhone":"822-555-0145","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":58,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-03-22","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":183,"ParentEmployeeKey":9,"FirstName":"Cedrick","LastName":"Cooper","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-22","BirthDate":"1980-09-04","EmailAddress":"CedrickCooper@contoso.com","Phone":"559-555-0175","MaritalStatus":"M","EmergencyContactName":"Ryan Danner","EmergencyContactPhone":"559-555-0175","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":99,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-22","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":184,"ParentEmployeeKey":9,"FirstName":"Michael","LastName":"Trent","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-23","BirthDate":"1967-10-15","EmailAddress":"MichaelTrent@contoso.com","Phone":"751-555-0134","MaritalStatus":"M","EmergencyContactName":"Naoki Sato","EmergencyContactPhone":"751-555-0134","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":40,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":185,"ParentEmployeeKey":9,"FirstName":"Colleen","LastName":"Overson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-24","BirthDate":"1959-10-19","EmailAddress":"ColleenOverson@contoso.com","Phone":"319-555-0126","MaritalStatus":"S","EmergencyContactName":"Alex Darrow","EmergencyContactPhone":"319-555-0126","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":83,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-24","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":186,"ParentEmployeeKey":9,"FirstName":"Sofia","LastName":"Newton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-24","BirthDate":"1974-12-20","EmailAddress":"SofiaNewton@contoso.com","Phone":"809-555-0133","MaritalStatus":"S","EmergencyContactName":"Kazuki Sawanoi","EmergencyContactPhone":"809-555-0133","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":42,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-24","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":187,"ParentEmployeeKey":9,"FirstName":"John","LastName":"Griffiths","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-25","BirthDate":"1972-03-14","EmailAddress":"JohnGriffiths@contoso.com","Phone":"517-555-0122","MaritalStatus":"M","EmergencyContactName":"Velimir Davidovski","EmergencyContactPhone":"517-555-0122","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":24,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":188,"ParentEmployeeKey":9,"FirstName":"Ron","LastName":"Verdon","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-25","BirthDate":"1973-07-23","EmailAddress":"RonVerdon@contoso.com","Phone":"552-555-0111","MaritalStatus":"S","EmergencyContactName":"Gary Schare","EmergencyContactPhone":"552-555-0111","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":68,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":189,"ParentEmployeeKey":9,"FirstName":"Ethan","LastName":"Vollans","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-26","BirthDate":"1978-10-08","EmailAddress":"EthanVollans@contoso.com","Phone":"908-555-0159","MaritalStatus":"S","EmergencyContactName":"Sara Davis","EmergencyContactPhone":"908-555-0159","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":65,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":190,"ParentEmployeeKey":9,"FirstName":"Tiffany","LastName":"Thatcher","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-26","BirthDate":"1976-05-10","EmailAddress":"TiffanyThatcher@contoso.com","Phone":"508-555-0129","MaritalStatus":"M","EmergencyContactName":"Janet Schorr","EmergencyContactPhone":"508-555-0129","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":67,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":191,"ParentEmployeeKey":9,"FirstName":"Domenic","LastName":"Owens","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-27","BirthDate":"1961-08-24","EmailAddress":"DomenicOwens@contoso.com","Phone":"167-555-0139","MaritalStatus":"S","EmergencyContactName":"Marlowe Dayley","EmergencyContactPhone":"167-555-0139","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":10,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-27","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":192,"ParentEmployeeKey":9,"FirstName":"Erick","LastName":"Atkinson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-27","BirthDate":"1970-06-29","EmailAddress":"ErickAtkinson@contoso.com","Phone":"310-555-0133","MaritalStatus":"S","EmergencyContactName":"Thorsten Scholl","EmergencyContactPhone":"310-555-0133","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":69,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Information Services","StartDate":"1999-03-27","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":193,"ParentEmployeeKey":9,"FirstName":"Candace","LastName":"Shields","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-27","BirthDate":"1964-10-06","EmailAddress":"CandaceShields@contoso.com","Phone":"106-555-0120","MaritalStatus":"S","EmergencyContactName":"Aidan Delaney","EmergencyContactPhone":"106-555-0120","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":8,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-27","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":194,"ParentEmployeeKey":9,"FirstName":"Russel","LastName":"Bloom","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-28","BirthDate":"1971-06-29","EmailAddress":"RusselBloom@contoso.com","Phone":"949-555-0174","MaritalStatus":"M","EmergencyContactName":"Steve Schmidt","EmergencyContactPhone":"949-555-0174","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":51,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-28","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":195,"ParentEmployeeKey":9,"FirstName":"Liam","LastName":"Webster","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-29","BirthDate":"1966-05-18","EmailAddress":"LiamWebster@contoso.com","Phone":"955-555-0131","MaritalStatus":"S","EmergencyContactName":"Eduard Dell","EmergencyContactPhone":"955-555-0131","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":66,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Human Resources","StartDate":"1999-03-29","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":196,"ParentEmployeeKey":9,"FirstName":"Lucas","LastName":"Buckley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-29","BirthDate":"1979-07-17","EmailAddress":"LucasBuckley@contoso.com","Phone":"817-555-0186","MaritalStatus":"S","EmergencyContactName":"James Seymour","EmergencyContactPhone":"817-555-0186","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":94,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-29","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":197,"ParentEmployeeKey":10,"FirstName":"John","LastName":"Gilmore","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-30","BirthDate":"1978-04-15","EmailAddress":"JohnGilmore@contoso.com","Phone":"450-555-0152","MaritalStatus":"S","EmergencyContactName":"Stephen Deming","EmergencyContactPhone":"450-555-0152","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":78,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":198,"ParentEmployeeKey":10,"FirstName":"Benny","LastName":"Robinson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-30","BirthDate":"1976-02-11","EmailAddress":"BennyRobinson@contoso.com","Phone":"278-555-0118","MaritalStatus":"M","EmergencyContactName":"Shish Shridhar","EmergencyContactPhone":"278-555-0118","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":37,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":199,"ParentEmployeeKey":10,"FirstName":"Carl","LastName":"Knight","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-30","BirthDate":"1975-06-05","EmailAddress":"CarlKnight@contoso.com","Phone":"927-555-0168","MaritalStatus":"M","EmergencyContactName":"Bruno Denuit","EmergencyContactPhone":"927-555-0168","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":96,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Shipping and Receiving","StartDate":"1999-03-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":200,"ParentEmployeeKey":10,"FirstName":"Boris","LastName":"Wheeler","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-30","BirthDate":"1972-10-19","EmailAddress":"BorisWheeler@contoso.com","Phone":"296-555-0121","MaritalStatus":"M","EmergencyContactName":"Edmund Silva","EmergencyContactPhone":"296-555-0121","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":35,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":201,"ParentEmployeeKey":10,"FirstName":"Michaela","LastName":"Tailor","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-03-30","BirthDate":"1970-08-19","EmailAddress":"MichaelaTailor@contoso.com","Phone":"289-555-0196","MaritalStatus":"S","EmergencyContactName":"Shane DeSeranno","EmergencyContactPhone":"289-555-0196","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":76,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-03-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":202,"ParentEmployeeKey":10,"FirstName":"Barry","LastName":"Summers","MiddleName":"J.","Title":"Sales Store Manager","HireDate":"1999-04-01","BirthDate":"1964-09-21","EmailAddress":"BarrySummers@contoso.com","Phone":"848-555-0163","MaritalStatus":"M","EmergencyContactName":"Britta Simon","EmergencyContactPhone":"848-555-0163","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":60,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"1999-04-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":203,"ParentEmployeeKey":10,"FirstName":"Wade","LastName":"Hardwick","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-01","BirthDate":"1966-01-21","EmailAddress":"WadeHardwick@contoso.com","Phone":"165-555-0113","MaritalStatus":"S","EmergencyContactName":"Craig Dewar","EmergencyContactPhone":"165-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":19,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":204,"ParentEmployeeKey":10,"FirstName":"Kieth","LastName":"Cassidy","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-01","BirthDate":"1967-11-27","EmailAddress":"KiethCassidy@contoso.com","Phone":"869-555-0125","MaritalStatus":"S","EmergencyContactName":"Katherine Simpson","EmergencyContactPhone":"869-555-0125","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":80,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Quality Assurance","StartDate":"1999-04-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":205,"ParentEmployeeKey":10,"FirstName":"Judith","LastName":"Baldwin","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-02","BirthDate":"1969-04-09","EmailAddress":"JudithBaldwin@contoso.com","Phone":"393-555-0186","MaritalStatus":"M","EmergencyContactName":"Holly Dickson","EmergencyContactPhone":"393-555-0186","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":64,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-04-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":206,"ParentEmployeeKey":10,"FirstName":"Remy","LastName":"Wilkinson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-03","BirthDate":"1980-02-26","EmailAddress":"RemyWilkinson@contoso.com","Phone":"318-555-0137","MaritalStatus":"M","EmergencyContactName":"Soumya Singhi","EmergencyContactPhone":"318-555-0137","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":5,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":207,"ParentEmployeeKey":10,"FirstName":"Chris","LastName":"Horton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-03","BirthDate":"1976-03-07","EmailAddress":"ChrisHorton@contoso.com","Phone":"138-555-0118","MaritalStatus":"M","EmergencyContactName":"Andrew Dixon","EmergencyContactPhone":"138-555-0118","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":44,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"1999-04-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":208,"ParentEmployeeKey":10,"FirstName":"Oliver","LastName":"Woodcock","MiddleName":"L.","Title":"Sales Store Manager","HireDate":"1999-04-04","BirthDate":"1972-04-24","EmailAddress":"OliverWoodcock@contoso.com","Phone":"663-555-0172","MaritalStatus":"S","EmergencyContactName":"Morgan Skinner","EmergencyContactPhone":"663-555-0172","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":27,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":209,"ParentEmployeeKey":10,"FirstName":"Dani","LastName":"Calderwood","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-04","BirthDate":"1973-06-13","EmailAddress":"DaniCalderwood@contoso.com","Phone":"224-555-0187","MaritalStatus":"M","EmergencyContactName":"Jane Dow","EmergencyContactPhone":"224-555-0187","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":46,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":210,"ParentEmployeeKey":10,"FirstName":"Boris","LastName":"Ralph","MiddleName":"Ivar","Title":"Sales Store Manager","HireDate":"1999-04-04","BirthDate":"1974-09-12","EmailAddress":"BorisRalph@contoso.com","Phone":"313-555-0196","MaritalStatus":"M","EmergencyContactName":"Randy Slycord","EmergencyContactPhone":"313-555-0196","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":48,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production Control","StartDate":"1999-04-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":211,"ParentEmployeeKey":10,"FirstName":"Colleen","LastName":"Gordon","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-05","BirthDate":"1977-07-07","EmailAddress":"ColleenGordon@contoso.com","Phone":"785-555-0132","MaritalStatus":"S","EmergencyContactName":"Patricia Doyle","EmergencyContactPhone":"785-555-0132","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":89,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":212,"ParentEmployeeKey":10,"FirstName":"Leroy","LastName":"Ballard","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-06","BirthDate":"1966-03-14","EmailAddress":"LeroyBallard@contoso.com","Phone":"407-555-0165","MaritalStatus":"S","EmergencyContactName":"Denise Smith","EmergencyContactPhone":"407-555-0165","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":32,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":213,"ParentEmployeeKey":10,"FirstName":"Oliver","LastName":"Eagle","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-06","BirthDate":"1964-12-16","EmailAddress":"OliverEagle@contoso.com","Phone":"139-555-0131","MaritalStatus":"S","EmergencyContactName":"Dominik Dubicki","EmergencyContactPhone":"139-555-0131","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":30,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":214,"ParentEmployeeKey":10,"FirstName":"Jaylene","LastName":"Hunt","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-06","BirthDate":"1973-03-31","EmailAddress":"JayleneHunt@contoso.com","Phone":"142-555-0139","MaritalStatus":"M","EmergencyContactName":"Derek Snyder","EmergencyContactPhone":"142-555-0139","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":71,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":215,"ParentEmployeeKey":10,"FirstName":"Eduardo","LastName":"Rothwell","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-07","BirthDate":"1978-10-26","EmailAddress":"EduardoRothwell@contoso.com","Phone":"207-555-0192","MaritalStatus":"S","EmergencyContactName":"Marina Dukhon","EmergencyContactPhone":"207-555-0192","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":73,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":216,"ParentEmployeeKey":10,"FirstName":"Anthony","LastName":"Exton","MiddleName":"G.","Title":"Sales Store Manager","HireDate":"1999-04-07","BirthDate":"1977-06-26","EmailAddress":"AnthonyExton@contoso.com","Phone":"575-555-0126","MaritalStatus":"M","EmergencyContactName":"Tony Smith","EmergencyContactPhone":"575-555-0126","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":75,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Document Control","StartDate":"1999-04-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":217,"ParentEmployeeKey":10,"FirstName":"Doug","LastName":"Walton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-08","BirthDate":"1976-09-07","EmailAddress":"DougWalton@contoso.com","Phone":"315-555-0144","MaritalStatus":"S","EmergencyContactName":"Adrian Dumitrascu","EmergencyContactPhone":"315-555-0144","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":16,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":218,"ParentEmployeeKey":10,"FirstName":"Agnes","LastName":"Nurton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-08","BirthDate":"1977-01-08","EmailAddress":"AgnesNurton@contoso.com","Phone":"991-555-0184","MaritalStatus":"S","EmergencyContactName":"Christof Sprenger","EmergencyContactPhone":"991-555-0184","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":14,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":219,"ParentEmployeeKey":10,"FirstName":"Wade","LastName":"Fowler","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-09","BirthDate":"1978-06-11","EmailAddress":"WadeFowler@contoso.com","Phone":"310-555-0117","MaritalStatus":"M","EmergencyContactName":"Daniel Durrer","EmergencyContactPhone":"310-555-0117","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":57,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"1999-04-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":220,"ParentEmployeeKey":10,"FirstName":"Nick","LastName":"Stevenson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-04-09","BirthDate":"1969-08-01","EmailAddress":"NickStevenson@contoso.com","Phone":"927-555-0150","MaritalStatus":"S","EmergencyContactName":"Jamie Stark","EmergencyContactPhone":"927-555-0150","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":59,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Finance","StartDate":"1999-04-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":221,"ParentEmployeeKey":10,"FirstName":"Nick","LastName":"Lee","MiddleName":null,"Title":"Sales Store Manager","HireDate":"1999-06-04","BirthDate":"1975-01-01","EmailAddress":"NickLee@contoso.com","Phone":"330-555-2568","MaritalStatus":"M","EmergencyContactName":"Maria Dykstra","EmergencyContactPhone":"330-555-2568","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":16,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Research and Development","StartDate":"1999-06-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":222,"ParentEmployeeKey":10,"FirstName":"Michael","LastName":"Robertson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-03","BirthDate":"1961-03-21","EmailAddress":"MichaelRobertson@contoso.com","Phone":"110-555-0112","MaritalStatus":"M","EmergencyContactName":"Heidi Steen","EmergencyContactPhone":"110-555-0112","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":86,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Facilities and Maintenance","StartDate":"2000-01-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":223,"ParentEmployeeKey":10,"FirstName":"Chuck","LastName":"Williams","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-04","BirthDate":"1961-10-03","EmailAddress":"ChuckWilliams@contoso.com","Phone":"931-555-0118","MaritalStatus":"S","EmergencyContactName":"Krittiya Eamsiri","EmergencyContactPhone":"931-555-0118","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":27,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":224,"ParentEmployeeKey":10,"FirstName":"Gabriel","LastName":"Dixon","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-07","BirthDate":"1976-10-23","EmailAddress":"GabrielDixon@contoso.com","Phone":"202-555-0187","MaritalStatus":"S","EmergencyContactName":"Kern Sutton","EmergencyContactPhone":"202-555-0187","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":93,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":225,"ParentEmployeeKey":10,"FirstName":"Martin","LastName":"Ellis","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-12","BirthDate":"1960-12-13","EmailAddress":"MartinEllis@contoso.com","Phone":"492-555-0174","MaritalStatus":"M","EmergencyContactName":"Mads Ebdrup","EmergencyContactPhone":"492-555-0174","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":4,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":226,"ParentEmployeeKey":10,"FirstName":"Boris","LastName":"Fields","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-12","BirthDate":"1961-01-23","EmailAddress":"BorisFields@contoso.com","Phone":"730-555-0117","MaritalStatus":"S","EmergencyContactName":"Ram Thirunavukkarasu","EmergencyContactPhone":"730-555-0117","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":63,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":227,"ParentEmployeeKey":10,"FirstName":"Maia","LastName":"Jenkins","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-18","BirthDate":"1960-12-31","EmailAddress":"MaiaJenkins@contoso.com","Phone":"916-555-0165","MaritalStatus":"M","EmergencyContactName":"Alexander Eggerer","EmergencyContactPhone":"916-555-0165","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":56,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2000-01-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":228,"ParentEmployeeKey":10,"FirstName":"Grace","LastName":"Moreno","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-19","BirthDate":"1933-01-17","EmailAddress":"GraceMoreno@contoso.com","Phone":"405-555-0171","MaritalStatus":"S","EmergencyContactName":"Tien Dung Thoi","EmergencyContactPhone":"405-555-0171","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":99,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":229,"ParentEmployeeKey":10,"FirstName":"Gil","LastName":"Griffiths","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-22","BirthDate":"1961-09-27","EmailAddress":"GilGriffiths@contoso.com","Phone":"583-555-0182","MaritalStatus":"M","EmergencyContactName":"Mohamed Elkugia","EmergencyContactPhone":"583-555-0182","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":87,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Facilities and Maintenance","StartDate":"2000-01-22","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":230,"ParentEmployeeKey":10,"FirstName":"Phillip","LastName":"Jackson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-23","BirthDate":"1960-04-07","EmailAddress":"PhillipJackson@contoso.com","Phone":"447-555-0186","MaritalStatus":"S","EmergencyContactName":"Alicia Thornber","EmergencyContactPhone":"447-555-0186","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":28,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":231,"ParentEmployeeKey":10,"FirstName":"Angelique","LastName":"Avery","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-26","BirthDate":"1976-10-20","EmailAddress":"AngeliqueAvery@contoso.com","Phone":"283-555-0185","MaritalStatus":"M","EmergencyContactName":"Heiko Elmsheuser","EmergencyContactPhone":"283-555-0185","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":94,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":232,"ParentEmployeeKey":10,"FirstName":"George","LastName":"Phillips","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-26","BirthDate":"1976-10-20","EmailAddress":"GeorgePhillips@contoso.com","Phone":"555-555-0113","MaritalStatus":"S","EmergencyContactName":"Steven Thorpe","EmergencyContactPhone":"555-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":90,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":233,"ParentEmployeeKey":10,"FirstName":"Michael","LastName":"Saunders","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-01-30","BirthDate":"1961-04-09","EmailAddress":"MichaelSaunders@contoso.com","Phone":"733-555-0128","MaritalStatus":"S","EmergencyContactName":"Terry Eminhizer","EmergencyContactPhone":"733-555-0128","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":64,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-01-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":234,"ParentEmployeeKey":10,"FirstName":"Bridget","LastName":"Widdows","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-02","BirthDate":"1976-10-11","EmailAddress":"BridgetWiddows@contoso.com","Phone":"264-555-0150","MaritalStatus":"M","EmergencyContactName":"Hung-Fu Ting","EmergencyContactPhone":"264-555-0150","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":89,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-02","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":235,"ParentEmployeeKey":10,"FirstName":"Mason","LastName":"Craig","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-05","BirthDate":"1960-12-25","EmailAddress":"MasonCraig@contoso.com","Phone":"520-555-0177","MaritalStatus":"M","EmergencyContactName":"Alexei Eremenko","EmergencyContactPhone":"520-555-0177","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":57,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2000-02-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":236,"ParentEmployeeKey":10,"FirstName":"Oliver","LastName":"Saunders","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-07","BirthDate":"1961-11-23","EmailAddress":"OliverSaunders@contoso.com","Phone":"497-555-0181","MaritalStatus":"S","EmergencyContactName":"Richard Turner","EmergencyContactPhone":"497-555-0181","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":0,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":237,"ParentEmployeeKey":10,"FirstName":"Aiden","LastName":"Cartwright","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-12","BirthDate":"1932-12-30","EmailAddress":"AidenCartwright@contoso.com","Phone":"230-555-0144","MaritalStatus":"M","EmergencyContactName":"Daniel Escapa","EmergencyContactPhone":"230-555-0144","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":52,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2000-02-12","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":238,"ParentEmployeeKey":10,"FirstName":"Isabel","LastName":"Benfield","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-13","BirthDate":"1976-10-14","EmailAddress":"IsabelBenfield@contoso.com","Phone":"123-555-0167","MaritalStatus":"S","EmergencyContactName":"Raja D. Venugopal","EmergencyContactPhone":"123-555-0167","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":95,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-13","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":239,"ParentEmployeeKey":6,"FirstName":"Selena","LastName":"Carpenter","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-17","BirthDate":"1933-01-14","EmailAddress":"SelenaCarpenter@contoso.com","Phone":"208-555-0114","MaritalStatus":"M","EmergencyContactName":"John Evans","EmergencyContactPhone":"208-555-0114","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":24,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":240,"ParentEmployeeKey":6,"FirstName":"Liam","LastName":"Baker","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-18","BirthDate":"1961-01-03","EmailAddress":"LiamBaker@contoso.com","Phone":"166-555-0156","MaritalStatus":"S","EmergencyContactName":"Giorgio Veronesi","EmergencyContactPhone":"166-555-0156","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":65,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":241,"ParentEmployeeKey":6,"FirstName":"William","LastName":"Latham","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-23","BirthDate":"1943-06-01","EmailAddress":"WilliamLatham@contoso.com","Phone":"129-555-0199","MaritalStatus":"M","EmergencyContactName":"Sten Faerch","EmergencyContactPhone":"129-555-0199","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":5,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":242,"ParentEmployeeKey":6,"FirstName":"Cedrick","LastName":"Dickson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-24","BirthDate":"1942-06-13","EmailAddress":"CedrickDickson@contoso.com","Phone":"163-555-0147","MaritalStatus":"M","EmergencyContactName":"Aldis Vilums","EmergencyContactPhone":"163-555-0147","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":58,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2000-02-24","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":243,"ParentEmployeeKey":6,"FirstName":"Ryan","LastName":"Rainford","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-25","BirthDate":"1964-10-11","EmailAddress":"RyanRainford@contoso.com","Phone":"590-555-0152","MaritalStatus":"M","EmergencyContactName":"Maciej Fedorow","EmergencyContactPhone":"590-555-0152","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":1,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":244,"ParentEmployeeKey":6,"FirstName":"Mason","LastName":"Flynn","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-02-25","BirthDate":"1933-01-08","EmailAddress":"MasonFlynn@contoso.com","Phone":"680-555-0118","MaritalStatus":"M","EmergencyContactName":"Rob Walters","EmergencyContactPhone":"680-555-0118","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":60,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-02-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":246,"ParentEmployeeKey":6,"FirstName":"Gabriel","LastName":"Palmer","MiddleName":"J.","Title":"Sales Store Manager","HireDate":"2000-02-28","BirthDate":"1961-01-03","EmailAddress":"GabrielPalmer@contoso.com","Phone":"720-555-0158","MaritalStatus":"S","EmergencyContactName":"Gregory Weber","EmergencyContactPhone":"720-555-0158","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":89,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Facilities and Maintenance","StartDate":"2000-02-28","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":247,"ParentEmployeeKey":6,"FirstName":"Martin","LastName":"Hall","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-01","BirthDate":"1945-03-02","EmailAddress":"MartinHall@contoso.com","Phone":"237-555-0128","MaritalStatus":"S","EmergencyContactName":"Walter Felhofer","EmergencyContactPhone":"237-555-0128","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":30,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":248,"ParentEmployeeKey":6,"FirstName":"Britney","LastName":"Aldridge","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-03","BirthDate":"1961-02-04","EmailAddress":"BritneyAldridge@contoso.com","Phone":"842-555-0158","MaritalStatus":"S","EmergencyContactName":"Maira Wenzel","EmergencyContactPhone":"842-555-0158","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":66,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2000-03-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":249,"ParentEmployeeKey":6,"FirstName":"John","LastName":"Ellery","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-04","BirthDate":"1976-10-11","EmailAddress":"JohnEllery@contoso.com","Phone":"413-555-0124","MaritalStatus":"S","EmergencyContactName":"Burke Fewel","EmergencyContactPhone":"413-555-0124","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":96,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":250,"ParentEmployeeKey":6,"FirstName":"Barney","LastName":"Robinson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-08","BirthDate":"1942-04-03","EmailAddress":"BarneyRobinson@contoso.com","Phone":"203-555-0196","MaritalStatus":"M","EmergencyContactName":"Jim Wickham","EmergencyContactPhone":"203-555-0196","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":66,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":251,"ParentEmployeeKey":6,"FirstName":"Chris","LastName":"Button","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-08","BirthDate":"1961-10-12","EmailAddress":"ChrisButton@contoso.com","Phone":"919-555-0140","MaritalStatus":"S","EmergencyContactName":"Heinrich Fischer","EmergencyContactPhone":"919-555-0140","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":25,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-08","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":252,"ParentEmployeeKey":6,"FirstName":"Rocco","LastName":"Ebbs","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-11","BirthDate":"1976-11-01","EmailAddress":"RoccoEbbs@contoso.com","Phone":"153-555-0166","MaritalStatus":"M","EmergencyContactName":"Rainer Witte","EmergencyContactPhone":"153-555-0166","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":91,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-11","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":253,"ParentEmployeeKey":6,"FirstName":"David","LastName":"Gosling","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-15","BirthDate":"1964-01-24","EmailAddress":"DavidGosling@contoso.com","Phone":"425-555-0117","MaritalStatus":"M","EmergencyContactName":"Florence Flipo","EmergencyContactPhone":"425-555-0117","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":61,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":254,"ParentEmployeeKey":6,"FirstName":"Eduardo","LastName":"Hill","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-16","BirthDate":"1961-10-06","EmailAddress":"EduardoHill@contoso.com","Phone":"491-555-0183","MaritalStatus":"S","EmergencyContactName":"Joanna Yuan","EmergencyContactPhone":"491-555-0183","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":2,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":255,"ParentEmployeeKey":6,"FirstName":"Rita","LastName":"Hobbs","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-19","BirthDate":"1960-08-31","EmailAddress":"RitaHobbs@contoso.com","Phone":"295-555-0161","MaritalStatus":"M","EmergencyContactName":"Olivier Fontana","EmergencyContactPhone":"295-555-0161","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":90,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Facilities and Maintenance","StartDate":"2000-03-19","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":256,"ParentEmployeeKey":6,"FirstName":"Charlotte","LastName":"Osmond","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-23","BirthDate":"1976-10-08","EmailAddress":"CharlotteOsmond@contoso.com","Phone":"500-555-0172","MaritalStatus":"S","EmergencyContactName":"Erwin Zischka","EmergencyContactPhone":"500-555-0172","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":97,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":257,"ParentEmployeeKey":6,"FirstName":"Anthony","LastName":"Dowson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-26","BirthDate":"1933-01-05","EmailAddress":"AnthonyDowson@contoso.com","Phone":"325-555-0137","MaritalStatus":"M","EmergencyContactName":"Viggo Forde","EmergencyContactPhone":"325-555-0137","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":85,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Quality Assurance","StartDate":"2000-03-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":258,"ParentEmployeeKey":6,"FirstName":"Elijah","LastName":"Gunn","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-26","BirthDate":"1963-10-07","EmailAddress":"ElijahGunn@contoso.com","Phone":"582-555-0148","MaritalStatus":"S","EmergencyContactName":"Satomi Hayakawa","EmergencyContactPhone":"582-555-0148","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":26,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":259,"ParentEmployeeKey":6,"FirstName":"Julian","LastName":"Nielson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-26","BirthDate":"1960-05-29","EmailAddress":"JulianNielson@contoso.com","Phone":"961-555-0122","MaritalStatus":"M","EmergencyContactName":"Garth Fort","EmergencyContactPhone":"961-555-0122","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":29,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-26","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":260,"ParentEmployeeKey":6,"FirstName":"Matthew","LastName":"Murray","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-03-30","BirthDate":"1976-10-29","EmailAddress":"MatthewMurray@contoso.com","Phone":"254-555-0114","MaritalStatus":"S","EmergencyContactName":"Roger Harui","EmergencyContactPhone":"254-555-0114","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":92,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-03-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":261,"ParentEmployeeKey":6,"FirstName":"Hayden","LastName":"Wood","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-04-03","BirthDate":"1963-09-30","EmailAddress":"HaydenWood@contoso.com","Phone":"521-555-0113","MaritalStatus":"S","EmergencyContactName":"Jill Frank","EmergencyContactPhone":"521-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":62,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-04-03","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":262,"ParentEmployeeKey":6,"FirstName":"Melanie","LastName":"Baldwin","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-04-04","BirthDate":"1960-05-05","EmailAddress":"MelanieBaldwin@contoso.com","Phone":"306-555-0186","MaritalStatus":"S","EmergencyContactName":"Phyllis Harris","EmergencyContactPhone":"306-555-0186","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":3,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-04-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":263,"ParentEmployeeKey":6,"FirstName":"Chadwick","LastName":"Brown","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-04-05","BirthDate":"1962-01-17","EmailAddress":"ChadwickBrown@contoso.com","Phone":"539-555-0149","MaritalStatus":"M","EmergencyContactName":"Sven Freitag","EmergencyContactPhone":"539-555-0149","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":88,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Facilities and Maintenance","StartDate":"2000-04-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":264,"ParentEmployeeKey":6,"FirstName":"Freya","LastName":"Quinnell","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-04-07","BirthDate":"1944-05-25","EmailAddress":"FreyaQuinnell@contoso.com","Phone":"228-555-0159","MaritalStatus":"M","EmergencyContactName":"Walter Harp","EmergencyContactPhone":"228-555-0159","SalariedFlag":false,"Gender":"F","PayFrequency":1,"BaseRate":25.0000,"VacationHours":91,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Facilities and Maintenance","StartDate":"2000-04-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":265,"ParentEmployeeKey":6,"FirstName":"Matt","LastName":"Powell","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-04-09","BirthDate":"1963-07-05","EmailAddress":"MattPowell@contoso.com","Phone":"151-555-0113","MaritalStatus":"M","EmergencyContactName":"Mihail Frintu","EmergencyContactPhone":"151-555-0113","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":55,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2000-04-09","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":266,"ParentEmployeeKey":6,"FirstName":"Bart","LastName":"Wright","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2000-04-10","BirthDate":"1976-11-01","EmailAddress":"BartWright@contoso.com","Phone":"295-555-0161","MaritalStatus":"M","EmergencyContactName":"Mark Hanson","EmergencyContactPhone":"295-555-0161","SalariedFlag":false,"Gender":"M","PayFrequency":1,"BaseRate":25.0000,"VacationHours":98,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Production","StartDate":"2000-04-10","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":267,"ParentEmployeeKey":6,"FirstName":"Aiden","LastName":"Rowe","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-01-05","BirthDate":"1968-02-18","EmailAddress":"AidenRowe@contoso.com","Phone":"719-555-0181","MaritalStatus":"S","EmergencyContactName":"Don Funk","EmergencyContactPhone":"719-555-0181","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":7,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Tool Design","StartDate":"2001-01-05","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":268,"ParentEmployeeKey":6,"FirstName":"Eden","LastName":"Henderson","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-01-06","BirthDate":"1968-03-01","EmailAddress":"EdenHenderson@contoso.com","Phone":"125-555-0196","MaritalStatus":"M","EmergencyContactName":"Kerim Hanif","EmergencyContactPhone":"125-555-0196","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":50,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2001-01-06","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":269,"ParentEmployeeKey":6,"FirstName":"Leanne","LastName":"Walker","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-01-23","BirthDate":"1979-06-29","EmailAddress":"LeanneWalker@contoso.com","Phone":"473-555-0117","MaritalStatus":"M","EmergencyContactName":"Lawrie Gaffney","EmergencyContactPhone":"473-555-0117","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":8,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Tool Design","StartDate":"2001-01-23","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":270,"ParentEmployeeKey":6,"FirstName":"Liam","LastName":"Eagle","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-01-25","BirthDate":"1968-02-18","EmailAddress":"LiamEagle@contoso.com","Phone":"370-555-0163","MaritalStatus":"M","EmergencyContactName":"Jay Hamlin","EmergencyContactPhone":"370-555-0163","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":51,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2001-01-25","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":271,"ParentEmployeeKey":6,"FirstName":"Alan","LastName":"Mcleod","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-01-30","BirthDate":"1969-07-17","EmailAddress":"AlanMcleod@contoso.com","Phone":"465-555-0156","MaritalStatus":"S","EmergencyContactName":"Chris Gallagher","EmergencyContactPhone":"465-555-0156","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":3,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Engineering","StartDate":"2001-01-30","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":272,"ParentEmployeeKey":6,"FirstName":"Jacob","LastName":"York","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-02-04","BirthDate":"1941-11-17","EmailAddress":"JacobYork@contoso.com","Phone":"238-555-0197","MaritalStatus":"M","EmergencyContactName":"Thomas Hamborg","EmergencyContactPhone":"238-555-0197","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":14,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-02-04","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":273,"ParentEmployeeKey":6,"FirstName":"Shelby","LastName":"Locke","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-02-07","BirthDate":"1965-04-17","EmailAddress":"ShelbyLocke@contoso.com","Phone":"708-555-0141","MaritalStatus":"M","EmergencyContactName":"David Galvin","EmergencyContactPhone":"708-555-0141","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":41,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"2001-02-07","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":274,"ParentEmployeeKey":6,"FirstName":"Evie","LastName":"Flack","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-02-18","BirthDate":"1951-06-03","EmailAddress":"EvieFlack@contoso.com","Phone":"970-555-0138","MaritalStatus":"M","EmergencyContactName":"Pernille Halberg","EmergencyContactPhone":"970-555-0138","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":4,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Engineering","StartDate":"2001-02-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":275,"ParentEmployeeKey":6,"FirstName":"Tony","LastName":"Hill","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-03-10","BirthDate":"1968-04-06","EmailAddress":"TonyHill@contoso.com","Phone":"486-555-0150","MaritalStatus":"S","EmergencyContactName":"Debra Garcia","EmergencyContactPhone":"486-555-0150","SalariedFlag":false,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":48,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"2001-03-10","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":276,"ParentEmployeeKey":6,"FirstName":"Ally","LastName":"Ingram","MiddleName":"Kay","Title":"Sales Store Manager","HireDate":"2001-03-17","BirthDate":"1968-03-01","EmailAddress":"AllyIngram@contoso.com","Phone":"124-555-0114","MaritalStatus":"S","EmergencyContactName":"Ivo Haemels","EmergencyContactPhone":"124-555-0114","SalariedFlag":false,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":43,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Marketing","StartDate":"2001-03-17","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":277,"ParentEmployeeKey":6,"FirstName":"Aiden","LastName":"Reid","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-03-18","BirthDate":"1967-07-08","EmailAddress":"AidenReid@contoso.com","Phone":"716-555-0127","MaritalStatus":"S","EmergencyContactName":"Euan Garden","EmergencyContactPhone":"716-555-0127","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":10,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Sales","StartDate":"2001-03-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":278,"ParentEmployeeKey":6,"FirstName":"Dasha","LastName":"Harper","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-03-28","BirthDate":"1968-03-13","EmailAddress":"DashaHarper@contoso.com","Phone":"210-555-0193","MaritalStatus":"S","EmergencyContactName":"Pedro Gutierrez","EmergencyContactPhone":"210-555-0193","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":49,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2001-03-28","EndDate":"2001-08-30","Status":"NULL","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":279,"ParentEmployeeKey":6,"FirstName":"Candice","LastName":"Ross","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-03-28","BirthDate":"1968-03-13","EmailAddress":"CandiceRoss@contoso.com","Phone":"210-555-0193","MaritalStatus":"S","EmergencyContactName":"Benjamin Gay","EmergencyContactPhone":"210-555-0193","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":49,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2001-08-31","EndDate":"2002-08-15","Status":"NULL","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":280,"ParentEmployeeKey":6,"FirstName":"Paige","LastName":"Burge","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-03-28","BirthDate":"1968-03-13","EmailAddress":"PaigeBurge@contoso.com","Phone":"210-555-0193","MaritalStatus":"S","EmergencyContactName":"Daniela Guaita","EmergencyContactPhone":"210-555-0193","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":49,"CurrentFlag":true,"SalesPersonFlag":false,"DepartmentName":"Purchasing","StartDate":"2002-08-16","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":281,"ParentEmployeeKey":6,"FirstName":"Barney","LastName":"Tailor","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1959-01-26","EmailAddress":"BarneyTailor@contoso.com","Phone":"257-555-0154","MaritalStatus":"S","EmergencyContactName":"Darren Gehring","EmergencyContactPhone":"257-555-0154","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":38,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":282,"ParentEmployeeKey":7,"FirstName":"Rowan","LastName":"Wright","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1970-03-30","EmailAddress":"RowanWright@contoso.com","Phone":"883-555-0116","MaritalStatus":"M","EmergencyContactName":"Brian Groth","EmergencyContactPhone":"883-555-0116","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":27,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":283,"ParentEmployeeKey":7,"FirstName":"Lauren","LastName":"Owen","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1952-09-29","EmailAddress":"LaurenOwen@contoso.com","Phone":"517-555-0117","MaritalStatus":"S","EmergencyContactName":"Jens Geschwandtner","EmergencyContactPhone":"517-555-0117","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":24,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":284,"ParentEmployeeKey":7,"FirstName":"Benny","LastName":"Fulton","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1965-03-07","EmailAddress":"BennyFulton@contoso.com","Phone":"922-555-0165","MaritalStatus":"M","EmergencyContactName":"Geoff Grisso","EmergencyContactPhone":"922-555-0165","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":33,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":285,"ParentEmployeeKey":7,"FirstName":"Ron","LastName":"Smith","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1964-02-19","EmailAddress":"RonSmith@contoso.com","Phone":"664-555-0112","MaritalStatus":"M","EmergencyContactName":"Wriju Ghosh","EmergencyContactPhone":"664-555-0112","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":29,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":286,"ParentEmployeeKey":7,"FirstName":"Evie","LastName":"Chapman","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1965-01-06","EmailAddress":"EvieChapman@contoso.com","Phone":"340-555-0193","MaritalStatus":"S","EmergencyContactName":"Ryan Gregg","EmergencyContactPhone":"340-555-0193","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":22,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":287,"ParentEmployeeKey":7,"FirstName":"Sebastian","LastName":"Forth","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1934-04-10","EmailAddress":"SebastianForth@contoso.com","Phone":"330-555-0120","MaritalStatus":"M","EmergencyContactName":"Phil Gibbins","EmergencyContactPhone":"330-555-0120","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":26,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":288,"ParentEmployeeKey":7,"FirstName":"Marvin","LastName":"Hobbs","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1930-01-11","EmailAddress":"MarvinHobbs@contoso.com","Phone":"185-555-0169","MaritalStatus":"M","EmergencyContactName":"Chris Gray","EmergencyContactPhone":"185-555-0169","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":31,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":289,"ParentEmployeeKey":7,"FirstName":"Michael","LastName":"Potts","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2001-07-01","BirthDate":"1964-03-14","EmailAddress":"MichaelPotts@contoso.com","Phone":"740-555-0182","MaritalStatus":"S","EmergencyContactName":"Guy Gilbert","EmergencyContactPhone":"740-555-0182","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":23,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2001-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":290,"ParentEmployeeKey":7,"FirstName":"Jane","LastName":"Foxley","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2002-05-18","BirthDate":"1947-10-22","EmailAddress":"JaneFoxley@contoso.com","Phone":"775-555-0164","MaritalStatus":"M","EmergencyContactName":"Elisa Graceffo","EmergencyContactPhone":"775-555-0164","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":21,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2002-05-18","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":291,"ParentEmployeeKey":7,"FirstName":"Claire","LastName":"Chappell","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2002-07-01","BirthDate":"1958-04-18","EmailAddress":"ClaireChappell@contoso.com","Phone":"1 (11) 500 555-0145","MaritalStatus":"M","EmergencyContactName":"Adriana Giorgi","EmergencyContactPhone":"1 (11) 500 555-0145","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":37,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2002-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":292,"ParentEmployeeKey":7,"FirstName":"Logan","LastName":"Bailey","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2002-07-01","BirthDate":"1965-10-31","EmailAddress":"LoganBailey@contoso.com","Phone":"1 (11) 500 555-0117","MaritalStatus":"S","EmergencyContactName":"Jon Gordner","EmergencyContactPhone":"1 (11) 500 555-0117","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":34,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2002-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":293,"ParentEmployeeKey":7,"FirstName":"Luke","LastName":"May","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2002-11-01","BirthDate":"1968-02-06","EmailAddress":"LukeMay@contoso.com","Phone":"615-555-0153","MaritalStatus":"M","EmergencyContactName":"Jim Glynn","EmergencyContactPhone":"615-555-0153","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":39,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2002-11-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":294,"ParentEmployeeKey":7,"FirstName":"Nate","LastName":"Brown","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2003-04-15","BirthDate":"1965-02-11","EmailAddress":"NateBrown@contoso.com","Phone":"926-555-0182","MaritalStatus":"M","EmergencyContactName":"Howard Gonzalez","EmergencyContactPhone":"926-555-0182","SalariedFlag":true,"Gender":"M","PayFrequency":2,"BaseRate":25.0000,"VacationHours":20,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2003-04-15","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":295,"ParentEmployeeKey":7,"FirstName":"Makenzie","LastName":"Allen","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2003-07-01","BirthDate":"1965-08-09","EmailAddress":"MakenzieAllen@contoso.com","Phone":"1 (11) 500 555-0140","MaritalStatus":"S","EmergencyContactName":"Mete Goktepe","EmergencyContactPhone":"1 (11) 500 555-0140","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":35,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2003-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null},{"EmployeeKey":296,"ParentEmployeeKey":7,"FirstName":"Leah","LastName":"Chapman","MiddleName":null,"Title":"Sales Store Manager","HireDate":"2003-07-01","BirthDate":"1961-04-18","EmailAddress":"LeahChapman@contoso.com","Phone":"1 (11) 500 555-0190","MaritalStatus":"S","EmergencyContactName":"Maxim Goldin","EmergencyContactPhone":"1 (11) 500 555-0190","SalariedFlag":true,"Gender":"F","PayFrequency":2,"BaseRate":25.0000,"VacationHours":36,"CurrentFlag":true,"SalesPersonFlag":true,"DepartmentName":"Sales","StartDate":"2003-07-01","EndDate":null,"Status":"Current","EtlloadId":1,"LoadDate":"2009-08-01","UpdateDate":"2009-08-01","AvatarUrl":null}]}