Data Mapping During EnterpriseTrack Import

Scheduling Mode

MS Project Task Type

ET Activity Schedule Mode

Fixed Duration - non effort driven

Duration and % resource availability

Fixed Work

Effort at activity level - Equal distribution

Fixed Work

Effort at activity level - Unequal distribution

Fixed Work

Effort at resource level (Summary)

Fixed Work

Effort at resource level (Detailed)

Note: Scheduling Mode in EnterpriseTrack maps to Task Type in MS Project.

Calendar

MS Project Field

ET Field

Hours per day

Work Hours Per Day

Hours per week

 

Work Hours Per Week

Fiscal year starts in

Start Fiscal Year

Cost

MS Project Field

ET Field

Fixed Cost

Planned_non_resource_fixed_cost

Actual Cost

Actual_non_resource_fixed_cost

Cost

Planned_non_resource_material_cost

Actual Cost

Actual_non_resource_material_cost

Cost

Planned_non_resource_other_cost

Actual Cost

Actual_non_resource_other_cost

Notes:

Task

MS Project Field

ET Field

Baseline start

Activity dates -baseline_start_date

Baseline Completion

Activity dates -baseline_completion_date

Baseline start

Activity dates- baseline duration

Start

Activity dates- planned start date

Finish

Activity dates - planned completion date

Plan duration of task

Activity dates- planned duration

Start date of task

Activity dates - actual start date

Actual finish of task

Activity dates-actual completion date

Actual duration of task

Activity dates- actual duration

Plan duration of task

Owner dates- planned duration

Actual duration of task

Owner dates-actual duration

% Complete of task

Percent_completion

Actual work (of resource)

Actual_total_effort

Work (of task)

Planned_total_effort

N/A

Baseline_effort

See Also

Data Mapping for EnterpriseTrack and MS Project

Data Mapping During EnterpriseTrack Export



Legal Notices
Copyright © 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, May 03, 2018