Resource Assignments

Microsoft Project Field P6 EPPM Table Field P6 EPPM Table P6 EPPM Field
Units target_qty_per_hr TASKRSRC Budgeted/Planned Units/Time
Work total_qty TASKRSRC At Completion Units
Planned Work target_qty TASKRSRC Budgeted/Planned Units
Actual Work act_reg_qty TASKRSRC Actual Regular Units
Actual Overtime Work act_ot_qty TASKRSRC Actual Overtime Units
Cost total_cost TASKRSRC At Completion Cost
Planned Cost target_cost TASKRSRC

Planned Cost (P6 EPPM)

Budgeted Cost or Planned Cost (P6 Professional)

Actual Cost act_cost TASKRSRC Actual Cost
Assignment Delay lag_drtn_hr_cnt TASKRSRC Lag

Work Contour

See resource curve sub-table.

curv_id (foreign key) TASKRSRC

Resource Curve

Notes

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
Date1 – Date10

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
Text1 – Text30

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

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 Work1 – Baseline Work10

(Microsoft Project 2002 and later)

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

Resource Curve Sub-table

Microsoft Project Field P6 EPPM Field
Flat Linear
Back Loaded Triangular Increase
Front Loaded Triangular Decrease
Double Peak Double Peak
Early Peak Early Peak
Late Peak Offset Triangular
Bell Bell Shaped
Turtle Trapezoidal
Contoured Manual