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 | Notes |
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 |