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 |