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

Related Topics