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