|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimAssignment |
| Database Table Name | DimAssignment |
| Schema | dbo |
| Friendly Name | DimAssignment |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
AssignmentSK |
AssignmentSK |
System.Int32 | ||
 |
AssignmentAK |
AssignmentAK |
System.String(20) | ||
|
PersonId |
PersonId |
System.Int32 | ||
|
PositionCode |
PositionCode |
System.String(8) | ||
|
AssignmentSequenceNumber |
AssignmentSequenceNumber |
System.Int16 | ||
|
JobTitle |
JobTitle |
System.String(30) | ||
|
AssignmentStatus |
AssignmentStatus |
System.String(10) | ||
|
AssignmentTypeCode |
AssignmentTypeCode |
System.String(3) | ||
|
AssignmentType |
AssignmentType |
System.String(60) | ||
|
FunctionCode |
FunctionCode |
System.String(3) | ||
|
FunctionDesc |
FunctionDesc |
System.String(60) | ||
|
PrimarySalaryAccountNumber |
PrimarySalaryAccountNumber |
System.String(28) | ||
|
StartDate |
StartDate |
System.DateTime | ||
|
EndDate |
EndDate |
System.DateTime | ||
|
JobGroupCode |
JobGroupCode |
System.String(8) | ||
|
JobGroup |
JobGroup |
System.String(60) | ||
|
JobClassCode |
JobClassCode |
System.String(8) | ||
|
PayBasis |
PayBasis |
System.String(8) | ||
|
InstitutionalAssignmentTypeCode |
InstitutionalAssignmentTypeCode |
System.String(8) | ||
|
InstitutionalAssignmentType |
InstitutionalAssignmentType |
System.String(30) | ||
|
PrimaryAssignment |
PrimaryAssignment |
System.String(3) | ||
|
RegularTemporary |
RegularTemporary |
System.String(10) | ||
|
ExemptStatus |
ExemptStatus |
System.String(3) | ||
|
AssignmentFulltimeParttime |
AssignmentFulltimeParttime |
System.String(10) | ||
|
AssignmentEndDateRange |
AssignmentEndDateRange |
System.String(30) | ||
|
LastPaymentDateRange |
LastPaymentDateRange |
System.String(30) | ||
|
EndBasisCode |
EndBasisCode |
System.String(8) | ||
|
EndBasis |
EndBasis |
System.String(60) | ||
|
BaseSalary |
BaseSalary |
System.Decimal | ||
|
ActualSalary |
ActualSalary |
System.Decimal | ||
|
DailyRate |
DailyRate |
System.Decimal | ||
|
HourlyRate |
HourlyRate |
System.Decimal | ||
|
OvertimeRate |
OvertimeRate |
System.Decimal | ||
|
TotalSalary |
TotalSalary |
System.Decimal | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime |
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 |
AssignmentSK |
FactPositionExpense |
Table |
False |
||
AssignmentSK |
FactHoursWorkedByWeek |
Table |
False |
||
AssignmentSK |
FactHoursReportedByDay |
Table |
False |
||
AssignmentSK |
FactCheckComponent |
Table |
False |
| Powered by BI Documenter |
