ResourceAssignment

Description: Resource assignments track the work of resources or roles that are performing various activities.

Field

Description

ActivityId

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

ActivityName

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

ActivityObjectId

The unique ID of the activity to which the resource is assigned.

ActualCost

The actual non-overtime plus overtime cost for the resource assignment on the activity. Computed as actual cost = actual regular cost + actual overtime cost.

ActualDuration

The actual duration for the resource assignment on the activity.

ActualFinishDate

The date the resource actually finished working on the activity.

ActualOvertimeCost

The actual overtime cost for the resource assignment on the activity. Computed as actual overtime cost = actual overtime units * cost per time * overtime factor.

ActualOvertimeUnits

The actual overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

ActualRegularCost

The actual non-overtime cost for the resource assignment on the activity. Computed as actual regular cost = actual regular units * cost per time.

ActualRegularUnits

The actual non-overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

ActualStartDate

The date the resource actually started working on the activity.

ActualThisPeriodCost

The actual this period cost (will be labor or nonlabor).

ActualThisPeriodUnits

The actual this period units (hours) (will be labor or nonlabor).

ActualUnits

The actual non-overtime plus overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

AtCompletionCost

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

AtCompletionDuration

The total working time from the activity's current start date to the current finish date.

AtCompletionUnits

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

AutoComputeActuals

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.

CalendarName

The name of the calendar.

CalendarObjectId

The unique ID generated by the system for the calendar associated with the resource assignment.

CostAccountId

The id of associated cost account.

CostAccountName

The name of the associated cost account.

CostAccountObjectId

The unique ID of the cost account associated with this resource assignment.

CreateDate

The date this assignment was created.

CreateUser

The name of the user that created this assignment.

DrivingActivityDatesFlag

The flag indicating whether new resource/role assignments drive activity dates, by default.

FinishDate

The finish date of the resource assignment on the activity. Set to the remaining finish date until the activity is completed, then set to the actual finish date.

GUID

The globally unique ID generated by the system.

HasFutureBucketData

The flag that indicates whether the assignment has future bucket data.

IsActive

The option that determines whether the resource is currently active. Non-active resources may be resources that have left the organization but not deleted from the system since they may have actual hours.

IsBaseline

The flag that indicates whether this resource assignment is active.

IsCostUnitsLinked

The flag that determines whether or not cost should be calculated based on units.

IsOvertimeAllowed

The flag that indicates whether the resource is allowed to log overtime hours.

IsPrimaryResource

The flag that indicates whether this resource is the activity's primary resource.

IsTemplate

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

LastUpdateDate

The date this assignment was last updated.

LastUpdateUser

The name of the user that last updated this assignment.

ObjectId

The unique ID generated by the system.

OvertimeFactor

The overtime factor used to compute the overtime price for the resource assignment on this activity. Overtime price = standard price * overtime factor.

PendingActualOvertimeUnits

The actual overtime units worked by the resource on this activity.

PendingActualRegularUnits

The actual nonovertime units worked by the resource on this activity.

PendingPercentComplete

The estimate of the percentage of the resource's units of work completed on this activity. The pending percent complete is entered by each resource using Timesheets.

PendingRemainingUnits

The estimate of the resource's remaining units on this activity. The pending remaining units is entered by each resource using Timesheets.

PlannedCost

The planned cost for the resource assignment on the activity. Computed as planned cost = planned units * price per time.

PlannedDuration

The planned working time for the resource assignment on the activity, from the resource's planned start date to the planned finish date.

PlannedFinishDate

The date the resource is scheduled to finish working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

PlannedLag

The planned time lag between the activity's planned start date and the resource's planned start date on the activity. If the resource is planned to start work when the activity is planned to start, the planned lag is zero.

PlannedStartDate

The date the resource is scheduled to begin working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

PlannedUnits

The planned units of work for the resource assignment on the activity. This field is named BudgetedUnits in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

PlannedUnitsPerTime

The planned units per time at which the resource is to perform work on this activity.

