P6 - Activity / Primavera Activity on Demand
Description: Use this subject area to observe real time changes to project, WBS, and activity level details. This subject area includes earned value metrics and percent complete metrics, planned and actual units and hours, and project baseline comparisons.
| Folder | SubFolder | Field Name | Dimension/Fact/Lookup | Description | Values derived from |
|---|---|---|---|---|---|
| n.a. | Presentation Table | Presentation Column | n.a. | Description - Presentation Column | n.a. |
| Time | Calendar | Day of Month | Dimension | Day of the month (1 - 31) | Dim_W_DAY_D_Common.DAY_OF_MONTH |
| Time | Calendar | Day of Week | Dimension | Day of the week (1=Sunday, 7=Saturday) | Dim_W_DAY_D_Common.DAY_OF_WEEK |
| Time | Calendar | Day of Year | Dimension | Day of the year (1-365) | Dim_W_DAY_D_Common.DAY_OF_YEAR |
| Time | Calendar | Day Name | Dimension | Full day name (January 1, 2013) | Dim_W_DAY_D_Common.DAY_NAME |
| Time | Calendar | Calendar Half | Dimension | Calendar Half (1-2) | Dim_W_DAY_D_Common.CAL_HALF |
| Time | Calendar | Calendar Month | Dimension | Calendar Month (1-12) | Dim_W_DAY_D_Common.CAL_MONTH |
| Time | Calendar | Calendar Quarter | Dimension | Calendar Quarter (1-4) | Dim_W_DAY_D_Common.CAL_QTR |
| Time | Calendar | Calendar Week | Dimension | Calendar Week (1-53) | Dim_W_DAY_D_Common.CAL_WEEK |
| Time | Calendar | Calendar Date | Dimension | Calendar Date (01/01/2013 12:00am) | Dim_W_DAY_D_Common.DAY_DT |
| Time | Calendar | Calendar Year | Dimension | Calendar Year (2013) | Dim_W_DAY_D_Common.CAL_YEAR |
| Time | Calendar | Short Day Name | Dimension | Day-Month (01-JAN) | Dim_W_DAY_D_Common.SHORT_DAY_NAME |
| Time | Calendar | Day Date | Dimension | Calendar Date (01/01/2013 12:00am) | Dim_W_DAY_D_Common.DAY_DT |
| Time | Calendar | Financial Period | Dimension | Financial Period (2013-01-01) | Dim_W_DAY_D_Common.FIN_PERIOD_1 |
| Time | Calendar | Week Name | Dimension | First day of the week (2013-01-01) | Dim_W_DAY_D_Common.SORT_WEEK_NAME |
| Time | Calendar | Month Name | Dimension | Year-Month name (2013-01) | Dim_W_DAY_D_Common.SORT_MONTH_NAME |
| Time | Calendar | Quarter Name | Dimension | Year-Quarter name (2013-Q4) | Dim_W_DAY_D_Common.SORT_QUARTER_NAME |
| Time | Calendar | Half Name | Dimension | Year-Half name (2013-H1) | Dim_W_DAY_D_Common.SORT_HALF_NAME |
| Time | Calendar | Year Name | Dimension | Year Name (2013) | Dim_W_DAY_D_Common.YEAR_NAME |
| Time | Financial Period | Year Name | Dimension | Year Name (2013) | Dim_W_DAY_D_Financial_Period.YEAR_NAME |
| Time | Financial Period | Financial Period | Dimension | Financial Period (2013-01-01) | Dim_W_DAY_D_Financial_Period.FIN_PERIOD_1 |
| Time | Financial Period | Week Name | Dimension | The first day of the week (2013-01-01) | Dim_W_DAY_D_Financial_Period.WEEK_NAME |
| Time | Financial Period | Day Name | Dimension | Full day name (January 1, 2013) | Dim_W_DAY_D_Financial_Period.DAY_NAME |
| EPS | EPS | Root Level Id | Dimension | A short code which uniquely identifies the root level EPS | Dim_W_EPS_HIERARCHY_D_EpsHier.ROOT_LEVEL_SHORT_NAME |
| EPS | EPS | Root Level Name | Dimension | The name of the root level EPS | Dim_W_EPS_HIERARCHY_D_EpsHier.ROOT_LEVEL_NAME |
| EPS | EPS | EPS Id Level1 | Dimension | EPS Id Level 1 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV1 |
| EPS | EPS | EPS Name Level1 | Dimension | EPS Name Level 1 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV1 |
| EPS | EPS | EPS Id Level2 | Dimension | EPS Id Level 2 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV2 |
| EPS | EPS | EPS Name Level2 | Dimension | EPS Name Level 2 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV2 |
| EPS | EPS | EPS Id Level3 | Dimension | EPS Id Level 3 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV3 |
| EPS | EPS | EPS Name Level3 | Dimension | EPS Name Level 3 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV3 |
| EPS | EPS | EPS Id Level4 | Dimension | EPS Id Level 4 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV4 |
| EPS | EPS | EPS Name Level4 | Dimension | EPS Name Level 4 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV4 |
| EPS | EPS | EPS Id Level5 | Dimension | EPS Id Level 5 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV5 |
| EPS | EPS | EPS Name Level5 | Dimension | EPS Name Level 5 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV5 |
| EPS | EPS | EPS Id Level6 | Dimension | EPS Id Level 6 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV6 |
| EPS | EPS | EPS Name Level6 | Dimension | EPS Name Level 6 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV6 |
| EPS | EPS | EPS Id Level7 | Dimension | EPS Id Level 7 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV7 |
| EPS | EPS | EPS Name Level7 | Dimension | EPS Name Level 7 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV7 |
| EPS | EPS | EPS Id Level8 | Dimension | EPS Id Level 8 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV8 |
| EPS | EPS | EPS Name Level8 | Dimension | EPS Name Level 8 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV8 |
| EPS | EPS | EPS Id Level9 | Dimension | EPS Id Level 9 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV9 |
| EPS | EPS | EPS Name Level9 | Dimension | EPS Name Level 9 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV9 |
| EPS | EPS | EPS Id Level10 | Dimension | EPS Id Level 10 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV10 |
| EPS | EPS | EPS Name Level10 | Dimension | EPS Name Level 10 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV10 |
| EPS | EPS | EPS Id Level11 | Dimension | EPS Id Level 11 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV11 |
| EPS | EPS | EPS Name Level11 | Dimension | EPS Name Level 11 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV11 |
| EPS | EPS | EPS Id Level12 | Dimension | EPS Id Level 12 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV12 |
| EPS | EPS | EPS Name Level12 | Dimension | EPS Name Level 12 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV12 |
| EPS | EPS | EPS Id Level13 | Dimension | EPS Id Level 13 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV13 |
| EPS | EPS | EPS Name Level13 | Dimension | EPS Name Level 13 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV13 |
| EPS | EPS | EPS Id Level14 | Dimension | EPS Id Level 14 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV14 |
| EPS | EPS | EPS Name Level14 | Dimension | EPS Name Level 14 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV14 |
| EPS | EPS | EPS Id Level15 | Dimension | EPS Id Level 15 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV15 |
| EPS | EPS | EPS Name Level15 | Dimension | EPS Name Level 15 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV15 |
| EPS | EPS | EPS Id Level16 | Dimension | EPS Id Level 16 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV16 |
| EPS | EPS | EPS Name Level16 | Dimension | EPS Name Level 16 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV16 |
| EPS | EPS | EPS Id Level17 | Dimension | EPS Id Level 17 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV17 |
| EPS | EPS | EPS Name Level17 | Dimension | EPS Name Level 17 | Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV17 |
| Notebooks - (EPS) | Notebooks - (EPS) | Notebook Topic Name | Dimension | The name of the notebook topic | Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.NOTEBOOK_TOPIC_NAME |
| Notebooks - (EPS) | Notebooks - (EPS) | Notebook Text | lookup | The text of the notebook topic | lookup( DENSE Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.RAW_TEXT_NOTE, Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.ROW_WID, Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.EPS_WID) |
| Notebooks - (EPS) | Notebooks - (EPS) | Update User | Dimension | The last user to update notebook topic | Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.UPDATE_USER |
| Notebooks - (EPS) | Notebooks - (EPS) | Update Date | Dimension | The date the notebook topic was updated | Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.UPDATE_DATE |
| Notebooks - (EPS) | Notebooks - (EPS) | Create User | Dimension | The user that created the notebook topic | Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.CREATE_USER |
| Notebooks - (EPS) | Notebooks - (EPS) | Create Date | Dimension | The date the notebook topic was created | Dim_W_MV_P6_EPS_NOTE_D_EPS_Note_MV.CREATE_DATE |
| WBS | WBS Hierarchy - (WBS) | Full Path Name | Dimension | Full path for wbs hierarchy | Dim_W_WBS_HIERARCHY_D_WbsHier.FULL_PATH_NAME |
| WBS | WBS Hierarchy - (WBS) | Project Level Id | Dimension | A short code assigned to each WBS element for identification. Each WBS element is uniquely identified by concatenating its own code together with its parents codes | Dim_W_WBS_HIERARCHY_D_WbsHier.PROJ_LEVEL_SHORT_NAME |
| WBS | WBS Hierarchy - (WBS) | Project Level Name | Dimension | The name of the WBS element | Dim_W_WBS_HIERARCHY_D_WbsHier.PROJ_LEVEL_NAME |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level1 | Dimension | WBS ID Level 1 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV1 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level1 | Dimension | WBS Name Level 1 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV1 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level2 | Dimension | WBS ID Level 2 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV2 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level2 | Dimension | WBS Name Level 2 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV2 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level3 | Dimension | WBS ID Level 3 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV3 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level3 | Dimension | WBS Name Level 3 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV3 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level4 | Dimension | WBS ID Level 4 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV4 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level4 | Dimension | WBS Name Level 4 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV4 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level5 | Dimension | WBS ID Level 5 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV5 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level5 | Dimension | WBS Name Level 5 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV5 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level6 | Dimension | WBS ID Level 6 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV6 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level6 | Dimension | WBS Name Level 6 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV6 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level7 | Dimension | WBS ID Level 7 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV7 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level7 | Dimension | WBS Name Level 7 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV7 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level8 | Dimension | WBS ID Level 8 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV8 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level8 | Dimension | WBS Name Level 8 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV8 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level9 | Dimension | WBS ID Level 9 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV9 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level9 | Dimension | WBS Name Level9 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV9 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level10 | Dimension | WBS ID Level 10 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV10 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level10 | Dimension | WBS Name Level 10 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV10 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level11 | Dimension | WBS ID Level 11 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV11 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level11 | Dimension | WBS Name Level 11 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV11 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level12 | Dimension | WBS ID Level 12 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV12 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level12 | Dimension | WBS Name Level 12 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV12 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level13 | Dimension | WBS ID Level 13 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV13 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level13 | Dimension | WBS Name Level 13 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV13 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level14 | Dimension | WBS ID Level 14 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV14 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level14 | Dimension | WBS Name Level 14 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV14 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level15 | Dimension | WBS ID Level 15 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV15 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level15 | Dimension | WBS Name Level 15 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV15 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level16 | Dimension | WBS ID Level 16 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV16 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level16 | Dimension | WBS Name Level 16 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV16 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level17 | Dimension | WBS ID Level 17 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV17 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level17 | Dimension | WBS Name Level 17 | Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV17 |
| WBS | Notebooks - (WBS) | Notebook Topic Name | Dimension | The name of the notebook topic | Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.NOTEBOOK_TOPIC_NAME |
| WBS | Notebooks - (WBS) | Notebook Text | Lookup | The text of the notebook topic | lookup( DENSE Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.RAW_TEXT_NOTE, Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.ROW_WID, Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.WBS_WID) |
| WBS | Notebooks - (WBS) | Update User | Dimension | The last user to update notebook topic | Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.UPDATE_USER |
| WBS | Notebooks - (WBS) | Update Date | Dimension | The date the notebook topic was updated | Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.UPDATE_DATE |
| WBS | Notebooks - (WBS) | Create User | Dimension | The user that created the notebook topic | Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.CREATE_USER |
| WBS | Notebooks - (WBS) | Create Date | Dimension | The date the notebook topic was created | Dim_W_MV_P6_WBS_NOTE_D_WBS_Note_MV.CREATE_DATE |
| WBS | UDF Text - (WBS) | UDF'S | Dimension | n.a. | This folder displays WBS Text UDF's |
| WBS | UDF Date - (WBS) | UDF'S | Dimension | n.a. | This folder displays WBS Date UDF's |
| WBS | UDF Indicator - (WBS) | UDF'S | Dimension | n.a. | This folder displays WBS Indicator UDF's |
| OBS | OBS | OBS Name | Dimension | The name of the person/role in the organization | Dim_W_MV_P6_OBS_D_Obs_MV.OBS_NAME |
| Cost Breakdown Structure | Hierarchy - (CBS) | Root Level Name | Dimension | The root cost code name in the cost code hierarchy | Dim_W_CBS_HIERARCHY_D_CbsHier.ROOT_LEVEL_NAME |
| Cost Breakdown Structure | Hierarchy - (CBS) | Root Level Code | Dimension | The root cost code in the cost code hierarchy | Dim_W_CBS_HIERARCHY_D_CbsHier.ROOT_LEVEL_CODE |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level1 | Dimension | The cost code at the first level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV1 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level1 | Dimension | The cost code name at the first level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV1 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level2 | Dimension | The cost code at the second level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV2 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level2 | Dimension | The cost code name at the second level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV2 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level3 | Dimension | The cost code at the third level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV3 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level3 | Dimension | The cost code name at the third level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV3 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level4 | Dimension | The cost code at the fourth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV4 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level4 | Dimension | The cost code name at the fourth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV4 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level5 | Dimension | The cost code at the fifth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV5 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level5 | Dimension | The cost code name at the fifth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV5 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level6 | Dimension | The cost code at the sixth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV6 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level6 | Dimension | The cost code name at the sixth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV6 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level7 | Dimension | The cost code at the seventh level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV7 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level7 | Dimension | The cost code name at the seventh level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV7 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level8 | Dimension | The cost code at the eighth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV8 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level8 | Dimension | The cost code name at the eighth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV8 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level9 | Dimension | The cost code at the nineth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV9 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level9 | Dimension | The cost code name at the ninth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV9 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level10 | Dimension | The cost code at the tenth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV10 |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level10 | Dimension | The cost code name at the tenth level of detail | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV10 |
| Cost Breakdown Structure | General - (CBS) | CBS Code | Dimension | The full cost code | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE |
| Cost Breakdown Structure | General - (CBS) | CBS Name | Dimension | The name of the CBS element | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME |
| Cost Breakdown Structure | General - (CBS) | Cost Status | Dimension | The status of the cost code | Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_STATUS |
| Project | Project Portfolio | Project Portfolio Name | Dimension | The name of the portfolio | Dim_W_MV_P6_PROJECT_PORTFOLIO_D_Project_Portfolio_MV.PROJECT_PORTFOLIO_NAME |
| Project | Project Portfolio | Project Portfolio Description | Dimension | The description of the portfolio | Dim_W_MV_P6_PROJECT_PORTFOLIO_D_Project_Portfolio_MV.PROJECT_PORTFOLIO_DESCR |
| Project | General - (Project) | Project Object Id | Dimension | The Unique ID of the project | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_OBJECT_ID |
| Project | General - (Project) | Project WBS Object Id | Dimension | The Unique ID of the projects root level WBS | Dim_W_MV_P6_PROJECT_D_Project_MV.WBS_OBJECT_ID |
| Project | General - (Project) | Project ID | Dimension | The Project Id of the project | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_ID |
| Project | General - (Project) | Project Name | Dimension | The project name | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_NAME |
| Project | General - (Project) | Project Description | Dimension | The project description | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_DESCRIPTION |
| Project | General - (Project) | Added By | Dimension | The name of the user who added the project | Dim_W_MV_P6_PROJECT_D_Project_MV.ADDED_BY_NAME |
| Project | General - (Project) | Leveling Priority | Dimension | Priority for leveling | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_PRIORITY |
| Project | General - (Project) | Overall Project Score | Dimension | The Project score | Dim_W_MV_P6_PROJECT_D_Project_MV.OVERALL_PROJECT_SCORE |
| Project | General - (Project) | Project Risk Level | Dimension | Project risk level (1 - Very Low, 2 - Low, 3 - Medium, 4 - High, 5 - Very High) | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_RISK_LEVEL |
| Project | General - (Project) | Project Risk Score | Dimension | The calculated score value of the impact values assigned to the risk | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_RISK_SCORE |
| Project | General - (Project) | Project Risk Exposure | Dimension | The calculated exposure value for the risk | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_RISK_EXPOSURE |
| Project | General - (Project) | Status | Dimension | The status of the project as active, inactive, planned or what-if | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_STATUS |
| Project | General - (Project) | Strategic Priority | Dimension | Range 1 to 10,000 | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_STRATEGIC_PRIORITY |
| Project | General - (Project) | Project Owner | Dimension | Resource designated as owner of the project | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_OWNER |
| Project | General - (Project) | 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. | Dim_W_MV_P6_PROJECT_D_Project_MV.DATASOURCE_ID |
| Project | Dates - (Project) | Anticipated Start | Dimension | Anticipated start date of WBS, Project and EPS elements. User-entered - not dependent upon any other fields. If there are no children, the anticipated start date will be the Start date displayed in the columns. | Dim_W_MV_P6_PROJECT_D_Project_MV.ANTICIPATED_START_DATE |
| Project | Dates - (Project) | Anticipated Finish | Dimension | Anticipated finish date of WBS, Project and EPS elements. User-entered - not dependent upon any other fields. If there are no children, the anticipated finish date will be the Finish date displayed in the columns. | Dim_W_MV_P6_PROJECT_D_Project_MV.ANTICIPATED_FINISH_DATE |
| Project | Dates - (Project) | Data Date | Dimension | The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied. | Dim_W_MV_P6_PROJECT_D_Project_MV.DATA_DATE |
| Project | Dates - (Project) | Date Added | Dimension | The date this project was added | Dim_W_MV_P6_PROJECT_D_Project_MV.ADD_DATE |
| Project | Dates - (Project) | Start | Dimension | The current start date of the project. For a not started project, this is the project's planned start date. For a project that has started or is complete, this is the project's actual start date. For projects with no activities, the start date is equal to the anticipated start date if one is defined; if no anticipated start is defined, then the start date is equal to the project's planned start date. | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_START_DATE |
| Project | Dates - (Project) | Finish | Dimension | The current finish date of the project. For not started and in-progress projects, this is the latest early finish date from all activities in the project. For completed projects, this is the latest actual finish date derived from all activities. For projects with no activities, the Finish Date is equal to the Anticipated Finish date if one is defined. For projects with no activities and no Anticipated Finish date, the Finish Date field is blank. | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_FINISH_DATE |
| Project | Dates - (Project) | Forecast Start Date | Dimension | The start date optionally used by the project scheduler | Dim_W_MV_P6_PROJECT_D_Project_MV.FORECAST_START_DATE |
| Project | Dates - (Project) | Forecast Finish Date | Dimension | The end date optionally used by the project scheduler | Dim_W_MV_P6_PROJECT_D_Project_MV.FORECAST_FINISH_DATE |
| Project | Dates - (Project) | Must Finish By | Dimension | The optional date constraint you can specify for the project end date | Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_PLANNED_FINISH_DATE |
| Project | Dates - (Project) | Planned Start | Dimension | The date the project is scheduled to start | Dim_W_MV_P6_PROJECT_D_Project_MV.PLANNED_START_DATE |
| Project | Dates - (Project) | Planned Finish | Dimension | The date the project is scheduled to start | Dim_W_MV_P6_PROJECT_D_Project_MV.PLANNED_FINISH_DATE |
| Project | Dates - (Project) | Scheduled Finish | Dimension | The calculated latest early finish date, which is based on the schedule most recently generated for the project. | Dim_W_MV_P6_PROJECT_D_Project_MV.SCHEDULED_FINISH_DATE |
| Project | Dates - (Project) | Actual Start Date | Dimension | Actual Start Date | Dim_W_MV_P6_PROJECT_D_Project_MV.ACTUAL_START_DATE |
| Project | Dates - (Project) | Actual Finish Date | Dimension | Actual Finish Date | Dim_W_MV_P6_PROJECT_D_Project_MV.ACTUAL_FINISH_DATE |
| Project | Dates - (Project) | Baseline Start Date | Dimension | Baseline Start Date | Dim_W_MV_P6_PROJECT_D_Project_MV.BASELINE_START_DATE |
| Project | Dates - (Project) | Baseline Finish Date | Dimension | Baseline Finish Date | Dim_W_MV_P6_PROJECT_D_Project_MV.BASELINE_FINISH_DATE |
| Project | Dates - (Project) | Baseline Late Start Date | Dimension | Baseline Late Start Date | Dim_W_MV_P6_PROJECT_D_Project_MV.BL_LATE_START_DATE |
| Project | Dates - (Project) | Baseline Late Finish Date | Dimension | Baseline Late Finish Date | Dim_W_MV_P6_PROJECT_D_Project_MV.BL_LATE_FINISH_DATE |
| Project | Durations - (Project) | Actual Duration | Dimension | Actual duration is the total time from the project actual start date to the actual finish date (for completed projects), or to the current data date (for in-progress projects). | Dim_W_MV_P6_PROJECT_D_Project_MV.ACTUAL_DURATION |
| Project | Durations - (Project) | At Completion Duration | Dimension | The duration at completion is the total time from the project current start date to the current finish date. | Dim_W_MV_P6_PROJECT_D_Project_MV.AT_COMPLETION_DURATION |
| Project | Durations - (Project) | Baseline Duration | Dimension | The duration of the baseline project. | Dim_W_MV_P6_PROJECT_D_Project_MV.BASELINE_DURATION |
| Project | Durations - (Project) | Planned Duration | Dimension | Planned duration is the total time from the project planned start date to the planned finish date. | Dim_W_MV_P6_PROJECT_D_Project_MV.PLANNED_DURATION |
| Project | Durations - (Project) | Remaining Duration | Dimension | Remaining duration is the total time from the current data date to the current finish date. | Dim_W_MV_P6_PROJECT_D_Project_MV.REMAINING_DURATION |
| Project | Durations - (Project) | Variance - Baseline Project Duration | Dimension | The duration between the baseline project duration and the current project duration. Calculated as Planned Duration minus At Completion Duration. | Dim_W_MV_P6_PROJECT_D_Project_MV.DURATION_VARIANCE |
| Project | Durations - (Project) | Variance - Baseline Project Finish Date | Dimension | Variance - Baseline Project Finish Date | Dim_W_MV_P6_PROJECT_D_Project_MV.FINISH_DATE_VARIANCE |
| Project | Codes - (Project) | n.a. | Dimension | n.a. | Includes Project codes and descriptions |
| Project | Budget - (Project) | Current Budget | Dimension | The Current Budget is the sum of the Original Budget and all approved budget changes in the Budget Change Log. | Dim_W_MV_P6_PROJECT_D_Project_MV.CURRENT_BUDGET |
| Project | Budget - (Project) | Current Variance | Dimension | The difference between the current budget and the total spending plan. This value is not rolled up. Calculated as Current Budget minus Total Spending Plan. | Dim_W_MV_P6_PROJECT_D_Project_MV.CURRENT_VARIANCE |
| Project | Budget - (Project) | Distributed Current Budget | Dimension | The sum of all budgets that were assigned to control accounts during baseline planning. These budgets are allocated for work and planning packages. Calculated as the sum of the Current Budget values from one level lower. Not rolled up. | Dim_W_MV_P6_PROJECT_D_Project_MV.DISTRIBUTED_CURRENT_BUDGET |
| Project | Budget - (Project) | Original Budget | Dimension | The estimate of the total amount you require for the selected project, including all contributed funds. | Dim_W_MV_P6_PROJECT_D_Project_MV.ORIGINAL_BUDGET |
| Project | Budget - (Project) | Proposed Budget | Dimension | The proposed budget for the project. Calculated as Original Budget plus the sum of the Approved and Pending Budgets from the budget log. | Dim_W_MV_P6_PROJECT_D_Project_MV.PROPOSED_BUDGET |
| Project | Budget - (Project) | Total Benefit Plan | Dimension | Sum of the Monthly Benefit Plan. Not rolled up. | Dim_W_MV_P6_PROJECT_D_Project_MV.TOTAL_BENEFIT_PLAN |
| Project | Budget - (Project) | Total Benefit Plan Tally | Dimension | Sum of the Monthly Benefit Plan Tally. Not rolled up. | Dim_W_MV_P6_PROJECT_D_Project_MV.TOTAL_BENEFIT_PLAN_TALLY |
| Project | Budget - (Project) | Total Funding | Dimension | The total amount of funding contributed to the project by your funding sources. | Dim_W_MV_P6_PROJECT_D_Project_MV.TOTAL_FUNDING |
| Project | Budget - (Project) | Total Spending Plan | Dimension | Sum of the Monthly Spending Plan. Not rolled up. | Dim_W_MV_P6_PROJECT_D_Project_MV.TOTAL_SPENDING_PLAN |
| Project | Budget - (Project) | Total Spending Plan Tally | Dimension | Sum of the Monthly Spending Plan Tally. Not rolled up. | Dim_W_MV_P6_PROJECT_D_Project_MV.TOTAL_SPENDING_PLAN_TALLY |
| Project | Budget - (Project) | Unallocated Budget | Dimension | Calculated as Total Current Budget - Distributed Current Budget. | Dim_W_MV_P6_PROJECT_D_Project_MV.UNALLOCATED_BUDGET |
| Project | Budget - (Project) | Undistributed Current Variance | Dimension | Computed as the Total Spending Plan minus the Total Spending Plan Tally. Not rolled up. | Dim_W_MV_P6_PROJECT_D_Project_MV.UNDISTRIBUTED_CURRENT_VARIANCE |
| Project | Location - (Project) | Location Name | Dimension | The name of the location | Dim_W_MV_P6_PROJECT_D_Project_MV.LOCATION_NAME |
| Project | Location - (Project) | Location Type | Dimension | Location Type | Dim_W_MV_P6_PROJECT_D_Project_MV.LOCATION_TYPE |
| Project | Location - (Project) | Address Line 1 | Dimension | The first line of the address | Dim_W_MV_P6_PROJECT_D_Project_MV.ADDRESS_LINE1 |
| Project | Location - (Project) | Address Line 2 | Dimension | The second line of the address | Dim_W_MV_P6_PROJECT_D_Project_MV.ADDRESS_LINE2 |
| Project | Location - (Project) | City Name | Dimension | The city name for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.CITY_NAME |
| Project | Location - (Project) | Municipality Name | Dimension | The municipality name for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.MUNICIPALITY_NAME |
| Project | Location - (Project) | State Name | Dimension | The state name for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.STATE_NAME |
| Project | Location - (Project) | State Code | Dimension | The state abbreviation for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.STATE_CODE |
| Project | Location - (Project) | Country Name | Dimension | The country name for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.COUNTRY_NAME |
| Project | Location - (Project) | Country Code | Dimension | The country code for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.COUNTRY_CODE |
| Project | Location - (Project) | Postal Code | Dimension | The postal code for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.POSTAL_CODE |
| Project | Location - (Project) | Longitude | Dimension | The longitude for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.LONGITUDE |
| Project | Location - (Project) | Latitude | Dimension | The latitude for this Location | Dim_W_MV_P6_PROJECT_D_Project_MV.LATITUDE |
| Project | Notebooks - (Project) | Notebook Topic Name | Dimension | The name of the notebook topic | Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.NOTEBOOK_TOPIC_NAME |
| Project | Notebooks - (Project) | Notebook Text | Lookup | The text of the notebook topic | lookup( DENSE Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.RAW_TEXT_NOTE, Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.ROW_WID, Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.PROJECT_WID) |
| Project | Notebooks - (Project) | Update User | Dimension | The last user to update notebook topic | Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.UPDATE_USER |
| Project | Notebooks - (Project) | Update Date | Dimension | The date the notebook topic was updated | Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.UPDATE_DATE |
| Project | Notebooks - (Project) | Create User | Dimension | The user that created the notebook topic | Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.CREATE_USER |
| Project | Notebooks - (Project) | Create Date | Dimension | The date the notebook topic was created | Dim_W_MV_P6_PROJECT_NOTE_D_Project_Note_MV.CREATE_DATE |
| Project | Project Code Hierarchy - (Project) | Project Object ID | Dimension | The Unique ID of the project | Dim_W_PROJ_CODE_HIER_D_ProjHier.PROJECT_OBJECT_ID |
| Project | Project Code Hierarchy - (Project) | Assigned Code ID | Dimension | Assigned Code ID | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID |
| Project | Project Code Hierarchy - (Project) | Assigned Code Name | Dimension | Assigned Code Name | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME |
| Project | Project Code Hierarchy - (Project) | Assigned Code Object ID | Dimension | The Unique ID of the Assigned Code | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID |
| Project | Project Code Hierarchy - (Project) | Assigned Code Level | Dimension | Assigned Code Level | Dim_W_PROJ_CODE_HIER_D_ProjHier.LVL |
| Project | Project Code Hierarchy - (Project) | Full Path Name | Dimension | Full Path Name | Dim_W_PROJ_CODE_HIER_D_ProjHier.FULL_PATH_NAME |
| Project | Project Code Hierarchy - (Project) | Hierarchy Short Name | Dimension | Hierarchy Short Name | Dim_W_PROJ_CODE_HIER_D_ProjHier.HIER_SHORT_NAME |
| Project | Project Code Hierarchy - (Project) | Hierarchy Level Name | Dimension | Hierarchy Level Name | Dim_W_PROJ_CODE_HIER_D_ProjHier.HIER_LEVEL_NAME |
| Project | Project Code Hierarchy - (Project) | Code ID Level 1 | Dimension | Project Code ID Level 1 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV1 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 1 | Dimension | Project Code Name Level 1 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV1 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 1 | Dimension | Project Code Unique ID Level 1 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV1 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 2 | Dimension | Project Code ID Level 2 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV2 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 2 | Dimension | Project Code Name Level 2 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV2 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 2 | Dimension | Project Code Unique ID Level 2 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV2 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 3 | Dimension | Project Code ID Level 3 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV3 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 3 | Dimension | Project Code Name Level 3 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV3 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 3 | Dimension | Project Code Unique ID Level 3 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV3 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 4 | Dimension | Project Code ID Level 4 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV4 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 4 | Dimension | Project Code Name Level 4 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV4 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 4 | Dimension | Project Code Unique ID Level 4 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV4 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 5 | Dimension | Project Code ID Level 5 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV5 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 5 | Dimension | Project Code Name Level 5 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV5 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 5 | Dimension | Project Code Unique ID Level 5 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV5 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 6 | Dimension | Project Code ID Level 6 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV6 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 6 | Dimension | Project Code Name Level 6 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV6 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 6 | Dimension | Project Code Unique ID Level 6 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV6 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 7 | Dimension | Project Code ID Level 7 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV7 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 7 | Dimension | Project Code Name Level 7 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV7 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 7 | Dimension | Project Code Unique ID Level 7 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV7 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 8 | Dimension | Project Code ID Level 8 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV8 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 8 | Dimension | Project Code Name Level 8 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV8 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 8 | Dimension | Project Code Unique ID Level 8 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV8 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 9 | Dimension | Project Code ID Level 9 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV9 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 9 | Dimension | Project Code Name Level 9 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV9 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 9 | Dimension | Project Code Unique ID Level 9 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV9 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 10 | Dimension | Project Code ID Level 10 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV10 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 10 | Dimension | Project Code Name Level 10 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV10 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 10 | Dimension | Project Code Unique ID Level 10 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV10 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 11 | Dimension | Project Code ID Level 11 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV11 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 11 | Dimension | Project Code Name Level 11 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV11 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 11 | Dimension | Project Code Unique ID Level 11 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV11 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 12 | Dimension | Project Code ID Level 12 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV12 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 12 | Dimension | Project Code Name Level 12 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV12 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 12 | Dimension | Project Code Unique ID Level 12 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV12 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 13 | Dimension | Project Code ID Level 13 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV13 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 13 | Dimension | Project Code Name Level 13 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV13 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 13 | Dimension | Project Code Unique ID Level 13 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV13 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 14 | Dimension | Project Code ID Level 14 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV14 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 14 | Dimension | Project Code Name Level 14 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV14 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 14 | Dimension | Project Code Unique ID Level 14 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV14 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 15 | Dimension | Project Code ID Level 15 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV15 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 15 | Dimension | Project Code Name Level 15 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV15 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 15 | Dimension | Project Code Unique ID Level 15 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV15 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 16 | Dimension | Project Code ID Level 16 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV16 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 16 | Dimension | Project Code Name Level 16 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV16 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 16 | Dimension | Project Code Unique ID Level 16 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV16 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 17 | Dimension | Project Code ID Level 17 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV17 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 17 | Dimension | Project Code Name Level 17 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV17 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 17 | Dimension | Project Code Unique ID Level 17 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV17 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 18 | Dimension | Project Code ID Level 18 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV18 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 18 | Dimension | Project Code Name Level 18 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV18 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 18 | Dimension | Project Code Unique ID Level 18 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV18 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 19 | Dimension | Project Code ID Level 19 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV19 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 19 | Dimension | Project Code Name Level 19 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV19 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 19 | Dimension | Project Code Unique ID Level 19 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV19 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 20 | Dimension | Project Code ID Level 20 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV20 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 20 | Dimension | Project Code Name Level 20 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV20 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 20 | Dimension | Project Code Unique ID Level 20 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV20 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 21 | Dimension | Project Code ID Level 21 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV21 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 21 | Dimension | Project Code Name Level 21 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV21 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 21 | Dimension | Project Code Unique ID Level 21 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV21 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 22 | Dimension | Project Code ID Level 22 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV22 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 22 | Dimension | Project Code Name Level 22 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV22 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 22 | Dimension | Project Code Unique ID Level 22 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV22 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 23 | Dimension | Project Code ID Level 23 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV23 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 23 | Dimension | Project Code Name Level 23 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV23 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 23 | Dimension | Project Code Unique ID Level 23 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV23 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 24 | Dimension | Project Code ID Level 24 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV24 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 24 | Dimension | Project Code Name Level 24 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV24 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 24 | Dimension | Project Code Unique ID Level 24 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV24 |
| Project | Project Code Hierarchy - (Project) | Code ID Level 25 | Dimension | Project Code ID Level 25 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_ID_LV25 |
| Project | Project Code Hierarchy - (Project) | Code Name Level 25 | Dimension | Project Code Name Level 25 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_NAME_LV25 |
| Project | Project Code Hierarchy - (Project) | Code Object ID Level 25 | Dimension | Project Code Unique ID Level 25 | Dim_W_PROJ_CODE_HIER_D_ProjHier.ALT_HIER_OBJECT_ID_LV25 |
| Project | P6 Links | Link to Activities | Dimension | Go to Project Activities | '<a target="_blank" href="' || VALUEOF(NQ_SESSION.DW_P6_LINK_BASE_URL) || '/bookmark?uri=navigatetopage&ctx=projectList%3D' || cast(Dim_W_MV_P6_PROJECT_D_Project_MV.WBS_OBJECT_ID as VARCHAR ( 10 )) || '%26key%3Dactivities">' || 'Project Activities' || '</a>' |
| Project | P6 Links | Link to Team Usage | Dimension | Go to Project Team Usage | '<a target="_blank" href="' || VALUEOF(NQ_SESSION.DW_P6_LINK_BASE_URL) || '/bookmark?uri=navigatetopage&ctx=projectList%3D' || cast(Dim_W_MV_P6_PROJECT_D_Project_MV.WBS_OBJECT_ID as VARCHAR ( 10 )) || '%26key%3Dteamusage">' || 'Project Team Usage' || '</a>' |
| Project | P6 Links | Link to Issues | Dimension | Go to Project Issues | '<a target="_blank" href="' || VALUEOF(NQ_SESSION.DW_P6_LINK_BASE_URL) || '/action/pm/lwfissuemanagement?projectId=' || cast(Dim_W_MV_P6_PROJECT_D_Project_MV.PROJECT_OBJECT_ID as VARCHAR ( 10 )) || '&wbsId=' || cast(Dim_W_MV_P6_PROJECT_D_Project_MV.WBS_OBJECT_ID as VARCHAR ( 10 )) || '&checkTabs=true">' || 'Project Issues' || '</a>' |
| Project | P6 Links | Link to Risks | Dimension | Go to Project Risks | '<a target="_blank" href="' || VALUEOF(NQ_SESSION.DW_P6_LINK_BASE_URL) || '/bookmark?uri=navigatetopage&ctx=projectList%3D' || cast(Dim_W_MV_P6_PROJECT_D_Project_MV.WBS_OBJECT_ID as VARCHAR ( 10 )) || '%26key%3Drisks">' || 'Project Risks' || '</a>' |
| Project | P6 Links | Link to Documents | Dimension | Go to Project Documents | '<a target="_blank" href="' || VALUEOF(NQ_SESSION.DW_P6_LINK_BASE_URL) || '/bookmark?uri=navigatetopage&ctx=projectList%3D' || cast(Dim_W_MV_P6_PROJECT_D_Project_MV.WBS_OBJECT_ID as VARCHAR ( 10 )) || '%26key%3Ddocuments">' || 'Project Documents' || '</a>' |
| Project | UDF Text - (Project) | UDF'S | Dimension | n.a. | This folder displays Project Text UDF's |
| Project | UDF Date - (Project) | UDF'S | Dimension | n.a. | This folder displays Project Date UDF's |
| Project | UDF Indicator - (Project) | UDF'S | Dimension | n.a. | This folder displays Project Indicator UDF's |
| Expense | Expense | Expense Object Id | Dimension | The unique ID of the expense | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.ACTIVITY_EXPENSE_OBJECT_ID |
| Expense | Expense | Expense Item | Dimension | The name of the expense | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.EXPENSE_ITEM |
| Expense | Expense | Expense Category Name | Dimension | The category name of the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.EXPENSE_CAT_NAME |
| Expense | Expense | Expense Percent Complete | Dimension | The percent complete for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.EXPENSE_PERCENT_COMPLETE |
| Expense | Expense | Accrual Type | Dimension | The accrual type of the expense. Valid values are 'Start of Activity', 'End of Activity', and 'Uniform over Activity'. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.ACCRUAL_TYPE |
| Expense | Expense | Auto Compute | Dimension | Identifies whether the percent complete and actual/remaining units and costs for the expense are computed automatically using the status and percent complete of the associated activity. If this option is selected, the percent complete and actual/remaining units and costs are automatically updated when project actuals are applied. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.AUTO_COMPUTE |
| Expense | Expense | Cost Account ID | Dimension | The ID of the cost account associated with the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.COST_ACCOUNT_ID |
| Expense | Expense | Cost Account Name | Dimension | The name of the cost account associated with the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.COST_ACCOUNT_NAME |
| Expense | Expense | CBS Code | Dimension | The full cost code associated with the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.CBS_CODE |
| Expense | Expense | CBS Name | Dimension | The name of the cost code associated with the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.CBS_NAME |
| Expense | Expense | Document Number | Dimension | The document number for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.DOCUMENT_NUMBER |
| Expense | Expense | Actual Cost | Dimension | The actual cost of the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.ACTUAL_COST |
| Expense | Expense | Actual Units | Dimension | The actual units for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.ACTUAL_UNITS |
| Expense | Expense | At Completion Cost | Dimension | The at completion cost of the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.AT_COMPLETION_COST |
| Expense | Expense | At Completion Units | Dimension | The at completion units for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.AT_COMPLETION_UNITS |
| Expense | Expense | Planned Cost | Dimension | The planned cost of the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.PLANNED_COST |
| Expense | Expense | Planned Units | Dimension | The planned units for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.PLANNED_UNITS |
| Expense | Expense | Remaining Cost | Dimension | The remaining cost of the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.REMAINING_COST |
| Expense | Expense | Remaining Units | Dimension | The remaining units for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.REMAINING_UNITS |
| Expense | Expense | Over Budget | Dimension | Identifies whether actual cost exceeds the budgeted cost for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.OVER_BUDGET |
| Expense | Expense | Price Per Unit | Dimension | The price per unit for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.PRICE_PER_UNIT |
| Expense | Expense | Unit Of Measure | Dimension | The unit of measure for the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.UNIT_OF_MEASURE |
| Expense | Expense | Vendor Name | Dimension | The name of the vendor associated with the expense. | Dim_W_MV_P6_ACTIVITY_EXPENSE_D_Activity_Expense_MV.VENDOR_NAME |
| Risk | Risk | Risk Id | Dimension | The unique ID of the associated risk | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.RISK_ID |
| Risk | Risk | Risk Name | Dimension | The name of the risk | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.RISK_NAME |
| Risk | Risk | Description | Dimension | The risk description | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.DESCRIPTION |
| Risk | Risk | Risk Type | Dimension | Determines whether a risk is a threat or an opportunity. A threat will have a negative impact on your project, while an opportunity can have a perceived benefit to the project. | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.RISK_TYPE |
| Risk | Risk | Risk Status | Dimension | The current status of the Risk. Valid values are 'Proposed', 'Open', 'Rejected', 'Managed', and 'Impacted'. | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.RISK_STATUS |
| Risk | Risk | Category | Dimension | The name for a particular type of risk classification | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.CATEGORY |
| Risk | Risk | Owner | Dimension | The resource who has ownership of the risk | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.OWNER |
| Risk | Risk | Score | Dimension | The calculated score value of the impact values assigned to the risk. | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.SCORE |
| Risk | Risk | Score Color | Dimension | Risk Score Color | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.SCORE_COLOR |
| Risk | Risk | Score Text | Dimension | Risk Score Text | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.SCORE_TEXT |
| Risk | Risk | Risk Total Cost | Dimension | The total estimated cost for the risk. If the risk has an associated response plan, the cost is calculated from the risk response actions for the response plan. Not available if user does not have View Project Costs-Financial privilege. | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.TOTAL_COST |
| Risk | Risk | Exposure | Dimension | The calculated exposure value for the risk | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.Exposure |
| Risk | Risk | Exposure Start | Dimension | Risk Exposure Start Date | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.EXPOSURE_START |
| Risk | Risk | Exposure Finish | Dimension | Risk Exposure Finish Date | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.EXPOSURE_FINISH |
| Risk | Risk | Identified By Resource Id | Dimension | The short code of the resource that identified the risk | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.IDENTIFIED_BY_RESOURCE_ID |
| Risk | Risk | Identified By Resource Name | Dimension | The name of the resource that identified the risk | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.IDENTIFIED_BY_RESOURCE_NAME |
| Risk | Risk | Identified Date | Dimension | The date the risk was identified | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.IDENTIFIED_DATE |
| Risk | Risk | Cause | Dimension | The Cause the risk was identified | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.CAUSE |
| Risk | Risk | Effect | Dimension | The Effect of the risk was identified | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.EFFECT |
| Risk | Risk | Added By | Dimension | The user the risk was last modified by | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.ADDED_BY |
| Risk | Risk | Added Date | Dimension | The date the risk was last modified | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.CREATE_DATE |
| Risk | Risk | Last Modified By | Dimension | The user the risk was last modified by | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.LAST_MODIFIED_BY |
| Risk | Risk | Last Modified Date | Dimension | The date the risk was last modified | Dim_W_MV_P6_ACTIVITY_RISK_D_Activity_Risk_MV.UPDATE_DATE |
| Activity | General - (Activity) | Activity Id | Dimension | A short ID which uniquely identifies the activity within the project. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTIVITY_ID |
| Activity | General - (Activity) | Activity Name | Dimension | The name of the activity. The activity name does not have to be unique. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTIVITY_NAME |
| Activity | General - (Activity) | Activity Owner | Dimension | User who owns the activity | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTIVITY_OWNER |
| Activity | General - (Activity) | Activity Status | Dimension | The current status of the activity, either Not Started, In Progress, or Completed. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTIVITY_STATUS |
| Activity | General - (Activity) | Activity Type | Dimension | The type of activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone' or 'Finish Milestone'. A Task Dependent activity is scheduled using the activity's calendar rather than the calendars of the assigned resources. A Resource Dependent activity is scheduled using the calendars of the assigned resources. This type is used when several resources are assigned to the activity, but they may work separately. A Start/Finish Milestone is a zero-duration activity, marking a significant start/end of project event. A Level of Effort activity has a duration which is determined by its dependent activities. Administration-type activities are typically level of effort. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTIVITY_TYPE |
| Activity | General - (Activity) | Auto Compute Actuals | Dimension | Identifies whether the actual and remaining units, start date, finish date, and percent complete for the activity are computed automatically using the planned dates, budgeted units and the activity's schedule percent complete. If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. This assumes that all work for the activity proceeds according to plan. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.AUTO_COMPUTE_ACTUALS_FLAG |
| Activity | General - (Activity) | Calendar Name | Dimension | The calendar assigned to the activity. Activity calendars can be assigned from the global calendar pool or the project calendar pool. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.CALENDAR_NAME |
| Activity | General - (Activity) | Duration Type | Dimension | The duration type of the activity. One of Fixed Units per Time, Fixed Duration, or Fixed Units. For Fixed Units per Time activities, the resource units per time are constant when the activity duration or units are changed. This type is used when an activity has fixed resources with fixed productivity output per time period. For Fixed Duration activities, the activity duration is constant as the units or resource units per time are changed. This type is used when the activity is to be completed within a fixed time period regardless of the resources assigned. For Fixed Units activities, the activity units are constant when the duration or resource units per time are changed. This type is used when the total amount of work is fixed, and increasing the resources can decrease the activity duration. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.DURATION_TYPE |
| Activity | General - (Activity) | Is Critical | Dimension | Indicates whether the activity is critical. An activity is critical when its Total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.IS_CRITICAL |
| Activity | General - (Activity) | Is Longest Path | Dimension | Indicates whether an activity is on the longest path. The longest path is defined as activities that are on the critical path and determine the end date of the project. Defining critical activities based on the longest path in the project provides an alternative to viewing critical activities based on float. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.IS_LONGEST_PATH |
| Activity | General - (Activity) | Leveling Priority | Dimension | The activity priority can be used to prioritize activities in a project when performing resource leveling. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LEVELING_PRIORITY |
| Activity | General - (Activity) | Percent Complete Type | Dimension | The activity percent complete type is one of Duration, Units, or Physical. The percent complete type controls whether the Activity % Complete is tied to the Duration % Complete, the Units % Complete, or the Physical % Complete for the activity. Set the percent complete type to Duration for activities which are duration driven, for example, administration tasks and training classes. Set the percent complete type to Physical for activities which are work-product driven, for example, creating a document or a product. Set the percent complete type to Units for activities which are work effort driven, for example, providing a consulting service. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.COMPLETE_PCT_TYPE |
| Activity | General - (Activity) | Primary Constraint Type | Dimension | The type of constraint applied to the activity start or finish date. Activity constraints are used by the project scheduler. Start date constraints are 'Start On', 'Start On or Before', 'Start On or After' and 'Mandatory Start'. Finish date constraints are 'Finish On', 'Finish On or Before', 'Finish On or After' and 'Mandatory Finish'. Another type of constraint, 'As Late as Possible', schedules the activity as late as possible based on the available free float. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PRIMARY_CONSTRAINT_TYPE |
| Activity | General - (Activity) | Primary Resource Name | Dimension | The primary resource for the activity. The primary resource is responsible for the overall work on the activity and updates the activity status using Progress Reporter. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PRIMARY_RESOURCE_NAME |
| Activity | General - (Activity) | Secondary Constraint Type | Dimension | The second type of constraint applied to the activity start or finish date. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.SECONDARY_CONSTRAINT_TYPE |
| Activity | General - (Activity) | WBS Code | Dimension | The Work Breakdown Structure Code for the activity | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.WBS_CODE |
| Activity | General - (Activity) | WBS Name | Dimension | The Work Breakdown Structure Name for the activity | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.WBS_NAME |
| Activity | Dates - (Activity) | Actual Start | Dimension | The date on which the activity actually started | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTUAL_START_DATE |
| Activity | Dates - (Activity) | Actual Finish | Dimension | The date on which the activity actually finished | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTUAL_FINISH_DATE |
| Activity | Dates - (Activity) | Baseline Project Start | Dimension | The Project Baseline Planned Start Date | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.BASELINE_START_DATE |
| Activity | Dates - (Activity) | Baseline Project Finish | Dimension | The Project Baseline Planned Finish Date | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.BASELINE_FINISH_DATE |
| Activity | Dates - (Activity) | Baseline Late Start Date | Dimension | Baseline Late Start Date | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.BL_LATE_START_DATE |
| Activity | Dates - (Activity) | Baseline Late Finish Date | Dimension | Baseline Late Finish Date | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.BL_LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Data Date | Dimension | The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.DATA_DATE |
| Activity | Dates - (Activity) | Early Start | Dimension | The earliest possible date the remaining work for the activity can begin. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.EARLY_START_DATE |
| Activity | Dates - (Activity) | Early Finish | Dimension | The earliest possible date the activity can finish. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.EARLY_FINISH_DATE |
| Activity | Dates - (Activity) | Expected Finish | Dimension | The date the activity is expected to finish. Typically, this date is entered in the Timesheets module by the primary resource. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.EXPECT_FINISH_DATE |
| Activity | Dates - (Activity) | External Early Start | Dimension | The External Early Start date is the earliest finish date of all lost external relationships. This field is populated only during import when a relationship is lost because it does not exist in the current database. This date may be used to calculate the start date of the current activity in place of the true relationship when scheduling. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.EXTERNAL_EARLY_START_DATE |
| Activity | Dates - (Activity) | External Late Finish | Dimension | The External Late Finish date is the latest start date of all lost external relationships. This field is populated only during import when a relationship is lost because it does not exist in the current database. This date may be used to calculate the finish date of the current activity in place of the true relationship when scheduling. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.EXTERNAL_LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Start | Dimension | The current start date of the activity. Set to the activity remaining early start date while the activity is not started, and the actual start date once the activity is started. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.START_DATE |
| Activity | Dates - (Activity) | Finish | Dimension | The current finish date of the activity. Set to the activity remaining early finish date while the activity is not started or in progress, and the actual finish date once the activity is completed. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.FINISH_DATE |
| Activity | Dates - (Activity) | Late Start | Dimension | The latest possible date the remaining work for the activity must begin without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LATE_START_DATE |
| Activity | Dates - (Activity) | Late Finish | Dimension | The latest possible date the activity must finish without delaying the project finish date. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Planned Start | Dimension | The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PLANNED_START_DATE |
| Activity | Dates - (Activity) | Planned Finish | Dimension | The date the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PLANNED_FINISH_DATE |
| Activity | Dates - (Activity) | Primary Constraint Date | Dimension | The constraint date for the activity, if the activity has a constraint. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PRIMARY_CONSTRAINT_DATE |
| Activity | Dates - (Activity) | Secondary Constraint Date | Dimension | The second constraint date for the activity, if the activity has a constraint | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.SECONDARY_CONSTRAINT_DATE |
| Activity | Dates - (Activity) | Remaining Early Start | Dimension | The date the remaining work for the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining start date is the same as the planned start date. This is the start date that Progress Reporter users follow. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.REMAINING_START_DATE |
| Activity | Dates - (Activity) | Remaining Early Finish | Dimension | The date the remaining work for the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date. This is the finish date that Progress Reporter users follow. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.REMAINING_FINISH_DATE |
| Activity | Dates - (Activity) | Remaining Late Start | Dimension | Remaining late start date as calculated by the scheduler | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.REMAINING_LATE_START_DATE |
| Activity | Dates - (Activity) | Remaining Late Finish | Dimension | Remaining late end date as calculated by the scheduler | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.REMAINING_LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Suspend Date | Dimension | The date progress is suspended on an activity | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.SUSPEND_DATE |
| Activity | Dates - (Activity) | Resume Date | Dimension | The date progress is resumed on an activity | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.RESUME_DATE |
| Activity | Durations - (Activity) | Actual Duration | Dimension | Actual duration is the total working time from the activity actual start date to the actual finish date (for completed activities), or to the current data date (for in-progress activities). The actual working time is computed using the activity's calendar. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ACTUAL_DURATION |
| Activity | Durations - (Activity) | At Completion Duration | Dimension | The duration at completion is the total working time from the activity's current start date to the current finish date. The current start date is the planned start date until the activity is started, then it is the actual start date. The current finish date is the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed. The total working time is computed using the activity's calendar. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.AT_COMPLETION_DURATION |
| Activity | Durations - (Activity) | Baseline Duration | Dimension | The duration for the activity in the primary baseline | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.BASELINE_DURATION |
| Activity | Durations - (Activity) | Baseline Planned Duration | Dimension | Baseline Planned Duration is the total working time from the baseline activity planned start date to the baseline planned finish date. The baseline planned working time is computed using the activity's calendar. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.BASELINE_PLANNED_DURATION |
| Activity | Durations - (Activity) | Free Float | Dimension | The amount of time the activity can be delayed before delaying the start date of any successor activity. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.FREE_FLOAT |
| Activity | Durations - (Activity) | Original Duration | Dimension | Original Duration is the total working time from the activity planned start date to the planned finish date. The planned working time is computed using the activity's calendar. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PLANNED_DURATION |
| Activity | Durations - (Activity) | Remaining Duration | Dimension | Remaining duration is the total working time from the activity remaining start date to the remaining finish date. The remaining working time is computed using the activity's calendar. Before the activity is started, the remaining duration is the same as the Original Duration. After the activity is completed the remaining duration is zero. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.REMAINING_DURATION |
| Activity | Durations - (Activity) | Remaining Float | Dimension | The amount of time remaining by which the activity can be delayed before delaying the project finish date. Computed as Late Finish - Remaining Finish. If the remaining finish is the same as the early finish ( in general, when the activity is not started), then the remaining float is the same as the total float. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.REMAINING_FLOAT |
| Activity | Durations - (Activity) | Total Float | Dimension | The amount of time the activity can be delayed before delaying the project finish date. Total float can be computed as Late Start - Early Start or as Late Finish - Early Finish; this option can be set when running the project scheduler. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.TOTAL_FLOAT |
| Activity | Durations - (Activity) | Variance - Baseline Project Duration | Dimension | The duration between the activity's baseline duration and the at completion duration. Calculated as Planned Duration minus At Completion Duration. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.DURATION_VARIANCE |
| Activity | Durations - (Activity) | Variance - Baseline Project Start Date | Dimension | The duration between the current project start date and the baseline start date. Calculated as Start minus Baseline Project Start. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.START_DATE_VARIANCE |
| Activity | Durations - (Activity) | Variance - Baseline Project Finish Date | Dimension | The duration between the current project finish date and the baseline project finish date. Calculated as Finish minus Baseline Project Finish. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.FINISH_DATE_VARIANCE |
| Activity | Percent Completes - (Activity) | Duration % of Planned | Dimension | The percent complete of the activity duration. Computed as (Planned Duration - Remaining Duration)/Original Duration * 100. Always in the range 0 to 100. The Planned Duration is taken from the current plan, not from the baseline. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.DURATION_PCT_OF_PLANNED |
| Activity | Percent Completes - (Activity) | Duration Percent Complete | Dimension | The percent complete of the activity duration. Computed as (Original Duration - Remaining Duration)/Original Duration * 100. Always in the range 0 to 100. The Original Duration is taken from the current plan, not from the baseline. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.DURATION_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Expense Cost % Complete | Dimension | Percent complete of cost for all expenses associated with an activity. Computed as Actual Expense Cost / At Completion Expense Cost* 100. Always in the range 0 to 100. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.EXPENSE_COST_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Labor Units % Complete | Dimension | The percent complete of units for all labor resources for the activity. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LABOR_UNITS_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Nonlabor Cost % Complete | Dimension | The percent complete of cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.NONLABOR_COST_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Nonlabor Units % Complete | Dimension | The percent complete of units for all nonlabor resources for the activity. Computed as Actual Nonlabor Units / At Completion Nonlabor Units * 100. Always in the range 0 to 100. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.NONLABOR_UNITS_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Percent Complete | Dimension | The activity percent complete. This value is tied to the activity Duration % Complete, Units % Complete, or Physical % Complete, depending on the setting for the activity's Percent Complete Type, which is one of Duration, Units, or Physical. Always in the range 0 to 100. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PERCENT_COMPLETE |
| Activity | Percent Completes - (Activity) | Performance % Complete | Dimension | The activity performance percent complete. The performance percent complete is used to compute earned value and may be based on the Activity % Complete, on the 0/100 rule, on the 50/50 rule, etc., depending on the technique for computing earned-value percent complete for the activity's WBS. The Performance % Complete specifies what percentage of the activity's planned worth has been earned so far. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PERFORMANCE_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Physical % Complete | Dimension | The physical percent complete can either be user entered or calculated from the activity's weighted steps. There is a project setting specifying this. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.PHYSICAL_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Schedule % Complete | Dimension | The activity schedule percent complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline Start, the Schedule % Complete is 0. If the data date is later than the baseline Finish, the Schedule % Complete is 100. The Schedule % Complete indicates how much of the activity duration should be currently completed, relative to the selected baseline. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.SCHEDULE_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Units % Complete | Dimension | The percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as Actual Units / At Completion Units * 100. Always in the range 0 to 100. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.UNITS_PCT_COMPLETE |
| Activity | Codes - (Activity) | n.a. | Dimension | n.a. | Includes activity codes and descriptions |
| Activity | Activity Code Hierarchy - (Activity) | Activity Object ID | Dimension | Activity Object ID | Dim_W_ACT_CODE_HIER_D_ActHier.ACTIVITY_OBJECT_ID |
| Activity | Activity Code Hierarchy - (Activity) | Assigned Code ID | Dimension | Assigned Code ID | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID |
| Activity | Activity Code Hierarchy - (Activity) | Assigned Code Name | Dimension | Assigned Code Name | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME |
| Activity | Activity Code Hierarchy - (Activity) | Assigned Code Object ID | Dimension | Assigned Code Unique ID | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID |
| Activity | Activity Code Hierarchy - (Activity) | Assigned Code Level | Dimension | Assigned Code Level | Dim_W_ACT_CODE_HIER_D_ActHier.LVL |
| Activity | Activity Code Hierarchy - (Activity) | Full Path Name | Dimension | Full Path Name | Dim_W_ACT_CODE_HIER_D_ActHier.FULL_PATH_NAME |
| Activity | Activity Code Hierarchy - (Activity) | Hierarchy Short Name | Dimension | Hierarchy Short Name | Dim_W_ACT_CODE_HIER_D_ActHier.HIER_SHORT_NAME |
| Activity | Activity Code Hierarchy - (Activity) | Hierarchy Level Name | Dimension | Hierarchy Level Name | Dim_W_ACT_CODE_HIER_D_ActHier.HIER_LEVEL_NAME |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 1 | Dimension | Activity Code ID Level 1 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV1 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 1 | Dimension | Activity Code Name Level 1 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV1 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 1 | Dimension | Activity Code Unique ID Level 1 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV1 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 2 | Dimension | Activity Code ID Level 2 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV2 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 2 | Dimension | Activity Code Name Level 2 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV2 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 2 | Dimension | Activity Code Unique ID Level 2 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV2 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 3 | Dimension | Activity Code ID Level 3 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV3 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 3 | Dimension | Activity Code Name Level 3 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV3 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 3 | Dimension | Activity Code Unique ID Level 3 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV3 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 4 | Dimension | Activity Code ID Level 4 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV4 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 4 | Dimension | Activity Code Name Level 4 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV4 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 4 | Dimension | Activity Code Unique ID Level 4 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV4 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 5 | Dimension | Activity Code ID Level 5 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV5 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 5 | Dimension | Activity Code Name Level 5 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV5 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 5 | Dimension | Activity Code Unique ID Level 5 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV5 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 6 | Dimension | Activity Code ID Level 6 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV6 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 6 | Dimension | Activity Code Name Level 6 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV6 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 6 | Dimension | Activity Code Unique ID Level 6 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV6 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 7 | Dimension | Activity Code ID Level 7 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV7 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 7 | Dimension | Activity Code Name Level 7 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV7 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 7 | Dimension | Activity Code Unique ID Level 7 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV7 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 8 | Dimension | Activity Code ID Level 8 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV8 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 8 | Dimension | Activity Code Name Level 8 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV8 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 8 | Dimension | Activity Code Unique ID Level 8 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV8 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 9 | Dimension | Activity Code ID Level 9 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV9 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 9 | Dimension | Activity Code Name Level 9 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV9 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 9 | Dimension | Activity Code Unique ID Level 9 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV9 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 10 | Dimension | Activity Code ID Level 10 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV10 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 10 | Dimension | Activity Code Name Level 10 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV10 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 10 | Dimension | Activity Code Unique ID Level 10 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV10 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 11 | Dimension | Activity Code ID Level 11 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV11 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 11 | Dimension | Activity Code Name Level 11 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV11 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 11 | Dimension | Activity Code Unique ID Level 11 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV11 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 12 | Dimension | Activity Code ID Level 12 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV12 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 12 | Dimension | Activity Code Name Level 12 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV12 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 12 | Dimension | Activity Code Unique ID Level 12 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV12 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 13 | Dimension | Activity Code ID Level 13 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV13 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 13 | Dimension | Activity Code Name Level 13 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV13 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 13 | Dimension | Activity Code Unique ID Level 13 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV13 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 14 | Dimension | Activity Code ID Level 14 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV14 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 14 | Dimension | Activity Code Name Level 14 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV14 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 14 | Dimension | Activity Code Unique ID Level 14 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV14 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 15 | Dimension | Activity Code ID Level 15 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV15 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 15 | Dimension | Activity Code Name Level 15 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV15 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 15 | Dimension | Activity Code Unique ID Level 15 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV15 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 16 | Dimension | Activity Code ID Level 16 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV16 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 16 | Dimension | Activity Code Name Level 16 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV16 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 16 | Dimension | Activity Code Unique ID Level 16 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV16 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 17 | Dimension | Activity Code ID Level 17 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV17 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 17 | Dimension | Activity Code Name Level 17 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV17 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 17 | Dimension | Activity Code Unique ID Level 17 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV17 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 18 | Dimension | Activity Code ID Level 18 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV18 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 18 | Dimension | Activity Code Name Level 18 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV18 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 18 | Dimension | Activity Code Unique ID Level 18 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV18 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 19 | Dimension | Activity Code ID Level 19 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV19 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 19 | Dimension | Activity Code Name Level 19 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV19 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 19 | Dimension | Activity Code Unique ID Level 19 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV19 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 20 | Dimension | Activity Code ID Level 20 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV20 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 20 | Dimension | Activity Code Name Level 20 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV20 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 20 | Dimension | Activity Code Unique ID Level 20 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV20 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 21 | Dimension | Activity Code ID Level 21 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV21 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 21 | Dimension | Activity Code Name Level 21 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV21 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 21 | Dimension | Activity Code Unique ID Level 21 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV21 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 22 | Dimension | Activity Code ID Level 22 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV22 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 22 | Dimension | Activity Code Name Level 22 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV22 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 22 | Dimension | Activity Code Unique ID Level 22 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV22 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 23 | Dimension | Activity Code ID Level 23 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV23 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 23 | Dimension | Activity Code Name Level 23 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV23 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 23 | Dimension | Activity Code Unique ID Level 23 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV23 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 24 | Dimension | Activity Code ID Level 24 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV24 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 24 | Dimension | Activity Code Name Level 24 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV24 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 24 | Dimension | Activity Code Unique ID Level 24 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV24 |
| Activity | Activity Code Hierarchy - (Activity) | Code ID Level 25 | Dimension | Activity Code ID Level 25 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_ID_LV25 |
| Activity | Activity Code Hierarchy - (Activity) | Code Name Level 25 | Dimension | Activity Code Name Level 25 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_NAME_LV25 |
| Activity | Activity Code Hierarchy - (Activity) | Code Object ID Level 25 | Dimension | Activity Code Unique ID Level 25 | Dim_W_ACT_CODE_HIER_D_ActHier.ALT_HIER_OBJECT_ID_LV25 |
| Activity | Notebooks - (Activity) | Notebook Topic Name | Dimension | The name of the notebook topic | Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.NOTEBOOK_TOPIC_NAME |
| Activity | Notebooks - (Activity) | Notebook Text | Lookup | The text of the notebook topic | lookup( DENSE Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.RAW_TEXT_NOTE, Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.ROW_WID, Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.ACTIVITY_WID) |
| Activity | Notebooks - (Activity) | Update User | Dimension | The last user to update notebook topic | Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.UPDATE_USER |
| Activity | Notebooks - (Activity) | Update Date | Dimension | The date the notebook topic was updated | Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.UPDATE_DATE |
| Activity | Notebooks - (Activity) | Create User | Dimension | The user that created the notebook topic | Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.CREATE_USER |
| Activity | Notebooks - (Activity) | Create Date | Dimension | The date the notebook topic was created | Dim_W_MV_P6_ACTIVITY_NOTE_D_Activity_Note_MV.CREATE_DATE |
| Activity | Relationships - (Activity) | Predecessor Activity Id | Dimension | The ID of the predecessor activity. | Dim_W_MV_P6_RELATIONSHIP_D_Relationship_MV.PRED_ACT_ID |
| Activity | Relationships - (Activity) | Predecessor Activity Name | Dimension | The name of the predecessor activity. | Dim_W_MV_P6_RELATIONSHIP_D_Relationship_MV.PRED_ACT_NAME |
| Activity | Relationships - (Activity) | Successor Activity Id | Dimension | The ID of the successor activity. | Dim_W_MV_P6_RELATIONSHIP_D_Relationship_MV.SUCC_ACT_ID |
| Activity | Relationships - (Activity) | Successor Activity Name | Dimension | The name of the successor activity. | Dim_W_MV_P6_RELATIONSHIP_D_Relationship_MV.SUCC_ACT_NAME |
| Activity | Relationships - (Activity) | Type | Dimension | The type of the activity based on the relationship (predecessor, successor, or orphan). | Dim_W_MV_P6_RELATIONSHIP_D_Relationship_MV.TYPE |
| Activity | Relationships - (Activity) | Relationship Type | Dimension | The relationship type (Finish to Start, Start to Start, etc.). | Dim_W_MV_P6_RELATIONSHIP_D_Relationship_MV.RELATIONSHIP_TYPE |
| Activity | Relationships - (Activity) | Lag | Dimension | The lag assigned to the relationship. | Dim_W_MV_P6_RELATIONSHIP_D_Relationship_MV.LAG |
| Activity | Steps - (Activity) | Activity Step Object ID | Dimension | The Unique ID of the activity step | Dim_W_MV_P6_ACTIVITY_STEP_D_Activity_Step_MV.ACTIVITY_STEP_OBJECT_ID |
| Activity | Steps - (Activity) | Step Name | Dimension | The name of the step | Dim_W_MV_P6_ACTIVITY_STEP_D_Activity_Step_MV.STEP_NAME |
| Activity | Steps - (Activity) | Step Weight | Dimension | Step weight determines the importance of this step in relation to other steps assigned to the activity. | Dim_W_MV_P6_ACTIVITY_STEP_D_Activity_Step_MV.STEP_WEIGHT |
| Activity | Steps - (Activity) | Weight Percent Complete | Dimension | Step weight associated percent complete. | Dim_W_MV_P6_ACTIVITY_STEP_D_Activity_Step_MV.WEIGHT_COMPLETE |
| Activity | Steps - (Activity) | Step Percent Complete | Dimension | The percent complete of this specific step. This is manually entered. | Dim_W_MV_P6_ACTIVITY_STEP_D_Activity_Step_MV.STEP_PERCENT_COMPLETE |
| Activity | Steps - (Activity) | Sequence Number | Dimension | Sequence Number of Steps assigned to Activity | Dim_W_MV_P6_ACTIVITY_STEP_D_Activity_Step_MV.SEQUENCE_NUMBER |
| Activity | Steps - (Activity) | Is Completed | Dimension | Is Completed flag determines if the step has been marked completed | Dim_W_MV_P6_ACTIVITY_STEP_D_Activity_Step_MV.IS_COMPLETED_FLAG |
| Activity | Multiple Float Paths - (Activity) | Float Path | Dimension | The project scheduler determines the most critical and sub-critical paths. The float path field identifies the critical path that each activity is on. The number starts from 1 (where 1 is most critical) to the max number of float paths identified by the scheduler. This field is used when determining multiple float paths using the Free Float and Total Float method. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.FLOAT_PATH |
| Activity | Multiple Float Paths - (Activity) | Float Path Order | Dimension | This field is computed by the project scheduler and identifies the order in which the activities were processed within the float path. | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.FLOAT_PATH_ORDER |
| Activity | Location - (Activity) | Location Name | Dimension | The name of the location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LOCATION_NAME |
| Activity | Location - (Activity) | Location Type | Dimension | Location Type | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LOCATION_TYPE |
| Activity | Location - (Activity) | Address Line1 | Dimension | The first line of the address | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ADDRESS_LINE1 |
| Activity | Location - (Activity) | Address Line2 | Dimension | The second line of the address | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.ADDRESS_LINE2 |
| Activity | Location - (Activity) | City Name | Dimension | The city name for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.CITY_NAME |
| Activity | Location - (Activity) | Municipality Name | Dimension | The municipality name for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.MUNICIPALITY_NAME |
| Activity | Location - (Activity) | State Name | Dimension | The state name for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.STATE_NAME |
| Activity | Location - (Activity) | State Code | Dimension | The state abbreviation for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.STATE_CODE |
| Activity | Location - (Activity) | Country Name | Dimension | The country name for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.COUNTRY_NAME |
| Activity | Location - (Activity) | Country Code | Dimension | The country code for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.COUNTRY_CODE |
| Activity | Location - (Activity) | Postal Code | Dimension | The postal code for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.POSTAL_CODE |
| Activity | Location - (Activity) | Longitude | Dimension | The longitude for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LONGITUDE |
| Activity | Location - (Activity) | Latitude | Dimension | The latitude for this Location | Dim_W_MV_P6_ACTIVITY_D_Activity_MV.LATITUDE |
| Activity | Text UDFs - (Activity) | UDF'S | Dimension | n.a. | This folder displays Activity Text UDF's |
| Activity | Date UDFs - (Activity) | UDF'S | Dimension | n.a. | This folder displays Activity Date UDF's |
| Activity | Indicator UDFs - (Activity) | UDF'S | Dimension | n.a. | This folder displays Activity Indicator UDF's |
| Resource | General - (Resource) | Resource Id | Dimension | A short code which uniquely identifies the primary resource | Dim_W_MV_P6_RESOURCE_D_Resource_MV.RESOURCE_ID |
| Resource | General - (Resource) | Resource Name | Dimension | The name of the primary resource | Dim_W_MV_P6_RESOURCE_D_Resource_MV.RESOURCE_NAME |
| Resource | General - (Resource) | Resource Title | Dimension | The title of the resource | Dim_W_MV_P6_RESOURCE_D_Resource_MV.RESOURCE_TITLE |
| Resource | General - (Resource) | Resource Type | Dimension | Indicates whether the resource is labor, nonlabor, or material | Dim_W_MV_P6_RESOURCE_D_Resource_MV.RESOURCE_TYPE |
| Resource | General - (Resource) | Active Flag | 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. | Dim_W_MV_P6_RESOURCE_D_Resource_MV.ACTIVE_FLAG |
| Resource | General - (Resource) | Primary Role Object Id | Dimension | The unique Id of the role that is assigned as the resource's primary role | Dim_W_MV_P6_RESOURCE_D_Resource_MV.PRIMARY_ROLE_OBJECT_ID |
| Resource | General - (Resource) | Primary Role Name | Dimension | The name of the role that is assigned as the resource's primary role | Dim_W_MV_P6_RESOURCE_D_Resource_MV.PRIMARY_ROLE_NAME |
| 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. | Dim_W_MV_P6_RESOURCE_D_Resource_MV.DATASOURCE_ID |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID | Dimension | Resource Unique ID | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID |
| Resource | Resource Hierarchy - (Resource) | Resource ID | Dimension | Resource ID | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID |
| Resource | Resource Hierarchy - (Resource) | Resource Name | Dimension | Resource Name | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME |
| Resource | Resource Hierarchy - (Resource) | Root Level Resource Object ID | Dimension | Root Level Resource Unique ID | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.ROOT_LEVEL_RESOURCE_OBJECT_ID |
| Resource | Resource Hierarchy - (Resource) | Root Level Resource ID | Dimension | Root Level Resource ID | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.ROOT_LEVEL_RESOURCE_ID |
| Resource | Resource Hierarchy - (Resource) | Root Level Resource Name | Dimension | Root Level Resource Name | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.ROOT_LEVEL_RESOURCE_NAME |
| Resource | Resource Hierarchy - (Resource) | Resource Level | Dimension | Resource Level | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.LVL |
| Resource | Resource Hierarchy - (Resource) | Full Path Name | Dimension | Full Path Name | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.FULL_PATH_NAME |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 1 | Dimension | Resource ID Level 1 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV1 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 1 | Dimension | Resource Name Level 1 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV1 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 1 | Dimension | Resource Unique ID Level 1 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV1 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 2 | Dimension | Resource ID Level 2 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV2 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 2 | Dimension | Resource Name Level 2 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV2 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 2 | Dimension | Resource Unique ID Level 2 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV2 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 3 | Dimension | Resource ID Level 3 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV3 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 3 | Dimension | Resource Name Level 3 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV3 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 3 | Dimension | Resource Unique ID Level 3 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV3 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 4 | Dimension | Resource ID Level 4 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV4 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 4 | Dimension | Resource Name Level 4 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV4 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 4 | Dimension | Resource Unique ID Level 4 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV4 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 5 | Dimension | Resource ID Level 5 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV5 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 5 | Dimension | Resource Name Level 5 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV5 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 5 | Dimension | Resource Unique ID Level 5 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV5 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 6 | Dimension | Resource ID Level 6 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV6 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 6 | Dimension | Resource Name Level 6 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV6 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 6 | Dimension | Resource Unique ID Level 6 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV6 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 7 | Dimension | Resource ID Level 7 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV7 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 7 | Dimension | Resource Name Level 7 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV7 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 7 | Dimension | Resource Unique ID Level 7 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV7 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 8 | Dimension | Resource ID Level 8 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV8 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 8 | Dimension | Resource Name Level 8 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV8 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 8 | Dimension | Resource Unique ID Level 8 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV8 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 9 | Dimension | Resource ID Level 9 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV9 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 9 | Dimension | Resource Name Level 9 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV9 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 9 | Dimension | Resource Unique ID Level 9 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV9 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 10 | Dimension | Resource ID Level 10 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV10 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 10 | Dimension | Resource Name Level 10 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV10 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 10 | Dimension | Resource Unique ID Level 10 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV10 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 11 | Dimension | Resource ID Level 11 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV11 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 11 | Dimension | Resource Name Level 11 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV11 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 11 | Dimension | Resource Unique ID Level 11 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV11 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 12 | Dimension | Resource ID Level 12 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV12 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 12 | Dimension | Resource Name Level 12 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV12 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 12 | Dimension | Resource Unique ID Level 12 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV12 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 13 | Dimension | Resource ID Level 13 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV13 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 13 | Dimension | Resource Name Level 13 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV13 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 13 | Dimension | Resource Unique ID Level 13 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV13 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 14 | Dimension | Resource ID Level 14 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV14 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 14 | Dimension | Resource Name Level 14 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV14 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 14 | Dimension | Resource Unique ID Level 14 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV14 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 15 | Dimension | Resource ID Level 15 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV15 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 15 | Dimension | Resource Name Level 15 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV15 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 15 | Dimension | Resource Unique ID Level 15 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV15 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 16 | Dimension | Resource ID Level 16 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV16 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 16 | Dimension | Resource Name Level 16 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV16 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 16 | Dimension | Resource Unique ID Level 16 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV16 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 17 | Dimension | Resource ID Level 17 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV17 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 17 | Dimension | Resource Name Level 17 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV17 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 17 | Dimension | Resource Unique ID Level 17 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV17 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 18 | Dimension | Resource ID Level 18 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV18 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 18 | Dimension | Resource Name Level 18 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV18 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 18 | Dimension | Resource Unique ID Level 18 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV18 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 19 | Dimension | Resource ID Level 19 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV19 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 19 | Dimension | Resource Name Level 19 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV19 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 19 | Dimension | Resource Unique ID Level 19 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV19 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 20 | Dimension | Resource ID Level 20 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV20 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 20 | Dimension | Resource Name Level 20 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV20 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 20 | Dimension | Resource Unique ID Level 20 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV20 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 21 | Dimension | Resource ID Level 21 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV21 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 21 | Dimension | Resource Name Level 21 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV21 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 21 | Dimension | Resource Unique ID Level 21 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV21 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 22 | Dimension | Resource ID Level 22 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV22 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 22 | Dimension | Resource Name Level 22 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV22 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 22 | Dimension | Resource Unique ID Level 22 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV22 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 23 | Dimension | Resource ID Level 23 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV23 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 23 | Dimension | Resource Name Level 23 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV23 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 23 | Dimension | Resource Unique ID Level 23 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV23 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 24 | Dimension | Resource ID Level 24 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV24 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 24 | Dimension | Resource Name Level 24 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV24 |
| Resource | Resource Hierarchy - (Resource) | Resource Object ID Level 24 | Dimension | Resource Unique ID Level 24 | Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV24 |
| Resource | Codes - (Resource) | n.a. | Dimension | n.a. | Includes Resource codes and descriptions |
| Resource | Resource Code Hierarchy - (Resource) | Resource Object ID | Dimension | Resource Unique ID | Dim_W_RSRC_CODE_HIER_D_RsrcHier.RESOURCE_OBJECT_ID |
| Resource | Resource Code Hierarchy - (Resource) | Assigned Code ID | Dimension | Assigned Code ID | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID |
| Resource | Resource Code Hierarchy - (Resource) | Assigned Code Name | Dimension | Assigned Code Name | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME |
| Resource | Resource Code Hierarchy - (Resource) | Assigned Code Object ID | Dimension | Assigned Code Unique ID | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID |
| Resource | Resource Code Hierarchy - (Resource) | Assigned Code Level | Dimension | Assigned Code Level | Dim_W_RSRC_CODE_HIER_D_RsrcHier.LVL |
| Resource | Resource Code Hierarchy - (Resource) | Full Path Name | Dimension | Full Path Name | Dim_W_RSRC_CODE_HIER_D_RsrcHier.FULL_PATH_NAME |
| Resource | Resource Code Hierarchy - (Resource) | Hierarchy Short Name | Dimension | Hierarchy Short Name | Dim_W_RSRC_CODE_HIER_D_RsrcHier.HIER_SHORT_NAME |
| Resource | Resource Code Hierarchy - (Resource) | Hierarchy Level Name | Dimension | Hierarchy Level Name | Dim_W_RSRC_CODE_HIER_D_RsrcHier.HIER_LEVEL_NAME |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 1 | Dimension | Resource Code ID Level 1 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV1 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 1 | Dimension | Resource Code Name Level 1 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV1 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 1 | Dimension | Resource Code Unique ID Level 1 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV1 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 2 | Dimension | Resource Code ID Level 2 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV2 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 2 | Dimension | Resource Code Name Level 2 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV2 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 2 | Dimension | Resource Code Unique ID Level 2 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV2 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 3 | Dimension | Resource Code ID Level 3 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV3 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 3 | Dimension | Resource Code Name Level 3 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV3 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 3 | Dimension | Resource Code Unique ID Level 3 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV3 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 4 | Dimension | Resource Code ID Level 4 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV4 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 4 | Dimension | Resource Code Name Level 4 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV4 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 4 | Dimension | Resource Code Unique ID Level 4 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV4 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 5 | Dimension | Resource Code ID Level 5 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV5 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 5 | Dimension | Resource Code Name Level 5 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV5 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 5 | Dimension | Resource Code Unique ID Level 5 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV5 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 6 | Dimension | Resource Code ID Level 6 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV6 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 6 | Dimension | Resource Code Name Level 6 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV6 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 6 | Dimension | Resource Code Unique ID Level 6 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV6 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 7 | Dimension | Resource Code ID Level 7 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV7 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 7 | Dimension | Resource Code Name Level 7 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV7 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 7 | Dimension | Resource Code Unique ID Level 7 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV7 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 8 | Dimension | Resource Code ID Level 8 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV8 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 8 | Dimension | Resource Code Name Level 8 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV8 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 8 | Dimension | Resource Code Unique ID Level 8 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV8 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 9 | Dimension | Resource Code ID Level 9 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV9 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 9 | Dimension | Resource Code Name Level 9 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV9 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 9 | Dimension | Resource Code Unique ID Level 9 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV9 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 10 | Dimension | Resource Code ID Level 10 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV10 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 10 | Dimension | Resource Code Name Level 10 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV10 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 10 | Dimension | Resource Code Unique ID Level 10 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV10 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 11 | Dimension | Resource Code ID Level 11 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV11 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 11 | Dimension | Resource Code Name Level 11 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV11 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 11 | Dimension | Resource Code Unique ID Level 11 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV11 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 12 | Dimension | Resource Code ID Level 12 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV12 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 12 | Dimension | Resource Code Name Level 12 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV12 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 12 | Dimension | Resource Code Unique ID Level 12 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV12 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 13 | Dimension | Resource Code ID Level 13 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV13 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 13 | Dimension | Resource Code Name Level 13 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV13 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 13 | Dimension | Resource Code Unique ID Level 13 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV13 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 14 | Dimension | Resource Code ID Level 14 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV14 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 14 | Dimension | Resource Code Name Level 14 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV14 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 14 | Dimension | Resource Code Unique ID Level 14 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV14 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 15 | Dimension | Resource Code ID Level 15 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV15 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 15 | Dimension | Resource Code Name Level 15 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV15 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 15 | Dimension | Resource Code Unique ID Level 15 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV15 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 16 | Dimension | Resource Code ID Level 16 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV16 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 16 | Dimension | Resource Code Name Level 16 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV16 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 16 | Dimension | Resource Code Unique ID Level 16 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV16 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 17 | Dimension | Resource Code ID Level 17 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV17 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 17 | Dimension | Resource Code Name Level 17 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV17 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 17 | Dimension | Resource Code Unique ID Level 17 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV17 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 18 | Dimension | Resource Code ID Level 18 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV18 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 18 | Dimension | Resource Code Name Level 18 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV18 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 18 | Dimension | Resource Code Unique ID Level 18 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV18 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 19 | Dimension | Resource Code ID Level 19 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV19 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 19 | Dimension | Resource Code Name Level 19 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV19 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 19 | Dimension | Resource Code Unique ID Level 19 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV19 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 20 | Dimension | Resource Code ID Level 20 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV20 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 20 | Dimension | Resource Code Name Level 20 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV20 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 20 | Dimension | Resource Code Unique ID Level 20 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV20 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 21 | Dimension | Resource Code ID Level 21 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV21 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 21 | Dimension | Resource Code Name Level 21 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV21 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 21 | Dimension | Resource Code Unique ID Level 21 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV21 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 22 | Dimension | Resource Code ID Level 22 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV22 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 22 | Dimension | Resource Code Name Level 22 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV22 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 22 | Dimension | Resource Code Unique ID Level 22 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV22 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 23 | Dimension | Resource Code ID Level 23 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV23 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 23 | Dimension | Resource Code Name Level 23 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV23 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 23 | Dimension | Resource Code Unique ID Level 23 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV23 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 24 | Dimension | Resource Code ID Level 24 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV24 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 24 | Dimension | Resource Code Name Level 24 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV24 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 24 | Dimension | Resource Code Unique ID Level 24 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV24 |
| Resource | Resource Code Hierarchy - (Resource) | Code ID Level 25 | Dimension | Resource Code ID Level 25 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_ID_LV25 |
| Resource | Resource Code Hierarchy - (Resource) | Code Name Level 25 | Dimension | Resource Code Name Level 25 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_NAME_LV25 |
| Resource | Resource Code Hierarchy - (Resource) | Code Object ID Level 25 | Dimension | Resource Code Unique ID Level 25 | Dim_W_RSRC_CODE_HIER_D_RsrcHier.ALT_HIER_OBJECT_ID_LV25 |
| Resource | Location - (Resource) | Location Name | Dimension | The name of the location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.LOCATION_NAME |
| Resource | Location - (Resource) | Location Type | Dimension | Location Type | Dim_W_MV_P6_RESOURCE_D_Resource_MV.LOCATION_TYPE |
| Resource | Location - (Resource) | Address Line 1 | Dimension | The first line of the address | Dim_W_MV_P6_RESOURCE_D_Resource_MV.ADDRESS_LINE1 |
| Resource | Location - (Resource) | Address Line 2 | Dimension | The second line of the address | Dim_W_MV_P6_RESOURCE_D_Resource_MV.ADDRESS_LINE2 |
| Resource | Location - (Resource) | City Name | Dimension | The city name for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.CITY_NAME |
| Resource | Location - (Resource) | Municipality Name | Dimension | The municipality name for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.MUNICIPALITY_NAME |
| Resource | Location - (Resource) | State Name | Dimension | The state name for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.STATE_NAME |
| Resource | Location - (Resource) | State Code | Dimension | The state abbreviation for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.STATE_CODE |
| Resource | Location - (Resource) | Country Name | Dimension | The country name for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.COUNTRY_NAME |
| Resource | Location - (Resource) | Country Code | Dimension | The country code for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.COUNTRY_CODE |
| Resource | Location - (Resource) | Postal Code | Dimension | The postal code for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.POSTAL_CODE |
| Resource | Location - (Resource) | Longitude | Dimension | The longitude for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.LONGITUDE |
| Resource | Location - (Resource) | Latitude | Dimension | The latitude for this Location | Dim_W_MV_P6_RESOURCE_D_Resource_MV.LATITUDE |
| Resource | UDF Text - (Resource) | UDF's | Dimension | n.a. | This folder displays Resource Text UDF's |
| Resource | UDF Date - (Resource) | UDF's | Dimension | n.a. | This folder displays Resource Date UDF's |
| Resource | UDF Indicator - (Resource) | UDF's | Dimension | n.a. | This folder displays Resource Indicator UDF's |
| n.a. | n.a. | n.a. | n.a. | n.a. | n.a. |
| n.a. | n.a. | n.a. | n.a. | n.a. | n.a. |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Cost % Complete | Fact | The percent complete of cost for all labor resources, nonlabor resources, material resources, and expenses for the activity. Computed as Actual Total Cost / At Completion Total Cost * 100. Always in the range 0 to 100. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_TOTAL_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_TOTAL_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Cost % of Planned | Fact | The proportion of the cost budget that has been spent. Computed as actual total cost / baseline total cost. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Expense Cost % Complete | Fact | The percent complete of cost for all expenses associated with the wbs. Computed as Actual Expense Cost / At Complete Expense Cost * 100. Always in the range 0 to 100. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_EXPENSE_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_EXPENSE_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Labor Cost % Complete | Fact | The percent complete of cost for all labor resources assigned to the wbs. Computed as Actual Labor Cost / At Complete Labor Cost * 100. Always in the range 0 to 100. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_LABOR_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Labor Units % Complete | Fact | The percent complete of units for all labor resources for the activity. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_LABOR_UNITS) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Material Cost % Complete | Fact | The percent complete of cost for all material resources assigned to the wbs. Computed as Actual Material Cost / At Complete Material Cost * 100. Always in the range 0 to 100. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_MATERIAL_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_MATERIAL_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Nonlabor Cost % Complete | Fact | The percent complete of cost for all nonlabor resources assigned to the wbs. Computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100. Always in the range 0 to 100. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_NONLABOR_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_NONLABOR_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Nonlabor Units % Complete | Fact | The percent complete of units for all nonlabor resources for the activity. Computed as Actual Nonlabor Units / At Completion Nonlabor Units * 100. Always in the range 0 to 100. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_NONLABOR_UNITS) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_NONLABOR_UNITS) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Performance % Complete | Fact | The activity performance percent complete. The performance percent complete is used to compute earned value and may be based on the Activity % Complete, on the 0/100 rule, on the 50/50 rule, etc., depending on the technique for computing earned-value percent complete for the activity's WBS. The Performance % Complete specifies what percentage of the activity's planned worth has been earned so far. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Schedule % Complete | Fact | Schedule % Complete | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Units % Complete | Fact | The percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as Actual Units / At Completion Units * 100. Always in the range 0 to 100. | (ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) , 0) + ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_NONLABOR_UNITS) , 0)) / nullif( ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_LABOR_UNITS) , 0) + ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_NONLABOR_UNITS) , 0) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Performance % Complete (Units) | Fact | Perfomance % Complete (Units) | ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) , 0) / nullif( ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS) , 0) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Percent Complete | Schedule % Complete (Units) | Fact | Schedule % Complete (Units) | ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS) , 0) / nullif( ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS) , 0) , 0) * 100 |
| Fact - Primavera - Activity (On Demand) | Units | Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Actual Nonlabor Units | Fact | The actual units for all nonlabor resources assigned to the activity | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_NONLABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | At Completion Labor Units | Fact | The labor units at completion is the sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as Actual Labor Units + Remaining Labor Units. Same as the budgeted labor units if the activity is not started and the actual labor units once the activity is completed. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | At Completion Nonlabor Units | Fact | The nonlabor units at completion is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Units + Remaining Nonlabor Units. Same as the budgeted nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_NONLABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Planned Labor Units | Fact | The budgeted units for all labor resources assigned to the activity | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Planned Nonlabor Units | Fact | The budgeted units for all nonlabor resources assigned to the activity | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_NONLABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Remaining Labor Units | Fact | The remaining units for all labor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the budgeted units. After the activity is completed, the remaining units are zero. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Remaining Late Labor Units | Fact | Remaining Late Labor Units | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LATE_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Remaining Late Nonlabor Units | Fact | Remaining Late Nonlabor Units | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LATE_NONLABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Remaining Nonlabor Units | Fact | The remaining units for all nonlabor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the budgeted units. After the activity is completed, the remaining units are zero. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_NONLABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Baseline Project Labor Units | Fact | The sum of the Budgeted (or At Completion) units for all labor resources assigned to the activity in the project baseline. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Baseline Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity in the project baseline | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_ACTUAL_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Baseline Project Nonlabor Units | Fact | The sum of the Budgeted (or At Completion) units for all nonlabor resources assigned to the activity in the project baseline | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_NONLABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Units | Baseline Actual Nonlabor Units | Fact | The actual units for all nonlabor resources assigned to the activity in the project baseline | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_ACTUAL_NONLABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Costs | Actual Expense Cost | Fact | The actual cost for all project expenses associated with the activity | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_EXPENSE_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Actual Labor Cost | Fact | The actual cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Actual Labor Units * Project Default Price / Time. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Actual Material Cost | Fact | The actual cost for all material resources assigned to the activity | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_MATERIAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Actual Nonlabor Cost | Fact | The actual cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Actual Nonlabor Units * Project Default Price / Time. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_NONLABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Actual Total Cost | Fact | The Actual Total Cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Actual Total Cost = Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_TOTAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | At Completion Expense Cost | Fact | The expense cost at completion is the sum of the actual plus remaining cost for all expenses associated with the activity. Computed as Actual Expense Cost + Remaining Expense Cost. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_EXPENSE_COST |
| Fact - Primavera - Activity (On Demand) | Costs | At Completion Labor Cost | Fact | The labor cost at completion is the sum of the actual plus remaining cost for all labor resources assigned to the activity. Computed as Actual Labor Cost + Remaining Labor Cost. Same as the budgeted labor cost if the activity is not started and the actual labor cost once the activity is completed. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_LABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | At Completion Material Cost | Fact | The material cost at completion is the sum of the actual plus remaining cost for all material resources assigned to the activity. Computed as Actual Material Cost + Remaining Material Cost. Same as the budgeted material cost if the activity is not started and the actual material cost once the activity is completed. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_MATERIAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | At Completion Nonlabor Cost | Fact | The nonlabor cost at completion is the sum of the actual plus remaining cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost + Remaining Nonlabor Cost. Same as the budgeted nonlabor cost if the activity is not started and the actual nonlabor cost once the activity is completed. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_NONLABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | At Completion Total Cost | Fact | The total cost at completion for the activity, including labor resources, nonlabor resources, material resources, and project expenses. At Completion Total Cost = At Completion Labor Cost + At Completion Nonlabor Cost + At Completion Material Cost + At Completion Expense Cost. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.AT_COMPLETION_TOTAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Planned Expense Cost | Fact | The budgeted cost for all project expenses associated with the activity. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_EXPENSE_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Planned Labor Cost | Fact | The budgeted costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Budgeted Labor Units * Project Default Price / Time. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_LABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Planned Material Cost | Fact | The budgeted costs for all material resources assigned to the activity. If no resources are assigned, computed as the activity Budgeted Labor Units * Project Default Price / Time. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_MATERIAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Planned Nonlabor Cost | Fact | The budgeted costs for all nonlabor resources assigned to the activity. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_NONLABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Planned Total Cost | Fact | The budgeted total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Budgeted Total Cost = Budgeted Labor Cost + Budgeted Nonlabor Cost + Budgeted Material Cost + Budgeted Expense Cost. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_TOTAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Expense Cost | Fact | The remaining cost for all project expenses associated with the activity. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_EXPENSE_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Labor Cost | Fact | The remaining cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Labor Units * Project Default Price / Time. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Late Expense Cost | Fact | Remaining Late Expense Cost | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LATE_EXPENSE_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Late Labor Cost | Fact | Remaining Late Labor Cost | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LATE_LABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Late Material Cost | Fact | Remaining Late Material Cost | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LATE_MATERIAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Late Nonlabor Cost | Fact | Remaining Late Nonlabor Cost | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LATE_NONLABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Late Total Cost | Fact | The Remaining Late Total Cost for the period specified | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_LATE_TOTAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Material Cost | Fact | The remaining cost for all material resources assigned to the activity. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_MATERIAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Nonlabor Cost | Fact | The remaining cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Nonlabor Units * Project Default Price / Time. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_NONLABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Remaining Total Cost | Fact | The remaining total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Remaining Total Cost = Remaining Labor Cost + Remaining Nonlabor Cost + Remaining Material Cost + Remaining Expense Cost. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.REMAINING_TOTAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Project Expense Cost | Fact | The cost for all the project expenses associated with the activity in the project baseline. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_EXPENSE_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Project Labor Cost | Fact | The cost for all the labor resources assigned to an activity in the project baseline. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Project Material Cost | Fact | Budgeted or (At Completion)cost for all material resources assigned to the activity in the project baseline. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_MATERIAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Project Nonlabor Cost | Fact | The cost for all the Nonlabor resources assigned to an activity in the project baseline | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_NONLABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Project Total Cost | Fact | The total cost of the activity in the project baseline, including labor resources, non-labor resources, material resources, and project expenses. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Actual Expense Cost | Fact | The actual cost for all project expenses associated with the activity in the primary baseline | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_ACTUAL_EXPENSE_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Actual Labor Cost | Fact | The actual cost for all labor resources assigned to the activity in the project baseline. If no resources are assigned, computed as the activity Baseline Project Actual Labor Units * Project Default Price / Time. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_ACTUAL_LABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Actual Material Cost | Fact | The actual cost for all material resources assigned to the activity in the project baseline | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_ACTUAL_MATERIAL_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Actual Nonlabor Cost | Fact | The actual cost for all nonlabor resources assigned to the activity in the project baseline. If no resources are assigned, computed as the activity Baseline Project Actual Nonlabor Units * Project Default Price / Time | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_ACTUAL_NONLABOR_COST |
| Fact - Primavera - Activity (On Demand) | Costs | Baseline Actual Total Cost | Fact | The actual total cost for the activity in the project baseline, including labor resources, nonlabor resources, material resources and project expenses. Baseline Project Actual Total Cost = Baseline Project Actual Labor Cost + Baseline Project Actual Nonlabor Cost + Baseline Project Actual Material Cost + Baseline Project Actual Expense Cost | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_ACTUAL_TOTAL_COST |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Accounting Variance (Units) | Fact | Accounting Variance Labor Units is the Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Budget At Completion (Units) | Fact | Budget at Completion Labor Units is the baseline Labor Units + baseline Nonlabor Labor Units + baseline Expense Labor Units + baseline Material Labor Units. Same as the baseline Total Labor Units. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Cost Performance Index (Units) | Fact | Cost Performance Index Labor Units is the Earned Value Labor Units / Actual Labor Units. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Cost Schedule Index (Units) | Fact | Cost Schedule Index By Units | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) , 0) * sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Cost Variance (Units) | Fact | Cost Variance Labor Units is Earned Value Labor Units minus Actual Labor Units. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Cost Variance Index (Units) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | (sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Earned Value (Units) | Fact | Earned Value Labor Units Performed is the portion of the baseline Labor Units that is actually completed as of the project data date. Computed as baseline Labor Units * Performance % Complete. The Earned Value Labor Units is essentially the labor units earned value for the activity. The method for computing the Performance % Complete depends on the earned value technique selected for the activity's WBS. The baseline Labor Units is taken from the baseline. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Estimate At Completion (Units) | Fact | Estimate At Completion Labor Units is calculated as Actual Labor Units + Estimate To Complete Labor Units. (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the WBS.) | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_AT_COMPLETION_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Estimate To Complete (Units) | Fact | The estimated quantity to complete of the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Budgeted Labor Units - Budgeted Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS. | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_TO_COMPLETE_LABOR_UNITS |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Planned Value (Units) | Fact | Planned Value Labor Units Scheduled is the portion of the baseline Labor Units that is scheduled to be completed as of the project data date. For activities without resource assignments, and for activity resource assignments that do not have resource curves, computed as baseline Labor Units * Schedule % Complete. For activity resource assignments that do have resource curves, the curve distribution is additionally factored into the calculation. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. The baseline Labor Units is taken from the baseline. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Schedule Performance Index (Units) | Fact | Schedule Performance Index Labor Units is the Earned Value Labor Units divided by Planned Value Labor Units. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Schedule Variance (Units) | Fact | Schedule Variance Labor Units is the Earned Value Labor Units minus Planned Value Labor Units. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Schedule Variance Index (Units) | Fact | Schedule Variance Index is the Schedule Variance Labor Units divided by the Planned Value Labor Units. | (sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_LABOR_UNITS) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | To Complete Performance Index - BAC (Units) | Fact | The To Complete Performance Index is (Budget at Completion (BAC) - Earned Value Labor Units) / (Budget at Completion (BAC) - Actual Labor Units). | (sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | To Complete Performance Index - EAC (Units) | Fact | The To Complete Performance Index is (Budget at Completion (EAC) - Earned Value Labor Units) / (Estimated at Completion - Actual Labor Units). | (sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_LABOR_UNITS)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_AT_COMPLETION_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_LABOR_UNITS) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Units) | Variance at Completion (Units) | Fact | Variance At Completion is the Planned Labor Units minus Estimate At Completion Labor Units. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_LABOR_UNITS) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_AT_COMPLETION_LABOR_UNITS) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Accounting Variance (Cost) | Fact | Accounting Variance is the Planned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value | ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST) , 0) - ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Budget At Completion (Cost) | Fact | Budget at Completion is the baseline Labor Cost + baseline Nonlabor Cost + baseline Expense Cost + baseline Material Cost. Same as the baseline Total Cost. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Cost Performance Index (Cost) | Fact | Cost Performance Index is the Earned Value divided by the Actual Cost. A value less than 1 indicates that Actual Cost have exceeded the Planned Value. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Cost Schedule Index (Cost) | Fact | Cost Schedule Index By Cost | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) , 0) * sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Cost Variance (Cost) | Fact | Cost Variance is the Earned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value. | ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) , 0) - ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Cost Variance Index (Cost) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | (ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) , 0) - ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) , 0)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Earned Value (Cost) | Fact | Earned value cost for the project | Sum Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Estimate At Completion (Cost) | Fact | Estimate Cost at Completion is the Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS. | Sum Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_AT_COMPLETION_COST |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Estimate To Complete (Cost) | Fact | Calculated Estimate To Complete using specified technique | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_TO_COMPLETE_COST |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Planned Value (Cost) | Fact | Planned cost of work scheduled for the project | sum of Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Schedule Performance Index (Cost) | Fact | Schedule Performance Index is the Earned Value divided by Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled. | sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Schedule Variance (Cost) | Fact | Schedule Variance is the Earned Value minus the Planned Value. A negative value indicates that less work was actually performed than was scheduled. | ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) , 0) - ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Schedule Variance Index (Cost) | Fact | Schedule Variance Index is the Schedule Variance divided by Planned Value. | (ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST) , 0) - ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST) , 0)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PLANNED_VALUE_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | To Complete Performance Index - BAC (Cost) | Fact | The To Complete Performance Index is (Budget at Completion - Earned Value) / (Budget at Completion (BAC)- Actual Cost). | (sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | To Complete Performance Index - EAC (Cost) | Fact | The To Complete Performance Index is (Budget at Completion - Earned Value) / (Estimate at Completion - Actual Cost). | (sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EARNED_VALUE_COST)) / nullif( sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_AT_COMPLETION_COST) - sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTUAL_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Earned Value - (Cost) | Variance at Completion (Cost) | Fact | Variance At Completion is the Budget At Completion (baseline total cost) minus Estimate At Completion. | ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.BL_PLANNED_TOTAL_COST) , 0) - ifnull(sum(Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.EST_AT_COMPLETION_COST) , 0) |
| Fact - Primavera - Activity (On Demand) | Metrics | # of Projects | Fact | # Of Projects | count(distinct Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.PROJECT_WID) |
| Fact - Primavera - Activity (On Demand) | Metrics | # of Activities | Fact | # Of Activities | count(distinct case when Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTIVITY_WID > 0 then Fact_W_MV_P6_ACTIVITY_SPREAD_F_Activity_Spread_MV.ACTIVITY_WID else NULL end ) |