MPX Field ID | MPX Field | P6 EPPM Table Field | P6 EPPM Table | P6 EPPM Field | |
|---|---|---|---|---|---|
90 | ID | auto incremented value | n/a | Activity ID | |
1 | Name | task_name | TASK | Activity Name | |
2 | WBS | wbs_short_name | PROJWBS | WBS Code | |
3 | Outline Level | builds the WBS structure | n/a | n/a | |
91 | Constraint Type See constraint sub-table. | cstr_type | TASK | Primary Constraint | |
68 | Constraint Date | cstr_date | TASK | Primary Constraint Date | |
95 | Priority See priority sub-table. | priority_type | TASK | Activity Leveling Priority | |
81 | Milestone=Yes | task_type | TASK | Activity Type | |
120 | Summary | Yes=WBS levels | n/a | n/a | |
84 | Rollup | Yes=WBS levels | n/a | n/a | |
40 | Duration | total_drtn_hr_cnt | TASK | At Completion Duration | |
41 | Baseline Duration | target_drtn_hr_cnt | TASK | Planned Duration (P6 EPPM) Budgeted Duration or Planned Duration (P6 Professional) | |
43 | Remaining Duration | remain_drtn_hr_cnt | TASK | Remaining Duration | |
80 | Fixed See fixed sub-table. | duration_type | TASK | Duration Type | |
70 | Predecessors | n/a | TASKPRED | Predecessors | |
50 | Start | start_date | TASK | Start | |
51 | Finish | end_date | TASK | Finish | |
56 | Baseline Start | target_start_date | TASK | Planned Start | |
57 | Baseline Finish | target_end_date | TASK | Planned Finish | |
58 | Actual Start | act_start_date | TASK | Actual Start | |
59 | Actual Finish | act_end_date | TASK | Actual Finish | |
20 | Work | total_work_qty | TASK | At Completion Labor Units | |
21 | Baseline Work | target_work_qty | TASK | Planned Labor Units (P6 EPPM) Budgeted Labor Units or Planned Labor Units (P6 Professional) | |
22 | Actual Work | act_work_qty | TASK | Actual Labor Units | |
30 | Cost | EAC | TASK | Estimate At Completion Cost (actual cost + estimate to complete cost) | |
35 | Fixed Cost | total_expense_cost | TASK | At Completion Expense Cost | |
31 | Baseline Cost | BAC | TASK | 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) | |
32 | Actual Cost | ACWP | TASK | Actual Cost (actual labor+nonlabor+expense cost) | |
33 | Remaining Cost | ETC | TASK | Estimate to Complete (remaining labor cost + nonlabor cost + expense cost) | |
4-13 | Text1-Text10 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title | |
36-38 | Cost1-Cost3 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title | |
46-48 | Duration1-Duration3 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title | |
60, 62, 64, 126, 128 | Start1-Start5 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title | |
61, 63, 65, 127, 129 | Finish1-Finish5 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title | |
110-119 | Flag1-Flat10 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title | |
140-144 | Number1-Number5 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title | |
Constraint Type Sub-table
MPX Field | P6 EPPM Field |
|---|---|
As late as possible | As late as possible |
As soon as possible | n/a |
Finish no earlier than | Finish on or after |
Finish no later than | Finish on or before |
Must finish on | Mandatory finish |
Must start on | Mandatory start |
Start no earlier than | Start on or after |
Start no later than | Start on or before |
Priority Sub-table
MPX Field | P6 EPPM Field |
|---|---|
Lowest (0-199) | 5-Lowest |
Very Low (200-299) | 5-Lowest |
Lower (300-399) | 4-Low |
Low (400-499) | 4-Low |
Medium (500-599) | 3-Normal |
High (600-699) | 3-Normal |
Higher (700-799) | 2-High |
Very High (800-899) | 2-High |
Highest (900-999) | 1-Top |
Do not level (1000) | 1-Top |
Fixed Sub-table
Fixed=Yes | Fixed=No |
|---|---|
Fixed Duration and Units | Fixed Units |