Microsoft Project Field | P6 EPPM Table Field | P6 EPPM Table | P6 EPPM Field |
|---|---|---|---|
ID | auto-increment or Microsoft Project ID | TASK | Activity ID |
Name | task_name | TASK | Activity Name |
WBS | wbs_short_name | PROJWBS | WBS Code |
Outline Level | builds the WBS structure | n/a | n/a |
Constraint Type See constraint type sub-table. | cstr_type | TASK | Primary Constraint |
Constraint Date | cstr_date | TASK | Primary Constraint Date |
Priority See activity leveling priority sub-table. | priority_type | TASK | Activity Leveling Priority |
Task or Milestone See activity type sub-table. | task_type | TASK | Activity Type |
Duration | total_drtn_hr_cnt | TASK | At Completion Duration |
Baseline Duration | target_drtn_hr_cnt | TASK | Planned Duration (P6 EPPM) Original Duration or Planned Duration (P6 Professional) |
Actual Duration | act_drtn_hr_cnt | TASK | Actual Duration |
Remaining Duration | remain_drtn_hr_cnt | TASK | Remaining Duration |
Task Type See duration type sub-table. | duration_type | TASK | Duration Type |
Predecessors | n/a | TASKPRED | Predecessors |
Start | start_date | TASK | Start |
Finish | end_date | TASK | Finish |
Early Start | early_start_date | TASK | Early Start |
Early Finish | early_end_date | TASK | Early Finsih |
Late Start | late_start_date | TASK | Late Start |
Late Finish | late_end_date | TASK | Late Finish |
Baseline Start | target_start_date | TASK | Planned Start |
Baseline Finish | target_end_date | TASK | Planned Finish |
Actual Start | act_start_date | TASK | Actual Start |
Actual Finish | act_end_date | TASK | Actual Finish |
Work | total_work_qty | TASK | At Completion Labor Units |
Baseline Work | target_work_qty | TASK | Planned Labor Units (P6 EPPM) Budgeted Labor Units or Planned Labor Units (P6 Professional) |
Actual Work | act_work_qty | TASK | Actual Labor Units |
Cost | EAC | TASK | Estimate At Completion Cost |
Fixed Cost | total_expense_cost | TASK | At Completion Expense Cost |
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) |
Actual Cost | ACWP | TASK | Actual Cost (actual labor, nonlabor, and expense cost) |
Fixed Cost Accrual See accrual type sub-table | cost_load_type | PROJCOST | Accrual Type |
Task Calendar | clndr_id (foreign key) | TASK | Activity Calendars |
Deadline (Microsoft Project 2000 and later) | expect_end_date | TASK | Expected Finish |
Physical % Complete | phys_complete_pct | TASK | Physical % Complete |
Remaining Cost | ETC | TASK | Estimate To Complete |
Notes | task_memo | TASKMEMO | Notebook Description |
Text1-Text30 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Cost1-Cost10 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Duration1-Duration10 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Start1-Start10 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Finish1-Finish10 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Flag1-Flag20 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Number1-Number20 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Date1-Date10 | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Baseline Cost1-Baseline Cost10 (Microsoft Project 2002 and later) | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Baseline Duration 1-Baseline Duration10 (Microsoft Project 2002 and later) | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Baseline Work1-Baseilne Work10 (Microsoft Project 2002 and later) | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Activity ID | User defined field (Exchanged only if a mapping is defined for the field.) | UDFVALUE | User Defined Field Title |
Constraint Sub-table
Microsoft Project Field | P6 EPPM Field |
|---|---|
Must start on | Mandatory Start |
Start no later than | Start on or before |
Start no earlier than | Start on or after |
Must finish on | Mandatory Finish |
Finish no earlier than | Finish on or after |
Finish no later than | Finish on or before |
As late as possible | As late as possible |
As soon as possible | Activities without constraints |
Activity Leveling Priority Sub-table
Microsoft Project Field | P6 EPPM Field |
|---|---|
Highest | Top |
Higher | High |
Medium | Medium |
Lower | Low |
Lowest | Lowest |
Activity Type Sub-table
Microsoft Project Field | P6 EPPM Field |
|---|---|
Task - Scheduling Ignores Resource Calendars is selected (Microsoft Project 2000 and later) | Task Dependent |
Task - Scheduling Ignores Resource Calendars is not selected (Microsoft Project 2000 and later) | Resource Dependent |
Milestone - Mark Task as Milestone is selected | Task imported as a Start Milestone |
Duration Type Sub-table
Microsoft Project Field | P6 EPPM Field |
|---|---|
Fixed Duration (Effort Driven No) | Fixed Duration and Units/Time |
Fixed Units (Effort Driven Yes) | Fixed Units/Time |
Fixed Work (Effort Driven No) | Fixed Units |
Fixed Duration (Effort Driven Yes) | Fixed Duration and Units |
Fixed Units (Effort Driven No) | Fixed Units/Time |
Accrual Type Sub-table
Microsoft Project Field | P6 EPPM Field |
|---|---|
Start | Start of Activity |
Prorated | Uniform over Activity |
End | Finish of Activity |