Table: DimEmployee

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimEmployee 
 Friendly name   Employee 
 Table name   dbo_DimEmployee 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_DimEmployee_DimSalesTerritory SalesTerritoryKey DimSalesTerritory Table SalesTerritoryKey
FK_DimEmployee_DimEmployee ParentEmployeeKey DimEmployee Table EmployeeKey
Total: 2 parent relationship(s)

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_FactResellerSales_DimEmployee EmployeeKey FactResellerSales Table EmployeeKey
FK_DimEmployee_DimEmployee EmployeeKey DimEmployee Table ParentEmployeeKey
FK_FactSalesQuota_DimEmployee EmployeeKey Sales Quota Facts View EmployeeKey
Total: 3 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
EmployeeKey System.Int32  
ParentEmployeeKey System.Int32  
EmployeeNationalIDAlternateKey System.String  
ParentEmployeeNationalIDAlternateKey System.String  
FirstName System.String  
LastName System.String  
MiddleName System.String  
NameStyle System.Boolean  
Title System.String  
HireDate System.DateTime  
BirthDate System.DateTime  
LoginID System.String  
EmailAddress System.String  
Phone System.String  
MaritalStatus System.String  
EmergencyContactName System.String  
EmergencyContactPhone System.String  
SalariedFlag System.Boolean  
Gender System.String  
PayFrequency System.Byte  
BaseRate System.Decimal  
VacationHours System.Int16  
SickLeaveHours System.Int16  
CurrentFlag System.Boolean  
SalesPersonFlag System.Boolean  
DepartmentName System.String  
FullName System.String
CASE 
    WHEN MiddleName IS NULL THEN 
        FirstName + ' ' + LastName
    ELSE 
        FirstName + ' ' + MiddleName + '.' + ' ' + LastName
END
SalesTerritoryKey System.Int32  
GenderDesc System.String
CASE 
    WHEN Gender = 'M' THEN 
        'Male'
    ELSE 
        'Female'
END
MaritalStatusDesc System.String
CASE 
    WHEN MaritalStatus = 'S' THEN 
        'Single'
    ELSE 
        'Married'
END
StartDate System.DateTime  
EndDate System.DateTime  
Status System.String  
PayFrequencyDesc System.String
CASE 
    WHEN PayFrequency = '1' THEN 
        'Monthly'
    ELSE 
        'Bi-Monthly'
END
EmployeeStatus System.String
CASE
    WHEN Status = 'Current' THEN 'Active'
    ELSE 'Inactive'
END
SimpleEndDate System.String
CASE
    WHEN EndDate IS NULL THEN 'Active'
    ELSE
    DATENAME(mm, EndDate) + ' ' +
    DATENAME(dd, EndDate) + ', ' + 
    DATENAME(yy, EndDate)
END
SimpleStartDate System.String
DATENAME(mm, StartDate) + ' ' +
DATENAME(dd, StartDate) + ', ' +
DATENAME(yy, StartDate)
SimpleHireDate System.String
DATENAME(mm, HireDate) + ' ' +
DATENAME(dd, HireDate) + ', ' +
DATENAME(yy, HireDate)
HireYear System.Int32
DATEPART(yy, HireDate)
SalariedFlagDesc System.String
Case
    When SalariedFlag = 0
    Then 'False'
    Else 'True'
End
SalesPersonFlagDesc System.String
Case
    When SalesPersonFlag = 0
    Then 'False'
    Else 'True'
End
EmployeePhoto System.Byte[]  
Total: 42 column(s)

Collapse image See also


About this documentation