Primavera Cloud - Lean Task

Description: Use this subject area to analyze task commitments, completion, percent complete and reason, if any, for missing commitments.

Folder	SubFolder	Field Name	Dimension/ Fact / Lookup	Description
Project Portfolio				Portfolios consist of projects grouped together in a meaningful way. Portfolios are used to do project analysis across the enterprise.
Project Portfolio	not applicable	Project Portfolio Name	Dimension	The name of the portfolio.
Project Portfolio	not applicable	Project Portfolio Description	Dimension	The description of the portfolio.
Project
Project	General - (Project)
		Project Object Id	Dimension	The Unique ID of the project.
		Project ID	Dimension	The Project Id of the project
		Project Name	Dimension	The project name.
		Added By	Dimension	The name of the user who added the project.
		Status	Dimension	The status of the project as active, inactive, planned, or what-if.
		Overall Project Score	Dimension	The project score.
		Schedule Health score	Dimension	Schedule Health Score
		Datasource Id	Dimension	A unique source Id created for the data source being used. Used to identify data sources when using multiple data sources.
Project	Dates - (Project)
		Anticipated Start	Dimension	Anticipated start date of the project.
		Anticipated Finish	Dimension	Anticipated finish date of the 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.
		Date Added	Dimension	The date this project was added.
		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.
		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.
		Forecast Start Date	Dimension	The start date optionally used by the project scheduler.
		Forecast Finish Date	Dimension	The end date optionally used by the project scheduler.
		Must Finish By	Dimension	The optional date constraint you can specify for the project end date.
		Planned Start	Dimension	The date the project is scheduled to start.
		Scheduled Finish	Dimension	The calculated latest early finish date, which is based on the schedule most recently generated for the project.
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).
		At Completion Duration	Dimension	The duration at completion is the total time from the project current start date to the current finish date.
		Baseline Duration	Dimension	The duration of the baseline project.
		Planned Duration	Dimension	Planned duration is the total time from the project planned start date to the planned finish date.
		Remaining Duration	Dimension	Remaining duration is the total time from the current data date to the current finish date.
		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.
Project	Location - (Project)
		Location Name	Dimension	The name of the location.
		Location Type	Dimension	Location Type
		Address Line 1	Dimension	The first line of the address.
		Address Line 2	Dimension	The second line of the address.
		City Name	Dimension	The city name for this location.
		Municipality Name	Dimension	The municipality name for this location.
		State Name	Dimension	State/Province
		Country Code	Dimension	The country code for this location.
		Postal Code	Dimension	The postal code for this location.
		Longitude	Dimension	The longitude for this location.
		Latitude	Dimension	The latitude for this location.
Project	Codes - (Project)			This folder displays a maximum of 300 Project codes that are selected by your organization in the CIC Administration application. To include or exclude project codes, contact your CIC Analytics administrator.
Project	Text UDFs - (Project)			This folder displays a maximum of 300 Project UDFs of Text data type that have been selected by your organization in the CIC Administration application. To include or exclude UDFs, contact your CIC Analytics administrator.
Project	Date UDFs - (Project)			This folder displays a maximum of 300 Project UDFs of Date data type that have been selected by your organization in the CIC Administration application. To include or exclude UDFs, contact your CIC Analytics administrator.
Activity	General - (Activity)
		Activity Id	Dimension	A short ID which uniquely identifies the activity within the project.
		Activity Name	Dimension	The name of the activity. The activity name does not have to be unique.
		Activity Owner Id	Dimension
		Activity Owner	Dimension
		Activity Status	Dimension	The current status of the activity, either Not Started, In Progress, or Completed.
		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.
		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.
		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.
		Is Critical	Dimension	Indicates whether the activity is critical. An activity is critical when its Total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project.
		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.
		Primary Constraint Type	Dimension	The type of constraint applied to the activity start or finish date. Activity constraints are used by the project scheduler. Start date constraints are 'Start On', 'Start On or Before', 'Start On or After' and 'Mandatory Start'. Finish date constraints are 'Finish On', 'Finish On or Before', 'Finish On or After' and 'Mandatory Finish'. Another type of constraint, 'As Late as Possible', schedules the activity as late as possible based on the available free float.
		Secondary Constraint Type	Dimension	The second type of constraint applied to the activity start or finish date.
Activity	Dates - (Activity)
		Actual Start	Dimension	The date on which the activity actually started.
		Actual Finish	Dimension	The date on which the activity actually finished.
		Baseline Project Start	Dimension	The Project Baseline Planned Start Date.
		Baseline Project Finish	Dimension	The Project Baseline Planned Finish Date
		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.
		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.
		Expected Finish	Dimension	The date the activity is expected to finish. Typically, this date is entered in the Timesheets module by the primary resource.
		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.
		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.
		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.
		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.
		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.
		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.
		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.
		Secondary Constraint Date	Dimension	The second constraint date for the activity, if the activity has a constraint
		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.
		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.
		Remaining Late Start	Dimension	Remaining late start date as calculated by the scheduler
		Remaining Late Finish	Dimension	Remaining late end date as calculated by the scheduler
		Suspend Date	Dimension	The date progress is suspended on an activity.
		Resume Date	Dimension	The date progress is resumed on an activity.
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.
		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.
		Baseline Duration	Dimension	The duration for the activity in the primary baseline.
		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.
		Free Float	Dimension	The amount of time the activity can be delayed before delaying the start date of any successor 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.
		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.
		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.
		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.
