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 existing Microsoft Project data to create or update a project in Primavera Cloud.

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	SummaryTaskkObjectID

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
caldendarCode	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
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
UnitOfMeasure	UnitOfMeasure
Key	MaterialLabel

WBS Fields

Primavera Cloud Field Name	MSP Field Name
parentId	ParentObjectId
projectId	ProjectObjectId
sequenceNumber	SequenceNumber
wbsCode	WBS
wbsName	Name

Next: P6 EPPM Default Business Flow Reference