This project data field-mapping template supports projects starting in P6 then pushed to Primavera Cloud. This field mapping template creates a new project in the destination application with project data such as Status, Dates, and Owner.
The following fields are mapped in the template for each Project business object:
Primavera Cloud | Gateway | P6 |
|---|---|---|
projectName | Name | ProjectName |
description | Description | Description |
status | Status | Status |
manager | Owner | OwnerResourceId |
primaveraWorkspace | PrimaveraWorkspace | PrimaveraWorkspace |
planStartDate | PlannedStartDate | PlannedStartDate |
mustFinishByDate | MustFinishByDate | MustFinishByDate |
plannedBudget | PlannedBudget | SummaryPlannedCost |
actualCost | ActualCost | SummaryActualTotalCost |
atCompletionCost | AtCompletionCost | SummaryAtCompletionTotalCost |
dataDate | DataDate | DataDate |
startDate | StartDate | StartDate |
finishDate | FinishDate | FinishDate |
PlanDuration | PlannedDuration | SummaryPlannedDuration |
remainingDuration | RemainingDuration | SummaryRemainingDuration |
locationName | LocationName | LocationName |
LocationObjectId | LocationCode | LocationCode |
calculateFloatBasedOnFinishDate | CalculateFloatBasedOnFinishDate | CalculateFloatBasedOnFinishDate |
computeTotalFloatType | ComputeTotalFloatType | ComputeTotalFloatType |
criticalDuration | CriticalActivityFloatThreshold | CriticalActivityFloatThreshold |
ignoreOtherProjectRelationships | IgnoreOtherProjectRelationships | IgnoreOtherProjectRelationships |
makeOpenEndedActivitiesCritical | MakeOpenEndedActivitiesCritical | MakeOpenEndedActivitiesCritical |
multipleFloatPathsEndingActivityObjectId | MultipleFloatPathsEndingActivityObjectId | MultipleFloatPathsEndingActivityObjectId |
outOfSequenceScheduleType | OutOfSequenceScheduleType | OutOfSequenceScheduleType |
relationshipLagCalendar | RelationshipLagCalendar | RelationshipLagCalendar |
startToStartLagCalculationType | StartToStartLagCalculationType | StartToStartLagCalculationType |
useExpectedFinishDates | UseExpectedFinishDates | UseExpectedFinishDates |
actualStartDate | ActualStartDate | SummaryActualStartDate |
actualFinishDate | ActualFinishDate | SummaryActualFinishDate |
strgyPriorityNum | StrategicPriority | StrategicPriority |
websiteURL | URL | URL |
startDateVariance | VarianceStartDate | SummaryStartDateVariance |
finishDateVariance | VarianceFinishDate | SummaryFinishDateVariance |
netPresentValue | NetPresentValue | NetPresentValue |
paybackPeriod | PaybackPeriod | PaybackPeriod |
returnInvestment | ReturnInvestment | ReturnOnInvestment |
annualDiscountRate | AnnualDiscountRate | AnnualDiscountRate |
plannedValueCost | PlannedValueCost | SummaryPlannedValueByCost |
earnedValueCost | EarnedValueCost | SummaryEarnedValueByCost |
scheduleCostVariance | ScheduleVariance | SummaryScheduleVarianceByCost |
costVariance | CostVariance | SummaryTotalCostVariance |
schedPerfIndex | SchedulePerformanceIndex | SummarySchedulePerformanceIndexByCost |
costPerfIndex | CostPerformanceIndex | SummaryCostPerformanceIndexByCost |
estAtCompleteCost | EstimateAtCompletionCost | SummaryEstimateAtCompletionByCost |
estToCompleteCost | EstimateToCompleteCost | SummaryEstimateToCompleteByCost |
criticalActivityPathType | CriticalActivityPathType | CriticalActivityPathType |
riskMatrixName | RiskMatrixName | RiskMatrixName |
projectCode | Id | Id |
criticalActivityFloatThreshold | CriticalActivityFloatThreshold | CriticalActivityFloatThreshold |
calendarId | ActivityDefaultCalendarObjectId | ActivityDefaultCalendarObjectId |