[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '20' >
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55 | 12.45 | 1996-02-03 | Production | david2@adventure-works.com | David Ortiz | 712-555-0119 | 36151748 | David | M | 2020-01-20 | Ortiz | adventure-works\david2 | M | J | 20 | 1 | 712-555-0119 | | 36 | 2020-01-20 | Current | Production Technician - WC60 | 33 |
| 178 | 12.45 | 2002-05-11 | Production | steve0@adventure-works.com | Steve Masters | 712-555-0170 | 752513276 | Steve | M | 2020-03-22 | Masters | adventure-works\steve0 | S | F | 20 | 1 | 712-555-0170 | | 35 | 2020-03-22 | Current | Production Technician - WC60 | 31 |
| 212 | 12.45 | 1987-03-18 | Production | jay0@adventure-works.com | Jay Adams | 407-555-0165 | 63179277 | Jay | M | 2020-04-09 | Adams | adventure-works\jay0 | S | G | 20 | 1 | 407-555-0165 | | 36 | 2020-04-09 | Current | Production Technician - WC60 | 32 |
| 223 | 12.45 | 1982-10-07 | Production | charles0@adventure-works.com | Charles Fitzgerald | 931-555-0118 | 537092325 | Charles | M | 2021-01-07 | Fitzgerald | adventure-works\charles0 | S | B | 20 | 1 | 931-555-0118 | | 33 | 2021-01-07 | Current | Production Technician - WC60 | 27 |
| 230 | 12.45 | 1981-04-11 | Production | karan0@adventure-works.com | Karan Khanna | 447-555-0186 | 834186596 | Karan | M | 2021-01-26 | Khanna | adventure-works\karan0 | S | R | 20 | 1 | 447-555-0186 | | 34 | 2021-01-26 | Current | Production Technician - WC60 | 28 |
| 247 | 12.45 | 1966-03-06 | Production | maciej0@adventure-works.com | Maciej Dusza | 237-555-0128 | 414476027 | Maciej | M | 2021-03-05 | Dusza | adventure-works\maciej0 | S | W | 20 | 1 | 237-555-0128 | | 35 | 2021-03-05 | Current | Production Technician - WC60 | 30 |
| 258 | 12.45 | 1984-10-10 | Production | michael7@adventure-works.com | Michael Zwilling | 582-555-0148 | 582347317 | Michael | M | 2021-03-30 | Zwilling | adventure-works\michael7 | S | J | 20 | 1 | 582-555-0148 | | 33 | 2021-03-30 | Current | Production Technician - WC60 | 26 |
| 259 | 12.45 | 1981-06-02 | Production | randy0@adventure-works.com | Randy Reeves | 961-555-0122 | 8066363 | Randy | M | 2021-03-30 | Reeves | adventure-works\randy0 | M | T | 20 | 1 | 961-555-0122 | | 34 | 2021-03-30 | Current | Production Technician - WC60 | 29 |
Generated 2025-08-04 23:45:06.837 UTC