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