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
- To ensure that the WBS order in MSP is same as that of Primavera Cloud after importing a Primavera Cloud project into MSP, follow the steps outlined in the My Oracle Support article (Doc ID 2913326.1)
Last Published Wednesday, October 16, 2024