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

Black 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



Legal Notices | Your Privacy Rights
Copyright © 1999, 2020, Oracle and/or its affiliates. All rights reserved.

Last Published Tuesday, December 17, 2019