P6ActivitySheet

bitemid

String

Cost Code

Yes

DailySpreadActualCost

String

The actual cost of the project for daily spread.

Yes

DailySpreadActualExpenseCost

String

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

Yes

DailySpreadActualLaborCost

String

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

No

DailySpreadActualLaborUnits

String

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

No

DailySpreadActualMaterialCost

String

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

Yes

DailySpreadActualNonLaborCost

String

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

No

DailySpreadActualNonLaborUnits

String

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

No

DailySpreadActualTotalCost

String

The actual total cost for the activity, including labor resources, nonlabor resources, and project expenses for daily spread. Calculated as Daily spread actual labor costs + daily spread actual nonlabor costs + daily spread actual expense costs.

Yes

DailySpreadAtCompletionExpenseCost

String

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

Yes

DailySpreadAtCompletionLaborCost

String

The sum of the actual plus remaining costs for all labor resources assigned to the activity for daily spread. Computed as daily spread actual labor cost + daily spread remaining labor cost.

No

DailySpreadAtCompletionLaborUnits

String

The sum of the actual plus remaining units for all labor resources assigned to the activity for daily spread. Computed as daily spread actual labor units + daily spread remaining labor units.

No

DailySpreadAtCompletionMaterialCost

String

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

Yes

DailySpreadAtCompletionNonLaborCost

String

The sum of the actual plus remaining costs for all nonlabor resources assigned to the activity for daily spread. Computed as daily spread actual nonlabor cost + daily spread remaining nonlabor cost.

No

DailySpreadAtCompletionNonLaborUnits

String

The sum of the actual plus remaining units for all nonlabor resources assigned to the activity for daily spread. Computed as daily spread actual nonlabor units + daily spread remaining nonlabor units.

No

DailySpreadAtCompletionTotalCost

String

The total cost at completion for the activity, including labor resources, nonlabor resources, and project expenses for daily spread. Calculated as (at completion labor cost + at completion nonlabor cost + at completion expense cost) for daily spread.

Yes

DailySpreadBaseline1ActualExpenseCost

String

The actual costs for all project expenses associated with the activity for Baseline 1 daily spread.

Yes

DailySpreadBaseline1ActualLaborCost

String

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

Yes

DailySpreadBaseline1ActualLaborUnits

String

The actual units for all labor resources assigned to the activity for Baseline 1 daily spread.

Yes

DailySpreadBaseline1ActualMaterialCost

String

The sum of all regular and overtime costs for material resources for Baseline 1 daily spread.

Yes

DailySpreadBaseline1ActualNonLaborCost

String

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

Yes

DailySpreadBaseline1ActualNonLaborUnits

String

The actual units for all nonlabor resources assigned to the activity for Baseline 1 daily spread.

Yes

DailySpreadBaseline1ActualTotalCost

String

The actual total cost for the activity, including labor resources, nonlabor resources, and project expenses for Baseline 1 daily spread. Calculated as (actual labor costs + actual nonlabor costs + actual expense costs) for daily spread.

Yes

DailySpreadBaseline1PlannedExpenseCost

String

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

Yes

DailySpreadBaseline1PlannedLaborCost

String

The cost at completion for all labor resources assigned to the activity in the primary baseline for daily spread. Computed from the primary baseline at completion labor units.

Yes

DailySpreadBaseline1PlannedLaborUnits

String

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

Yes

DailySpreadBaseline1PlannedMaterialCost

String

The Planned Material Cost for a primary baseline activity for daily spread.

Yes

DailySpreadBaseline1PlannedNonLaborCost

String

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

Yes

DailySpreadBaseline1PlannedNonLaborUnits

String

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

Yes

DailySpreadBaseline1PlannedTotalCost

String

The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses for Baseline 1 daily spread. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost.

Yes

DailySpreadBaselineActualExpenseCost

String

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

Yes

DailySpreadBaselineActualLaborCost

String

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

Yes

DailySpreadBaselineActualLaborUnits

String

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

Yes

DailySpreadBaselineActualMaterialCost

String

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

Yes

DailySpreadBaselineActualNonLaborCost

String

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

Yes

DailySpreadBaselineActualNonLaborUnits

String

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

Yes

DailySpreadBaselineActualTotalCost

String

The actual total cost for the activity, including labor resources, nonlabor resources, and project expenses for Baseline daily spread. Calculated as (actual labor costs + actual nonlabor costs actual expense costs) for daily spread.

