[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '51' >
4 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 246 | 9.25 | 1982-04-03 | Facilities and Maintenance | pat0@adventure-works.com | Pat Coleman | 720-555-0158 | 646304055 | Pat | M | 2021-05-28 | Coleman | adventure-works\pat0 | S | H | 51 | 1 | 720-555-0158 | | 64 | 2021-05-28 | Current | Janitor | 89 |
| 255 | 9.25 | 1981-11-29 | Facilities and Maintenance | lori1@adventure-works.com | Lori Penor | 295-555-0161 | 879334904 | Lori | F | 2021-06-17 | Penor | adventure-works\lori1 | M | K | 51 | 1 | 295-555-0161 | | 65 | 2021-06-17 | Current | Janitor | 90 |
| 263 | 9.25 | 1983-04-17 | Facilities and Maintenance | stuart1@adventure-works.com | Stuart Macrae | 539-555-0149 | 28414965 | Stuart | M | 2021-07-04 | Macrae | adventure-works\stuart1 | M | J | 51 | 1 | 539-555-0149 | | 64 | 2021-07-04 | Current | Janitor | 88 |
| 264 | 9.25 | 1965-08-23 | Facilities and Maintenance | jo1@adventure-works.com | Jo Berry | 228-555-0159 | 153479919 | Jo | F | 2021-07-06 | Berry | adventure-works\jo1 | M | L | 51 | 1 | 228-555-0159 | | 65 | 2021-07-06 | Current | Janitor | 91 |
Generated 2025-10-29 11:42:35.295 UTC