[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '7' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 13.4615 | 1998-07-17 | Marketing | kevin0@adventure-works.com | Kevin Brown | 150-555-0189 | 253022876 | Kevin | M | 2018-04-11 | Brown | adventure-works\kevin0 | S | F | 7 | 2 | 150-555-0189 | | 41 | 2018-04-11 | Current | Marketing Assistant | 42 |
| 109 | 14.4231 | 1973-11-27 | Marketing | mary0@adventure-works.com | Mary Gibson | 531-555-0183 | 767955365 | Mary | F | 2020-03-28 | Gibson | adventure-works\mary0 | M | E | 7 | 2 | 531-555-0183 | | 43 | 2020-03-28 | Current | Marketing Specialist | 46 |
| 207 | 14.4231 | 1997-04-20 | Marketing | terry0@adventure-works.com | Terry Eminhizer | 138-555-0118 | 243322160 | Terry | M | 2020-05-16 | Eminhizer | adventure-works\terry0 | M | J | 7 | 2 | 138-555-0118 | | 42 | 2020-05-16 | Current | Marketing Specialist | 44 |
| 273 | 13.4615 | 1986-05-31 | Marketing | wanida0@adventure-works.com | Wanida Benshoof | 708-555-0141 | 323403273 | Wanida | F | 2022-03-23 | Benshoof | adventure-works\wanida0 | M | M | 7 | 2 | 708-555-0141 | | 40 | 2022-03-23 | Current | Marketing Assistant | 41 |
| 48 | 14.4231 | 1998-08-04 | Marketing | sariya0@adventure-works.com | Sariya Harnpadoungsataya | 399-555-0176 | 95958330 | Sariya | M | 2020-02-26 | Harnpadoungsataya | adventure-works\sariya0 | S | E | 7 | 2 | 399-555-0176 | | 42 | 2020-02-26 | Current | Marketing Specialist | 45 |
| 122 | 14.4231 | 1990-09-01 | Marketing | jill0@adventure-works.com | Jill Williams | 510-555-0121 | 72636981 | Jill | F | 2020-04-03 | Williams | adventure-works\jill0 | M | A | 7 | 2 | 510-555-0121 | | 43 | 2020-04-03 | Current | Marketing Specialist | 47 |
| 275 | 14.4231 | 1989-05-20 | Marketing | john5@adventure-works.com | John Wood | 486-555-0150 | 222969461 | John | M | 2022-04-23 | Wood | adventure-works\john5 | S | L | 7 | 2 | 486-555-0150 | | 44 | 2022-04-23 | Current | Marketing Specialist | 48 |
| 276 | 13.4615 | 1989-04-14 | Marketing | mary2@adventure-works.com | Mary Dempsey | 124-555-0114 | 52541318 | Mary | F | 2022-04-30 | Dempsey | adventure-works\mary2 | S | A | 7 | 2 | 124-555-0114 | | 41 | 2022-04-30 | Current | Marketing Assistant | 43 |
Generated 2025-09-13 17:34:31.144 UTC