Yes

DailySpreadBaselinePlannedExpenseCost

String

The planned costs for all project expenses associated with the activity for Baseline daily spread.

Yes

DailySpreadBaselinePlannedLaborCost

String

The cost at completion for all labor resources assigned to the activity in the project baseline for daily spread.

Yes

DailySpreadBaselinePlannedLaborUnits

String

The planned units for all labor resources assigned to the activity for baseline daily spread.

Yes

DailySpreadBaselinePlannedMaterialCost

String

The planned material cost for a project baseline activity for daily spread.

Yes

DailySpreadBaselinePlannedNonLaborCost

String

The planned costs for all nonlabor resources assigned to the activity for baseline daily spread.

Yes

DailySpreadBaselinePlannedNonLaborUnits

String

The planned units for all nonlabor resources assigned to the activity for baseline daily spread.

Yes

DailySpreadBaselinePlannedTotalCost

String

The planned total cost for activity, including labor resources, nonlabor resources, and project expenses for baseline daily spreads.

Yes

DailySpreadEarnedValueCost

String

The portion of the project baseline total cost of the activity that is actually completed as of the project data date for daily spread. Computed as earned value = BAC * performance % complete.

Yes

DailySpreadEarnedValueLaborUnits

String

The portion of the project baseline labor units that is actually completed as of the project data date for daily spread. Computed as labor units earned value - project baseline units * performance % complete.

Yes

DailySpreadEstimateAtCompletionCost

String

The estimated cost at completion of the activity for daily spread. Computed as the daily spread actual total cost plus the estimate-to-complete cost: EAC = ACWP + ETC.

Yes

DailySpreadEstimateAtCompletionLaborUnits

String

The estimated labor units at completion of the activity for daily spread. Calculated as actual labor units + estimate to complete labor units.

Yes

DailySpreadEstimateToCompleteCost

String

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

Yes

DailySpreadEstimateToCompleteLaborUnits

String

Field Description

Yes

DailySpreadPlannedExpenseCost

String

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

Yes

DailySpreadPlannedLaborCost

String

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

Yes

DailySpreadPlannedLaborUnits

String

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

Yes

DailySpreadPlannedMaterialCost

String

The sum of all material resource costs for daily spread.

Yes

DailySpreadPlannedNonLaborCost

String

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

Yes

DailySpreadPlannedNonLaborUnits

String

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

Yes

DailySpreadPlannedTotalCost

String

The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses for daily spread. Calculated as (planned total cost = planned labor cost + planned nonlabor cost + planned expense cost) for daily spread.

Yes

DailySpreadPlannedValueCost

String

The portion of the project baseline total cost of the activity that is scheduled to be completed as of the project data date for daily spread. Computed as BAC * schedule % complete. Also known as the work scheduled to be performed for the activity.

Yes

DailySpreadPlannedValueLaborUnits

String

The portion of the project baseline labor units that is scheduled to be completed as of the project data date for daily spread. Computed as BL labor units * schedule % complete.

Yes

DailySpreadRemainingExpenseCost

String

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

Yes

DailySpreadRemainingLaborCost

String

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

Yes

DailySpreadRemainingLaborUnits

String

The remaining units for all labor resources assigned to the activity for daily spread. The remaining units reflects the work remaining to be done for the activity.

Yes

DailySpreadRemainingLateExpenseCost

String

The remaining late expense costs for all project expenses associated with the activity for daily spread.

Yes

DailySpreadRemainingLateLaborCost

String

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

Yes

DailySpreadRemainingLateLaborUnits

String

The remaining late units for all labor resources assigned to the activity for daily spread. The remaining units reflects the work remaining to be done for the activity.

Yes

DailySpreadRemainingLateMaterialCost

String

The sum of all late material resource remaining costs for daily spread.

Yes

DailySpreadRemainingLateNonLaborCost

String

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

Yes

DailySpreadRemainingLateNonLaborUnits

String

The remaining late units for all nonlabor resources assigned to the activity for daily spread. The remaining late units reflect the work remaining to be done for the activity.

Yes

DailySpreadRemainingLateTotalCost

String

The remaining late total cost for the activity, including labor resources, nonlabor resources, and project expenses. Computed as (remaining late labor costs + remaining late nonlabor costs + remaining late expense costs) for daily spread.

Yes

DailySpreadRemainingMaterialCost

