P6 EPPM Field | P6 EPPM Table Field | P6 EPPM Table | MPX Field | MPX Field ID |
|---|---|---|---|---|
n/a | auto incremented value | n/a | ID | 90 |
Unique ID | auto incremented value | TASK | Unique ID | 98 |
Activity Name | task_name | TASK | Name | 1 |
WBS Code | wbs_short_name | PROJWBS | WBS | 2 |
n/a | calculated on export | n/a | Outline Level | 3 |
Primary Constraint See constraint sub-table. | cstr_type | TASK | Constraint Type | 91 |
Primary Constraint Date | cstr_date | TASK | Constraint Date | 68 |
Activity Leveling Priority See activity leveling priority sub-table. | priority_type | TASK | Priority | 95 |
Activity Type | task_type | TASK | Milestone = Yes | 81 |
n/a | Yes = WBS levels | n/a | Summary | 120 |
n/a | Yes = WBS levels | n/a | Rollup | 84 |
At Completion Duration | total_drtn_hr_cnt | TASK | Duration | 40 |
Planned Duration (P6 EPPM) | target_drtn_hr_cnt | TASK | Baseline Duration | 41 |
Actual Duration | act_drtn_hr_cnt | TASK | Actual Duration | 42 |
Remaining Duration | remain_drtn_hr_cnt | TASK | Remaining Duration | 43 |
Duration Type See duration type sub-table. | duration_type | TASK | Fixed | 80 |
Predecessors | n/a | TASKPRED | Predecessors | 70 |
Start | start_date | TASK | Start | 50 |
Finish | end_date | TASK | Finish | 51 |
Early Start | early_start_date | TASK | Early Start (Calculated by P6 EPPM.) | 52 |
Early Finish | early_end_date | TASK | Early Finish (Calculated by P6 EPPM.) | 53 |
Late Start | late_start_date | TASK | Late Start (Calculated by P6 EPPM.) | 54 |
Late Finish | late_end_date | TASK | Late Finish (Calculated by P6 EPPM.) | 55 |
n/a | defaults to 0 | n/a | Delay | 92 |
Free Float | free_float_hr_cnt | TASK | Free Slack (Calculated by P6 EPPM.) | 93 |
Total Float | total_float_hr_cnt | TASK | Total Slack (Calculated by P6 EPPM.) | 94 |
Duration % Complete | drtn_complete_pct | TASK | %Complete (Calculated by P6 EPPM.) | 44 |
Planned Start | target_start_date | TASK | Baseline Start | 56 |
Planned Finish | target_end_date | TASK | Baseline Finish | 57 |
Actual Start | act_start_date | TASK | Actual Start | 58 |
Actual Finish | act_end_date | TASK | Actual Finish | 59 |
At Completion Labor Units | total_work_qty | TASK | Work | 20 |
Planned Labor Units (P6 EPPM) Budgeted Labor Units or Planned Labor Units (P6 Professional) | target_work_qty | TASK | Baseline Work | 21 |
Actual Labor Units | act_work_qty | TASK | Actual Work | 22 |
Estimate At Completion Cost (actual cost + estimate to complete cost) | EAC | TASK | Cost | 30 |
At Completion Expense Cost | total_expense_cost | TASK | Fixed Cost | 35 |
Budget At Completion (planned labor cost + planned nonlabor cost + planned expense cost in P6 EPPM) (budgeted or planned labor cost + budgeted or planned nonlabor cost + budgeted or planned expense cost in P6 Professional) | BAC | TASK | Baseline Cost | 31 |
Actual Cost (actual labor cost + actual nonlabor cost + actual expense cost) | ACWP | TASK | Actual Cost | 32 |
Estimate to Complete (Remaining labor cost + remaining nonlabor cost + remaining expense cost) | ETC | TASK | Remaining Cost | 33 |
User Defined Field Title | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | Text1-Text10 | 4-13 |
User Defined Field Title | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | Cost-Cost3 | 36-38 |
User Defined Field Title | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | Duration1-Duartion3 | 46-48 |
User Defined Field Title | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | Start1-Start5 | 60, 62, 64, 126, 128 |
User Defined Field Title | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | Finish1-Finish5 | 61, 63, 65, 127, 129 |
User Defined Field Title | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | Flag1-Flag10 | 110-119 |
User Defined Field Title | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | Number1-Number5 | 140-144 |
Constraint Sub-table
P6 EPPM Field | MPX Field |
|---|---|
As late as possible | As late as possible |
Finish on | Must finish on |
Finish on or after | Finish no earlier than |
Finish on or before | Finish no later than |
Mandatory finish | Must finish on |
Mandatory start | Must start on |
Start on | Must start on |
Start on or after | Start no earlier than |
Start on or before | Start no later than |
Activities without constraints | As soon as possible |
Activity Leveling Priority Sub-table
P6 EPPM Field | MPX Field |
|---|---|
5-Lowest (exports as 100) | Lowest (0-199) |
4-Low (exports as 300) | Lower (300-399) |
3-Normal (exports as 500) | Medium (500-599) |
2-High (exports as 700) | Higher (700-799) |
1-Top (exports as 900) | Highest (900-999) |
Duration Type Sub-table
Fixed = Yes | Fixed = No |
|---|---|
Fixed Duration and Units | Fixed Units |
Fixed Duration and Units/Time | Fixed Units/Time |