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 |