|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactPositionBudget |
| Database Table Name | FactPositionBudget |
| Schema | dbo |
| Friendly Name | FactPositionBudget |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
PositionBudgetSK |
PositionBudgetSK |
System.Int32 | ||
 |
PositionSK |
PositionSK |
System.Int32 | ||
|
StartDateSK |
StartDateSK |
System.Int32 | ||
|
EndDateSK |
EndDateSK |
System.Int32 | ||
|
OrgUnitSK |
OrgUnitSK |
System.Int32 | ||
|
GlCodeSK |
GlCodeSK |
System.Int32 | ||
|
GLAccountSK |
GLAccountSK |
System.Int32 | ||
|
BudgetAmount |
BudgetAmount |
System.Decimal | ||
|
CompensationTypeSK |
System.Int32 |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
GlCodeSK |
DimGlCode |
Table |
False |
||
StartDateSK |
DimDate |
Table |
False |
||
EndDateSK |
DimDate |
Table |
False |
||
PositionSK |
DimPosition |
Table |
False |
||
OrgUnitSK |
DimOrgUnit |
Table |
False |
||
GLAccountSK |
DimChartOfAccount |
Table |
False |
||
CompensationTypeSK |
DimCompensationType |
Table |
False |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
