Property |
Value |
Database schema name |
dbo |
Database table name |
DimEmployee |
Friendly name |
Employee |
Table name |
dbo_DimEmployee |
Table type |
Table |
Is loaded |
|
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)
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)
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)