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