| 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)