[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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98 | 16 | 1992-09-17 | Production Control | william0@adventure-works.com | William Vong | 148-555-0145 | 621209647 | 2022-07-12 | William | M | 2019-11-19 | Vong | adventure-works\william0 | M | S | 46 | 2 | 148-555-0145 | 42 | 2019-11-19 | Scheduling Assistant | 45 | ||
143 | 60.0962 | 1986-11-17 | Executive | laura1@adventure-works.com | Laura Norman | 615-555-0110 | 184188301 | 2024-09-24 | Laura | F | 2019-12-13 | Norman | adventure-works\laura1 | M | F | 112 | 2 | 615-555-0110 | 1 | 20 | 2019-12-13 | Chief Financial Officer | 0 | |
4 | 29.8462 | 1985-11-03 | Tool Design | rob0@adventure-works.com | Rob Walters | 612-555-0100 | 112457891 | 2021-04-10 | Rob | M | 2018-10-16 | Walters | adventure-works\rob0 | S | 3 | 2 | 612-555-0100 | 80 | 2018-10-16 | Senior Tool Designer | 48 | |||
7 | 37.5 | 1986-01-28 | Marketing | david0@adventure-works.com | David Bradley | 913-555-0172 | 24756624 | 2020-05-25 | David | M | 2018-10-31 | Bradley | adventure-works\david0 | S | M | 112 | 2 | 913-555-0172 | 1 | 40 | 2018-10-31 | Marketing Manager | 40 | |
278 | 30 | 1988-12-22 | Purchasing | sheela0@adventure-works.com | Sheela Word | 210-555-0193 | 895209680 | 2022-06-10 | Sheela | F | 2022-01-06 | Word | adventure-works\sheela0 | S | H | 73 | 2 | 210-555-0193 | 1 | 44 | 2022-01-06 | Purchasing Manager | 49 | |
279 | 30 | 1988-12-22 | Purchasing | sheela0@adventure-works.com | Sheela Word | 210-555-0193 | 895209680 | 2023-05-26 | Sheela | F | 2022-01-06 | Word | adventure-works\sheela0 | S | H | 73 | 2 | 210-555-0193 | 1 | 44 | 2022-06-11 | Purchasing Manager | 49 |
Generated 2025-05-11 18:54:22.713 UTC