This project data field mapping template synchronizes Activity data from P6 to Unifier. This template is used in the Get Activities and Assignments data from P6 for EVM business flow. The following fields are mapped:
Unifier | Gateway | P6 |
|---|---|---|
bitemid | CBSCode | CBSCode |
DailySpreadPlannedTotalCost | DailySpreadPlannedTotalCost | DailySpreadPlannedTotalCost |
DailySpreadActualTotalCost | DailySpreadActualTotalCost | DailySpreadActualTotalCost |
DailySpreadAtCompletionTotalCost | DailySpreadAtCompletionTotalCost | DailySpreadAtCompletionTotalCost |
DailySpreadRemainingTotalCost | DailySpreadRemainingTotalCost | DailySpreadRemainingTotalCost |
DailySpreadEarnedValueCost | DailySpreadEarnedValueCost | DailySpreadEarnedValueCost |
DailySpreadPlannedValueCost | DailySpreadPlannedValueCost | DailySpreadPlannedValueCost |
DailySpreadEstimateToCompleteCost | DailySpreadEstimateToCompleteCost | DailySpreadEstimateToCompleteCost |
DailySpreadEstimateAtCompletionCost | DailySpreadEstimateAtCompletionCost | DailySpreadEstimateAtCompletionCost |
uuu_int_p6_project_id | ProjectId | ProjectId |
uuu_P6ActivityElementId | ActivityObjectId | ObjectId |
uuu_P6ActivityId | Id | Id |
uuu_P6ActivityName | Name | Name |
uuu_P6ActivityStatus | Status | Status |
uuu_P6ActivityType | Type | Type |
uuu_P6ActualDuration | ActualDuration | ActualDuration |
uuu_P6ActualFinish | ActualFinishDate | ActualFinishDate |
uuu_P6ActualStart | ActualStartDate | ActualStartDate |
uuu_P6ActualTotalCost | ActualTotalCost | ActualTotalCost |
uuu_P6ActualTotalUnits | ActualTotalUnits | ActualTotalUnits |
uuu_P6AtCompletionDuration | AtCompletionDuration | AtCompletionDuration |
uuu_P6AtCompletionTotalCost | AtCompletionTotalCost | AtCompletionTotalCost |
uuu_P6AtCompletionTotalUnits | AtCompletionTotalUnits | AtCompletionTotalUnits |
uuu_P6BAC | BudgetAtCompletion | BudgetAtCompletion |
uuu_P6CostVariance | CostVariance | CostVariance |
uuu_P6EACCost | EstimateAtCompletionCost | EstimateAtCompletionCost |
uuu_P6ETC | EstimateToComplete | EstimateToComplete |
uuu_P6EVCost | EarnedValueCost | EarnedValueCost |
uuu_P6PVCost | PlannedValueCost | PlannedValueCost |
uuu_P6Finish | FinishDate | FinishDate |
uuu_P6PercentComplete | PercentComplete | PercentComplete |
uuu_P6PerfPercComplete | PerformancePercentComplete | PerformancePercentComplete |
uuu_P6PlannedDuration | PlannedDuration | PlannedDuration |
uuu_P6PlannedFinish | PlannedFinishDate | PlannedFinishDate |
uuu_P6PlannedStart | PlannedStartDate | PlannedStartDate |
uuu_P6PlannedTotalCost | PlannedTotalCost | PlannedTotalCost |
uuu_P6PrimaryContraint | PrimaryConstraintType | PrimaryConstraintType |
uuu_P6RemainingEarlyFinish | RemainingEarlyFinishDate | RemainingEarlyFinishDate |
uuu_P6RemainingEarlyStart | RemainingEarlyStartDate | RemainingEarlyStartDate |
uuu_P6RemainingTotalCost | RemainingTotalCost | RemainingTotalCost |
uuu_P6RemainingTotalUnits | RemainingTotalUnits | RemainingTotalUnits |
uuu_P6ScheduleVariance | ScheduleVariance | ScheduleVariance |
uuu_P6CPIndex | CostPerformanceIndex | CostPerformanceIndex |
uuu_P6TCPIndex | ToCompletePerformanceIndex | ToCompletePerformanceIndex |
uuu_P6SPIndex | SchedulePerformanceIndex | SchedulePerformanceIndex |
uuu_P6Start | StartDate | StartDate |
uuu_P6VAC | AtCompletionVariance | AtCompletionVariance |
uuu_P6WBSCode | WBSCode | WBSCode |
uuu_P6WBSElementId | SWBSUniqueId | WBSObjectId |
uuu_P6WBSName | WBSName | WBSName |
uuu_P6WBSPath | WBSPath | WBSPath |
uuu_P6WBSUniqueId | WBSUniqueId | WBSObjectId |