Export Primavera Cloud Project Data to MSP Field Mappings

The following table lists field mappings for the Export Primavera Cloud Project Data to MSP business flow. Use this business flow to export project data from Primavera Cloud to Microsoft Project.

Activity Fields

Primavera Cloud Field Name

MSP Field Name

activityCode

ID

actvityName

Name

activityPriority

Priority

activityStatus

Status

activityType

Type

actualDuration

ActualDuration

actualFinishDate

ActualFinish

actualLaborUnits

ActualWork

actualStartDate

ActualStart

atCompletionLaborUnits

Work

calendarCode

CalendarCode

calendarId

CalendarUID

constraintDate

ConstraintDate

constraintType

ConstraintType

durationPercentComplete

PercentComplete

durationType

DurationType

earlyFinishDate

EarlyFinish

earlyStartDate

EarlyStart

expectedFinishDate

Deadline

finishDate

Finish

lateFinishDate

LateFinish

lateStartDate

LateStart

percentCompleteType

PercentCompleteType

physicalPercentComplete

PhysicalPercentComplete

plannedDuration

Duration

plannedFinishDate

Finish

plannedStartDate

Start

projectCode

ProjectId

projectId

ProjectObjectId

remainingDuratioin

RemainingDuration

remainingLaborUnits

RemainingWork

startDate

Start

unitsPercentComplete

PerecentWorkComplete

wbsCode

WBS

wbsID

SummaryTaskObjectID

Activity Code Fields

Primavera Cloud Field Name

MSP Field Name

codeTypeId

CodeTypeObjectId

codeValueCode

CodeValue

parentId

ParentObjectId

Activity Code Type Fields

Primavera Cloud Field Name

MSP Field Name

codeTypeCode

Name

projectId

ProjectObjectId

Calendar Fields

Primavera Cloud Field Name

MSP Field Name

caldendarCode

Name

calendarExceptions

HolidayOrExceptions

dayHourCount

HoursPerDay

monthHourCount

HoursPerMonth

standardWorkWeek

StandardWorkWeek

weekHourCount

HoursPerWeek

yearHourCount

HoursPerYear

Project Fields

Primavera Cloud Field Name

MSP Field Name

calendarId

CalendarUID

dataDate

StatusDate

finishDate

FinishDate

planEndDate

FinishDate

planStartDate

StartDate

projectCode

Name

projectDefaultDurationType

DefaultTaskType

projectName

Name

startDate

StartDate

Relationship Fields

Primavera Cloud Field Name

MSP Field Name

lagHours

Lag

predActivityCode

PredecessorTaskId

predActivityId

PredecessorTaskObjectId

relationshipType

Type

succActivityCode

SuccessorTaskId

succActivityId

SuccessorTaskObjectId

Resource Fields

Primavera Cloud Field Name

MSP Field Name

calendarCode

CalendarUID

calendarId

CalendarCode

emailAddress

EmailAddress

isActive

IsActive

parentId

ParentObjectId

resourceCode

Name

resourceName

Name

resourceType

Type

unitOfMeasureId

UOMObjectId

Resource Assignment Fields

Primavera Cloud Field Name

MSP Field Name

activityid

TaskObjectId

activityType

TaskType

actualFinishDate

ActualFinish

actucalStartDate

ActualStart

actualUnits

ActualWork

assignmenntCode

ObjectId

atCompletionUnits

Work

curveName

WorkContour

finishDate

Finish

plannedFinishDate

Finish

plannedLag

Delay

plannedStartDate

Start

plannedUnits

BudgetWork

plannedUnitsPerHour

Units

projectCode

ProjectId

remainingUnits

RemainingWork

remainingUnitsPerHour

RemainingUnitsPerHour

resourceCode

ResourceId

resoourceId

ResourceObjectId

startDate

Start

Resource Code Fields

Primavera Cloud Field Name

MSP Field Name

codeTypeId

CodeTypeObjectId

codeValueCode

CodeValue

codeValueName

CodeValue

parentId

ParentObjectId

Resource Code Type Fields

Primavera Cloud Field Name

MSP Field Name

codeTypeCode

Name

codeTypeName

Name

Resource Rate Fields

Primavera Cloud Field Name

MSP Field Name

effectiveStartDate

RatesFrom

maxUnitsPerTime

MaxUnits

pricePerUnit1

StandardRate

pricePerUnit2

OvertimeRate

resourceID

ResourceObjectId

Unit Of Measure Fields

Primavera Cloud Field Name

MSP Field Name

Key

MaterialLabel

WBS Fields

Primavera Cloud Field Name

MSP Field Name

parentId

ParentObjectId

projectId

ProjectObjectId

sequenceNumber

SequenceNumber

wbsCode

WBS

wbsName

Name

Note: The cost configured fields always export to MSP in Primavera Cloud project currency. You can append project at the end of cost configured field names to make them similar to the regular cost field names.

Tips