String

The sum of all material resource remaining costs for daily spread.

Yes

DailySpreadRemainingNonLaborCost

String

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

Yes

DailySpreadRemainingNonLaborUnits

String

The remaining units for all nonlabor resources assigned to the activity for daily spread. The remaining unit reflects the work remaining to be done for the activity.

Yes

DailySpreadRemainingTotalCost

String

DailySpreadRemainingTotalCost

Yes

ElementId

String

The unique identifier of the project.

No

ProjectNumber

ForeignKey

Project id

No

uuu_int_p6_project_id

String

P6 ProjectId

No

uuu_int_p6_project_id

String

Project Id

No

uuu_P6ActivityElementId

String

The unique Activity ID generated by the system.

No

uuu_P6ActivityId

String

P6 Activity id generated by system.

No

uuu_P6ActivityName

String

Activity Name

No

uuu_P6ActivityStatus

String

uuu_P6ActivityStatus

No

uuu_P6ActivityType

String

uuu_P6ActivityType

No

uuu_P6ActualDuration

Double

uuu_P6ActualDuration

No

uuu_P6ActualFinish

DateTime

uuu_P6ActualFinish

No

uuu_P6ActualStart

DateTime

uuu_P6ActualStart

No

uuu_P6ActualTotalCost

Double

uuu_P6ActualTotalCost

No

uuu_P6ActualTotalUnits

Double

Actual Total Units

Yes

uuu_P6AtCompletionDuration

Double

uuu_P6AtCompletionDuration

No

uuu_P6AtCompletionTotalCost

Double

uuu_P6AtCompletionTotalCost

No

uuu_P6AtCompletionTotalUnits

Double

At Completion Total Units

Yes

uuu_P6BAC

Double

Budget at Completion

Yes

uuu_P6CostVariance

Double

Cost Variance

Yes

uuu_P6CPIndex

Double

Cost Performance Index

Yes

uuu_P6CSIndex

Double

Cost Schedule Index

Yes

uuu_P6EACCost

Double

Estimate at Completion

Yes

uuu_P6ETC

Double

Estimate to Complete

Yes

uuu_P6ETCComputeType

String

Estimate to Complete computation technique

No

uuu_P6EVCost

Double

Earned Value Cost

Yes

uuu_P6Finish

DateTime

End date for the activity depending on the status

No

uuu_P6PercentComplete

Double

Percent Complete

No

uuu_P6PerfPercComplete

Double

Performance Percent Complete

Yes

uuu_P6PlannedDuration

Double

uuu_P6PlannedDuration

No

uuu_P6PlannedFinish

DateTime

uuu_P6PlannedFinish

No

uuu_P6PlannedStart

DateTime

uuu_P6PlannedStart

No

uuu_P6PlannedTotalCost

Double

uuu_P6PlannedTotalCost

No

uuu_P6PlannedTotalUnits

Double

Planned Total Units

Yes

uuu_P6PrimaryConstraint

String

Activity Primary Constraint type

No

uuu_P6PrimaryContraint

String

uuu_P6PrimaryContraint

No

uuu_P6PVCost

Double

Planned Value Cost

Yes

uuu_P6RemainingDuration

Double

uuu_P6RemainingDuration

No

uuu_P6RemainingEarlyFinish

DateTime

Reamining Early Finish

No

uuu_P6RemainingEarlyStart

DateTime

Remaining Early Start

No

uuu_P6RemainingTotalCost

Double

uuu_P6RemainingTotalCost

No

uuu_P6RemainingTotalUnits

Double

Remaining Total Units

Yes

uuu_P6ScheduleVariance

Double

Schedule Variance

Yes

uuu_P6SecondaryConstraint

String

Activity Secondary Constraint type

No

uuu_P6SPIndex

Double

Schedule Performance Index

Yes

uuu_P6Start

DateTime

Start date for the activity depending on the status

No

uuu_P6TCPIndex

Double

To Complete Performance Index

Yes

uuu_P6VAC

Double

Variance at Completion

Yes

uuu_P6WBSCode

String

uuu_P6WBSCode

No

uuu_P6WBSElementId

String

The unique WBS ID generated by the system.

No

uuu_P6WBSName

String

uuu_P6WBSName

No

uuu_P6WBSPath

String

The WBS path of the Activity.

No

uuu_parent_id

ForeignKey

Parent WBS Element Id

No