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