[ROOT] dt DimEmployee < WHERE Status EQ NULL >
6 items
DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | EndDate | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SalariedFlag | SickLeaveHours | StartDate | Title | VacationHours |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 29.8462 | 1984-10-22 | Tool Design | rob0@adventure-works.com | Rob Walters | 612-555-0100 | 112457891 | 2020-03-29 | Rob | M | 2017-10-04 | Walters | adventure-works\rob0 | S | 3 | 2 | 612-555-0100 | 80 | 2017-10-04 | Senior Tool Designer | 48 | |||
278 | 30 | 1987-12-11 | Purchasing | sheela0@adventure-works.com | Sheela Word | 210-555-0193 | 895209680 | 2021-05-29 | Sheela | F | 2020-12-25 | Word | adventure-works\sheela0 | S | H | 73 | 2 | 210-555-0193 | 1 | 44 | 2020-12-25 | Purchasing Manager | 49 | |
7 | 37.5 | 1985-01-16 | Marketing | david0@adventure-works.com | David Bradley | 913-555-0172 | 24756624 | 2019-05-14 | David | M | 2017-10-19 | Bradley | adventure-works\david0 | S | M | 112 | 2 | 913-555-0172 | 1 | 40 | 2017-10-19 | Marketing Manager | 40 | |
279 | 30 | 1987-12-11 | Purchasing | sheela0@adventure-works.com | Sheela Word | 210-555-0193 | 895209680 | 2022-05-14 | Sheela | F | 2020-12-25 | Word | adventure-works\sheela0 | S | H | 73 | 2 | 210-555-0193 | 1 | 44 | 2021-05-30 | Purchasing Manager | 49 | |
98 | 16 | 1991-09-06 | Production Control | william0@adventure-works.com | William Vong | 148-555-0145 | 621209647 | 2021-06-30 | William | M | 2018-11-07 | Vong | adventure-works\william0 | M | S | 46 | 2 | 148-555-0145 | 42 | 2018-11-07 | Scheduling Assistant | 45 | ||
143 | 60.0962 | 1985-11-05 | Executive | laura1@adventure-works.com | Laura Norman | 615-555-0110 | 184188301 | 2023-09-13 | Laura | F | 2018-12-01 | Norman | adventure-works\laura1 | M | F | 112 | 2 | 615-555-0110 | 1 | 20 | 2018-12-01 | Chief Financial Officer | 0 |
Generated 2024-04-29 16:21:07.870 UTC