[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '143' >
4 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 27.1394 | 1985-12-28 | Human Resources | paula0@adventure-works.com | Paula Barreto de Mattos | 523-555-0175 | 535145551 | Paula | F | 2018-10-23 | Barreto de Mattos | adventure-works\paula0 | M | M | 143 | 2 | 523-555-0175 | 1 | 47 | 2018-10-23 | Current | Human Resources Manager | 54 | |
73 | 43.2692 | 1994-08-28 | Finance | wendy0@adventure-works.com | Wendy Kahn | 248-555-0134 | 121491555 | Wendy | F | 2018-11-11 | Kahn | adventure-works\wendy0 | S | Beth | 143 | 2 | 248-555-0134 | 1 | 47 | 2018-11-11 | Current | Finance Manager | 55 | |
106 | 13.4615 | 1974-05-08 | Finance | david5@adventure-works.com | David Barber | 477-555-0132 | 231203233 | David | M | 2018-11-29 | Barber | adventure-works\david5 | S | M | 143 | 2 | 477-555-0132 | 48 | 2018-11-29 | Current | Assistant to the Chief Financial Officer | 56 | ||
142 | 34.7356 | 1993-05-24 | Finance | david6@adventure-works.com | David Liu | 646-555-0185 | 30845 | David | M | 2018-12-17 | Liu | adventure-works\david6 | M | J | 143 | 2 | 646-555-0185 | 1 | 48 | 2018-12-17 | Current | Accounts Manager | 57 |
Generated 2024-05-17 01:02:40.491 UTC