Supported Field Mapping Templates for All Prime Data

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

Related Topics

Configuring the Primavera Gateway User Interface

Configuring Primavera Gateway Settings

Adding an Application Deployment Connection

Supported Business Flows

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