Activity Fields

AccountingVariance

double

X

The difference between the planned value of work scheduled and the actual cost of work performed. Computed as accounting variance = planned value - actual cost . A negative value indicates that actual costs have exceeded the scheduled costs.

AccountingVarianceLaborUnits

double

X

The difference between the planned value of work scheduled and the actual work performed. Computed as accounting variance labor units = planned value labor units - actual units. A negative value indicates that actual costs have exceeded the scheduled costs.

ActivityOwnerUserId

int

X

X

The unique user ID of the activity owner.

ActualDuration

double
restricted to
minInclusive(0.0)

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.

ActualExpenseCost

double

X

The actual costs for all project expenses associated with the activity.

ActualFinishDate

dateTime

X

The date on which the activity is actually finished.

ActualLaborCost

double

The actual costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity actual labor units * project default price / time.

ActualLaborUnits

double

X

The actual units for all labor resources assigned to the activity.

ActualMaterialCost

double

X

The sum of all regular and overtime costs for material resources.

ActualNonLaborCost

double

The actual costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity actual nonlabor units * project default price / time.

ActualNonLaborUnits

double

X

The actual units for all nonlabor resources assigned to the activity.

ActualStartDate

dateTime

X

The date on which the activity is actually started.

ActualThisPeriodLaborCost

double

The actual this period labor cost for all labor resources assigned to the activity.

ActualThisPeriodLaborUnits

double

X

The actual this period labor units (hours) for all labor resources assigned to the activity.

ActualThisPeriodMaterialCost

double

X

The sum of all material resource costs for the current period.

ActualThisPeriodNonLaborCost

double

The actual this period nonlabor 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.

ActualThisPeriodNonLaborUnits

double

X

The actual this period nonlabor units (hours) for all nonlabor resources assigned to the activity.

ActualTotalCost

double

X

The actual total cost for the activity, including labor resources, nonlabor resources, and project expenses. Actual total cost = actual labor costs + actual nonlabor costs + actual expense costs.

ActualTotalUnits

double

X

the sum of Actual Labor Units and Actual Nonlabor Units.

AtCompletionDuration

double
restricted to
minInclusive(0.0)

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.

AtCompletionExpenseCost

double

X

The sum of the actual plus remaining costs for all expenses associated with the activity. Computed as actual expense cost + remaining expense cost.

AtCompletionLaborCost

double

The sum of the actual plus remaining costs for all labor resources assigned to the activity. Computed as actual labor cost + remaining labor cost. Same as the planned labor costs if the activity is not started and the actual labor costs once the activity is completed.

AtCompletionLaborUnits

double

X

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 planned labor units if the activity is not started and the actual labor units once the activity is completed.

AtCompletionLaborUnitsVariance

double

X

The project baseline planned total labor units minus the estimate at completion labor units.

AtCompletionMaterialCost

double

X

The sum of all actual and remaining costs for material resources.

AtCompletionNonLaborCost

double

The sum of the actual plus remaining costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost + remaining nonlabor cost. Same as the planned nonlabor costs if the activity is not started and the actual nonlabor costs once the activity is completed.

AtCompletionNonLaborUnits

double

X

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 planned nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed.

AtCompletionTotalCost

double

X

The total cost at completion for the activity, including labor resources, nonlabor resources, and project expenses. At completion total cost = at completion labor cost + at completion nonlabor cost + at completion expense cost.

AtCompletionTotalUnits

double

X

The sum of the actual plus remaining units for the resource assignment on the activity.

AtCompletionVariance

double

X

The difference between the project baseline total cost and the current estimate of total cost. Computed as VAC = BAC - EAC. A negative value indicates an estimated cost overrun. BAC is computed from the current project baseline.

AutoComputeActuals

boolean

X

The option that determines whether the activity's actual and remaining units, start date, finish date, and percent complete are computed automatically using the planned dates, planned units and the schedule percent complete. If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. Use this option to assume that all work for the activity proceeds according to plan.

Baseline1Duration

double

X

The duration for the activity in the primary baseline. The duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar.

Baseline1FinishDate

dateTime

X

The current finish date of the activity in the primary baseline. Set to 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.

Baseline1PlannedDuration

double

X

The planned duration for the activity in the primary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. This field is named Baseline 1 Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline1PlannedExpenseCost

double

X

The planned costs for all project expenses associated with the activity. This field is named Baseline 1 Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline1PlannedLaborCost

double

X

The cost at completion for all labor resources assigned to the activity in the primary baseline. Computed from the primary baseline at completion labor units. If no resources are assigned, computed as the activity BL labor units * project default price / time. This field is named Baseline 1 Budgeted Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline1PlannedLaborUnits

double

X

The planned units for all labor resources assigned to the activity. This field is named Baseline 1 Budgeted Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline1PlannedMaterialCost

double

X

The Planned Material Cost for a primary baseline activity.

Baseline1PlannedNonLaborCost

double

X

The planned costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time. This field is named Baseline 1 Budgeted Non Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline1PlannedNonLaborUnits

