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 |