Activity	Codes - (Activity)			This folder displays a maximum of 300 Activity codes that have been in the CIC Administration application selected by your organization. To include or exclude activity codes, contact your CIC Analytics administrator.
Activity	Text UDFs - (Activity)			This folder displays a maximum of 300 Activty UDFs of Text data type that have been selected in the CIC Administration application by your organization. To include or exclude UDFs, contact your CIC Analytics administrator.
Activity	Date UDFs - (Activity)			This folder displays a maximum of 300 Activty UDFs of Date data type that have been selected in the CIC Administration application by your organization. To include or exclude UDFs, contact your CIC Analytics administrator.
Task	General - (Task)			General- (Task)
Task	General - (Task)	Activity Complete Status	Dimension	Activity Complete Status
Task	General - (Task)	Activity Date Status	Dimension	Activity Date Status
Task	General - (Task)	Overdue Flag	Dimension	Overdue Flag
Task	General - (Task)	Code Prefix	Dimension	Code Prefix
Task	General - (Task)	Code Suffix	Dimension	Code Suffix
Task	General - (Task)	Predecessor Count	Dimension	Predecessor Count
Task	General - (Task)	Task Code	Dimension	Task Code
Task	General - (Task)	Task Name	Dimension	Task Name
Task	General - (Task)	Task Object ID	Dimension	The Unique ID of the task
Task	General - (Task)	Task Status	Dimension	Task Status
Task	General - (Task)	Task Type	Dimension	Task Type
Task	Dates - (Task)			Dates- (Task)
Task	Dates - (Task)	Completed Date	Dimension	Completed Date
Task	Dates - (Task)	Latest Commitment Due Date	Dimension	Latest Commitment Due Date
Task	Dates - (Task)	Start Date	Dimension	Start Date
Task	Dates - (Task)	Tentative Date	Dimension	Tentative Date
Task	Durations - (Task)			Durations- (Task)
Task	Durations - (Task)	Duration Hours	Dimension	Duration Hours
Task	Durations - (Task)	Slack	Dimension	Slack
Task	Commitment - (Task)			Commitment- (Task)
Task	Commitment - (Task)	Unique Commitment ID	Dimension	The Unique ID of the commitment
Task	Commitment - (Task)	Commitment Status	Dimension	Commitment Status
Task	Commitment - (Task)	Due Date	Dimension	Due Date
Task	Commitment - (Task)	Reason	Dimension	Reason
WBS	WBS Hierarchy - (WBS)
		Full Path Name	Dimension	Full path for wbs hierarchy
		Project Level ID	Dimension	The name of the activity. The activity name does not have to be unique.
		Project Level Name	Dimension	The name of the WBS element.
		WBS ID Level 1	Dimension	WBS ID Level 1
		WBS Name Level 1	Dimension	WBS Name Level 1
		WBS ID Level 2	Dimension	WBS ID Level 1
		WBS Name Level 2	Dimension	WBS Name Level 1
		WBS ID Level 3	Dimension	WBS ID Level 1
		WBS Name Level 3	Dimension	WBS Name Level 1
		WBS ID Level 4	Dimension	WBS ID Level 1
		WBS Name Level 4	Dimension	WBS Name Level 1
		WBS ID Level 5	Dimension	WBS ID Level 1
		WBS Name Level 5	Dimension	WBS Name Level 1
		WBS ID Level 6	Dimension	WBS ID Level 1
		WBS Name Level 6	Dimension	WBS Name Level 1
		WBS ID Level 7	Dimension	WBS ID Level 1
		WBS Name Level 7	Dimension	WBS Name Level 1
		WBS ID Level 8	Dimension	WBS ID Level 1
		WBS Name Level 8	Dimension	WBS Name Level 1
		WBS ID Level 9	Dimension	WBS ID Level 1
		WBS Name Level 9	Dimension	WBS Name Level 1
		WBS ID Level 10	Dimension	WBS ID Level 1
		WBS Name Level 10	Dimension	WBS Name Level 1
		WBS ID Level 11	Dimension	WBS ID Level 1
		WBS Name Level 11	Dimension	WBS Name Level 1
		WBS ID Level 12	Dimension	WBS ID Level 1
		WBS Name Level 12	Dimension	WBS Name Level 1
		WBS ID Level 13	Dimension	WBS ID Level 1
		WBS Name Level 13	Dimension	WBS Name Level 1
		WBS ID Level 14	Dimension	WBS ID Level 1
		WBS Name Level 14	Dimension	WBS Name Level 1
		WBS ID Level 15	Dimension	WBS ID Level 1
		WBS Name Level 15	Dimension	WBS Name Level 1
		WBS ID Level 16	Dimension	WBS ID Level 1
		WBS Name Level 16	Dimension	WBS Name Level 1
		WBS ID Level 17	Dimension	WBS ID Level 1
		WBS Name Level 17	Dimension	WBS Name Level 1
Fact - Primavera - Lean Task	Counts			Counts
Fact - Primavera - Lean Task	Counts	Commitment Count	Fact	Commitment Count
Fact - Primavera - Lean Task	Counts	Completed Count	Fact	Completed Count
Fact - Primavera - Lean Task	Metrics			Metrics
Fact - Primavera - Lean Task	Metrics	# of Activities	Fact	# of Activities
Fact - Primavera - Lean Task	Metrics	# of Projects	Fact	# of Projects
Fact - Primavera - Lean Task	Metrics	# of Tasks	Fact	# of Tasks

Related Topics