double

X

The planned units for all nonlabor resources assigned to the activity. This field is named Baseline 1 Budgeted Non Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline1PlannedTotalCost

double

X

The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost. This field is named Baseline 1 Budgeted Total Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline1StartDate

dateTime

X

The current start date of the activity in the primary baseline. Set to the planned start date until the activity is started, then set to the actual start date.

BaselineDuration

double

X

The duration for the activity in the project baseline. The duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar.

BaselineFinishDate

dateTime

X

The current finish date of the activity in the project baseline. Set to 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.

BaselinePlannedDuration

double

X

The planned duration for the activity in the project baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. This field is named Baseline Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

BaselinePlannedExpenseCost

double

X

The planned costs for all project expenses associated with the activity. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

BaselinePlannedLaborCost

double

X

The cost at completion for all labor resources assigned to the activity in the project baseline. Computed from the baseline at completion labor units. If no resources are assigned, computed as the activity BL labor units * project default price / time. This field is named Baseline Budgeted Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

BaselinePlannedLaborUnits

double

X

The planned units for all labor resources assigned to the activity. This field is named Baseline Budgeted Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

BaselinePlannedMaterialCost

double

X

The Planned Material Cost for a project baseline activity.

BaselinePlannedNonLaborCost

double

X

The planned costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time. This field is named Baseline Budgeted Non Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

BaselinePlannedNonLaborUnits

double

X

The planned units for all nonlabor resources assigned to the The planned duration for the activity in the project baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. This field is named Baseline Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.activity. This field is named Baseline Budgeted Non Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

BaselinePlannedTotalCost

double

X

The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost. This field is named Baseline Budgeted Total Cost in Primavera's Engineering & The planned costs for all project expenses associated with the activity. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.Construction and Maintenance & Turnaround solutions.

BaselineStartDate

dateTime

X

The current start date of the activity in the project baseline. Set to the planned start date until the activity is started, then set to the actual start date.

Baseline2Duration

double

X

The duration for the activity in the user's secondary baseline. The duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar.

Baseline2FinishDate

dateTime

X

The planned units for all labor resources assigned to the activity. This field is named Baseline Budgeted Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.The current finish date of the activity in the user's secondary baseline. Set to 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.

Baseline2PlannedDuration

double

X

The planned duration for the activity in the user's secondary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. This field is named Baseline Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline2PlannedExpenseCost

double

X

The planned costs for all project expenses associated with the activity in the user's secondary baseline. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline2PlannedLaborCost

double

X

The planned costs for all project expenses associated with the activity in the user's secondary baseline. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline2PlannedLaborUnits

double

X

The planned units for all labor resources assigned to the activity in the user's secondary baseline. This field is named Baseline Budgeted Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline2PlannedMaterialCost

double

X

The Planned Material Cost for the activity in the user's secondary baseline.

Baseline2PlannedNonLaborCost

double

X

The planned costs for all nonlabor resources assigned to the activity in the user's secondary baseline. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time. This field is named Baseline Budgeted Non Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline2PlannedNonLaborUnits

double

X

The planned units for all nonlabor resources assigned to the The planned duration for the activity in the user's secondary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. This field is named Baseline Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.activity. This field is named Baseline Budgeted Non Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline2PlannedTotalCost

double

X

The planned total cost for the activity in the user's secondary baseline. Total cost includes the costs for labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost. This field is named Baseline Budgeted Total Cost in Primavera's Engineering & The planned costs for all project expenses associated with the activity. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.Construction and Maintenance & Turnaround solutions.

Baseline2StartDate

dateTime

X

The current start date of the activity in the user's secondary baseline. Set to the planned start date until the activity is started, then set to the actual start date.

Baseline3Duration

double

X

The duration for the activity in the user's tertiary baseline. The duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar.

Baseline3FinishDate

dateTime

X

The current finish date of the activity in the user's tertiary baseline. Set to 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.

Baseline3PlannedDuration

double

X

The planned duration for the activity in the user's tertiary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. This field is named Baseline Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline3PlannedExpenseCost

double

X

The planned costs for all project expenses associated with the activity in the user's tertiary baseline. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline3PlannedLaborCost

double

X

The planned costs for all project expenses associated with the activity in the user's tertiary baseline. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline3PlannedLaborUnits

double

X

The planned units for all labor resources assigned to the activity in the user's tertiary baseline. This field is named Baseline Budgeted Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline3PlannedMaterialCost

double

X

The Planned Material Cost for the activity in the user's tertiary baseline.

Baseline3PlannedNonLaborCost

double

X

The planned costs for all nonlabor resources assigned to the activity in the user's tertiary baseline. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time. This field is named Baseline Budgeted Non Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline3PlannedNonLaborUnits

double

X

The planned units for all nonlabor resources assigned to the The planned duration for the activity in the user's tertiary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. This field is named Baseline Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.activity. This field is named Baseline Budgeted Non Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Baseline3PlannedTotalCost

double

X

