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