Data Mapping During EnterpriseTrack Export

ET Field

MS Project Field

Currency Symbol

Symbol

Positive Currency Format

Placement X

Number of Decimal Places

Decimal digits

ET Activity Schedule Mode	MS Project Task Type
Duration and % resource availability	Fixed Duration - non effort driven
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)	Fixed Work

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

ET Field

MS Project Field

Work Hours Per Day

Hours per day

Work Hours Per Week

Hours per week

Start Fiscal Year

Fiscal year starts in

ET Field	MS Project Field
Team Member rate	Rate based (standard or overtime)
Equipment rate	Material (rate based) Cost Resource (cost)
Cost-planned_fixed	Fixed Cost
cost- planned_material	N/A
cost - actual_material	N/A

ET Field	MS Project Field
Et_tm_id	Text30
ET_user_id	Text29
ET_role_id	Text28
ET_role_name	Text27
ET_1nameET_fname	Name
Resource type (person or equipment)	Type (work= person or equipment)
Resource calendar	Resource Calendar

ET Field	MS Project Field
Name	Name
Comments	Notes
Activity_id	Text30
% completion	% completion
Owners	Owner
Activity marked NA	Text29 is set to NA_Closed
WBS Code	WBS
Milestone	Milestone
Critical tasks	Tasks are critical if slack is less than or equal to 0 days.

Notes:

For open activities, the % completion is set by EnterpriseTrack. For completed activities, the % completion is set to 100%. For NA activities, the % completion is explicitly specified.
Based on the scheduling mode, EnterpriseTrack sends either the duration or the completion date.