The planned total cost for the activity in the user's tertiary baseline. Total cost includes the costs for labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost. This field is named Baseline Budgeted Total Cost in Primavera's Engineering & The planned costs for all project expenses associated with the activity. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.Construction and Maintenance & Turnaround solutions.

Baseline3StartDate

dateTime

X

The current start date of the activity in the user's tertiary baseline. Set to the planned start date until the activity is started, then set to the actual start date.

BudgetAtCompletion

double

X

The planned total cost through activity completion. Computed as planned labor cost + planned nonlabor cost + planned expense cost, same as the planned total cost.

CBSCode

string
restricted to
maxLength(1024)

X

The unique name of the Unifier CBS Code. Assign CBS codes to activities so that you can filter which activities you will send to Unifier.

CBSId

int

X

The unique Id of CBS Code.

CBSObjectId

int

X

X

The identifier of the CoUnifier CBS.

CalendarName

string
restricted to
maxLength(255)

X

X

The name of the calendar.

CalendarObjectId

int

X

The unique ID of the calendar assigned to the activity. Activity calendars can be assigned from the global calendar pool or the project calendar pool.

CostPercentComplete

double

X

The percent complete of costs for all labor resources, nonlabor resources, and expenses for the activity. Computed as actual total cost / at completion total cost * 100. Always in the range 0 to 100.

CostPercentOfPlanned

double

X

The percent complete of planned costs for all labor resources, nonlabor resources, and expenses for the activity. Computed as actual total cost / BL planned total cost * 100. The value can exceed 100.

CostPerformanceIndex

double

X

The earned value divided by the actual cost. A value less than 1 indicates that actual cost have exceeded the planned value.

CostPerformanceIndexLaborUnits

double

X

The ratio of the earned value labor units and the actual work performed. Computed as CPI labor units = earned value labor units / actual labor units .

CostVariance

double

X

The difference between the earned value and the actual cost of work performed. Computed as CV = earned value - actual costs. A negative value indicates that actual costs have exceeded the value of work performed.

CostVarianceIndex

double

X

The ratio of the cost variance and the earned value of work performed. Computed as CVI = cost variance / earned value.

CostVarianceIndexLaborUnits

double

X

The ratio of the cost variance labor units and the earned value of work performed. Computed as CVI labor units = CV labor units / earned value labor units

CostVarianceLaborUnits

double

X

The difference between the earned value of labor units and the actual cost of labor units. Calculated as CV labor units = earned value planned units - actual units. A negative value indicates that actual costs have exceeded the value of work performed.

CreateDate

dateTime

X

X

The date this activity was created.

CreateUser

string
restricted to
maxLength(255)

X

X

The name of the user that created this activity.

DataDate

dateTime

X

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.

Duration1Variance

double

X

The duration between the activity's primary baseline duration and the at complete duration. Computed as primary baseline duration - at completion duration.

Duration2Variance

double

X

The duration between the activity's baseline duration and the at complete duration. Computed as user's secondary baseline duration - at completion duration.

Duration3Variance

double

X

The duration between the activity's baseline duration and the at complete duration. Computed as user's tertiary baseline duration - at completion duration.

DurationPercentComplete

double
restricted to
minInclusive(0.0)

The percent complete of the activity duration. Computed as (planned duration - remaining duration) / planned duration * 100. Always in the range 0 to 100. The planned duration is taken from the current plan, not from the baseline.

DurationPercentOfPlanned

double

X

The activity actual duration percent of planned. Computed as actual duration / BL duration * 100. The value can exceed 100. The BL duration is the activity's at completion duration from the project baseline.

DurationType

string
restricted to
'Fixed Units/Time'
'Fixed Duration and Units/Time'
'Fixed Units'
'Fixed Duration and Units'

X

The duration type of the activity. One of 'Fixed Units/Time', 'Fixed Duration and Units/Time', 'Fixed Units', or 'Fixed Duration and Units'. For 'Fixed Units/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 and Units/Time' 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.

DurationVariance

double

X

The duration between the activity's project baseline duration and the at complete duration. Computed as project baseline duration - at completion duration.

EarlyFinishDate

dateTime

X

X

The earliest possible date the activity can finish. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.

EarlyStartDate

dateTime

X

X

The earliest possible date the remaining work for the activity can begin. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.

EarnedValueCost

double

X

The portion of the project baseline total cost of the activity that is actually completed as of the project data date. Computed as earned value = BAC * performance % complete. The method for computing performance % complete depends on the earned-value technique selected for the activity's WBS. BAC is computed from the project baseline.

EarnedValueLaborUnits

double

X

The portion of the project baseline labor units that is actually completed as of the project data date. Computed as labor units earned value = project baseline labor units * performance % complete. The method for computing performance % complete depends on the earned-value technique selected for the activity's WBS. The BL labor units is taken from the project baseline.

EstimateAtCompletionCost

double

X

The estimated cost at completion for the activity. Computed as the actual total cost plus the estimate-to-complete cost; EAC = ACWP + ETC. Note that the method for computing ETC depends on the earned-value technique selected for the activity's WBS.

EstimateAtCompletionLaborUnits

