Field Mapping Reference

The following tables help you understand how fields in one application map to fields in the other application. It presents a guide for mapping fields from Microsoft Project to OpenAir and one for mapping fields from OpenAir to Microsoft Project.

Field From Microsoft Project	To Field in OpenAir
Microsoft Project duration	OpenAir duration
Microsoft Project task ID	OpenAir task ID
Microsoft Project summary task name	OpenAir phase name
Microsoft Project task name	OpenAir task name
Microsoft Project predecessor	OpenAir predecessor
Microsoft Project resource names, % allocation	OpenAir task assignment, including % allocation units
If Microsoft Project % complete has data, Microsoft Project % complete	OpenAir % complete
If Microsoft Project has work and OpenAir internal setting “Input planned hours for each user assigned to the task” is enabled then, Microsoft Project work hours	OpenAir planned hours

Note:

OpenAir Start/Finish dates are calculated from the duration by default. Optionally, there is a setting that allows Projects Connector to set OpenAir fixed start/end dates based on Microsoft Project tasks' start/finish date.

Field From OpenAir	To Field in Microsoft Project
OpenAir duration	Microsoft Project duration
OpenAir ID	Microsoft Project ID
OpenAir phase name	Microsoft Project summary task name
OpenAir task name	Microsoft Project task name
OpenAir predecessor	Microsoft Project predecessor
OpenAir resource task assignment and % allocation	Microsoft Project resource names and % allocation units
If OpenAir has % complete data, OpenAir % complete	Microsoft Project % complete
If selected from Advanced > Settings during export from OpenAir, either all timesheet hours or approved timesheet hours (depending on user selection)	Actual work hours in Microsoft Project