[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '142' >
7 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61 | 19 | 1986-01-20 | Finance | deborah0@adventure-works.com | Deborah Poe | 602-555-0194 | 363923697 | Deborah | F | 2018-11-03 | Poe | adventure-works\deborah0 | M | E | 142 | 2 | 602-555-0194 | 50 | 2018-11-03 | Current | Accounts Receivable Specialist | 60 | ||
96 | 19 | 1986-01-08 | Finance | candy0@adventure-works.com | Candy Spoon | 920-555-0177 | 60517918 | Candy | F | 2018-11-22 | Spoon | adventure-works\candy0 | S | L | 142 | 2 | 920-555-0177 | 50 | 2018-11-22 | Current | Accounts Receivable Specialist | 61 | ||
170 | 19 | 1986-12-31 | Finance | dragan0@adventure-works.com | Dragan Tomic | 117-555-0185 | 663843431 | Dragan | M | 2018-12-28 | Tomic | adventure-works\dragan0 | M | K | 142 | 2 | 117-555-0185 | 51 | 2018-12-28 | Current | Accounts Payable Specialist | 63 | ||
133 | 19 | 1994-08-06 | Finance | bryan1@adventure-works.com | Bryan Walton | 935-555-0199 | 931190412 | Bryan | M | 2018-12-10 | Walton | adventure-works\bryan1 | S | A | 142 | 2 | 935-555-0199 | 51 | 2018-12-10 | Current | Accounts Receivable Specialist | 62 | ||
182 | 26.4423 | 1985-11-19 | Finance | barbara1@adventure-works.com | Barbara Moreland | 822-555-0145 | 363910111 | Barbara | F | 2019-01-04 | Moreland | adventure-works\barbara1 | M | C | 142 | 2 | 822-555-0145 | 1 | 49 | 2019-01-04 | Current | Accountant | 58 | |
205 | 19 | 1989-01-22 | Finance | janet0@adventure-works.com | Janet Sheperdigian | 393-555-0186 | 519756660 | Janet | F | 2019-01-15 | Sheperdigian | adventure-works\janet0 | M | L | 142 | 2 | 393-555-0186 | 52 | 2019-01-15 | Current | Accounts Payable Specialist | 64 | ||
220 | 26.4423 | 1989-05-16 | Finance | mike0@adventure-works.com | Mike Seamans | 927-555-0150 | 480951955 | Mike | M | 2019-01-22 | Seamans | adventure-works\mike0 | S | K | 142 | 2 | 927-555-0150 | 1 | 49 | 2019-01-22 | Current | Accountant | 59 |
Generated 2024-05-15 17:42:49.914 UTC