double

X

The estimated labor units at completion of the activity. 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.

EstimateToComplete

double

X

The estimated cost to complete the activity. Computed as either the remaining total cost for the activity (remaining total cost), or as PF * (BAC - earned value), depending on the earned-value technique selected for the activity's WBS. BAC is computed from the project baseline.

EstimateToCompleteLaborUnits

double

X

The estimated quantity to complete the activity. Computed as either the remaining total units for the activity (remaining total units), or as PF * (BL labor units - earned value), depending on the earned-value technique selected for the activity's WBS.

ExpectedFinishDate

dateTime

X

The date the activity is expected to be finished according to the progress made on the activity's work products. The expected finish date is entered manually by people familiar with progress of the activity's work products.

ExpenseCost1Variance

double

X

The difference between primary baseline expense cost and at completion expense cost. Calculated as primary baseline expense cost - at completion expense cost (at completion expense cost = actual expense cost + remaining expense cost).

ExpenseCost2Variance

double

X

The difference between secondary baseline expense cost and at completion expense cost. Calculated as user's secondary baseline expense cost - at completion expense cost (at completion expense cost = actual expense cost + remaining expense cost).

ExpenseCost3Variance

double

X

The difference between tertiary baseline expense cost and at completion expense cost. Calculated as user's tertiary baseline expense cost - at completion expense cost (at completion expense cost = actual expense cost + remaining expense cost).

ExpenseCostPercentComplete

double

X

The percent complete of costs for all expenses associated with the activity. Computed as actual expense cost / at completion expense cost * 100. Always in the range 0 to 100.

ExpenseCostVariance

double

X

The difference between project baseline expense cost and at completion expense cost. Calculated as project baseline expense cost - at completion expense cost (at completion expense cost = actual expense cost + remaining expense cost).

ExternalEarlyStartDate

dateTime

X

The date value that determines the early start date for imported activities with external constraints lost (relations from/to external projects that do not exist in the database). This field is the relationship early finish date (REF) when the lost relationship type is FS or SS. When the relationship type is SF or FF, this field is calculated as REF - RD of the successor.

ExternalLateFinishDate

dateTime

X

The date value that determines the Late Finish Date for imported activities with external constraints lost (from/to external projects that do not exist in the database). This field is the relationship late finish date (RLF) when the lost relationship type is FS or FF. When the relationship type is SS or SF, this field is calculated as RLS + RD of the predecessor.

Feedback

string

The feedback from the resource.

FinancialPeriodTmplId

int

X

The unique identifier of the financial period calendar assigned to the project.

FinishDate

dateTime

The current finish date of the activity. Set to 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.

FinishDate1Variance

double

X

The duration between the finish date in the current project and the primary baseline finish date. Calculated as finish date - primary baseline finish date.

FinishDate2Variance

double

X

The duration between the finish date in the current project and the finish date in the user's secondary baseline. Calculated as finish date - secondary baseline finish date.

FinishDate3Variance

double

X

The duration between the finish date in the current project and the finish date in the user's tertiary baseline. Calculated as finish date - tertiary baseline finish date.

FinishDateVariance

double

X

the duration between the finish date in the current project and the project baseline finish date. Calculated as finish date - project baseline finish date.

FloatPath

int

X

X

The integer representing the critical path this activity is on. The value 1 is the most critical path, value 2 is the second most critical path, etc.

FloatPathOrder

int

X

X

The integer representing the order in which this object was found on one of the critical paths.

FreeFloat

double

X

X

The amount of time the activity can be delayed before delaying the start date of any successor activity.

GUID

string
restricted to
pattern
'\{[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}\}|'

X

The globally unique ID generated by the system.

HasFutureBucketData

boolean

X

The flag that indicates whether a resource assignment on the activity has future bucket data.

Id

string
restricted to
maxLength(40)

X

The short ID that uniquely identifies the activity within the project.

IsBaseline

boolean

X

X

The boolean value indicating if this business object is related to a Project or Baseline

IsCritical

boolean

X

The flag that 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.

IsLongestPath

boolean

X

X

The flag that indicates whether an activity is on the longest path. Default = 'N'

IsNewFeedback

boolean

X

The flag that indicates that a resource has sent feedback notes about this activity which have not been reviewed yet.

IsTemplate

boolean

X

X

The boolean value indicating if this business object is related to a template Project.

IsWorkPackage

boolean

X

X

Indicates if this WBS is a workpackage in Primavera Cloudor not.

IsStarred

boolean

The boolean value indicating if this business object has been assigned a star in P6 Team Member

LaborCost1Variance

double

X

The difference between primary baseline labor cost and at completion labor cost. Calculated as BL labor cost - at completion labor cost

LaborCost2Variance

double

X

The difference between user's secondary baseline labor cost and at completion labor cost. Calculated as BL2 labor cost - at completion labor cost

LaborCost3Variance

double

X

The difference between user's tertiary baseline labor cost and at completion labor cost. Calculated as BL3 labor cost - at completion labor cost

LaborCostPercentComplete

