ResourceAssignment

ActivityId

String

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

No

ActivityObjectId

ForeignKey

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

No

ActivityType

Enum

The type of the activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

No

ActualCost

Double

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

No

ActualCostProject

Double

The actual cost for the resource or role assignment on the activity if using project currency.

No

ActualCurve

String

The actual hours for the resource assignment on the activity for a manual curve.

No

ActualDuration

Double

The actual duration for the resource assignment on the activity.

Yes

ActualFinish

DateTime

The date on which the assignment was completed..

No

ActualFinishDate

DateTime

The date the resource actually finished working on the activity.

No

ActualOvertimeUnits

Double

The amount of overtime work incurred on the assignment.

No

ActualRegularUnits

Double

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.

No

ActualStart

DateTime

If the activity has started, the date work began on the activity..

No

ActualStartDate

DateTime

The date the resource actually started working on the activity.

No

ActualThisPeriodCost

Double

The labor, nonlabor, and material costs incurred during the current financial period.

No

ActualThisPeriodCostProject

Double

The labor, nonlabor, and material costs incurred during the current financial period if using project currency.

No

ActualThisPeriodUnits

Double

The labor, nonlabor, and material units used during the current financial period.

No

ActualUnits

Double

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

No

AssignmentCode

String

The code that identifies this assignment

No

AtCompletionCost

Double

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

No

AtCompletionCostProject

Double

The sum of the actual costs plus remaining costs for the resource assignment on the activity if using project currency.

No

AtCompletionUnits

Double

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

No

CalculateCostFromUnitsFlag

Boolean

Determines whether to recalculate actual or actual this period units and costs when one of these values is updated.

No

CBSCode

String

The CBS code assigned to the Resource Assignment.

No

CBSId

ForeignKey

The unique ID of the CBS assigned to the Resource Assignment.

No

CBSObjectId

ForeignKey

The unique ID of the CBS assigned to the Resource Assignment.

No

CostAccountId

String

The id of associated cost account.

Yes

CurveName

Enum

The curve name for the resource assignment.

No

DailySpreadActualCost

String

Field Description

Yes

DailySpreadActualOvertimeCost

String

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

Yes

DailySpreadActualOvertimeUnits

String

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

Yes

DailySpreadActualRegularCost

String

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

Yes

DailySpreadActualRegularUnits

String

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

Yes

DailySpreadActualUnits

String

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

Yes

DailySpreadAtCompletionCost

String

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

Yes

DailySpreadAtCompletionUnits

String

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

Yes

DailySpreadPlannedCost

String

The planned cost of work required for the resource assignment on the activity to be completed for daily spread.

Yes

DailySpreadPlannedUnits

String

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

Yes

DailySpreadRemainingCost

String

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

Yes

DailySpreadRemainingLateCost

String

Field Description

Yes

DailySpreadRemainingLateUnits

String

Field Description

Yes

DailySpreadRemainingUnits

String

Desc

Yes

DailySpreadStaffedRemainingCost

String

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

Yes

DailySpreadStaffedRemainingLateCost

String

Field Description

Yes

DailySpreadStaffedRemainingLateUnits

String

Field Description

Yes

DailySpreadStaffedRemainingUnits

String

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

Yes

DailySpreadUnstaffedRemainingCost

String

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

Yes

DailySpreadUnstaffedRemainingLateCost

String

Field Description

Yes

DailySpreadUnstaffedRemainingLateUnits

String

Field Description

Yes

DailySpreadUnstaffedRemainingUnits

String

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

Yes

EarnedValueCost

Double

The approved budget for work actually completed by the specified project data date.

No

EarnedValueCostProject

Double

The approved budget for work actually completed by the specified project data date if using project currency.

No

FinishDate

DateTime

The finish date for the assignment.

No

Id

String

The unique identifier of the resourceassignment.

Yes

IsActivityFlagged

Boolean

The flag that indicates whether the resource who is assigned to the activity assignment has flagged the activity as important to the resource.

No

IsPrimaryResource

Boolean

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

No

ObjectId

String

The unique ID generated by the system.

No

PlannedCost

Double

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

No

PlannedCostProject

Double

The expected total cost of the item, such as an assignment, expense, or response plan if using project currency.

No

PlannedCurve

String

The planned hours for the resource assignment on the activity for a manual curve.

No

PlannedDuration

Double

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

No

PlannedFinish

DateTime

The date the assignment ios scheduled to be finished.

No

PlannedFinishDate

DateTime

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.

No

PlannedLag

String

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

No

PlannedStart

DateTime

The planned start date for the assignment on the activity.

No

PlannedStartDate

DateTime

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.

No

PlannedUnits

String

The planned units of work for the resource assignment on the activity.

No

PlannedUnitsPerTime

Double

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

No

PlannedValueCost

Double

The amount of approved capital spent on a scheduled portion of work on a project.

No

PlannedValueCostProject

Double

The amount of approved capital spent on a scheduled portion of work on a project if using project currency.

No

PricePerUnit

Double

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

No

PricePerUnitProject

Double

The price per unit of time for the resource or role if using project currency.

No

PriorActualCost

Double

The total actual costs incurred at the time of the last stored period performance. This represents the costs incurred from the last period closeout date.

No

PriorActualCostProject

Double

The total actual costs incurred at the time of the last stored period performance if using project currency.

No

PriorActualUnits

Double

The total actual units incurred at the time of the last stored period performance. This represents the total units incurred from the last period closeout date.

No

ProjectId

String

The short code that uniquely identifies the project.

No

ProjectObjectId

ForeignKey

The unique ID of the project.

No

RateSource

Enum

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

No

RateType

Enum

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.

No

RemainingCost

Double

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

No

RemainingCostProject

Double

The remaining cost for the resource assignment on the activity if using project currency.

No

RemainingCurve

String

The remaining hours for the resource assignment on the activity for a manual curve.

No

RemainingDuration

Double

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.

No

RemainingLag

Double

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

No

RemainingUnits

Double

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.

No

RemainingUnits

Double

The remaining units of work to be performed by this resource on this activity.

No

RemainingUnitsPerHour

Double

The units per time required for the resource assignment to complete the activity.

No

RemainingUnitsPerTime

Double

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

No

ResourceCurveName

String

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

Yes

ResourceCurveObjectId

ForeignKey

The unique ID of the resource curve.

No

ResourceId

String

The name that uniquely identifies the resource.

No

ResourceObjectId

ForeignKey

The unique ID of the associated resource.

No

ResourceType

Enum

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

No

RoleId

String

The short code that uniquely identifies the role.

No

RoleObjectId

ForeignKey

The unique ID of the associated role.

No

RolledupWBSObjectId

ForeignKey

Rolled up WBS key after filtering either by levels or tagging

No

StaffedRemainingCost

Double

The remaining cost for resource assignments that have a filled role.

No

StaffedRemainingCostProject

Double

The remaining cost for resource assignments that have a filled role if using project currency.

No

StartDate

DateTime

The start date for the activity assignment..

No

UnstaffedRemainingCost

Double

The remaining cost for resource assignments that do not have a filled role.

No

UnstaffedRemainingCostProject

Double

The remaining cost for resource assignments that do not have a filled role if using project currency.

No

WBSCode

String

WBSCode

No

WBSObjectId

ForeignKey

WBS key

No