[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