double

X

The percent complete of costs for all labor resources assigned to the activity. Computed as actual labor cost / at completion labor cost * 100. Always in the range 0 to 100.

LaborCostVariance

double

X

The difference between project baseline labor cost and at completion labor cost. Calculated as BL labor cost - at completion labor cost

LaborUnits1Variance

double

X

The difference between primary baseline labor units and at completion labor units. Calculated as BL labor units - at completion labor units.

LaborUnits2Variance

double

X

The difference between user's secondary baseline labor units and at completion labor units. Calculated as BL2 labor units - at completion labor units.

LaborUnits3Variance

double

X

The difference between user's tertiary baseline labor units and at completion labor units. Calculated as BL3 labor units - at completion labor units.

LaborUnitsPercentComplete

double

X

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.

LaborUnitsVariance

double

X

The difference between project baseline labor units and at completion labor units. Calculated as BL labor units - at completion labor units.

LastUpdateDate

dateTime

X

X

The date this activity was last updated.

LastUpdateUser

string
restricted to
maxLength(255)

X

X

The name of the user that last updated this activity.

LateFinishDate

dateTime

X

X

The latest possible date the activity must finish without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.

LateStartDate

dateTime

X

X

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.

LevelingPriority

string
restricted to
'Top'
'High'
'Normal'
'Low'
'Lowest'

X

The activity priority used to prioritize activities in a project when performing resource leveling. Valid values are 'Top', 'High', 'Normal', 'Low', and 'Lowest'.

LocationName

string
restricted to
maxLength(100)

X

X

The name of the location assigned to the activity.

LocationObjectId

int

X

The unique ID of the location assigned to the activity.

MaterialCost1Variance

double

X

The primary Baseline Planned Material Cost minus the At Completion Material Cost.

MaterialCost2Variance

double

X

The user's secondary Baseline Planned Material Cost minus the At Completion Material Cost.

MaterialCost3Variance

double

X

The user's tertiary Baseline Planned Material Cost minus the At Completion Material Cost.

MaterialCostPercentComplete

double

X

The percent complete of costs for all material resources assigned to the activity. Computed as actual nonlabor cost / at completion nonlabor cost * 100. Always in the range 0 to 100.

MaterialCostVariance

double

X

The project BaselinePlannedMaterialCost minus the AtCompletionMaterialCost.

MaximumDuration

double
restricted to
minInclusive(0.0)

X

The maximum duration of the activity.

MinimumDuration

double
restricted to
minInclusive(0.0)

X

The minimum duration of the activity.

MostLikelyDuration

double
restricted to
minInclusive(0.0)

X

The most likely duration of the activity.

Name

string
restricted to
maxLength(120)

X

The name of the activity. The activity name does not have to be unique.

NonLaborCost1Variance

double

X

The difference between the primary baseline nonlabor cost and at completion nonlabor cost. Calculated as BL nonlabor cost - at completion nonlabor cost.

NonLaborCost2Variance

double

X

The difference between the user's secondary baseline nonlabor cost and at completion nonlabor cost. Calculated as BL2 nonlabor cost - at completion nonlabor cost.

NonLaborCost3Variance

double

X

The difference between the user's tertiary baseline nonlabor cost and at completion nonlabor cost. Calculated as BL3 nonlabor cost - at completion nonlabor cost.

NonLaborCostPercentComplete

double

X

The percent complete of costs 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.

NonLaborCostVariance

double

X

The difference between the project baseline labor cost and at completion labor cost. Calculated as BL nonlabor cost - at completion nonlabor cost.

NonLaborUnits1Variance

double

X

The difference between the primary baseline nonlabor units and at completion nonlabor units. Calculated as BL nonlabor units - at completion nonlabor units.

NonLaborUnits2Variance

double

X

The difference between the user's secondary baseline nonlabor units and at completion nonlabor units. Calculated as BL2 nonlabor units - at completion nonlabor units.

NonLaborUnits3Variance

double

X

The difference between the user's tertiary baseline nonlabor units and at completion nonlabor units. Calculated as BL3 nonlabor units - at completion nonlabor units.

NonLaborUnitsPercentComplete

double

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.

NonLaborUnitsVariance

double

X

The difference between the project baseline labor units and at completion labor units. Calculated as BL nonlabor units - at completion nonlabor units.

NotesToResources

string

The notes from the project manager to the timesheet resources.

ObjectId

int

X

The unique ID generated by the system.

PercentComplete

double

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.

PercentCompleteType

string
restricted to
'Physical'
'Duration'
'Units'
'Scope'

X

The activity percent complete type: 'Physical', 'Duration', 'Units', or 'Scope'. 'Scope' is only a valid option when P6 is integrated with Oracle Primavera Cloud for scope management.

PerformancePercentComplete

double

X

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.

PerformancePercentCompleteByLaborUnits

double

X

The performance percent complete for the activity according to the labor units. Computed as Earned Value Labor Units divided by Budget at Completion (Labor Units) multiplied by 100.

PhysicalPercentComplete

double

