[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '112' >
9 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | EndDate | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SalariedFlag | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 143 | 60.0962 | 1987-12-06 | Executive | laura1@adventure-works.com | Laura Norman | 615-555-0110 | 184188301 | 2025-10-13 | Laura | F | 2020-12-31 | Norman | adventure-works\laura1 | M | F | 112 | 2 | 615-555-0110 | | 1 | 20 | 2020-12-31 | Chief Financial Officer | 0 | |
| 7 | 37.5 | 1987-02-16 | Marketing | david0@adventure-works.com | David Bradley | 913-555-0172 | 24756624 | 2021-06-13 | David | M | 2019-11-19 | Bradley | adventure-works\david0 | S | M | 112 | 2 | 913-555-0172 | | 1 | 40 | 2019-11-19 | Marketing Manager | 40 | |
| 144 | 60.0962 | 1987-12-06 | Executive | laura1@adventure-works.com | Laura Norman | 615-555-0110 | 184188301 | Laura | F | 2020-12-31 | Norman | adventure-works\laura1 | M | F | 112 | 2 | 615-555-0110 | | 1 | 20 | 2025-10-13 | Current | Chief Financial Officer | 0 | |
| 8 | 37.5 | 1987-02-16 | Marketing | david0@adventure-works.com | David Bradley | 913-555-0172 | 24756624 | David | M | 2019-11-19 | Bradley | adventure-works\david0 | S | M | 112 | 2 | 913-555-0172 | | 1 | 40 | 2021-06-14 | Current | Marketing Manager | 40 | |
| 14 | 63.4615 | 1983-07-01 | Engineering | terri0@adventure-works.com | Terri Duffy | 819-555-0175 | 245797967 | Terri | F | 2019-12-31 | Duffy | adventure-works\terri0 | S | Lee | 112 | 2 | 819-555-0175 | | 1 | 20 | 2019-12-31 | Current | Vice President of Engineering | 1 | |
| 23 | 24.5192 | 1994-10-03 | Production Control | peter0@adventure-works.com | Peter Krebs | 913-555-0196 | 277173473 | Peter | M | 2020-10-31 | Krebs | adventure-works\peter0 | M | J | 112 | 2 | 913-555-0196 | | 1 | 41 | 2020-10-31 | Current | Production Control Manager | 43 | |
| 44 | 50.4808 | 1987-11-12 | Information Services | jean0@adventure-works.com | Jean Trenary | 685-555-0120 | 441044382 | Jean | F | 2020-11-10 | Trenary | adventure-works\jean0 | S | E | 112 | 2 | 685-555-0120 | | 1 | 52 | 2020-11-10 | Current | Information Services Manager | 65 | |
| 277 | 72.1154 | 1989-05-06 | Sales | brian3@adventure-works.com | Brian Welcker | 716-555-0127 | 112432117 | Brian | M | 2023-01-15 | Welcker | adventure-works\brian3 | S | S | 112 | 2 | 716-555-0127 | | 1 | 25 | 2023-01-15 | Current | Vice President of Sales | 10 | |
| 152 | 84.1346 | 2000-06-05 | Production | james1@adventure-works.com | James Hamilton | 870-555-0122 | 519899904 | James | M | 2021-01-03 | Hamilton | adventure-works\james1 | S | R | 112 | 2 | 870-555-0122 | | 1 | 52 | 2021-01-03 | Current | Vice President of Production | 64 |
Generated 2026-05-30 19:29:18.223 UTC