PricePerUnit

The price per time for the resource on this activity. This price is used to compute the resource's cost for the activity.

PriorActualOvertimeUnits

The difference between the pending quantity value and the actual quantity value for overtime before applying the new actual value.

PriorActualRegularUnits

The difference between the pending quantity value and the actual quantity value before applying the new actual value.

Proficiency

The skill level that is associated with the role. The values are 'Master', 'Expert', 'Skilled', 'Proficient', and 'Inexperienced'.

ProjectId

The short code that uniquely identifies the project.

ProjectObjectId

The unique ID of the associated project.

RateSource

The value that indicates which price/unit will be used to calculate costs for the assignment, such as 'Resource', 'Role', and 'Override'.

RateType

The rate type that determines which of the five prices specified for the resource will be used to calculate the cost for the resource assignment.

RemainingCost

The remaining cost for the resource assignment on the activity. Computed as remaining cost = remaining units * cost per time.

RemainingDuration

The remaining duration of the resource assignment. The remaining duration is the remaining working time for the resource assignment on the activity, from the resource's remaining start date to the remaining finish date.

RemainingFinishDate

The date the resource is scheduled to finish the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

RemainingLag

The time lag between the activity's remaining start date and the resource's remaining start date on the activity.

RemainingLateFinishDate

The remaining late finish date calculated by the scheduler.

RemainingLateStartDate

The remaining late start date calculated by the scheduler.

RemainingStartDate

The date the resource is scheduled to begin the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

RemainingUnits

The remaining units of work to be performed by this resource on this 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.

RemainingUnitsPerTime

The units per time at which the resource will be performing work on the remaining portion of this activity.

ResourceCalendarName

The name of the calendar for the resource.

ResourceCurveName

The name of the resource curve that determines how resources and costs are distributed over time for this activity.

ResourceCurveObjectId

The unique ID of the resource curve.

ResourceId

The short code that uniquely identifies the resource.

ResourceName

The name of the resource.

ResourceObjectId

The unique ID of the associated resource.

ResourceType

The resource type: "Labor", "Nonlabor", or "Material".

RoleId

The short code that uniquely identifies the role.

RoleName

The name of the role. The role name uniquely identifies the role.

RoleObjectId

The unique ID of the role the resource is performing on this activity. A resource may be assigned to the same activity more than once, performing different roles.

StaffedRemainingCost

The time distribution of the resource's remaining cost for resource assignments that have filled a role.

StaffedRemainingUnits

The time distribution of the resource's remaining units for resource assignments that have filled a role.

StartDate

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

UnitsPercentComplete

The percent complete of units for the resource assignment on the activity. Computed as actual units / at completion units * 100. Always in the range 0 to 100.

UnstaffedRemainingCost

The time distribution of the resource's remaining cost for resource assignments that have not filled a role.

UnstaffedRemainingUnits

The time distribution of the resource's remaining units for resource assignments that have not filled a role.

WBSObjectId

The unique ID of the WBS for the activity.

RolledupWBSObjectId

Rolled up WBS Object Ids after filtering either by levels or tagging.

Related Topics

P6 Business Objects

Activity

ActivityCode

ActivityCodeType

ActivityExpense

ActivityRisk

BaselineType

Calendar

CBS

CBSDurationSummary

CBSExpenseSpread

CBSResourceSpread

CostAccount

Currency

EPS

ExpenseCategory

FinancialPeriod

Location

NotebookTopic

Project

ProjectCode

ProjectCodeType

ProjectResource

Relationship

Resource

ResourceCode

ResourceCodeType

ResourceRate

Risk

RiskImpact

RiskMatrix

RiskMatrixScore

RiskMatrixThreshold

RiskResponseAction

RiskResponseActionImpact

RiskResponsePlan

RiskThreshold

RiskThresholdLevel

Role

RoleRate

UDFType

WBS

WBSCategory

WBSExpenseSpread

WBSResourceSpread

WBSSpread



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Monday, March 30, 2015