|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimPosition |
| Database Table Name | DimPosition |
| Schema | dbo |
| Friendly Name | DimPosition |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
PositionSK |
PositionSK |
System.Int32 | ||
 |
PositionAK |
PositionAK |
System.String(8) | ||
|
PositionCode |
PositionCode |
System.String(8) | ||
|
PositionTitle |
PositionTitle |
System.String(30) | ||
|
PositionStatus |
PositionStatus |
System.String(10) | ||
|
PositionTypeCode |
PositionTypeCode |
System.String(3) | ||
|
PositionType |
PositionType |
System.String(60) | ||
|
FunctionCode |
FunctionCode |
System.String(3) | ||
|
FunctionDescription |
FunctionDescription |
System.String(60) | ||
|
DateEstablished |
DateEstablished |
System.DateTime | ||
|
DateInactivated |
DateInactivated |
System.DateTime | ||
|
JobGroupCode |
JobGroupCode |
System.String(8) | ||
|
JobGroup |
JobGroup |
System.String(60) | ||
|
JobClassCode |
JobClassCode |
System.String(8) | ||
|
PayBasis |
PayBasis |
System.String(8) | ||
|
Budgeted |
Budgeted |
System.String(3) | ||
|
RegularTemporary |
RegularTemporary |
System.String(10) | ||
|
PooledIndicator |
PooledIndicator |
System.String(3) | ||
|
ExemptStatus |
ExemptStatus |
System.String(3) | ||
|
PositionFulltimeParttime |
PositionFulltimeParttime |
System.String(10) | ||
|
PrimarySalaryAccountNumber |
PrimarySalaryAccountNumber |
System.String(28) | ||
|
CountOfActiveAssignments |
CountOfActiveAssignments |
System.Int32 | ||
|
CountOfInactiveAssignments |
CountOfInactiveAssignments |
System.Int32 | ||
|
InactiveReasonCode |
InactiveReasonCode |
System.String(8) | ||
|
InactiveReason |
InactiveReason |
System.String(60) | ||
|
FulltimeEquivalent |
FulltimeEquivalent |
System.Decimal | ||
|
WeeklyAuthorizedHours |
WeeklyAuthorizedHours |
System.Decimal | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
LocationCode |
System.String(3) | |||
|
Location |
System.String(60) | |||
|
InactiveVacantDateRange |
System.String(30) | |||
|
MultipleFunds |
System.String(3) |
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 |
PositionSK |
FactPositionExpense |
Table |
False |
||
PositionSK |
FactPositionBudget |
Table |
False |
||
PositionSK |
FactHoursWorkedByWeek |
Table |
False |
||
PositionSK |
FactHoursReportedByDay |
Table |
False |
||
PositionSK |
FactCheckComponent |
Table |
False |
| Powered by BI Documenter |
