[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '201' >
5 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 10 | 1996-12-20 | Production | scott0@adventure-works.com | Scott Gode | 391-555-0138 | 199546871 | Scott | M | 2018-11-18 | Gode | adventure-works\scott0 | M | R | 201 | 1 | 391-555-0138 | 63 | 2018-11-18 | Current | Production Technician - WC45 | 86 | |
185 | 10 | 1985-01-24 | Production | belinda0@adventure-works.com | Belinda Newman | 319-555-0126 | 20244403 | Belinda | F | 2018-12-31 | Newman | adventure-works\belinda0 | S | M | 201 | 1 | 319-555-0126 | 61 | 2018-12-31 | Current | Production Technician - WC45 | 83 | |
24 | 10 | 1972-07-23 | Production | stuart0@adventure-works.com | Stuart Munson | 413-555-0136 | 835460180 | Stuart | M | 2018-10-12 | Munson | adventure-works\stuart0 | S | V | 201 | 1 | 413-555-0136 | 62 | 2018-10-12 | Current | Production Technician - WC45 | 84 | |
139 | 10 | 2000-09-10 | Production | kathie0@adventure-works.com | Kathie Flood | 446-555-0118 | 167554340 | Kathie | F | 2018-12-07 | Flood | adventure-works\kathie0 | M | E | 201 | 1 | 446-555-0118 | 63 | 2018-12-07 | Current | Production Technician - WC45 | 87 | |
25 | 10 | 1986-02-24 | Production | greg0@adventure-works.com | Greg Alderson | 332-555-0150 | 687685941 | Greg | M | 2018-10-12 | Alderson | adventure-works\greg0 | S | F | 201 | 1 | 332-555-0150 | 62 | 2018-10-12 | Current | Production Technician - WC45 | 85 |
Generated 2024-05-09 22:17:51.168 UTC