Import MSP Project Data to Primavera Cloud Field Mappings

The following tables list the field mappings for the Import MSP Project Data to Primavera Cloud business flow. Use this business flow to import Microsoft Project data to create or update a project in Primavera Cloud.

The tables identify the Microsoft Project fields that supply data to Primavera Cloud fields. Some imported values are translated, calculated, or determined from a combination of Microsoft Project settings rather than copied directly from a single field. For information about these import rules, see Understanding Microsoft Project XML Import Mapping Behavior.

Activity Fields

Primavera Cloud Field Name

MSP Field Name

activityCode

ID

activityName

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

remainingDuration

RemainingDuration

remainingLaborUnits

RemainingWork

startDate

Start

unitsPercentComplete

PercentWorkComplete

wbsCode

WBS

wbsID

SummaryTaskObjectID

Activity Code Fields

Primavera Cloud Field Name

MSP Field Name

codeTypeId

CodeTypeObjectId

codeValueCode

CodeValue

codeValueName

CodeValue

parentId

ParentObjectId

Activity Code Type Fields

Primavera Cloud Field Name

MSP Field Name

codeTypeCode

Name

codeTypeName

Name

projectId

ProjectObjectId

scope

Scope

Calendar Fields

Primavera Cloud Field Name

MSP Field Name

calendarCode

Name

calendarExceptions

HolidayOrExceptions

calendarName

Name

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

CalendarUID

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

actualStartDate

ActualStart

actualUnits

ActualWork

assignmentCode

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

resourceId

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

UnitOfMeasure

UnitOfMeasure

Key

MaterialLabel

WBS Fields

Primavera Cloud Field Name

MSP Field Name

parentId

ParentObjectId

projectId

ProjectObjectId

sequenceNumber

SequenceNumber

wbsCode

WBS

wbsName

Name