The physical percent complete, which can either be user entered or calculated from the activity's weighted steps.

PlannedDuration

double
restricted to
minInclusive(0.0)

X

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. This field is named OriginalDuration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedExpenseCost

double

X

The planned costs for all project expenses associated with the activity. This field is named BudgetedExpenseCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedFinishDate

dateTime

X

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.

PlannedLaborCost

double

The planned costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity planned labor units * project default price / time. This field is named BudgetedLaborCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedLaborUnits

double

X

The planned units for all labor resources assigned to the activity. This field is named BudgetedLaborUnits in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedMaterialCost

double

X

The sum of all material resource costs.

PlannedNonLaborCost

double

The planned costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time. This field is named BudgetedNonLaborCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedNonLaborUnits

double

X

The planned units for all nonlabor resources assigned to the activity. This field is named BudgetedNonLaborUnits in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedStartDate

dateTime

X

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.

PlannedTotalCost

double

X

The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned material cost + planned expense cost. This field is named BudgetedTotalCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedTotalUnits

double

X

the sum of Planned Labor Units and Planned Nonlabor Units. This field is named BudgetedTotalUnits in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

PlannedValueCost

double

X

The portion of the project baseline total cost of the activity that is scheduled to be completed as of the project data date. Computed as BAC * schedule % complete. Also known as the work scheduled to be performed for the activity. The schedule % complete specifies how much of the activity's project baseline duration has been completed so far. BAC is computed from the project baseline.

PlannedValueLaborUnits

double

X

The portion of the project baseline labor units that is scheduled to be completed as of the project data date. Computed as BL labor units * schedule % complete. The schedule % complete specifies how much of the activity's project baseline duration has been completed so far. BL labor units is taken from the project baseline.

PostRespCriticalityIndex

double

X

x

The Post Response Criticality Index calculated by Oracle Primavera Cloud during quantitative risk analysis.

PostResponsePessimisticFinish

dateTime

X

The Post Response Pessimistic Finish date calculated by Oracle Primavera Cloud during quantitative risk analysis.

PostResponsePessimisticStart

dateTime

X

The Post Response Pessimistic Start date calculated by Oracle Primavera Cloud during quantitative risk analysis.

PreRespCriticalityIndex

double

X

X

The Pre Response Criticality Index calculated by Oracle Primavera Cloud during quantitative risk analysis.

PreResponsePessimisticFinish

dateTime

X

The Pre Response Pessimistic Finish date calculated by Oracle Primavera Cloud during quantitative risk analysis.

PreResponsePessimisticStart

dateTime

X

The Pre Response Pessimistic Start date calculated by Oracle Primavera Cloud during quantitative risk analysis.

PrimaryConstraintDate

dateTime

X

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.

PrimaryConstraintType

string
restricted to
''
'Start On'
'Start On or Before'
'Start On or After'
'Finish On'
'Finish On or Before'
'Finish On or After'
'As Late As Possible'
'Mandatory Start'
'Mandatory Finish'

X

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', and 'Start On or After'. Finish date constraints are 'Finish On', 'Finish On or Before', and 'Finish On or After'. Another type of constraint, 'As Late As Possible', schedules the activity as late as possible based on the available free float.

PrimaryResourceId

string
restricted to
maxLength(255)

X

X

The name of the resource.

PrimaryResourceName

string
restricted to
maxLength(255)

X

X

The name of the resource.

PrimaryResourceObjectId

int

X

The unique ID of the primary resource for the activity. The primary resource is responsible for the overall work on the activity and updates the activity status using Timesheets.

ProjectFlag

string

X

X

Indicates if this WBS node is a Project/EPS node.

ProjectId

string

X

X

The short code of the associated project.

ProjectName

string

X

X

The name of the associated project.

ProjectNameSepChar

string

X

The character used to differentiate levels of a project or WBS structure when exporting to CPP format.

ProjectObjectId

int

X

The unique ID of the associated project.

ProjectProjectFlag

string

X

X

Indicates if this Project/EPS nose is a Project or EPS.

RemainingDuration

double
restricted to
minInclusive(0.0)

X

The remaining duration of the activity. 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 planned duration. After the activity is completed the remaining duration is zero.

RemainingEarlyFinishDate

dateTime

X

The remaining late end date, which is calculated by the scheduler.

RemainingEarlyStartDate

dateTime

X

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 Timesheets users follow.

RemainingExpenseCost

double

X

The remaining costs for all project expenses associated with the activity.

RemainingFloat

double

X

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.

RemainingLaborCost

double

The remaining costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity remaining labor units * project default price / time.

RemainingLaborUnits

double

X

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 planned units. After the activity is completed, the remaining units are zero.

RemainingLateFinishDate

dateTime

X

the remaining late finish date calculated by the scheduler.

RemainingLateStartDate

dateTime

X

the remaining late start date calculated by the scheduler.

RemainingMaterialCost

double

X

The sum of all material resource remaining costs.

RemainingNonLaborCost

double

The remaining costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity remaining nonlabor units * project default price / time.

