P6 - Resource Assignment / Primavera - Resource Assignment
Description: Use this subject area to analyze resource assignment details for costs and units. This subject area includes information on planned, actual, remaining, staffed, unstaffed, and at completion costs and units.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Resource | Cost Account - (Resource) | Resource Cost Accounts | |||
| Resource | Cost Account - (Resource) | Cost Account ID | Dimension | A short ID assigned to each cost account for identification. Each cost account is uniquely identified by concatenating its own ID together with its parents' IDs. | Dim_W_COST_ACCOUNT_D_CostAcct.ACCT_SHORT_NAME |
| Resource | Cost Account - (Resource) | Cost Account Name | Dimension | The name of a cost account. | Dim_W_COST_ACCOUNT_D_CostAcct.ACCT_NAME |
| Resource | General - (Resource) | General Resource Information | |||
| Resource | General - (Resource) | Active | Dimension | Indicates whether the resource is currently active. Nonactive resources may have left the organization but are not deleted from the system since they may have actual hours. | Value Derived From : Dim_W_RESOURCE_D_Resource.ACTIVE_FLAG |
| Resource | General - (Resource) | Datasource Id | Dimension | A unique source Id created for the Primavera data source being used. Used to identify data sources when using multiple Primavera data sources. | Value Derived From : Dim_W_RESOURCE_D_Resource.DATASOURCE_ID |
| Resource | General - (Resource) | Primary Role Name | Dimension | The name of the role that is assigned as the resource's primary role | Value Derived From : Dim_W_RESOURCE_D_Resource.PRIMARY_ROLE_NAME |
| Resource | General - (Resource) | Unique Primary Role Id | Dimension | The unique Id of the role that is assigned as the resource's primary role | Value Derived From : Dim_W_RESOURCE_D_Resource.PRIMARY_ROLE_OBJECT_ID |
| Resource | General - (Resource) | Resource ID | Dimension | A short code which uniquely identifies the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_ID |
| Resource | General - (Resource) | Resource Name | Dimension | The name of the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_NAME |
| Resource | General - (Resource) | Title | Dimension | The title of the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_TITLE |
| Resource | General - (Resource) | Resource Type | Dimension | Indicates whether the resource is labor, nonlabor, or material | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_TYPE |
| Resource | Resource Team - (Resource) | Resource Teams | |||
| Resource | Resource Team - (Resource) | Resource Team Name | The name of the Resource Team. | ||
| Fact - Primavera - Resource Assignment Folder | |||||
| Fact - Primavera - Resource Assignment | Costs | Costs | |||
| Fact - Primavera - Resource Assignment | Costs | Actual Cost | Fact | The actual non-overtime plus overtime cost for the resource assignment on the activity. Calculated as Actual Regular Cost plus Actual Overtime Cost. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.ACTUAL_COST |
| Fact - Primavera - Resource Assignment | Costs | Actual Overtime Cost | Fact | The actual overtime cost for the resource assignment on the activity. Calculated as Actual Overtime Units multiplied by Cost per Time multiplied by Overtime Factor. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.ACTUAL_OVERTIME_COST |
| Fact - Primavera - Resource Assignment | Costs | Actual Regular Cost | Fact | The actual non-overtime cost for the resource assignment on the activity. Calculated as Actual Regular Units multiplied by Cost per Time. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.ACTUAL_REGULAR_COST |
| Fact - Primavera - Resource Assignment | Costs | At Completion Cost | Fact | The sum of the actual costs plus remaining costs for the resource assignment on the activity. Calculated as Actual Costs plus Remaining Costs. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.AT_COMPLETION_COST |
| Fact - Primavera - Resource Assignment | Costs | Planned Cost | Fact | The planned cost of work required for the assignment to be completed. Calculated as Planned Units multiplied by Price per Time. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.PLANNED_COST |
| Fact - Primavera - Resource Assignment | Costs | Remaining Cost | Fact | The remaining cost for the resource assignment on the activity. Calculated as Remaining Units multiplied by Cost/Time. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.REMAINING_COST |
| Fact - Primavera - Resource Assignment | Costs | Remaining Late Cost | Fact | Remaining Late Cost | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.REMAINING_LATE_COST |
| Fact - Primavera - Resource Assignment | Costs | Staffed Remaining Cost | Fact | The remaining cost for resource assignments that have a filled role. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.STAFFED_REMAINING_COST |
| Fact - Primavera - Resource Assignment | Costs | Staffed Remaining Late Cost | Fact | Staffed Remaining Late Cost | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.STAFFED_REMAINING_COST |
| Fact - Primavera - Resource Assignment | Costs | Unstaffed Remaining Cost | Fact | The remaining cost for resource assignments that do not have a filled role. | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.UNSTAFFED_REMAINING_COST |
| Fact - Primavera - Resource Assignment | Costs | Unstaffed Remaining Late Cost | Fact | Unstaffed Remaining Late Cost | Value Derived From : Fact_W_RESOURCE_SPREAD_F_Resource_Spread.UNSTAFFED_REMAINING_COST |
| Fact - Primavera - Resource Assignment | Metrics | Metrics | |||
| Fact - Primavera - Resource Assignment | Metrics | # Of Activities | Fact | # Of Activities | count(distinct Fact_W_RESOURCE_SPREAD_F_Resource_Spread.ACTIVITY_WID) |
| Fact - Primavera - Resource Assignment | Metrics | # Of Projects | Fact | # Of Projects | count(distinct Fact_W_RESOURCE_SPREAD_F_Resource_Spread.PROJECT_WID) |
| Fact - Primavera - Resource Assignment | Metrics | # Of Resources | Fact | # Of Resources | count(distinct Fact_W_RESOURCE_SPREAD_F_Resource_Spread.RESOURCE_WID) |
| Fact - Primavera - Resource Assignment | Units | Units | |||
| Fact - Primavera - Resource Assignment | Units | Actual Overtime Units | Fact | The actual overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.ACTUAL_OVERTIME_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Actual Regular Units | Fact | The actual nonovertime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.ACTUAL_REGULAR_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Actual Units | Fact | The sum of the actual non-overtime and the overtime units worked by the resource on the activity. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.ACTUAL_UNITS) |
| Fact - Primavera - Resource Assignment | Units | At Completion Units | Fact | The sum of the actual units and remaining units for the resource assignment on the activity. Calculated as Actual Units plus Remaining Units. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.AT_COMPLETION_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Planned Units | Fact | The planned units of work for the resource assignment on the activity. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.PLANNED_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Remaining Late Units | Fact | Remaining Late Units | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.REMAINING_LATE_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Remaining Units | Fact | The remaining units of work to be performed by the resource on the activity. Calculated as Planned Units minus Actual Units. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.REMAINING_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Staffed Remaining Late Units | Fact | Staffed Remaining Late Units | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.STAFFED_REMAINING_LATE_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Staffed Remaining Units | Fact | The remaining units for resource assignments that have filled a role. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.STAFFED_REMAINING_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Unstaffed Remaining Late Units | Fact | Unstaffed Remaining Late Units | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.UNSTAFFED_REMAINING_LATE_UNITS) |
| Fact - Primavera - Resource Assignment | Units | Unstaffed Remaining Units | Fact | The remaining units for resource assignments that have not filled a role. | sum(Fact_W_RESOURCE_SPREAD_F_Resource_Spread.UNSTAFFED_REMAINING_UNITS) |
| Assignment Role Folder | |||||
| Assignment Role | General - (Role) | General Role Information | |||
| Assignment Role | General - (Role) | Is Primary Role | Dimension | Is Primary Role | Value Derived From : Dim_W_RESOURCE_ROLE_D_Resource_Role.IS_PRIMARY_ROLE |
| Assignment Role | General - (Role) | Role ID | Dimension | The role the resource is performing on this activity. A resource may be assigned to the same activity more than once, performing different roles. The project manager controls whether the same resource can be assigned to an activity more than once. | Value Derived From : Dim_W_ROLE_D_Role.ROLE_SHORT_NAME |
| Assignment Role | General - (Role) | Role Name | Dimension | The role the resource is performing on this activity. A resource may be assigned to the same activity more than once, performing different roles. The project manager controls whether the same resource can be assigned to an activity more than once. | Value Derived From : Dim_W_ROLE_D_Role.ROLE_NAME |
| Assignment Role | Role Hierarchy - (Role) | Role Hierarchy | |||
| Assignment Role | Role Hierarchy - (Role) | Full Path Name | Dimension | Full Path Name | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.FULL_PATH_NAME |
| Assignment Role | Role Hierarchy - (Role) | Role Level | Dimension | Role Level | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.LVL |
| Assignment Role | Role Hierarchy - (Role) | Role Name | Dimension | Role Name | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 1 | Dimension | Role Name Level 1 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV1 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 10 | Dimension | Role Name Level 10 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV10 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 11 | Dimension | Role Name Level 11 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV11 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 12 | Dimension | Role Name Level 12 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV12 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 13 | Dimension | Role Name Level 13 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV13 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 14 | Dimension | Role Name Level 14 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV14 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 15 | Dimension | Role Name Level 15 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV15 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 16 | Dimension | Role Name Level 16 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV16 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 17 | Dimension | Role Name Level 17 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV17 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 18 | Dimension | Role Name Level 18 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV18 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 19 | Dimension | Role Name Level 19 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV19 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 2 | Dimension | Role Name Level 2 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV2 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 20 | Dimension | Role Name Level 20 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV20 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 21 | Dimension | Role Name Level 21 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV21 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 22 | Dimension | Role Name Level 22 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV22 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 23 | Dimension | Role Name Level 23 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV23 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 24 | Dimension | Role Name Level 24 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV24 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 3 | Dimension | Role Name Level 3 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV3 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 4 | Dimension | Role Name Level 4 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV4 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 5 | Dimension | Role Name Level 5 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV5 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 6 | Dimension | Role Name Level 6 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV6 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 7 | Dimension | Role Name Level 7 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV7 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 8 | Dimension | Role Name Level 8 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV8 |
| Assignment Role | Role Hierarchy - (Role) | Role Name Level 9 | Dimension | Role Name Level 9 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_NAME_LV9 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID | Dimension | Role Unique ID | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 1 | Dimension | Role Unique ID Level 1 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV1 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 10 | Dimension | Role Unique ID Level 10 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV10 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 11 | Dimension | Role Unique ID Level 11 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV11 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 12 | Dimension | Role Unique ID Level 12 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV12 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 13 | Dimension | Role Unique ID Level 13 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV13 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 14 | Dimension | Role Unique ID Level 14 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV14 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 15 | Dimension | Role Unique ID Level 15 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV15 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 16 | Dimension | Role Unique ID Level 16 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV16 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 17 | Dimension | Role Unique ID Level 17 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV17 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 18 | Dimension | Role Unique ID Level 18 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV18 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 19 | Dimension | Role Unique ID Level 19 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV19 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 2 | Dimension | Role Unique ID Level 2 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV2 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 20 | Dimension | Role Unique ID Level 20 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV20 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 21 | Dimension | Role Unique ID Level 21 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV21 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 22 | Dimension | Role Unique ID Level 22 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV22 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 23 | Dimension | Role Unique ID Level 23 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV23 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 24 | Dimension | Role Unique ID Level 24 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV24 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 3 | Dimension | Role Unique ID Level 3 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV3 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 4 | Dimension | Role Unique ID Level 4 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV4 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 5 | Dimension | Role Unique ID Level 5 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV5 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 6 | Dimension | Role Unique ID Level 6 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV6 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 7 | Dimension | Role Unique ID Level 7 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV7 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 8 | Dimension | Role Unique ID Level 8 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV8 |
| Assignment Role | Role Hierarchy - (Role) | Role Unique ID Level 9 | Dimension | Role Unique ID Level 9 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_OBJECT_ID_LV9 |
| Assignment Role | Role Hierarchy - (Role) | Role Short Name | Dimension | Role Short Name | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 1 | Dimension | Resource Role Short Name Level 1 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV1 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 10 | Dimension | Role ID Level 10 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV10 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 11 | Dimension | Role ID Level 11 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV11 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 12 | Dimension | Role ID Level 12 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV12 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 13 | Dimension | Role ID Level 13 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV13 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 14 | Dimension | Role ID Level 14 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV14 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 15 | Dimension | Role ID Level 15 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV15 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 16 | Dimension | Role ID Level 16 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV16 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 17 | Dimension | Role ID Level 17 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV17 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 18 | Dimension | Role ID Level 18 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV18 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 19 | Dimension | Role ID Level 19 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV19 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 2 | Dimension | Role ID Level 2 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV2 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 20 | Dimension | Role ID Level 20 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV20 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 21 | Dimension | Role ID Level 21 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV21 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 22 | Dimension | Role ID Level 22 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV22 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 23 | Dimension | Role ID Level 23 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV23 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 24 | Dimension | Role ID Level 24 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV24 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 3 | Dimension | Role ID Level 3 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV3 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 4 | Dimension | Role ID Level 4 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV4 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 5 | Dimension | Role ID Level 5 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV5 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 6 | Dimension | Role ID Level 6 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV6 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 7 | Dimension | Role ID Level 7 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV7 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 8 | Dimension | Role ID Level 8 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV8 |
| Assignment Role | Role Hierarchy - (Role) | Role ID Level 9 | Dimension | Role ID Level 9 | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROLE_ID_LV9 |
| Assignment Role | Role Hierarchy - (Role) | Root Level Role Name | Dimension | Root Level Role Name | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROOT_LEVEL_ROLE_NAME |
| Assignment Role | Role Hierarchy - (Role) | Root Level Role Unique ID | Dimension | Root Level Role Unique ID | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROOT_LEVEL_ROLE_OBJECT_ID |
| Assignment Role | Role Hierarchy - (Role) | Root Level Role Short Name | Dimension | Root Level Role Short Name | Oracle Primavera P6 Data Warehouse.Catalog.dbo.Dim_W_ROLE_HIERARCHY_D_RoleHierarchy.ROOT_LEVEL_ROLE_ID |