[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '46' >
5 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | EndDate | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 174 | 16 | 1995-07-28 | Production Control | alan0@adventure-works.com | Alan Brewer | 438-555-0172 | 470689086 | Alan | M | 2020-06-13 | Brewer | adventure-works\alan0 | M | J | 46 | 2 | 438-555-0172 | | 43 | 2020-06-13 | Current | Scheduling Assistant | 47 | |
| 210 | 16 | 1995-12-10 | Production Control | brian1@adventure-works.com | Brian LaMee | 313-555-0196 | 368691270 | Brian | M | 2020-07-01 | LaMee | adventure-works\brian1 | M | P | 46 | 2 | 313-555-0196 | | 44 | 2020-07-01 | Current | Scheduling Assistant | 48 | |
| 98 | 16 | 1993-03-06 | Production Control | william0@adventure-works.com | William Vong | 148-555-0145 | 621209647 | 2022-12-29 | William | M | 2020-05-07 | Vong | adventure-works\william0 | M | S | 46 | 2 | 148-555-0145 | | 42 | 2020-05-07 | Scheduling Assistant | 45 | |
| 99 | 16 | 1993-03-06 | Production Control | william0@adventure-works.com | William Vong | 148-555-0145 | 621209647 | William | M | 2020-05-07 | Vong | adventure-works\william0 | M | S | 46 | 2 | 148-555-0145 | | 42 | 2022-12-30 | Current | Scheduling Assistant | 45 | |
| 135 | 16 | 1999-04-21 | Production Control | sairaj0@adventure-works.com | Sairaj Uddin | 500-555-0159 | 981495526 | Sairaj | M | 2020-05-26 | Uddin | adventure-works\sairaj0 | M | L | 46 | 2 | 500-555-0159 | | 43 | 2020-05-26 | Current | Scheduling Assistant | 46 |
Generated 2025-10-28 17:33:35.360 UTC