|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimOrgUnit |
| Database Table Name | DimOrgUnit |
| Schema | dbo |
| Friendly Name | DimOrgUnit |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
OrgUnitSK |
OrgUnitSK |
System.Int32 | ||
 |
OrgUnitAK |
OrgUnitAK |
System.String(16) | ||
|
OrgUnit |
OrgUnit |
System.String(18) | ||
|
OrgUnitName |
OrgUnitName |
System.String(30) | ||
|
OrgUnitStatusCode |
OrgUnitStatusCode |
System.String(3) | ||
|
OrgUnitStatus |
OrgUnitStatus |
System.String(15) | ||
|
FundCode |
FundCode |
System.String(3) | ||
|
Fund |
Fund |
System.String(30) | ||
|
FunctionCode |
FunctionCode |
System.String(3) | ||
|
FunctionDescription |
FunctionDescription |
System.String(30) | ||
|
SubFunctionCode |
SubFunctionCode |
System.String(3) | ||
|
SubFunction |
SubFunction |
System.String(30) | ||
|
StateOrgUnit |
StateOrgUnit |
System.String(8) | ||
|
LocationCode |
LocationCode |
System.String(3) | ||
|
Location |
Location |
System.String(30) | ||
|
Qual1 |
Qual1 |
System.String(6) | ||
|
ControlOrgUnit |
ControlOrgUnit |
System.String(18) | ||
|
ControlOrgUnitName |
ControlOrgUnitName |
System.String(30) | ||
|
BudgetManagerId |
BudgetManagerId |
System.String(9) | ||
|
BudgetManager |
BudgetManager |
System.String(40) | ||
|
UserGroupId |
UserGroupId |
System.String(16) | ||
|
UserGroup |
UserGroup |
System.String(40) | ||
|
PrincipalAdminId |
PrincipalAdminId |
System.String(9) | ||
|
PrincipalAdmin |
PrincipalAdmin |
System.String(40) | ||
|
ProjectNumber |
ProjectNumber |
System.Int32 | ||
|
ReportDistributionCode |
ReportDistributionCode |
System.String(4) | ||
|
ReportDistribution |
ReportDistribution |
System.String(30) | ||
|
OrgUnitGrouping |
OrgUnitGrouping |
System.String(4) | ||
|
StartDate |
StartDate |
System.DateTime | ||
|
EndDate |
EndDate |
System.DateTime | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
ControlOrgStateOrg |
System.String(8) | SUBSTRING(ControlOrgUnit,1,8) |
||
|
LocationDescription |
System.String(36) | LocationCode + ' - ' + Location |
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 |
OrgUnitSK |
FactPositionExpense |
Table |
False |
||
OrgUnitSK |
FactPositionBudget |
Table |
False |
||
OrgUnitSK |
FactCheckComponent |
Table |
False |
||
OrgUnitSK |
FactOrgUnit_User_Bridge |
Table |
False |
||
OrgUnitSK |
FactGlTransactions |
Table |
False |
||
OrgUnitSK |
FactGlSummaryBalances |
Table |
False |
||
OrgUnitSK |
FactGlRollOverBalances |
Table |
False |
| Powered by BI Documenter |
