Primavera P6 to PM Compass Field Mapping

This topic lists the Primavera P6 source fields to PM Compass field names. In addition to the fields listed in this topic, all fields added in User-Defined Data are also loaded.

See Configure PM Compass for Primavera P6 Integration for more information.

Activity Table

Primavera P6 Field

PM Compass Field

Comments

% Complete

% Complete

 

Activity Calendar

Calendar

 

Activity ID

Activity ID

 

Activity Scheduling Priority

Priority

 

Activity Name

Activity Description

 

Activity Type

Activity Type

 

Baseline 1 Finish

Baseline Finish

 

Baseline 1 Start

Baseline Start

 

Early Finish

Early Finish

 

Early Start

Early Start

 

Finish

Scheduled Finish

Only set when resource assignments are included.

Finished Date

Actual Finish

 

Free Float

Free Float

 

Late Finish

Late Finish

 

Late Start

Late Start

 

Original Duration

Duration

Expressed in the units defined in the Schedule Duration Unit field on the Progress tab.

Physical % Complete

Physical % Complete

If an activity has at least 1 step, the calculation for Physical % Complete uses the following calculation:

Sum(step weight * Step %)/sum (step weight)

If the activity has no steps, the Physical % Complete on the activity is updated if you update the Physical % Complete on the resource assignments.

The numerous Unit and Cost Percent Complete fields are automatically calculated by Primavera P6 when the Resource Assignment Physical % Complete or the Remaining Units are updated.

Primary Constraint/Date

Target Start/Date

 

Remaining Duration

Remaining Duration

This is calculated based on the selected progress type. If you select a progress type of percent complete, the value entered is multiplied by the Planned Duration to determine remaining duration.  If the progress type is elapsed duration, the remaining duration is calculated using original duration – elapsed duration. If the result is 0 or less for an in-progress activity, the calculated percent complete is used.

When Remaining Duration is updated, Primavera P6 automatically calculates the Activity % Complete, Duration % Complete, and Performance % Complete fields.

If the progress type is % Complete, the progress value returned is the Duration % Complete.

Secondary Constraint/Date

Target Finish/Date

 

Start

Scheduled Start

Only set when the project contains resource assignments.

Started Date

Actual Start

 

Total Float

Total Float

 

Critical

Critical Flag

 

WBS

Code 1

The Work Breakdown Structure in P6 is automatically mapped to the Code 1 field in PM Compass.

Progress

Instead of using different fields, PM Compass has a progress type that indicates how the work that has been accomplished is measured for the activity. The Progress Type field is on the Enter Schedule Progress form.

The table below displays the Primavera P6 fields that are updated for the different progress types.

Progress Type

Primavera P6 Field Updated

Comments

Remaining Duration

Remaining Duration

 

Percent Complete

Duration % Complete

PM Compass calculates the Percent Complete based on the activity duration (Original Duration minus Time Now).

Elapsed Duration

Actual Duration

 

Complete

Start and Finish dates set as actual start/finish dates.

 

As Planned

Duration % Complete

When you select this progress type, PM Compass assumes that the activity is progressing as originally planned and calculates the Percent Complete based on the activity duration (Original Duration minus Time Now). After the integration is performed, the progress type changes to Percent Complete and a percentage is added to the Progress Value column.

Assignment Table

Primavera P6 Field

PM Compass Field

Comments

Budgeted Units

Budget

 

Remaining Units

Remaining Quantity

The numerous Unit and Cost Percent Complete fields are automatically calculated by Primavera P6 when the Resource Assignment Physical % Complete or the Remaining Units are updated.

Resource ID

Resource ID

 

Resource Name

Resource Description

 

Units % Complete

Physical % Complete

 

Steps Table

Primavera P6 Field

PM Compass Field

Comments

Step Name

Step Name

 

Step Weight

Step Weight

 

Step Weight %

Step Weight %

 

Step % Complete

Step % Complete

 

Completed

Completed

 


Learn more about...