RemainingNonLaborUnits

double

X

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 planned units. After the activity is completed, the remaining units are zero.

RemainingTotalCost

double

X

The remaining total cost for the activity, including labor resources, nonlabor resources, and project expenses. Remaining total cost = remaining labor costs + remaining nonlabor costs + remaining expense costs.

RemainingTotalUnits

double

X

X

the sum of Remaining Labor Units and Remaining Nonlabor Units.

ResumeDate

dateTime

X

The date when a suspended task or resource dependent activity should be resumed. The resume date must be later than the suspend date and earlier than the actual finish date. The Suspend/Resume period behaves like a nonworktime on the activity calendar or resource calendar for task and resource dependent activities.

ReviewFinishDate

dateTime

X

X

The finish date of the activity as proposed by the primary resource using Timesheets, while the activity is in "For Review" state. If the project manager approves the activity completion, the review finish is copied to the actual finish.

ReviewRequired

boolean

X

The indicator that determines whether the activity status updates made in Team Member interfaces must be approved before committing changes.

ReviewStatus

string
restricted to
'OK'
'For Review'
'Rejected'

X

The activity review status. Valid values are 'OK', 'For Review', and 'Rejected'. Primary resources set the status to 'For Review' when they believe the activity is completed but are not allowed to mark activities as completed.

SchedulePercentComplete

double

X

The activity schedule percent complete, which specifies how much of the activity's project baseline duration has been completed so far. Computed based on where the current data date falls relative to the activity's project baseline start and finish dates. If the data date is earlier than the BL start, the schedule % complete is 0. If the data date is later than the BL finish, the schedule % complete is 100. The schedule % complete indicates how much of the activity duration should be currently completed, relative to the selected project baseline.

SchedulePerformanceIndex

double

X

The ratio of the earned value of work performed and the work scheduled to be performed. Computed as SPI = earned value/ planned value. A value less than 1 indicates that less work was actually performed than was scheduled.

SchedulePerformanceIndexLaborUnits

double

X

The ratio of the earned value of labor units and the planned value of labor units. Computed as SPI labor units = earned value labor units / planned value labor units.

ScheduleVariance

double

X

The difference between the earned value of work performed and the work scheduled to be performed. Computed as SV = earned value - planned value. A negative value indicates that less work was actually performed than was scheduled.

ScheduleVarianceIndex

double

X

The ratio of the schedule variance and the work scheduled to be performed. Computed as SVI = SV / planned value.

ScheduleVarianceIndexLaborUnits

double

X

The ratio of the schedule variance and the work scheduled to be performed. Computed as SVI labor units = SV labor units / planned value labor units.

ScheduleVarianceLaborUnits

double

X

The difference between the earned value of work performed and the work scheduled to be performed. Computed as SV labor units = earned value labor units - planned value labor units.

ScopePercentComplete

double

The percent complete for the activity if the percent complete type is set to scope. Scope is calculated in Oracle Primavera Cloud when P6 is integrated with Oracle Primavera Cloud for scope management.

SecondaryConstraintDate

dateTime

X

The date to be used for the cstr_type2 assignment, if the activity has a cstr_type2 value. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler.

SecondaryConstraintType

string
restricted to
''
'Start On'
'Start On or Before'
'Start On or After'
'Finish On'
'Finish On or Before'
'Finish On or After'
'As Late As Possible'
'Mandatory Start'
'Mandatory Finish'

X

The additional constraint to be used by the scheduler. If more than one constraint is assigned, this value should be restricted to one of the following: "Start On or Before", "Start On or After", "Finish On or Before", or "Finish On or After".

StartDate

dateTime

The start date of the activity. Set to the remaining start date until the activity is started, then set to the actual start date.

StartDate1Variance

double

X

The duration between the start date in the current project and the primary baseline start date. Calculated as start date - primary baseline start date.

StartDate2Variance

double

X

The duration between the start date in the current project and the user's secondary baseline start date. Calculated as start date - secondary baseline start date.

StartDate3Variance

double

X

The duration between the start date in the current project and the user's tertiary baseline start date. Calculated as start date - tertiary baseline start date.

StartDateVariance

double

X

The duration between the start date in the current project and the project baseline start date. Calculated as start date - project baseline start date.

Status

string
restricted to
'Not Started'
'In Progress'
'Completed'

X

The current status of the activity, either 'Not Started', 'In Progress', or 'Completed'.

StatusCode

string
restricted to
'Planned'
'Active'
'Inactive'
'What-if'
'Requested'
'Templated'

X

X

The project status, either 'Planned', 'Active', 'Inactive', 'What-If', 'Requested', or 'Template'.

SuspendDate

dateTime

X

The start date when the progress of a task or resource dependent activity is delayed from. The suspend date must be later than the actual start date, which the activity must have. The progress of the activity can be resumed by setting the resume date. The Suspend/Resume period behaves like a nonworktime on the activity calendar or resource calendar for task and resource dependent activities.

TaskStatusCompletion

