The following tables show field mappings supported in each field mapping template:
Synchronize Project Actual Cost and Progress from P6 to Prime
Once the P6 project is in the execution phase, progress data such as Actual cost, schedule percent complete and dates are transferred to Prime.
P6 | Prime |
---|---|
Id | ProjectId |
Name | ProjectName |
Description | Description |
Status | Status |
OwnerResourceId | Owner |
SummaryActualStartDate | ActualStart |
SummaryActualFinishDate | ActualFinish |
SummaryActualTotalCost | ActualCost |
SummarySchedulePercentComplete | PercentComplete |
Synchronize Planned Budget and Plan Dates from P6 to Prime
This is an export project field mapping template that supports a bottom up budget process where planned budgets and dates are pulled from P6 and pushed to Prime.
P6 | Prime |
---|---|
Id | ProjectId |
Name | ProjectName |
Description | Description |
Status | Status |
OwnerResourceId | Owner |
PlannedStartDate | PlannedStartDate |
MustFinishByDate | PlannedFinishDate |
PlannedFinishDate | PlannedFinishDate |
SummaryPlannedCost | PlannedBudget |
Sync P6 Data to Prime
This is an export project field mapping template that supports projects starting in P6 then pushed to Prime. This field mapping template will create a new project in the destination application with project data such as Status, Dates, and Owner. For example, use this template for integrating cost, scope, and risk data.
P6 | Prime |
---|---|
Id | ProjectId |
Name | ProjectName |
Description | Description |
Status | Status |
OwnerResourceId | Owner |
PrimeWorkspace | PrimeWorkspace |
PlannedStartDate | PlannedStartDate |
MustFinishByDate | PlannedFinishDate |
SummaryPlannedCost | PlannedBudget |
SummaryActualTotalCost | ActualCost |
SummaryAtCompletionTotalCost | AtCompletionCost |
DataDate | DataDate |
StartDate | StartDate |
FinishDate | FinishDate |
SummaryPlannedDuration | PlannedDuration |
SummaryRemainingDuration | RemainingDuration |
LocationName | LocationName |
LocationObjectId | LocationCode |
CalculateFloatBasedOnFinishDate | CalculateFloatBasedOnFinishDate |
ComputeTotalFloatType | ComputeTotalFloatType |
CriticalActivityFloatThreshold | CriticalActivityFloatThreshold |
IgnoreOtherProjectRelationships | IgnoreOtherProjectRelationships |
MakeOpenEndedActivitiesCritical | MakeOpenEndedActivitiesCritical |
MaximumMultipleFloatPaths | MaximumMultipleFloatPaths |
MultipleFloatPathsEnabled | MultipleFloatPathsEnabled |
MultipleFloatPathsEndingActivityObjectId | MultipleFloatPathsEndingActivityObjectId |
MultipleFloatPathsUseTotalFloat | MultipleFloatPathsUseTotalFloat |
OutOfSequenceScheduleType | OutOfSequenceScheduleType |
RelationshipLagCalendar | RelationshipLagCalendar |
StartToStartLagCalculationType | StartToStartLagCalculationType |
UseExpectedFinishDates | UseExpectedFinishDates |
ActivityDefaultCalendarName | ActivityDefaultCalendarName |
ActivityDefaultCalendarObjectId | ActivityDefaultCalendarObjectId |
SummaryActualStartDate | ActualStart |
SummaryActualFinishDate | ActualFinish |
StrategicPriority | StrategicPriority |
WebsiteURL | URL |
SummaryStartDateVariance | VarianceStartDate |
SummaryFinishDateVariance | VarianceFinishDate |
NetPresentValue | NetPresentValue |
PaybackPeriod | PaybackPeriod |
ReturnOnInvestment | ReturnInvestment |
AnnualDiscountRate | AnnualDiscountRate |
SummaryPlannedValueByCost | PlannedValueCost |
SummaryEarnedValueByCost | EarnedValueCost |
SummaryScheduleVarianceByCost | ScheduleVariance |
SummaryTotalCostVariance | CostVariance |
SummarySchedulePerformanceIndexByCost | SchedulePerformanceIndex |
SummaryCostPerformanceIndexByCost | CostPerformanceIndex |
SummaryEstimateAtCompletionByCost | EstimateAtCompletionCost |
SummaryEstimateToCompleteByCost | EstimateToCompletionCost |
CriticalActivityPathType | CriticalActivityPathType |
RiskMatrixName | RiskMatrixName |
RiskMatrixObjectId | RiskMatrixCode |
SummaryRemainingTotalCost | SummaryRemainingTotalCost |
Update P6 Project with Prime Data
This is an import project field mapping template that support projects starting Primethen pushed to P6. This field mapping template will create a new project in the destination application with project data such as Status, Dates, Owner and Planned Budget.
Prime | P6 |
---|---|
ProjectId | Id |
ProjectName | Name |
Description | Description |
Status | Status |
Owner | OwnerResourceId |
PlannedStartDate | PlannedStartDate |
PlannedFinishDate | PlannedFinishDate |
PlannedBudget | PlannedBudget |
StrategicPriority | StrategicPriority |
LocationName | LocationName |
URL | WebsiteURL |
IntegratedType | IntegratedType |
ParentEPSId | ParentEPSId |
Update Activity Risk Results For P6
This is an import project field mapping template that support projects starting Primethen pushed to P6.
Prime | P6 |
---|---|
ProjectId | ProjectId |
Id | Id |
PostResponsePessimisticFinish | PostResponsePessimisticFinish |
PostResponsePessimisticStart | PostResponsePessimisticStart |
PreResponsePessimisticFinish | PreResponsePessimisticFinish |
PreResponsePessimisticStart | PreResponsePessimisticStart |
Synchronize Approved Budget and Plan Dates from Prime to P6
This is an import business flow where approved budgets are pushed from Prime to P6.
Prime | P6 |
---|---|
ProjectId | Id |
ProjectName | Name |
Description | Description |
Status | Status |
Owner | OwnerResourceId |
PlannedStartDate | PlannedStartDate |
PlannedFinishDate | PlannedFinishDate |
CurrentApprovedBudget | CurrentBudget |
Sync Proposed Budget and Plan Dates from Prime to P6
This is an import business flow that supports a top down budgeting process where proposed budgets and dates are pulled from Prime and pushed to P6.
Prime | P6 |
---|---|
ProjectId | Id |
ProjectName | Name |
Description | Description |
Status | Status |
Owner | OwnerResourceId |
PlannedStartDate | PlannedStartDate |
PlannedFinishDate | PlannedFinishDate |
ProposedBudget | ProposedBudget |
Sync Activity Data for Risk for Prime
This is an export project as well as an import project business flow supports synchronizing activity data for projects in P6 and Prime.
P6 | Prime |
---|---|
Name | Name |
ProjectId | ProjectId |
Id | Id |
CalendarName | CalendarName |
CalendarObjectId | CalendarObjectId |
CalendarObjectId | CalendarCode |
MaximumDuration | MaximumDuration |
MinimumDuration | MinimumDuration |
MostLikelyDuration | MostLikelyDuration |
PlannedDuration | PlannedDuration |
EarlyStartDate | EarlyStartDate |
ActualDuration | ActualDuration |
RemainingDuration | RemainingDuration |
SecondaryConstraintDate | SecondaryConstraintDate |
SecondaryConstraintType | SecondaryConstraintType |
Type | Type |
EarlyFinishDate | EarlyFinishDate |
StartDate | StartDate |
FinishDate | FinishDate |
LateStartDate | LateStartDate |
LateFinishDate | LateFinishDate |
ActualStartDate | ActualStartDate |
ActualFinishDate | ActualFinishDate |
PlannedStartDate | PlannedStartDate |
PlannedFinishDate | PlannedFinishDate |
PrimaryConstraintType | PrimaryConstraintType |
PrimaryConstraintDate | PrimaryConstraintDate |
Status | Status |
IsStarred | IsStarred |
RemainingEarlyStartDate | RemainingStart |
RemainingEarlyFinishDate | RemainingFinish |
RemainingLateStartDate | RemainingLateStart |
RemainingLateFinishDate | RemainingLateFinish |
SuspendDate | SuspendDate |
ResumeDate | ResumeDate |
PercentComplete | ActivityPercentComplete |
WBSCode | WBSCode |
IsWorkPackage | IsWorkPackage |
ExpectedFinishDate | ExpectedFinishDate |
DurationType | DurationType |
Sync Risk Matrix Score Data for Prime
This is an export project field mapping template which synchronizes risk matrix score data pulled from P6 and pushed to Prime.
P6 | Prime |
---|---|
RiskMatrixName | RiskMatrixName |
RiskMatrixObjectId | RiskMatrixCode |
ProbabilityThresholdLevel | ProbabilityThresholdLevel |
Severity1 | Severity1 |
Severity1Label | Severity1Label |
Severity2 | Severity2 |
Severity2Label | Severity2Label |
Severity3 | Severity3 |
Severity3Label | Severity3Label |
Severity4 | Severity4 |
Severity4Label | Severity4Label |
Severity5 | Severity5 |
Severity5Label | Severity5Label |
Severity6 | Severity6 |
Severity6Label | Severity6Label |
Severity7 | Severity7 |
Severity7Label | Severity7Label |
Severity8 | Severity8 |
Severity8Label | Severity8Label |
Severity9 | Severity9 |
Severity9Label | Severity9Label |
Sync risk response action data for Prime
This is an export project field mapping template that pulls risk response data from P6 into Prime.
P6 | Prime |
---|---|
Id | Id |
Name | Name |
RiskResponsePlanId | RiskResponsePlanId |
ActivityId | ActivityId |
StartDate | StartDate |
FinishDate | FinishDate |
PlannedStartDate | PlannedStartDate |
PlannedFinishDate | PlannedFinishDate |
RemainingCost | RemainingCost |
ActualCost | ActualCost |
PlannedCost | PlannedCost |
Status | Status |
RiskId | RiskId |
ProjectId | ProjectId |
Prime Project Planned Total Cost Spread from P6
This is an export project field mapping template that pulls planned total cost data from P6 to Prime.
P6 | Prime |
---|---|
PeriodType | PeriodType |
StartDate | StartDate |
EndDate | EndDate |
PlannedTotalCost | PlannedTotalCost |
Prime Project Actual Total Cost Spread from P6
This is an export project data field mapping template that pulls actual total cost data from P6 to Prime.
P6 | Prime |
---|---|
PeriodType | PeriodType |
StartDate | StartDate |
EndDate | EndDate |
ActualTotalCost | ActualTotalCost |
Prime Project At Completion Total Cost Spread from P6
This is an export project data field mapping template that pulls the At completion total cost data from P6 to Prime.
P6 | Prime |
---|---|
PeriodType | PeriodType |
StartDate | StartDate |
EndDate | EndDate |
AtCompletionTotalCost | AtCompletionTotalCost |
Sync Risk Data for Prime
This is an export project data field mapping template that pulls the Response total cost data from P6 to Prime.
P6 | Prime |
---|---|
Id | Id |
ProjectId | ProjectId |
Name | Name |
Type | Type |
Status | Status |
Description | Description |
Effect | Effect |
Cause | Cause |
Identified Date | IdentifiedDate |
ResponseTotalCost | ResponseTotalCost |
Sync Activity Data for Risk for Prime
This is an export project data field mapping template that synchronizes activity risk data between P6 and Prime.
P6 | Prime |
---|---|
Name | Name |
ProjectId | ProjectId |
Id | Id |
CalendarName | CalendarName |
CalendarObjectId | CalendarObjectId |
CalendarObjectId | CalendarCode |
MaximumDuration | MaximumDuration |
MinimumDuration | MinimumDuration |
MostLikelyDuration | MostLikelyDuration |
PlannedDuration | PlannedDuration |
EarlyStartDate | EarlyStartDate |
ActualDuration | ActualDuration |
RemainingDuration | RemainingDuration |
SecondaryConstraintDate | SecondaryConstraintDate |
SecondaryConstraintType | SecondaryConstraintType |
Type | Type |
EarlyFinishDate | EarlyFinishDate |
StartDate | StartDate |
FinishDate | FinishDate |
LateStartDate | LateStartDate |
LateFinishDate | LateFinishDate |
ActualStartDate | ActualStartDate |
ActualFinishDate | ActualFinishDate |
PlannedStartDate | PlannedStartDate |
PlannedFinishDate | PlannedFinishDate |
PrimaryConstraintType | PrimaryConstraintType |
PrimaryConstraintDate | PrimaryConstraintDate |
Status | Status |
IsStarred | IsStarred |
RemainingEarlyStartDate | RemainingStart |
RemainingEarlyFinishDate | RemainingFinish |
RemainingLateStartDate | RemainingLateStart |
RemainingLateFinishDate | RemainingLateFinish |
SuspendDate | SuspendDate |
ResumeDate | ResumeDate |
PercentComplete | ActivityPercentComplete |
WBSCode | WBSCode |
IsWorkPackage | IsWorkPackage |
ExpectedFinishDate | ExpectedFinishDate |
DurationType | DurationType |
P6 Location to Prime
This is an export master data field mapping template which synchronizes location data from P6 to Prime.
P6 | Prime |
---|---|
Name | LocationName |
ObjectId | LocationCode |
AddressLine1 | AddressLine1 |
AddressLine2 | AddressLine2 |
City | CityName |
CountryCode | CountryCode |
Latitude | Latitude |
Longitude | Longitude |
Municipality | MunicipalityName |
PostalCode | PostalCode |
State | StateName |
StateCode | StateCode |
Synchronize UDF Fields From P6
This is an export master data field mapping template which synchronizes UDF fields from P6 to Prime.
P6 | Prime |
---|---|
DataType | DataType |
Title | Title |
SubjectArea | SubjectArea |
Sync Calendar Data for Prime
This is an export project data field mapping template which synchronizes Calendar data from P6 to Prime.
P6 | Prime |
---|---|
Name | Name |
ObjectId | Code |
Type | Type |
IsPersonal | IsPersonal |
StarndardWorkWeek | StarndardWorkWeek |
HolidayOrExceptions | HolidayOrExceptions |
Sync Relationship Data for Prime
This is an export project data field mapping template which synchronizes relationship data from P6 to Prime.
P6 | Prime |
---|---|
Type | Type |
Lag | Lag |
PredecessorActivityId | PredecessorActivityId |
PredecessorActivityType | PredecessorActivityType |
PredecessorProjectID | PredecessorProjectID |
SuccessorActivityId | SuccessorActivityId |
SuccessorActivityType | SuccessorActivityType |
SuccessorProjectID | SuccecssorProjectID |
Sync Risk Threshold Level Data for Prime
This is an export project data field mapping template which synchronizes risk threshold level data from P6 to Prime.
P6 | Prime |
---|---|
Name | Name |
Code | Code |
RiskThresholdName | RiskThresholdName |
RiskThresholdObjectId | RiskThresholdCode |
Color | Color |
Level | Level |
Range | Range |
CostRange | CostRange |
ScheduleRange | ScheduleRange |
ToleranceRange | ToleranceRange |
ProbabiliityRange | ProbabiliityRange |
ThresholdType | ThresholdType |
Sync Risk Threshold Data for Prime
This is an export project data field mapping template which synchronizes risk threshold data from P6 to Prime.
P6 | Prime |
---|---|
Name | Name |
Code | Code |
ThresholdType | ThresholdType |
Sync Risk Impact Data for Prime
This is an export project data field mapping template which synchronizes risk impact data from P6 to Prime.
P6 | Prime |
---|---|
ProjectId | ProjectId |
RiskId | RiskId |
RiskThresholdName | RiskThresholdName |
RiskThresholdObjectId | RiskThresholdCode |
RiskThresholdLevelCode | RiskThresholdLevelCode |
Sync Risk Matrix Data for Prime
This is an export project data field mapping template which synchronizes risk matrix data from P6 to Prime.
P6 | Prime |
---|---|
Name | Name |
Code | Code |
Description | Description |
RiskScoringMethod | ImpactThresholdLevel |
ImpactThresholdLevel | ImpactThresholdLevel |
ProbabilityThresholdLevel | ProbabilityThresholdLevel |
Sync Risk Matrix Threshold Data for Prime
This is an export project data field mapping template which synchronizes risk matrix threshold data from P6 to Prime.
P6 | Prime |
---|---|
RiskMatrixName | RiskMatrixName |
RiskMatrixObjectId | RiskMatrixCode |
RiskThresholdName | RiskThresholdName |
RiskThresholdObjectId | RiskThresholdCode |
Sync Risk Response Plan Data for Prime
This is an export project data field mapping template which synchronizes risk response plan data from P6 to Prime.
P6 | Prime |
---|---|
Id | Id |
Name | Name |
ProjectId | ProjectId |
RiskId | RiskId |
IsActive | IsActive |
ResponseType | ResponseType |
Sync Risk Response Action Impact Data for Prime
This is an export project data field mapping template which synchronizes risk response action impact data from P6 to Prime.
P6 | Prime |
---|---|
RiskResponseActionId | RiskResponseActionId |
RiskThresholdName | RiskThresholdName |
RiskThresholdObjectId | RiskThresholdLevelCode |
RiskThresholdLevelCode | RiskThresholdLevelCode |
RiskId | RiskId |
ProjectId | ProjectId |
Sync Risk Response Action Data for Prime
This is an export project data field mapping template which synchronizes risk response action data from P6 to Prime.
P6 | Prime |
---|---|
Id | Id |
Name | Name |
RiskResponsePlanId | RiskResponsePlanId |
ActivityId | ActivityId |
StartDate | StartDate |
FinishDate | FinishDate |
PlannedStartDate | PlannedStartDate |
PlannedFinishDate | PlannedFinishDate |
RemainingCost | RemainingCost |
ActualCost | ActualCost |
PlannedCost | PlannedCost |
Status | Status |
RiskId | RiskId |
ProjectId | ProjectId |
Sync Activity Risk Assignment Data for Prime
This is an export project data field mapping template which synchronizes activity risk assignment data from P6 to Prime.
P6 | Prime |
---|---|
RiskId | RiskId |
ActivityId | ActivityId |
ProjectId | ProjectId |
Sync Workspaces to Prime Workspace Code
This is an import master data field mapping template hich synchronizes workspace location codes from Prime in P6.
P6 | Prime |
---|---|
CodeTypeName | CodeTypeName |
CodeValue | CodeValue |
Description | Description |
SequenceNumber | SequenceNumber |
Create ProjectCode Type Fields in P6
This is an import master data field mapping template hich synchronizes project code types from Prime in P6.
Prime | P6 |
---|---|
Name | Name |
Length | Length |
Sync WBS Structure For P6
This is an import project data field mapping template which synchronizes the WBS structure from Prime in P6.
P6 | Prime |
---|---|
Code | Code |
Name | Name |
ProjectId | ProjectId |
IsWorkPackage | IsWorkPackage |
SequenceNumber | SequenceNumber |
Sync EPS to EPS Code
This is an export master data field mapping template which synchronizes EPS codes from P6 in Prime.
P6 | Prime |
---|---|
Name | Name |
Id | Id |
SequenceNumber | SequenceNumber |
Configuring the Primavera Gateway User Interface
Configuring Primavera Gateway Settings
Adding an Application Deployment Connection
Supported Field Mapping Templates for Capital Plan Management
Legal Notices
Copyright © 2014, 2015,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 25, 2015