P6 - Activity / Primavera Activity
Description: Use this subject area to analyze 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 / Calculated By |
|---|---|---|---|---|---|
| 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. | Value Derived From : Dim_W_PROJECT_D_Project.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. | Value Derived From : Dim_W_PROJECT_D_Project.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. | Value Derived From : Dim_W_PROJECT_D_Project.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. | Value Derived From : Dim_W_PROJECT_D_Project.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. | Value Derived From : Dim_W_PROJECT_D_Project.PROPOSED_BUDGET |
| Project | Budget - (Project) | Total Benefit Plan | Dimension | Sum of the Monthly Benefit Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_D_Project.TOTAL_BENEFIT_PLAN |
| Project | Budget - (Project) | Total Benefit Plan Tally | Dimension | Sum of the Monthly Benefit Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_D_Project.TOTAL_BENEFIT_PLAN_TALLY |
| Project | Budget - (Project) | Total Funding | Dimension | The total amount of funding contributed to the project by your funding sources. | Value Derived From : Dim_W_PROJECT_D_Project.TOTAL_FUNDING |
| Project | Budget - (Project) | Total Spending Plan | Dimension | Sum of the Monthly Spending Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_D_Project.TOTAL_SPENDING_PLAN |
| Project | Budget - (Project) | Total Spending Plan Tally | Dimension | Sum of the Monthly Spending Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_D_Project.TOTAL_SPENDING_PLAN_TALLY |
| Project | Budget - (Project) | Unallocated Budget | Dimension | Calculated as Total Current Budget - Distributed Current Budget. | Value Derived From : Dim_W_PROJECT_D_Project.UNALLOCATED_BUDGET |
| Project | Budget - (Project) | Undistributed Current Variance | Dimension | Computed as the Total Spending Plan minus the Total Spending Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_D_Project.UNDISTRIBUTED_CURRENT_VARIANCE |
| Project | Dates - (Project) | Actual Finish Date | Dimension | Actual Finish Date | Value Derived From : Dim_W_PROJECT_D_Project.ACTUAL_FINISH_DATE |
| Project | Dates - (Project) | Actual Start Date | Dimension | Actual Start Date | Value Derived From : Dim_W_PROJECT_D_Project.ACTUAL_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. | Value Derived From : Dim_W_PROJECT_D_Project.ANTICIPATED_FINISH_DATE |
| 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. | Value Derived From : Dim_W_PROJECT_D_Project.ANTICIPATED_START_DATE |
| Project | Dates - (Project) | Baseline Finish Date | Dimension | Baseline Finish Date | Value Derived From : Dim_W_PROJECT_D_Project.BASELINE_FINISH_DATE |
| Project | Dates - (Project) | Baseline Start Date | Dimension | Baseline Start Date | Value Derived From : Dim_W_PROJECT_D_Project.BASELINE_START_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. | Value Derived From : Dim_W_PROJECT_D_Project.DATA_DATE |
| Project | Dates - (Project) | Date Added | Dimension | The date this project was added | Value Derived From : Dim_W_PROJECT_D_Project.ADD_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. | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_FINISH_DATE |
| Project | Dates - (Project) | Forecast Finish Date | Dimension | The end date optionally used by the project scheduler | Value Derived From : Dim_W_PROJECT_D_Project.FORECAST_FINISH_DATE |
| Project | Dates - (Project) | Forecast Start Date | Dimension | The start date optionally used by the project scheduler | Value Derived From : Dim_W_PROJECT_D_Project.FORECAST_START_DATE |
| Project | Dates - (Project) | Must Finish By | Dimension | The optional date constraint you can specify for the project end date | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_PLANNED_FINISH_DATE |
| Project | Dates - (Project) | Planned Finish | Dimension | The date the project is scheduled to start | Value Derived From : Dim_W_PROJECT_D_Project.PLANNED_FINISH_DATE |
| Project | Dates - (Project) | Planned Start | Dimension | The date the project is scheduled to start | Value Derived From : Dim_W_PROJECT_D_Project.PLANNED_START_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. | Value Derived From : Dim_W_PROJECT_D_Project.SCHEDULED_FINISH_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. | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_START_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). | Value Derived From : Dim_W_PROJECT_D_Project.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. | Value Derived From : Dim_W_PROJECT_D_Project.AT_COMPLETION_DURATION |
| Project | Durations - (Project) | Baseline Project Duration | Dimension | The duration of the baseline project. | Value Derived From : Dim_W_PROJECT_D_Project.ACTUAL_DURATION |
| Project | Durations - (Project) | Planned Duration | Dimension | Planned duration is the total time from the project planned start date to the planned finish date. | Value Derived From : Dim_W_PROJECT_D_Project.PLANNED_DURATION |
| Project | Durations - (Project) | Remaining Duration | Dimension | Remaining duration is the total time from the current data date to the current finish date. | Value Derived From : Dim_W_PROJECT_D_Project.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. | Value Derived From : Dim_W_PROJECT_D_Project.DURATION_VARIANCE |
| Project | Durations - (Project) | Variance - Baseline Project Finish Date | Dimension | Variance - Baseline Project Finish Date | Value Derived From : Dim_W_PROJECT_D_Project.FINISH_DATE_VARIANCE |
| Project | General - (Project) | Added By | Dimension | The name of the user who added the project | Value Derived From : Dim_W_PROJECT_D_Project.ADDED_BY_NAME |
| 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. | Value Derived From : Dim_W_PROJECT_D_Project.DATASOURCE_ID |
| Project | General - (Project) | Datasource Type | Lookup | Datasource Type | LOOKUP(DENSE "P6Core"."Lookup - ETL Source Type"."Feature Desc", "P6Core"."Dim - Project"."Datasource Id") |
| Project | General - (Project) | Project Leveling Priority | Dimension | Priority for leveling | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_PRIORITY |
| Project | General - (Project) | Project Score | Dimension | The Project score | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_RISK_SCORE |
| Project | General - (Project) | Project Description | Dimension | The project description | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_DESCRIPTION |
| Project | General - (Project) | Project Id | Dimension | The Project Id of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_ID |
| Project | General - (Project) | Project Name | Dimension | The project name | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_NAME |
| Project | General - (Project) | Unique Project ID | Dimension | The Unique ID of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_OBJECT_ID |
| Project | General - (Project) | Project Owner | Dimension | Resource designated as owner of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_OWNER |
| Project | General - (Project) | Project Risk Exposure | Dimension | The calculated exposure value for the risk | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_RISK_EXPOSURE |
| Project | General - (Project) | Project Risk Level | Dimension | Project risk level (1 - Very Low, 2 - Low, 3 - Medium, 4 - High, 5 - Very High) | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_RISK_LEVEL |
| Project | General - (Project) | Project Risk Score | Dimension | The calculated score value of the impact values assigned to the risk | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_RISK_SCORE |
| Project | General - (Project) | Unique Project WBS ID | Dimension | The Unique ID of the projects root level WBS | Value Derived From : Dim_W_PROJECT_D_Project.WBS_OBJECT_ID |
| Project | General - (Project) | Project Status | Dimension | The status of the project as active, inactive, planned or what-if | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_STATUS |
| Project | General - (Project) | Strategic Priority | Dimension | Range 1 to 10,000 | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_STRATEGIC_PRIORITY |
| Project | Location - (Project) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_PROJECT_D_Project.ADDRESS_LINE1 |
| Project | Location - (Project) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_PROJECT_D_Project.ADDRESS_LINE2 |
| Project | Location - (Project) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_PROJECT_D_Project.CITY_NAME |
| Project | Location - (Project) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_PROJECT_D_Project.COUNTRY_CODE |
| Project | Location - (Project) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_PROJECT_D_Project.COUNTRY_NAME |
| Project | Location - (Project) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_PROJECT_D_Project.LATITUDE |
| Project | Location - (Project) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_PROJECT_D_Project.LOCATION_NAME |
| Project | Location - (Project) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_PROJECT_D_Project.LOCATION_TYPE |
| Project | Location - (Project) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_PROJECT_D_Project.LONGITUDE |
| Project | Location - (Project) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_PROJECT_D_Project.MUNICIPALITY_NAME |
| Project | Location - (Project) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_PROJECT_D_Project.POSTAL_CODE |
| Project | Location - (Project) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_PROJECT_D_Project.STATE_CODE |
| Project | Location - (Project) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_PROJECT_D_Project.STATE_NAME |
| Project | P6 Links | Go to P6 Links | |||
| Project | P6 Links | Link to Activities | Dimension | Go to Project Activities | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Dactivities">' || 'Project Activities' || '</a>' |
| Project | P6 Links | Link to Documents | Dimension | Go to Project Documents | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Ddocuments">' || 'Project Documents' || '</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 (P6Core."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) || '&wbsId=' || CAST (P6Core."Dim - Project"."Project 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") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Drisks">' || 'Project Risks' || '</a>' |
| Project | Notebooks - (Project) | Link to Team Usage | Dimension | Go to Project Team Usage | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Dteamusage">' || 'Project Team Usage' || '</a>' |
| Project | Notebooks - (Project) | Create Date | Dimension | The date the notebook topic was created | Value Derived From : Dim_W_PROJECT_NOTE_D_Project_Note.W_CREATE_DT |
| Project | Notebooks - (Project) | Create User | Dimension | The user that created the notebook topic | Value Derived From : Dim_W_PROJECT_NOTE_D_Project_Note.W_CREATE_USER |
| Project | Notebooks - (Project) | Notebook Text | Lookup | The text of the notebook topic | Lookup(DENSE "P6Core"."Lookup - Project Note"."Raw Text", "P6Core"."Dim - Project Note"."Note Key", "P6Core"."Dim - Project Note"."Project Key") |
| Project | Notebooks - (Project) | Notebook Topic Name | Dimension | The name of the notebook topic | Value Derived From : Dim_W_PROJECT_NOTE_D_Project_Note.NOTEBOOK_TOPIC_NAME |
| Project | Notebooks - (Project) | Update Date | Dimension | The date the notebook topic was updated | Value Derived From : Dim_W_PROJECT_NOTE_D_Project_Note.W_UPDATE_DT |
| Project | Notebooks - (Project) | Update User | Dimension | The last user to update notebook topic | Value Derived From : Dim_W_PROJECT_NOTE_D_Project_Note.W_UPDATE_USER |
| Cost Breakdown Structure Folder | |||||
| Cost Breakdown Structure | General - (CBS) | CBS Code | Dimension | The full cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE |
| Cost Breakdown Structure | General - (CBS) | CBS Name | Dimension | The name of the CBS element | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME |
| Cost Breakdown Structure | General - (CBS) | Cost Status | Dimension | The status of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_STATUS |
| Time Folder | |||||
| Time | Calendar | Calendar Date | Dimension | Calendar Date (01/01/2013 12:00am) | Value Derived From : Dim_W_DAY_D_Common.DAY_DT |
| Time | Calendar | Calendar Half | Dimension | Calendar Half (1-2) | Value Derived From : Dim_W_DAY_D_Common.CAL_HALF |
| Time | Calendar | Calendar Month | Dimension | Calendar Month (1-12) | Value Derived From : Dim_W_DAY_D_Common.CAL_MONTH |
| Time | Calendar | Calendar Quarter | Dimension | Calendar Quarter (1-4) | Value Derived From : Dim_W_DAY_D_Common.CAL_QTR |
| Time | Calendar | Calendar Week | Dimension | Calendar Week (1-53) | Value Derived From : Dim_W_DAY_D_Common.CAL_WEEK |
| Time | Calendar | Calendar Year | Dimension | Calendar Year (2013) | Value Derived From : Dim_W_DAY_D_Common.CAL_YEAR |
| Time | Calendar | Day Date | Dimension | Calendar Date (01/01/2013 12:00am) | Value Derived From : Dim_W_DAY_D_Common.DAY_DT |
| Time | Calendar | Day Name | Dimension | Full day name (January 1, 2013) | Value Derived From : Dim_W_DAY_D_Common.DAY_NAME |
| Time | Calendar | Day Of Month | Dimension | Day of the month (1 - 31) | Value Derived From : Dim_W_DAY_D_Common.DAY_OF_MONTH |
| Time | Calendar | Day Of Week | Dimension | Day of the week (1=Sunday, 7=Saturday) | Value Derived From : Dim_W_DAY_D_Common.DAY_OF_WEEK |
| Time | Calendar | Day Of Year | Dimension | Day of the year (1-365) | Value Derived From : Dim_W_DAY_D_Common."DAY_OF_YEAR" |
| Time | Calendar | Financial Period | Dimension | Financial Period (2013-01-01) | Value Derived From : Dim_W_DAY_D_Common.FIN_PERIOD_1 |
| Time | Calendar | Short Day Name | Dimension | Day-Month (01-JAN) | Value Derived From : Dim_W_DAY_D_Common.SHORT_DAY_NAME |
| Time | Calendar | Half Name | Dimension | Year-Half name (2013-H1) | Value Derived From : Dim_W_DAY_D_Common.SORT_HALF_NAME |
| Time | Calendar | Month Name | Dimension | Year-Month name (2013-01) | Value Derived From : Dim_W_DAY_D_Common.SORT_MONTH_NAME |
| Time | Calendar | Quarter Name | Dimension | Year-Quarter name (2013-Q4) | Value Derived From : Dim_W_DAY_D_Common.SORT_QUARTER_NAME |
| Time | Calendar | Week Name | Dimension | First day of the week (2013-01-01) | Value Derived From : Dim_W_DAY_D_Common.SORT_WEEK_NAME |
| Time | Calendar | Year Name | Dimension | Year Name (2013) | Value Derived From : Dim_W_DAY_D_Common.YEAR_NAME |
| Fact - Primavera -Activity Folder | |||||
| Fact - Primavera -Activity | Costs | Actual Expense Cost | Fact | The actual cost for all project expenses associated with the activity | Value calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTUAL_EXPENSE_COST) |
| Fact - Primavera -Activity | 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. | Value calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTUAL_LABOR_COST) |
| Fact - Primavera -Activity | Costs | Actual Material Cost | Fact | The actual cost for all material resources assigned to the activity | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTUAL_MATERIAL_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTUAL_NONLABOR_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTUAL_TOTAL_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.AT_COMPLETION_EXPENSE_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.AT_COMPLETION_LABOR_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.AT_COMPLETION_MATERIAL_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.AT_COMPLETION_NONLABOR_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.AT_COMPLETION_TOTAL_COST) |
| Fact - Primavera -Activity | Costs | Baseline Actual Expense Cost | Fact | The actual cost for all project expenses associated with the activity in the primary baseline | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_ACTUAL_EXPENSE_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_ACTUAL_LABOR_COST) |
| Fact - Primavera -Activity | Costs | Baseline Actual Material Cost | Fact | The actual cost for all material resources assigned to the activity in the project baseline | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_ACTUAL_MATERIAL_COST) |
| Fact - Primavera -Activity | 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 | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_ACTUAL_NONLABOR_COST) |
| Fact - Primavera -Activity | 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 | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_ACTUAL_TOTAL_COST) |
| Fact - Primavera -Activity | Costs | Baseline Project Expense Cost | Fact | The cost for all the project expenses associated with the activity in the project baseline. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_PLANNED_EXPENSE_COST) |
| Fact - Primavera -Activity | Costs | Baseline Project Labor Cost | Fact | The cost for all the labor resources assigned to an activity in the project baseline. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_PLANNED_LABOR_COST) |
| Fact - Primavera -Activity | Costs | Baseline Project Material Cost | Fact | Budgeted or (At Completion)cost for all material resources assigned to the activity in the project baseline. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_PLANNED_MATERIAL_COST) |
| Fact - Primavera -Activity | Costs | Baseline Project Nonlabor Cost | Fact | The cost for all the Nonlabor resources assigned to an activity in the project baseline | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_PLANNED_NONLABOR_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_PLANNED_TOTAL_COST) |
| Fact - Primavera -Activity | Costs | Planned Expense Cost | Fact | The budgeted cost for all project expenses associated with the activity. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_EXPENSE_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_LABOR_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_MATERIAL_COST) |
| Fact - Primavera -Activity | Costs | Planned Nonlabor Cost | Fact | The budgeted costs for all nonlabor resources assigned to the activity. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_NONLABOR_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_TOTAL_COST) |
| Fact - Primavera -Activity | Costs | Remaining Expense Cost | Fact | The remaining cost for all project expenses associated with the activity. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_EXPENSE_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LABOR_COST) |
| Fact - Primavera -Activity | Costs | Remaining Late Expense Cost | Fact | Remaining Late Expense Cost | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LATE_EXPENSE_COST) |
| Fact - Primavera -Activity | Costs | Remaining Late Labor Cost | Fact | Remaining Late Labor Cost | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LATE_LABOR_COST) |
| Fact - Primavera -Activity | Costs | Remaining Late Material Cost | Fact | Remaining Late Material Cost | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LATE_MATERIAL_COST) |
| Fact - Primavera -Activity | Costs | Remaining Late Nonlabor Cost | Fact | Remaining Late Nonlabor Cost | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LATE_NONLABOR_COST) |
| Fact - Primavera -Activity | Costs | Period Remaining Late Total Cost | Fact | The Remaining Late Total Cost for the period specified | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LATE_TOTAL_COST) |
| Fact - Primavera -Activity | Costs | Remaining Material Cost | Fact | The remaining cost for all material resources assigned to the activity. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_MATERIAL_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_NONLABOR_COST) |
| Fact - Primavera -Activity | 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. | Value Calculated by: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_TOTAL_COST) |
| Fact - Primavera -Activity | 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 | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Planned Value Cost" - "P6Core"."Fact - Activity Spread"."Actual Cost" |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Baseline Project Total Cost" |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Cost" / "P6Core"."Fact - Activity Spread"."Actual Cost" |
| Fact - Primavera -Activity | Earned Value (Cost) | Cost Schedule Index (Cost) | Fact | Cost Schedule Index By Cost | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Cost Performance Index - (CPI)" * "P6Core"."Fact - Activity Spread"."Schedule Performance Index (SPI) - Cost" |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Cost" - "P6Core"."Fact - Activity Spread"."Actual Cos |
| Fact - Primavera -Activity | Earned Value (Cost) | Cost Variance Index (Cost) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Cost Variance" / "P6Core"."Fact - Activity Spread"."Earned Value Cost" |
| Fact - Primavera -Activity | Earned Value (Cost) | Earned Value (Cost) | Fact | Earned value cost for the project | Value Derived From: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.EARNED_VALUE_COST) |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.EST_AT_COMPLETION_COST) |
| Fact - Primavera -Activity | Earned Value (Cost) | Estimate to Complete (Cost) | Fact | Calculated Estimate To Complete using specified technique | Value Derived From existing columns using expression: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.EST_TO_COMPLETE_COST) |
| Fact - Primavera -Activity | Earned Value (Cost) | Planned Value (Cost) | Fact | Planned cost of work scheduled for the project | Value Derived From existing columns using expression: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_VALUE_COST) |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Cost" / "P6Core"."Fact - Activity Spread"."Planned Value Cost" |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Cost" - "P6Core"."Fact - Activity Spread"."Planned Value Cost" |
| Fact - Primavera -Activity | Earned Value (Cost) | Schedule Variance Index (Cost) | Fact | Schedule Variance Index is the Schedule Variance divided by Planned Value. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Schedule Variance - Cost" / "P6Core"."Fact - Activity Spread"."Planned Value Cost" |
| Fact - Primavera -Activity | 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). | Value Derived From existing columns using expression: ("P6Core"."Fact - Activity Spread"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread"."Earned Value Cost") / ("P6Core"."Fact - Activity Spread"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread"."Actual Cost") |
| Fact - Primavera -Activity | 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). | Value Derived From existing columns using expression: ("P6Core"."Fact - Activity Spread"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread"."Earned Value Cost") / ("P6Core"."Fact - Activity Spread"."Estimate At Completion Cost" - "P6Core"."Fact - Activity Spread"."Actual Cost") |
| Fact - Primavera -Activity | Earned Value (Cost) | Variance At Completion (Cost) | Fact | Variance At Completion is the Budget At Completion (baseline total cost) minus Estimate At Completion. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread"."Estimate At Completion Cost" |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Planned Value Labor Units" - "P6Core"."Fact - Activity Spread"."Actual Labor Units" |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Baseline Project Labor Units" |
| Fact - Primavera -Activity | Earned Value (Units) | Cost Performance Index (Units) | Fact | Cost Performance Index Labor Units is the Earned Value Labor Units / Actual Labor Units. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Labor Units" / "P6Core"."Fact - Activity Spread"."Actual Labor Units" |
| Fact - Primavera -Activity | Earned Value (Units) | Cost Schedule Index (Units) | Fact | Cost Schedule Index By Units | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Cost Performance Index (CPI) - Labor Units" * "P6Core"."Fact - Activity Spread"."Schedule Performance Index (SPI) - Labor Units" |
| Fact - Primavera -Activity | Earned Value (Units) | Cost Variance (Units) | Fact | Cost Variance Labor Units is Earned Value Labor Units minus Actual Labor Units. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Labor Units" - "P6Core"."Fact - Activity Spread"."Actual Labor Units" |
| Fact - Primavera -Activity | Earned Value (Units) | Cost Variance Index (Units) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Cost Variance - Labor Units" / "P6Core"."Fact - Activity Spread"."Earned Value Labor Units" |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.EARNED_VALUE_LABOR_UNITS) |
| Fact - Primavera -Activity | 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.) | Value Derived From existing columns using expression: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.EST_AT_COMPLETION_LABOR_UNITS) |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.EST_TO_COMPLETE_LABOR_UNITS) |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_VALUE_LABOR_UNITS) |
| Fact - Primavera -Activity | 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. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Labor Units" / "P6Core"."Fact - Activity Spread"."Planned Value Labor Units" |
| Fact - Primavera -Activity | Earned Value (Units) | Schedule Variance (Units) | Fact | Schedule Variance Labor Units is the Earned Value Labor Units minus Planned Value Labor Units. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Earned Value Labor Units" - "P6Core"."Fact - Activity Spread"."Planned Value Labor Units" |
| Fact - Primavera -Activity | Earned Value (Units) | Schedule Variance Index (Units) | Fact | Schedule Variance Index is the Schedule Variance Labor Units divided by the Planned Value Labor Units. | Value Derived From existing columns using expression: "P6Core"."Fact - Activity Spread"."Schedule Variance - Labor Units" / "P6Core"."Fact - Activity Spread"."Planned Value Labor Units" |
| Fact - Primavera -Activity | 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). | Value Derived From existing columns using expression: ("P6Core"."Fact - Activity Spread"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Activity Spread"."Earned Value Labor Units") / ("P6Core"."Fact - Activity Spread"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Activity Spread"."Actual Labor Units") |
| Fact - Primavera -Activity | 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). | Value Derived From existing columns using expression: ("P6Core"."Fact - Activity Spread"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Activity Spread"."Earned Value Labor Units") / ("P6Core"."Fact - Activity Spread"."Estimate At Completion - Labor Units" - "P6Core"."Fact - Activity Spread"."Actual Labor Units") |
| Fact - Primavera -Activity | Earned Value (Units) | Variance At Completion (Units) | Fact | Variance At Completion is the Planned Labor Units minus Estimate At Completion Labor Units. | "P6Core"."Fact - Activity Spread"."Baseline Project Labor Units" - "P6Core"."Fact - Activity Spread"."Estimate At Completion - Labor Units" |
| Fact - Primavera - Activity | Metrics | # Of Activities | Fact | # Of Activities | Value Derived From: count(distinct case when Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTIVITY_WID > 0 then Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTIVITY_WID else NULL end ) |
| Fact - Primavera -Activity | Metrics | # Of Projects | Fact | # Of Projects | Value Derived From: count(distinct Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PROJECT_WID) |
| Fact - Primavera - Activity | Percent Completes | ||||
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Actual Total Cost" / P6Core."Fact - Activity Spread"."At Completion Total Cost" * 100 |
| Fact - Primavera - Activity | Percent Completes | Cost % of Planned | Fact | The proportion of the cost budget that has been spent. Computed as actual total cost / baseline total cost. | P6Core."Fact - Activity Spread"."Actual Cost" / P6Core."Fact - Activity Spread"."Budget at Completion" * 100 |
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Actual Expense Cost" / P6Core."Fact - Activity Spread"."At Completion Expense Cost" * 100 |
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Actual Labor Cost" / P6Core."Fact - Activity Spread"."At Completion Labor Cost" * 100 |
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Actual Labor Units" / P6Core."Fact - Activity Spread"."At Completion Labor Units" * 100 |
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Actual Material Cost" / P6Core."Fact - Activity Spread"."At Completion Material Cost" * 100 |
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Actual Nonlabor Cost" / P6Core."Fact - Activity Spread"."At Completion Nonlabor Cost" * 100 |
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Actual Nonlabor Units" / P6Core."Fact - Activity Spread"."At Completion Nonlabor Units" * 100 |
| Fact - Primavera - Activity | Percent Completes | 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. | P6Core."Fact - Activity Spread"."Earned Value Cost" / P6Core."Fact - Activity Spread"."Budget at Completion" * 100 |
| Fact - Primavera - Activity | Percent Completes | Perfomance % Complete (Units) | Fact | Perfomance % Complete (Units) | IFNULL(P6Core."Fact - Activity Spread"."Earned Value Labor Units", 0) / IFNULL(P6Core."Fact - Activity Spread"."Budget At Completion (BAC) - Labor Units", 0) * 100 |
| Fact - Primavera - Activity | Percent Completes | Schedule % Complete | Fact | Schedule % Complete | P6Core."Fact - Activity Spread"."Planned Value Cost" / P6Core."Fact - Activity Spread"."Budget at Completion" * 100 |
| Fact - Primavera - Activity | Percent Completes | Schedule % Complete (Units) | Fact | Schedule % Complete (Units) | IFNULL(P6Core."Fact - Activity Spread"."Planned Value Labor Units", 0) / IFNULL(P6Core."Fact - Activity Spread"."Budget At Completion (BAC) - Labor Units", 0) * 100 |
| Fact - Primavera - Activity | Percent Completes | 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(P6Core."Fact - Activity Spread"."Actual Labor Units", 0) + IFNULL(P6Core."Fact - Activity Spread"."Actual Nonlabor Units", 0)) / ( IFNULL(P6Core."Fact - Activity Spread"."At Completion Labor Units", 0) + IFNULL(P6Core."Fact - Activity Spread"."At Completion Nonlabor Units", 0)) * 100 |
| Fact - Primavera - Activity | Units | Units | |||
| Fact - Primavera - Activity | Units | Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTUAL_LABOR_UNITS) |
| Fact - Primavera - Activity | Units | Actual Nonlabor Units | Fact | The actual units for all nonlabor resources assigned to the activity | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.ACTUAL_NONLABOR_UNITS) |
| Fact - Primavera - Activity | 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(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.AT_COMPLETION_LABOR_UNITS) |
| Fact - Primavera - Activity | 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(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.AT_COMPLETION_NONLABOR_UNITS) |
| Fact - Primavera - Activity | Units | Baseline Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity in the project baseline | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_ACTUAL_LABOR_UNITS) |
| Fact - Primavera - Activity | Units | Baseline Actual Nonlabor Units | Fact | The actual units for all nonlabor resources assigned to the activity in the project baseline | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_ACTUAL_NONLABOR_UNITS) |
| Fact - Primavera - Activity | 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(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_PLANNED_LABOR_UNITS) |
| Fact - Primavera - Activity | 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(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.BL_PLANNED_NONLABOR_UNITS) |
| Fact - Primavera - Activity | Units | Planned Labor Units | Fact | The budgeted units for all labor resources assigned to the activity | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_LABOR_UNITS) |
| Fact - Primavera - Activity | Units | Planned Nonlabor Units | Fact | The budgeted units for all nonlabor resources assigned to the activity | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.PLANNED_NONLABOR_UNITS) |
| Fact - Primavera - Activity | 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(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LABOR_UNITS) |
| Fact - Primavera - Activity | Units | Remaining Late Labor Units | Fact | Remaining Late Labor Units | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LATE_LABOR_UNITS) |
| Fact - Primavera - Activity | Units | Remaining Late Nonlabor Units | Fact | Remaining Late Nonlabor Units | sum(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_LATE_NONLABOR_UNITS) |
| Fact - Primavera - Activity | 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(Fact_W_ACTIVITY_SPREAD_F_Activity_Spread.REMAINING_NONLABOR_UNITS) |
| Activity Folder | |||||
| Activity | Dates - (Activity) | Actual Finish | Dimension | The date on which the activity actually finished | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTUAL_FINISH_DATE |
| Activity | Dates - (Activity) | Actual Start | Dimension | The date on which the activity actually started | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTUAL_START_DATE |
| Activity | Dates - (Activity) | Baseline Project Finish | Dimension | The Project Baseline Planned Finish Date | Value Derived From : Dim_W_ACTIVITY_D_Activity.BASELINE_FINISH_DATE |
| Activity | Dates - (Activity) | Baseline Project Start | Dimension | The Project Baseline Planned Start Date | Value Derived From : Dim_W_ACTIVITY_D_Activity.BASELINE_START_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.DATA_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EARLY_FINISH_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EARLY_START_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EXTERNAL_LATE_FINISH_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.FINISH_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.LATE_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.LATE_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PLANNED_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PLANNED_START_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PRIMARY_CONSTRAINT_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_FINISH_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_START_DATE |
| Activity | Dates - (Activity) | Remaining Late Finish | Dimension | Remaining late end date as calculated by the scheduler | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Remaining Late Start | Dimension | Remaining late start date as calculated by the scheduler | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_LATE_START_DATE |
| Activity | Dates - (Activity) | Resume Date | Dimension | The date progress is resumed on an activity | Value Derived From : Dim_W_ACTIVITY_D_Activity.RESUME_DATE |
| Activity | Dates - (Activity) | Secondary Constraint Date | Dimension | The second constraint date for the activity, if the activity has a constraint | Value Derived From : Dim_W_ACTIVITY_D_Activity.SECONDARY_CONSTRAINT_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.START_DATE |
| Activity | Dates - (Activity) | Suspend Date | Dimension | The date progress is suspended on an activity | Value Derived From : Dim_W_ACTIVITY_D_Activity.SUSPEND_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.AT_COMPLETION_DURATION |
| Activity | Durations - (Activity) | Baseline Project Duration | Dimension | The duration for the activity in the primary baseline | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTUAL_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.DURATION_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.FINISH_DATE_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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.START_DATE_VARIANCE |
| Activity | General - (Activity) | Activity ID | Dimension | A short ID which uniquely identifies the activity within the project. | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTIVITY_ID |
| Activity | General - (Activity) | Activity Name | Dimension | The name of the activity. The activity name does not have to be unique. | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTIVITY_NAME |
| Activity | General - (Activity) | Activity Owner | Dimension | User who owns the activity | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTIVITY_OWNER |
| Activity | General - (Activity) | Activity Status | Dimension | The current status of the activity, either Not Started, In Progress, or Completed. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.CALENDAR_NAME |
| Activity | General - (Activity) | Criticality Index | Dimension | Criticality Index | Value Derived From : Dim_W_ACTIVITY_D_Activity.CRITICALITY_INDEX |
| 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.DURATION_TYPE |
| Activity | General - (Activity) | 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.IS_CRITICAL |
| Activity | General - (Activity) | 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.IS_LONGEST_PATH |
| Activity | General - (Activity) | Activity Leveling Priority | Dimension | The activity priority can be used to prioritize activities in a project when performing resource leveling. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.COMPLETE_PCT_TYPE |
| Activity | General - (Activity) | Primary Constraint | 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PRIMARY_CONSTRAINT_TYPE |
| Activity | General - (Activity) | Primary Resource | 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PRIMARY_RESOURCE_NAME |
| Activity | General - (Activity) | Secondary Constraint | Dimension | The second type of constraint applied to the activity start or finish date. | Value Derived From : Dim_W_ACTIVITY_D_Activity.SECONDARY_CONSTRAINT_TYPE |
| Activity | General - (Activity) | WBS Code | Dimension | The Work Breakdown Structure Code for the activity | Value Derived From : Dim_W_ACTIVITY_D_Activity.WBS_CODE |
| Activity | General - (Activity) | WBS Name | Dimension | The Work Breakdown Structure Name for the activity | Value Derived From : Dim_W_ACTIVITY_D_Activity.WBS_NAME |
| Activity | Location - (Activity) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_ACTIVITY_D_Activity.ADDRESS_LINE1 |
| Activity | Location - (Activity) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_ACTIVITY_D_Activity.ADDRESS_LINE2 |
| Activity | Location - (Activity) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.CITY_NAME |
| Activity | Location - (Activity) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.COUNTRY_CODE |
| Activity | Location - (Activity) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.COUNTRY_NAME |
| Activity | Location - (Activity) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.LATITUDE |
| Activity | Location - (Activity) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_ACTIVITY_D_Activity.LOCATION_NAME |
| Activity | Location - (Activity) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_ACTIVITY_D_Activity.LOCATION_TYPE |
| Activity | Location - (Activity) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.LONGITUDE |
| Activity | Location - (Activity) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.MUNICIPALITY_NAME |
| Activity | Location - (Activity) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.POSTAL_CODE |
| Activity | Location - (Activity) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.STATE_CODE |
| Activity | Location - (Activity) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_ACTIVITY_D_Activity.STATE_NAME |
| 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.FLOAT_PATH_ORDER |
| Activity | Notebooks - (Activity) | Create Date | Dimension | The date the notebook topic was created | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_CREATE_DT |
| Activity | Notebooks - (Activity) | Create User | Dimension | The user that created the notebook topic | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_CREATE_USER |
| Activity | Notebooks - (Activity) | Notebook Topic Name | Dimension | The name of the notebook topic | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.NOTEBOOK_TOPIC_NAME |
| Activity | Notebooks - (Activity) | Notebook Text | Lookup | The text of the notebook topic | Value Derived From : LOOKUP(DENSE "P6Core"."Lookup - Activity Note"."Raw Text", "P6Core"."Dim - Activity Note"."Note Key", "P6Core"."Dim - Activity Note"."Activity Key") |
| Activity | Notebooks - (Activity) | Update Date | Dimension | The date the notebook topic was updated | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_UPDATE_DT |
| Activity | Notebooks - (Activity) | Update User | Dimension | The last user to update notebook topic | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_UPDATE_USER |
| Activity | Steps - (Activity) | Activity Step Object ID | Dimension | The Unique ID of the activity step | Value Derived From Physical Mapping: Dim_W_ACTIVITY_STEP_D_Activity_Step.ACTIVITY_STEP_OBJECT_ID |
| Activity | Steps - (Activity) | Step Name | Dimension | The name of the step | Value Derived From Physical Mapping: Dim_W_ACTIVITY_STEP_D_Activity_Step.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. | Value Derived From Physical Mapping: Dim_W_ACTIVITY_STEP_D_Activity_Step.STEP_WEIGHT |
| Activity | Steps - (Activity) | Weight Complete | Dimension | Step weight associated percent complete. | Value Derived From Physical Mapping: Dim_W_ACTIVITY_STEP_D_Activity_Step.WEIGHT_COMPLETE |
| Activity | Steps - (Activity) | Step Percent Complete | Dimension | The percent complete of this specific step. This is manually entered. | Value Derived From Physical Mapping: Dim_W_ACTIVITY_STEP_D_Activity_Step.STEP_PERCENT_COMPLETE |
| 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.DURATION_PCT_OF_PLANNED |
| Activity | Percent Completes - (Activity) | Duration % 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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.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. | Value Derived From : Dim_W_ACTIVITY_D_Activity.UNITS_PCT_COMPLETE |
| Activity | Relationships - (Activity) | Relationships Activity Information | |||
| Activity | Relationships - (Activity) | Lag | Dimension | The lag assigned to the relationship. | Value Derived From : Dim_W_RELATIONSHIP_D_Relationship.LAG |
| Activity | Relationships - (Activity) | Predecessor Activity ID | Dimension | The ID of the predecessor activity. | Value Derived From : Dim_W_RELATIONSHIP_D_Relationship.PRED_ACT_ID |
| Activity | Relationships - (Activity) | Predecessor Activity Name | Dimension | The name of the predecessor activity. | Value Derived From : Dim_W_RELATIONSHIP_D_Relationship.PRED_ACT_NAME |
| Activity | Relationships - (Activity) | Relationship Type | Dimension | The relationship type (Finish to Start, Start to Start, etc.). | Value Derived From : Dim_W_RELATIONSHIP_D_Relationship.RELATIONSHIP_TYPE |
| Activity | Relationships - (Activity) | Successor Activity ID | Dimension | The ID of the successor activity. | Value Derived From : Dim_W_RELATIONSHIP_D_Relationship.SUCC_ACT_ID |
| Activity | Relationships - (Activity) | Successor Activity Name | Dimension | The name of the successor activity. | Value Derived From : Dim_W_RELATIONSHIP_D_Relationship.SUCC_ACT_NAME |
| Activity | Relationships - (Activity) | Type | Dimension | The type of the activity based on the relationship (predecessor, successor, or orphan). | Value Derived From : Dim_W_RELATIONSHIP_D_Relationship.TYPE |
| EPS Folder | |||||
| EPS | EPS Id Level 1 | Dimension | EPS Id Level 1 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV1 | |
| EPS | EPS Id Level 10 | Dimension | EPS Id Level 10 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV10 | |
| EPS | EPS Id Level 11 | Dimension | EPS Id Level 11 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV11 | |
| EPS | EPS Id Level 12 | Dimension | EPS Id Level 12 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV12 | |
| EPS | EPS Id Level 13 | Dimension | EPS Id Level 13 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV13 | |
| EPS | EPS Id Level 14 | Dimension | EPS Id Level 14 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV14 | |
| EPS | EPS Id Level 15 | Dimension | EPS Id Level 15 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV15 | |
| EPS | EPS Id Level 16 | Dimension | EPS Id Level 16 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV16 | |
| EPS | EPS Id Level 17 | Dimension | EPS Id Level 17 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV17 | |
| EPS | EPS Id Level 2 | Dimension | EPS Id Level 2 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV2 | |
| EPS | EPS Id Level 3 | Dimension | EPS Id Level 3 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV3 | |
| EPS | EPS Id Level 4 | Dimension | EPS Id Level 4 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV4 | |
| EPS | EPS Id Level 5 | Dimension | EPS Id Level 5 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV5 | |
| EPS | EPS Id Level 6 | Dimension | EPS Id Level 6 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV6 | |
| EPS | EPS Id Level 7 | Dimension | EPS Id Level 7 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV7 | |
| EPS | EPS Id Level 8 | Dimension | EPS Id Level 8 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV8 | |
| EPS | EPS Id Level 9 | Dimension | EPS Id Level 9 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV9 | |
| EPS | EPS Name Level 1 | Dimension | EPS Name Level 1 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV1 | |
| EPS | EPS Name Level 10 | Dimension | EPS Name Level 10 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV10 | |
| EPS | EPS Name Level 11 | Dimension | EPS Name Level 11 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV11 | |
| EPS | EPS Name Level 12 | Dimension | EPS Name Level 12 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV12 | |
| EPS | EPS Name Level 13 | Dimension | EPS Name Level 13 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV13 | |
| EPS | EPS Name Level 14 | Dimension | EPS Name Level 14 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV14 | |
| EPS | EPS Name Level 15 | Dimension | EPS Name Level 15 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV15 | |
| EPS | EPS Name Level 16 | Dimension | EPS Name Level 16 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV16 | |
| EPS | EPS Name Level 17 | Dimension | EPS Name Level 17 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV17 | |
| EPS | EPS Name Level 2 | Dimension | EPS Name Level 2 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV2 | |
| EPS | EPS Name Level 3 | Dimension | EPS Name Level 3 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV3 | |
| EPS | EPS Name Level 4 | Dimension | EPS Name Level 4 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV4 | |
| EPS | EPS Name Level 5 | Dimension | EPS Name Level 5 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV5 | |
| EPS | EPS Name Level 6 | Dimension | EPS Name Level 6 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV6 | |
| EPS | EPS Name Level 7 | Dimension | EPS Name Level 7 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV7 | |
| EPS | EPS Name Level 8 | Dimension | EPS Name Level 8 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV8 | |
| EPS | EPS Name Level 9 | Dimension | EPS Name Level 9 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV9 | |
| EPS | Notebooks - (EPS) | Create Date | Dimension | The date the notebook topic was created | Value Derived From Physical Mapping: Dim_W_EPS_NOTE_D_EPS_Note.W_CREATE_DT |
| EPS | Notebooks - (EPS) | Create User | Dimension | The user that created the notebook topic | Value Derived From Physical Mapping: Dim_W_EPS_NOTE_D_EPS_Note.W_CREATE_USER |
| EPS | Notebooks - (EPS) | Notebook Text | Dimension | The text of the notebook topic | Value Derived From Physical Mapping: Dim_W_EPS_NOTE_D_EPS_Note.NOTEBOOK_TOPIC_NAME |
| EPS | Notebooks - (EPS) | Notebook Topic Name | Dimension | The name of the notebook topic | Value Derived From existing columns using expression: "P6Core"."Lookup - EPS Note"."Raw Text" "P6Core"."Dim - EPS Note"."Note Key" "P6Core"."Dim - EPS Note"."EPS Key" |
| EPS | Notebooks - (EPS) | Update Date | Dimension | The date the notebook topic was updated | Value Derived From Physical Mapping: Dim_W_EPS_NOTE_D_EPS_Note.W_UPDATE_DT |
| EPS | Notebooks - (EPS) | Update User | Dimension | The last user to update notebook topic | Value Derived From Physical Mapping: Dim_W_EPS_NOTE_D_EPS_Note.W_UPDATE_USER |
| Expense Folder | |||||
| Expense | Accrual Type | Dimension | The accrual type of the expense. Valid values are 'Start of Activity', 'End of Activity', and 'Uniform over Activity'. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.ACCRUAL_TYPE | |
| Expense | Actual Cost | Dimension | The actual cost of the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.ACTUAL_COST | |
| Expense | Actual Units | Dimension | The actual units for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.ACTUAL_UNITS | |
| Expense | At Completion Cost | Dimension | The at completion cost of the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.AT_COMPLETION_COST | |
| Expense | At Completion Units | Dimension | The at completion units for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.AT_COMPLETION_UNITS | |
| 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. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.AUTO_COMPUTE | |
| Expense | CBS Code | Dimension | The full cost code associated with the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.CBS_CODE | |
| Expense | CBS Name | Dimension | The name of the cost code associated with the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.CBS_NAME | |
| Expense | Cost Account ID | Dimension | The ID of the cost account associated with the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.COST_ACCOUNT_ID | |
| Expense | Cost Account Name | Dimension | The name of the cost account associated with the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.COST_ACCOUNT_NAME | |
| Expense | Document Number | Dimension | The document number for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.DOCUMENT_NUMBER | |
| Expense | Expense Category Name | Dimension | The category name of the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.EXPENSE_CAT_NAME | |
| Expense | Expense Item | Dimension | The name of the expense | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.EXPENSE_ITEM | |
| Expense | Unique Expense ID | Dimension | The unique ID of the expense | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.ACTIVITY_EXPENSE_OBJECT_ID | |
| Expense | Expense Percent Complete | Dimension | The percent complete for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.EXPENSE_PERCENT_COMPLETE | |
| Expense | Over Budget | Dimension | Identifies whether actual cost exceeds the budgeted cost for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.OVER_BUDGET | |
| Expense | Planned Cost | Dimension | The planned cost of the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.PLANNED_COST | |
| Expense | Planned Units | Dimension | The planned units for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.PLANNED_UNITS | |
| Expense | Price Per Unit | Dimension | The price per unit for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.PRICE_PER_UNIT | |
| Expense | Remaining Cost | Dimension | The remaining cost of the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.REMAINING_COST | |
| Expense | Remaining Units | Dimension | The remaining units for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.REMAINING_UNITS | |
| Expense | Unit Of Measure | Dimension | The unit of measure for the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.UNIT_OF_MEASURE | |
| Expense | Vendor Name | Dimension | The name of the vendor associated with the expense. | Value Derived From : Dim_W_ACTIVITY_EXPENSE_D_Activity_Expense.VENDOR_NAME | |
| Resource Folder | |||||
| Resource | General - (Resource) | Active | Dimension | Indicates whether the resource is currently active. Nonactive resources may have left the organization but are not deleted from the system since they may have actual hours. | Value Derived From : Dim_W_RESOURCE_D_Resource.ACTIVE_FLAG |
| Resource | General - (Resource) | Datasource Id | Dimension | A unique source Id created for the Primavera data source being used. Used to identify data sources when using multiple Primavera data sources. | Value Derived From : Dim_W_RESOURCE_D_Resource.DATASOURCE_ID |
| Resource | General - (Resource) | Primary Role Name | Dimension | The name of the role that is assigned as the resource's primary role | Value Derived From : Dim_W_RESOURCE_D_Resource.PRIMARY_ROLE_NAME |
| Resource | General - (Resource) | Unique Primary Role Id | Dimension | The unique Id of the role that is assigned as the resource's primary role | Value Derived From : Dim_W_RESOURCE_D_Resource.PRIMARY_ROLE_OBJECT_ID |
| Resource | General - (Resource) | Primary Resource ID | Dimension | A short code which uniquely identifies the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_ID |
| Resource | General - (Resource) | Primary Resource Name | Dimension | The name of the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_NAME |
| Resource | General - (Resource) | Title | Dimension | The title of the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_TITLE |
| Resource | General - (Resource) | Resource Type | Dimension | Indicates whether the resource is labor, nonlabor, or material | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_TYPE |
| Resource | Location - (Resource) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_RESOURCE_D_Resource.ADDRESS_LINE1 |
| Resource | Location - (Resource) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_RESOURCE_D_Resource.ADDRESS_LINE2 |
| Resource | Location - (Resource) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.CITY_NAME |
| Resource | Location - (Resource) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.COUNTRY_CODE |
| Resource | Location - (Resource) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.COUNTRY_NAME |
| Resource | Location - (Resource) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.LATITUDE |
| Resource | Location - (Resource) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_RESOURCE_D_Resource.LOCATION_NAME |
| Resource | Location - (Resource) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_RESOURCE_D_Resource.LOCATION_TYPE |
| Resource | Location - (Resource) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.LONGITUDE |
| Resource | Location - (Resource) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.MUNICIPALITY_NAME |
| Resource | Location - (Resource) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.POSTAL_CODE |
| Resource | Location - (Resource) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.STATE_CODE |
| Resource | Location - (Resource) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_RESOURCE_D_Resource.STATE_NAME |
| Resource | Resource Hierarchy - (Resource) | Dimension | Resource Hierarchy | ||
| Resource | Resource Hierarchy - (Resource) | Full Path Name | Dimension | Full Path Name | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.FULL_PATH_NAME |
| Resource | Resource Hierarchy - (Resource) | Resource ID | Dimension | Resource ID | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 1 | Dimension | Resource ID Level 1 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV1 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 10 | Dimension | Resource ID Level 10 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV10 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 11 | Dimension | Resource ID Level 11 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV11 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 12 | Dimension | Resource ID Level 12 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV12 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 13 | Dimension | Resource ID Level 13 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV13 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 14 | Dimension | Resource ID Level 14 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV14 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 15 | Dimension | Resource ID Level 15 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV15 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 16 | Dimension | Resource ID Level 16 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV16 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 17 | Dimension | Resource ID Level 17 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV17 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 18 | Dimension | Resource ID Level 18 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV18 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 19 | Dimension | Resource ID Level 19 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV19 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 2 | Dimension | Resource ID Level 2 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV2 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 20 | Dimension | Resource ID Level 20 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV20 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 21 | Dimension | Resource ID Level 21 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV21 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 22 | Dimension | Resource ID Level 22 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV22 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 23 | Dimension | Resource ID Level 23 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV23 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 24 | Dimension | Resource ID Level 24 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV24 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 3 | Dimension | Resource ID Level 3 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV3 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 4 | Dimension | Resource ID Level 4 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV4 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 5 | Dimension | Resource ID Level 5 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV5 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 6 | Dimension | Resource ID Level 6 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV6 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 7 | Dimension | Resource ID Level 7 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV7 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 8 | Dimension | Resource ID Level 8 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV8 |
| Resource | Resource Hierarchy - (Resource) | Resource ID Level 9 | Dimension | Resource ID Level 9 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_ID_LV9 |
| Resource | Resource Hierarchy - (Resource) | Resource Level | Dimension | Resource Level | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.LVL |
| Resource | Resource Hierarchy - (Resource) | Resource Name | Dimension | Resource Name | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 1 | Dimension | Resource Name Level 1 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV1 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 10 | Dimension | Resource Name Level 10 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV10 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 11 | Dimension | Resource Name Level 11 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV11 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 12 | Dimension | Resource Name Level 12 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV12 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 13 | Dimension | Resource Name Level 13 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV13 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 14 | Dimension | Resource Name Level 14 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV14 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 15 | Dimension | Resource Name Level 15 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV15 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 16 | Dimension | Resource Name Level 16 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV16 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 17 | Dimension | Resource Name Level 17 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV17 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 18 | Dimension | Resource Name Level 18 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV18 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 19 | Dimension | Resource Name Level 19 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV19 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 2 | Dimension | Resource Name Level 2 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV2 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 20 | Dimension | Resource Name Level 20 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV20 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 21 | Dimension | Resource Name Level 21 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV21 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 22 | Dimension | Resource Name Level 22 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV22 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 23 | Dimension | Resource Name Level 23 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV23 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 24 | Dimension | Resource Name Level 24 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV24 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 3 | Dimension | Resource Name Level 3 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV3 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 4 | Dimension | Resource Name Level 4 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV4 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 5 | Dimension | Resource Name Level 5 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV5 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 6 | Dimension | Resource Name Level 6 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV6 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 7 | Dimension | Resource Name Level 7 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV7 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 8 | Dimension | Resource Name Level 8 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV8 |
| Resource | Resource Hierarchy - (Resource) | Resource Name Level 9 | Dimension | Resource Name Level 9 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_NAME_LV9 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID | Dimension | Resource Unique ID | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 1 | Dimension | Resource Unique ID Level 1 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV1 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 10 | Dimension | Resource Unique ID Level 10 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV10 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 11 | Dimension | Resource Unique ID Level 11 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV11 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 12 | Dimension | Resource Unique ID Level 12 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV12 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 13 | Dimension | Resource Unique ID Level 13 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV13 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 14 | Dimension | Resource Unique ID Level 14 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV14 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 15 | Dimension | Resource Unique ID Level 15 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV15 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 16 | Dimension | Resource Unique ID Level 16 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV16 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 17 | Dimension | Resource Unique ID Level 17 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV17 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 18 | Dimension | Resource Unique ID Level 18 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV18 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 19 | Dimension | Resource Unique ID Level 19 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV19 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 2 | Dimension | Resource Unique ID Level 2 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV2 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 20 | Dimension | Resource Unique ID Level 20 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV20 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 21 | Dimension | Resource Unique ID Level 21 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV21 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 22 | Dimension | Resource Unique ID Level 22 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV22 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 23 | Dimension | Resource Unique ID Level 23 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV23 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 24 | Dimension | Resource Unique ID Level 24 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV24 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 3 | Dimension | Resource Unique ID Level 3 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV3 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 4 | Dimension | Resource Unique ID Level 4 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV4 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 5 | Dimension | Resource Unique ID Level 5 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV5 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 6 | Dimension | Resource Unique ID Level 6 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV6 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 7 | Dimension | Resource Unique ID Level 7 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV7 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 8 | Dimension | Resource Unique ID Level 8 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV8 |
| Resource | Resource Hierarchy - (Resource) | Resource Unique ID Level 9 | Dimension | Resource Unique ID Level 9 | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.RESOURCE_OBJECT_ID_LV9 |
| Resource | Resource Hierarchy - (Resource) | Root Level Resource ID | Dimension | Root Level Resource ID | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.ROOT_LEVEL_RESOURCE_ID |
| Resource | Resource Hierarchy - (Resource) | Root Level Resource Name | Dimension | Root Level Resource Name | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.ROOT_LEVEL_RESOURCE_NAME |
| Resource | Resource Hierarchy - (Resource) | Root Level Resource Unique ID | Dimension | Root Level Resource Unique ID | Value Derived From : Dim_W_RESOURCE_HIERARCHY_D_ResourceHierarchy.ROOT_LEVEL_RESOURCE_ID |
| Portfolio Folder | |||||
| Portfolio | Portfolios consist of projects grouped together in a meaningful way. Portfolios are used to do project analysis across the enterprise. | ||||
| Portfolio | Portfolio Description | Dimension | The description of the portfolio | Value Derived From : Dim_W_PROJECT_PORTFOLIO_D_Project_Portfolio.PROJECT_PORTFOLIO_DESCR | |
| Portfolio | Portfolio Name | Dimension | The name of the portfolio | Value Derived From : Dim_W_PROJECT_PORTFOLIO_D_Project_Portfolio.PROJECT_PORTFOLIO_NAME | |
| Risk Folder | |||||
| Risk | Risks are any uncertain events or conditions that, if they occur, have a positive or negative effect on project objectives. | ||||
| Risk | Added By | Dimension | The user the risk was last modified by | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.ADDED_BY | |
| Risk | Added Date | Dimension | The date the risk was last modified | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.W_CREATE_DT | |
| Risk | Risk Category | Dimension | The name for a particular type of risk classification | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.CATEGORY | |
| Risk | Cause | Dimension | The Cause the risk was identified | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.CAUSE | |
| Risk | Description | Dimension | The risk description | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.DESCRIPTION | |
| Risk | Effect | Dimension | The Effect of the risk was identified | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.EFFECT | |
| Risk | Risk Exposure | Dimension | The calculated exposure value for the risk | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.Exposure | |
| Risk | Risk Exposure Finish | Dimension | Risk Exposure Finish Date | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.EXPOSURE_FINISH | |
| Risk | Risk Exposure Start | Dimension | Risk Exposure Start Date | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.EXPOSURE_START | |
| Risk | Identified By Resource Id | Dimension | The short code of the resource that identified the risk | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.IDENTIFIED_BY_RESOURCE_ID | |
| Risk | Identified By Resource Name | Dimension | The name of the resource that identified the risk | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.IDENTIFIED_BY_RESOURCE_NAME | |
| Risk | Identified Date | Dimension | The date the risk was identified | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.IDENTIFIED_DATE | |
| Risk | Last Modified By | Dimension | The user the risk was last modified by | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.LAST_MODIFIED_BY | |
| Risk | Last Modified Date | Dimension | The date the risk was last modified | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.W_UPDATE_DT | |
| Risk | Owner | Dimension | The resource who has ownership of the risk | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.OWNER | |
| Risk | Risk Id | Dimension | The unique ID of the associated risk | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.RISK_ID | |
| Risk | Risk Name | Dimension | The name of the risk | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.RISK_NAME | |
| Risk | Risk Status | Dimension | The current status of the Risk. Valid values are 'Proposed', 'Open', 'Rejected', 'Managed', and 'Impacted'. | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.RISK_STATUS | |
| 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. | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.RISK_TYPE | |
| Risk | Risk Score | Dimension | The calculated score value of the impact values assigned to the risk. | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.SCORE | |
| Risk | Risk Score Color | Dimension | Risk Score Color | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.SCORE_COLOR | |
| Risk | Risk Score Text | Dimension | Risk Score Text | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.SCORE_TEXT | |
| 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. | Value Derived From : Dim_W_ACTIVITY_RISK_D_Activity_Risk.TOTAL_COST | |
| WBS Folder | |||||
| WBS | WBS Hierarchy - (WBS) | Full Path Name | Dimension | Full path for wbs hierarchy | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.FULL_PATH_NAME |
| WBS | WBS Hierarchy - (WBS) | WBS Code (Project Level) | 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 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.PROJ_LEVEL_SHORT_NAME |
| WBS | WBS Hierarchy - (WBS) | WBS Name (Project Level) | Dimension | The name of the WBS element | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.PROJ_LEVEL_NAME |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 1 | Dimension | WBS ID Level 1 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV1 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 10 | Dimension | WBS ID Level 10 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV10 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 11 | Dimension | WBS ID Level 11 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV11 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 12 | Dimension | WBS ID Level 12 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV12 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 13 | Dimension | WBS ID Level 13 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV13 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 14 | Dimension | WBS ID Level 14 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV14 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 15 | Dimension | WBS ID Level 15 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV15 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 16 | Dimension | WBS ID Level 16 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV16 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 17 | Dimension | WBS ID Level 17 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV17 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 2 | Dimension | WBS ID Level 2 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV2 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 3 | Dimension | WBS ID Level 3 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV3 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 4 | Dimension | WBS ID Level 4 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV4 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 5 | Dimension | WBS ID Level 5 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV5 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 6 | Dimension | WBS ID Level 6 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV6 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 7 | Dimension | WBS ID Level 7 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV7 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 8 | Dimension | WBS ID Level 8 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV8 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 9 | Dimension | WBS ID Level 9 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV9 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 1 | Dimension | WBS Name Level 1 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV1 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 10 | Dimension | WBS Name Level 10 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV10 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 11 | Dimension | WBS Name Level 11 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV11 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 12 | Dimension | WBS Name Level 12 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV12 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 13 | Dimension | WBS Name Level 13 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV13 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 14 | Dimension | WBS Name Level 14 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV14 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 15 | Dimension | WBS Name Level 15 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV15 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 16 | Dimension | WBS Name Level 16 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV16 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 17 | Dimension | WBS Name Level 17 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV17 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 2 | Dimension | WBS Name Level 2 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV2 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 3 | Dimension | WBS Name Level 3 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV3 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 4 | Dimension | WBS Name Level 4 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV4 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 5 | Dimension | WBS Name Level 5 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV5 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 6 | Dimension | WBS Name Level 6 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV6 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 7 | Dimension | WBS Name Level 7 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV7 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 8 | Dimension | WBS Name Level 8 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV8 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 9 | Dimension | WBS Name Level9 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV9 |
| WBS | Notebooks - (WBS) | WBS level notebook topics. | |||
| WBS | Notebooks - (WBS) | Create Date | Dimension | The date the notebook topic was created | Value Derived From : The date the notebook topic was created |
| WBS | Notebooks - (WBS) | Create User | Dimension | The user that created the notebook topic | Value Derived From : The user that created the notebook topic |
| WBS | Notebooks - (WBS) | Notebook Text | Lookup | The text of the notebook topic | P6Core."Lookup - WBS Note"."Notebook Text" |
| WBS | Notebooks - (WBS) | Notebook Topic Name | Dimension | The name of the notebook topic | Value Derived From : The name of the notebook topic |
| WBS | Notebooks - (WBS) | Update Date | Dimension | The date the notebook topic was updated | Value Derived From : The date the notebook topic was updated |
| WBS | Notebooks - (WBS) | Update User | Dimension | The last user to update notebook topic | Value Derived From : The last user to update notebook topic |