Task
| 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 (actual cost + estimate to complete 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 (Microsoft Project 2002 and later) | phys_complete_pct | TASK | Physical % Complete |
| Remaining Cost | ETC | TASK | Estimate To Complete (Remaining labor, nonlabor, and expense cost) |
| Note | 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 |