string
restricted to:
'BOTH_NOT_COMPLETE'
'TASKS_COMPLETE_ACTIVITY_NOT'
'ACTIVITY_COMPLETE_TASKS_NOT'
'BOTH_COMPLETE'
'NO_TASKS'

X

The completion status of tasks and activities from an integrated Oracle Primavera Cloud project used for lean scheduling. 'BOTH_NOT_COMPLETE' indicates that the activity and all associated tasks are not completed. 'TASKS_COMPLETE_ACTIVITY_NOT' indicates that the activity is not complete but all associated tasks are completed. 'ACTIVITY_COMPLETE_TASKS_NOT' indicates that the activity is complete but all assigned tasks are not completed. 'BOTH_COMPLETE' indicates that the activity and all assigned tasks are completed. If there are no tasks assigned to the activity, this field shows 'NO_TASKS'.

TaskStatusDates

string
restricted to:
'AT_LEAST_ONE_OUTSIDE'
'ALL_WITHIN'
'NO_TASK_DATES'

X

The date status of tasks and activitiesfrom an integrated Oracle Primavera Cloud project used for lean scheduling. 'AT_LEAST_ONE_OUTSIDE' indicates that one or more tasks has a start date earlier than the activity start date, and/or a due date or completed date later than the activity finish date. 'ALL_WITHIN' indicates that no tasks assigned to the activity have start dates earlier than the activity start date, nor due dates or completed dates dates later than the activity finish date. If there are no tasks assigned to the activity, this field shows 'NO_TASK_DATES'.

TaskStatusIndicator

boolean

X

An indicator that determines whether any of the following conditions is true: The task dates are outside of the activity dates, all of the tasks assigned to an activity are complete, but the activity is not complete, or the activity is complete but all of its assigned tasks are not complete.

ToCompletePerformanceIndex

double

X

The TCPI, which is calculated as (budget at completion - earned value) / (estimate at completion - ACWP).

TotalCost1Variance

double

X

The difference between the primary baseline total cost and the at completion total cost. Calculated as BL total cost - at completion total cost.

TotalCost2Variance

double

X

The difference between the user's secondary baseline total cost and the at completion total cost. Calculated as BL2 total cost - at completion total cost.

TotalCost3Variance

double

X

The difference between the user's tertiary baseline total cost and the at completion total cost. Calculated as BL3 total cost - at completion total cost.

TotalCostVariance

double

X

The difference between the project baseline total cost and the at completion total cost. Calculated as BL total cost - at completion total cost.

TotalFloat

double

X

X

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.

TotalPastPeriodEarnedValueCostBCWP

double

The total stored period earned value cost for each activity.

TotalPastPeriodEarnedValueLaborUnits

double

The total stored period earned value labor units for each activity.

TotalPastPeriodExpenseCost

double

The total stored period expense cost for each activity.

TotalPastPeriodLaborCost

double

The total stored period labor cost for each activity.

TotalPastPeriodLaborUnits

double

The total stored period labor units for each activity.

TotalPastPeriodMaterialCost

double

The total stored period material cost for each activity.

TotalPastPeriodNonLaborCost

double

The total stored period non labor cost for each activity.

TotalPastPeriodNonLaborUnits

double

The total stored period non labor units for each activity.

TotalPastPeriodPlannedValueCost

double

The total stored period planned value cost for each activity.

TotalPastPeriodPlannedValueLaborUnits

double

The total stored period planned value labor units for each activity.

Type

string
restricted to
'Task Dependent'
'Resource Dependent'
'Level of Effort'
'Start Milestone'
'Finish Milestone'
'WBS Summary'

X

The type of activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone', 'Finish Milestone', or 'WBS Summary'. 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 Milestone' or 'Finish Milestone' is a zero-duration activity without resources, marking a significant project event. A 'Level of Effort' activity has a duration that is determined by its dependent activities. Administration-type activities are typically 'Level of Effort'. A 'WBS Summary' comprises a group of activities that share a common WBS level. For example, all activities whose WBS codes start with A (A.1, A.1.1, A.1.1.2, A.2, A.3 and so forth) can be part of one WBS activity whose WBS code is A.

UnitsPercentComplete

double

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.

UnreadCommentCount

int

X

The number of Team Member Discussion comments associated with the Activity which have not yet been read.

WBSCode

string
restricted to
maxLength(40)

X

X

The 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.

WBSName

string
restricted to
maxLength(100)

X

X

The name of the WBS element.

WBSNamePath

string

X

The hierarchy of the parent WBS Names. WBS Names are listed in order from parent to child and hierarchical levels are separated by dots. For example: WBS_Name_1A.WBS_Name_2A.WBS_Name_3A

WBSObjectId

int

X

The unique ID of the WBS for the activity.

WBSPath

string

The WBS hierarchy of the activity.

WorkPackageId

string

X

The ID of the work package associated with an activity when P6 is integrated with Oracle Primavera Cloud for scope management.

WorkPackageName

string

X

The name of the work package associated with an activity when P6 is integrated with Oracle Primavera Cloud for scope management.