|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimEmployee |
| Database Table Name | DimEmployee |
| Schema | dbo |
| Friendly Name | DimEmployee |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
EmployeeSK |
EmployeeSK |
System.Int32 | ||
 |
EmployeeAK |
EmployeeAK |
System.Int32 | ||
|
PersonID |
PersonID |
System.Int32 | ||
|
EmployeeTypeCode |
EmployeeTypeCode |
System.String(8) | ||
|
EmployeeType |
EmployeeType |
System.String(30) | ||
|
FullName |
FullName |
System.String(80) | ||
|
LastName |
LastName |
System.String(50) | ||
|
FirstName |
FirstName |
System.String(30) | ||
|
MiddleInitial |
MiddleInitial |
System.String(3) | ||
|
GenderCode |
GenderCode |
System.String(3) | ||
|
Gender |
Gender |
System.String(30) | ||
|
EthnicityCode |
EthnicityCode |
System.String(3) | ||
|
Ethnicity |
Ethnicity |
System.String(30) | ||
|
StateCode |
StateCode |
System.String(3) | ||
|
State |
State |
System.String(30) | ||
|
ZipCode |
ZipCode |
System.String(11) | ||
|
CountyFIPSCode |
CountyFIPSCode |
System.String(5) | ||
|
County |
County |
System.String(45) | ||
|
CountryCode |
CountryCode |
System.String(3) | ||
|
Country |
Country |
System.String(30) | ||
|
CitizenshipCode |
CitizenshipCode |
System.String(3) | ||
|
Citizenship |
Citizenship |
System.String(30) | ||
|
CountryOfCitizenshipCode |
CountryOfCitizenshipCode |
System.String(3) | ||
|
CountryOfCitizenship |
CountryOfCitizenship |
System.String(30) | ||
|
HasActiveAssignment |
HasActiveAssignment |
System.String(3) | ||
|
NumberOfActiveAssignments |
NumberOfActiveAssignments |
System.Int32 | ||
|
LastActiveAssignmentDateRange |
LastActiveAssignmentDateRange |
System.String(30) | ||
|
LastPayCheckDateRange |
LastPayCheckDateRange |
System.String(30) | ||
|
PositionTypeCode |
PositionTypeCode |
System.String(3) | ||
|
PositionType |
PositionType |
System.String(60) | ||
|
FunctionCode |
FunctionCode |
System.String(3) | ||
|
FunctionDesc |
FunctionDesc |
System.String(60) | ||
|
PrimarySalaryAccountNumber |
PrimarySalaryAccountNumber |
System.String(28) | ||
|
IsAStudent |
IsAStudent |
System.String(3) | ||
|
EmployeeStudentId |
EmployeeStudentId |
System.String(9) | ||
|
HasDirectDeposit |
HasDirectDeposit |
System.String(3) | ||
|
HireDate |
HireDate |
System.DateTime | ||
|
EmployeeFulltimeParttime |
EmployeeFulltimeParttime |
System.String(10) | ||
|
TerminationDate |
TerminationDate |
System.DateTime | ||
|
TerminationDateRange |
TerminationDateRange |
System.String(30) | ||
|
YearsOfServiceToInstitution |
YearsOfServiceToInstitution |
System.Int16 | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
DateOfBirth |
System.DateTime | |||
|
LocationCode |
System.String(3) | |||
|
Location |
System.String(60) | |||
|
EmployeeAge |
System.Int32 | CAST(datediff("dd", DateOfBirth,getdate()) / 365.25 as INT) |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
EmployeeSK |
FactPositionExpense |
Table |
False |
||
EmployeeSK |
FactHoursWorkedByWeek |
Table |
False |
||
EmployeeSK |
FactHoursReportedByDay |
Table |
False |
||
EmployeeSK |
FactCheckSummary |
Table |
False |
||
EmployeeSK |
FactCheckComponent |
Table |
False |
| Powered by BI Documenter |
