[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '23' >
24 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SalariedFlag | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76 | 25 | 1991-04-04 | Production | kok-ho0@adventure-works.com | Kok-Ho Loh | 999-555-0155 | 778552911 | Kok-Ho | M | 2019-12-03 | Loh | adventure-works\kok-ho0 | S | T | 23 | 2 | 999-555-0155 | | 59 | 2019-12-03 | Current | Production Supervisor - WC50 | 78 | |
| 87 | 19.2308 | 1983-08-16 | Shipping and Receiving | pilar0@adventure-works.com | Pilar Ackerman | 577-555-0185 | 521265716 | Pilar | M | 2019-12-09 | Ackerman | adventure-works\pilar0 | S | G | 23 | 2 | 577-555-0185 | | 1 | 66 | 2019-12-09 | Current | Shipping and Receiving Supervisor | 93 |
| 89 | 25 | 1994-06-07 | Production | david4@adventure-works.com | David Hamilton | 986-555-0177 | 750905084 | David | M | 2019-12-10 | Hamilton | adventure-works\david4 | S | P | 23 | 2 | 986-555-0177 | | 56 | 2019-12-10 | Current | Production Supervisor - WC40 | 73 | |
| 111 | 25 | 1995-12-26 | Production | eric0@adventure-works.com | Eric Gubbels | 260-555-0119 | 45615666 | Eric | M | 2019-12-21 | Gubbels | adventure-works\eric0 | M | 23 | 2 | 260-555-0119 | | 40 | 2019-12-21 | Current | Production Supervisor - WC20 | 40 | ||
| 126 | 25 | 1987-12-22 | Production | jeff0@adventure-works.com | Jeff Hay | 350-555-0167 | 712885347 | Jeff | M | 2019-12-28 | Hay | adventure-works\jeff0 | M | V | 23 | 2 | 350-555-0167 | | 57 | 2019-12-28 | Current | Production Supervisor - WC45 | 74 | |
| 138 | 25 | 1992-07-24 | Production | cynthia0@adventure-works.com | Cynthia Randall | 352-555-0138 | 386315192 | Cynthia | F | 2020-01-03 | Randall | adventure-works\cynthia0 | S | S | 23 | 2 | 352-555-0138 | | 54 | 2020-01-03 | Current | Production Supervisor - WC30 | 69 | |
| 147 | 25 | 1988-03-12 | Production | yuhong0@adventure-works.com | Yuhong Li | 965-555-0155 | 319472946 | Yuhong | M | 2020-01-08 | Li | adventure-works\yuhong0 | M | L | 23 | 2 | 965-555-0155 | | 40 | 2020-01-08 | Current | Production Supervisor - WC20 | 41 | |
| 9 | 25 | 1966-12-22 | Production | jolynn0@adventure-works.com | JoLynn Dobney | 903-555-0145 | 309738752 | JoLynn | F | 2018-12-01 | Dobney | adventure-works\jolynn0 | S | M | 23 | 2 | 903-555-0145 | | 61 | 2018-12-01 | Current | Production Supervisor - WC60 | 82 | |
| 16 | 25 | 1967-03-08 | Production | taylor0@adventure-works.com | Taylor Maxwell | 508-555-0165 | 233069302 | Taylor | M | 2019-01-14 | Maxwell | adventure-works\taylor0 | M | R | 23 | 2 | 508-555-0165 | | 59 | 2019-01-14 | Current | Production Supervisor - WC50 | 79 | |
| 18 | 25 | 1967-09-14 | Production | jo0@adventure-works.com | Jo Brown | 632-555-0129 | 446466105 | Jo | F | 2019-02-02 | Brown | adventure-works\jo0 | S | A | 23 | 2 | 632-555-0129 | | 60 | 2019-02-02 | Current | Production Supervisor - WC60 | 80 | |
| 20 | 25 | 1967-07-14 | Production | john0@adventure-works.com | John Campbell | 435-555-0113 | 494170342 | John | M | 2019-02-21 | Campbell | adventure-works\john0 | M | T | 23 | 2 | 435-555-0113 | | 60 | 2019-02-21 | Current | Production Supervisor - WC60 | 81 | |
| 27 | 25 | 1994-10-01 | Production | zheng0@adventure-works.com | Zheng Mu | 113-555-0173 | 360868122 | Zheng | M | 2019-11-09 | Mu | adventure-works\zheng0 | S | W | 23 | 2 | 113-555-0173 | | 53 | 2019-11-09 | Current | Production Supervisor - WC10 | 66 | |
| 40 | 25 | 2000-01-12 | Production | jinghao0@adventure-works.com | Jinghao Liu | 794-555-0159 | 630184120 | Jinghao | M | 2019-11-14 | Liu | adventure-works\jinghao0 | S | K | 23 | 2 | 794-555-0159 | | 58 | 2019-11-14 | Current | Production Supervisor - WC50 | 77 | |
| 46 | 23.5577 | 1979-08-24 | Production Control | ascott0@adventure-works.com | A. Scott Wright | 992-555-0194 | 685233686 | A. Scott | M | 2019-11-18 | Wright | adventure-works\ascott0 | S | 23 | 2 | 992-555-0194 | | 42 | 2019-11-18 | Current | Master Scheduler | 44 | ||
| 53 | 25 | 1998-08-02 | Production | reuben0@adventure-works.com | Reuben D'sa | 191-555-0112 | 370989364 | Reuben | M | 2019-11-21 | D'sa | adventure-works\reuben0 | M | H | 23 | 2 | 191-555-0112 | | 56 | 2019-11-21 | Current | Production Supervisor - WC40 | 72 | |
| 66 | 25 | 1995-03-18 | Production | cristian0@adventure-works.com | Cristian Petculescu | 434-555-0133 | 7201901 | Cristian | M | 2019-11-28 | Petculescu | adventure-works\cristian0 | M | K | 23 | 2 | 434-555-0133 | | 53 | 2019-11-28 | Current | Production Supervisor - WC10 | 67 | |
| 163 | 25 | 2001-04-29 | Production | shane0@adventure-works.com | Shane Kim | 810-555-0178 | 551834634 | Shane | M | 2020-01-15 | Kim | adventure-works\shane0 | S | S | 23 | 2 | 810-555-0178 | | 57 | 2020-01-15 | Current | Production Supervisor - WC45 | 75 | |
| 177 | 25 | 2000-01-05 | Production | michael3@adventure-works.com | Michael Ray | 156-555-0199 | 578935259 | Michael | M | 2020-01-22 | Ray | adventure-works\michael3 | S | Sean | 23 | 2 | 156-555-0199 | | 55 | 2020-01-22 | Current | Production Supervisor - WC30 | 70 | |
| 186 | 25 | 1995-10-25 | Production | katie0@adventure-works.com | Katie McAskill-White | 809-555-0133 | 862951447 | Katie | F | 2020-01-27 | McAskill-White | adventure-works\katie0 | S | L | 23 | 2 | 809-555-0133 | | 41 | 2020-01-27 | Current | Production Supervisor - WC20 | 42 | |
| 188 | 25 | 1994-05-28 | Production | jack0@adventure-works.com | Jack Richins | 552-555-0111 | 60114406 | Jack | M | 2020-01-28 | Richins | adventure-works\jack0 | S | S | 23 | 2 | 552-555-0111 | | 54 | 2020-01-28 | Current | Production Supervisor - WC30 | 68 | |
| 189 | 25 | 1999-08-13 | Production | andrew0@adventure-works.com | Andrew Hill | 908-555-0159 | 33237992 | Andrew | M | 2020-01-29 | Hill | adventure-works\andrew0 | S | R | 23 | 2 | 908-555-0159 | | 52 | 2020-01-29 | Current | Production Supervisor - WC10 | 65 | |
| 201 | 25 | 1991-06-24 | Production | lori0@adventure-works.com | Lori Kane | 289-555-0196 | 332349500 | Lori | F | 2020-02-02 | Kane | adventure-works\lori0 | S | A | 23 | 2 | 289-555-0196 | | 58 | 2020-02-02 | Current | Production Supervisor - WC45 | 76 | |
| 204 | 28.8462 | 1988-10-01 | Quality Assurance | hazem0@adventure-works.com | Hazem Abolrous | 869-555-0125 | 398223854 | Hazem | M | 2020-02-04 | Abolrous | adventure-works\hazem0 | S | E | 23 | 2 | 869-555-0125 | | 1 | 60 | 2020-02-04 | Current | Quality Assurance Manager | 80 |
| 214 | 25 | 1994-02-03 | Production | brenda0@adventure-works.com | Brenda Diaz | 142-555-0139 | 634335025 | Brenda | F | 2020-02-09 | Diaz | adventure-works\brenda0 | M | M | 23 | 2 | 142-555-0139 | | 55 | 2020-02-09 | Current | Production Supervisor - WC40 | 71 |
Generated 2025-06-06 02:31:04.301 UTC