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