Resource Assignments

P6 EPPM Field P6 EPPM Table Field P6 EPPM Table Microsoft Project Field

Planned Units/Time (P6 EPPM)

Budgeted Units/Time or Planned Units/Time (P6 Professional)

target_qty_per_hr TASKRSRC Units
At Completion Units total_qty TASKRSRC Work

Planned Units (P6 EPPM)

Budgeted Units or Planned Units (P6 Professional)

target_qty TASKRSRC Planned Work
Actual Regular Units act_reg_qty TASKRSRC Actual Work
Actual Overtime Units act_ot_qty TASKRSRC Actual Overtime Work
At Completion Cost total_cost TASKRSRC Cost

Planned Cost (P6 EPPM)

Budgeted Cost or Planned Cost (P6 Professional)

target_cost TASKRSRC Planned Cost
Actual Cost act_cost TASKRSRC Actual Cost
Lag lag_drtn_hr_cnt TASKRSRC Assignment Delay

Resource Curve

See resource curve sub-table.

curv_id (foreign key) TASKRSRC Work Contour
User Defined Field Title

User defined field

(Exchanged only if a mapping is defined for the field.)

UDFVALUE Notes
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 Date1 – Date10
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 Text1 – Text30
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

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

(Microsoft Project 2002 and later)

User Defined Field Title

User defined field

(Exchanged only if a mapping is defined for the field.)

UDFVALUE Number1 – Number20

Resource Curve Sub-table

P6 EPPM Field Microsoft Project Field
Linear Flat
Triangular Increase Back Loaded
Triangular Decrease Front Loaded
Double Peak Double Peak
Early Peak Early Peak
Offset Triangular Late Peak
Bell Shaped Bell
Trapezoidal Turtle
All other curve types (including Manual) Contoured