Mappings Field Descriptions

The MSP Link Mappings dialog contains a grid with two columns:

Available MPM Fields — This column consists of all mappable MPM fields. The rows in this column are read only.
Available MSP Fields — The rows in this column consist of drop down picklists. Each picklist contains the fields that can be mapped to the corresponding MPM field.

The WBS ID field defaults to <Required> and is a required field in every mapping file. All other fields that are required for the import are prefixed with an "*."

Besides WBS ID, all other field mappings are only required for the imports that will be selected.

Field Level Summary

For a detailed description of the fields, see Detailed Field Level Description.

The following grid is a field level summary of the available MSP field levels for each available MPM field (Task, Resource or Assignment). Required fields are marked with an *.

Available MPM Fields	Field Level
WBS Selection
*WBS ID	Task
WBS Descriptive
WBS Description	Task
Alias	Task
User-defined XREF1	Task
User-defined XREF2	Task
User-defined XREF3	Task
User-defined XREF4	Task
User-defined XREF5	Task
User-defined XREF6	Task
User-defined XREF7	Task
User-defined XREF8	Task
User-defined XREF9	Task
User-defined XREF10	Task
Manager	Task
Charge Number	Task
Performing Department	Task
Responsible Department	Task
Element Type	Task
Earned Value Method	Task
CLIN	Task
Recurring or non-recurring	Task
Fee %	Task
Fee Limit Amount	Task
BCWP Base Unit	Task
*Parent WBS ID	Task
Base WBS	Task
WBS Schedule
Baseline Start	Task
Baseline Complete	Task
ETC Start	Task
ETC Complete	Task
Early Start	Task
Early Finish	Task
Late Start	Task
Late Finish	Task
Estimates
*Resource Code	Resource Assignment
Resource Department	Task Resource Assignment
XREF-EST	Task Resource Assignment
Overtime Factor	Resource Assignment
Rate Table	Task Resource Assignment
Burden Template	Task Resource Assignment
Estimate Identifier	Task
Time-Phased Estimates
Time-Phased Labor	Assignment
Time-Phased Material	Assignment
Autospread Estimates
Autospread Labor	Task Assignment
Autospread Material	Task Assignment
Spread Curve	Task
Estimate Type	Task
*Estimate Start	Task
*Estimate Complete	Task
BCWP
*EV %Complete Task Flag	Task
Task BAC	Task
Cumulative Percent Complete	Task
Cumulative BCWP Amount	Task
Milestones
Milestone Flag	Task
Milestone ID	Task
Milestone Symbol	Task
Milestone Description	Task
Milestone Weight	Task
Scheduled Date	Task
Forecast Date	Task
Milestone Complete Flag	Task
Percent Complete	Task

Detailed Field Level Description

WBS Selection	WBS Schedule	BCWP
WBS Descriptive	Estimates	Milestones

The grid that follows provides a detailed list of all available MPM Fields, the MSP Field Level (Task, Resource, or Assignment) and the Available MSP Fields for each MPM field.

	Available MPM Fields	Field Level	Available MSP Fields
WBS Selection
	*WBS ID	Task	ID Name Number1 - Number20 Text1 - Text30 Unique ID WBS
WBS Descriptive
	WBS Description	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	Alias	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF1	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF2	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF3	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF4	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF5	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF6	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF7	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF8	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF9	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	User-defined XREF10	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
	Manager	Task	Contact Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Summary Text1 - Text30
	Charge Number	Task	ID Name Notes Number1 - Number20 Summary Text1 - Text30 Unique ID WBS
	Performing Department	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30
	Responsible Department	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30
	Element Type	Task	Name Notes Text1 - Text30
	Earned Value Method Use the following codes: 1: 0/100 2: 25/75 3: 40/60 4: 50/50 5: % Complete 6: LOE 7: Earned Standards 8: Milestone Weights 9: BCWP P: Milestone Weights with % Complete K: Key Event	Task	Name Notes Text1 - Text30
	CLIN	Task	ID Number1 - Number20 Text1 - Text30
	Recurring or non-recurring If mapped to any Text or Notes field, and if that field is populated (with any value), then it will be imported as a recurring field. If mapped to any Text or Notes field and the field is not populated (i.e., it is left blank), it will be imported as a non-recurring field.	Task	EffortDriven Estimated Flag1 - Flag20 Marked Notes Recurring Rollup Text1 - Text30
	Fee %	Task	Notes Number1 - Number20 Text1 - Text30
	Fee Limit Amount	Task	Cost Cost1 - Cost10 Notes Number1 - Number20 Text1 - Text30
	BCWP Base Unit Use the following codes: H: Hours/Units P: Prime B: Total Burdened C: Total Cost D: Total Dollars	Task	Notes Text1 - Text30
	Parent WBS ID (enter if top level)	Task	Text1 - Text30
	Base WBS; used if EVM is apportioned	Task	ID Name Notes Number1 - Number20 Text1 - Text30 UniqueID WBS
WBS Schedule
	Baseline Start	Task	ActualStart BaselineStart Baseline1Start - Baseline10Start ConstraintDate Created Date1 - Date10 EarlyStart LateStart PreleveledStart Resume Start Start1 - Startt10
	Baseline Complete	Task	ActualFinish BaselineFinish Baseline1Finish - Baseline10Finish ConstraintDate Date1 - Date10 Deadline EarlyFinish Finish Finish1 - Finish10 LateFinish PreleveledFinish Stop
	ETC Start	Task	ActualStart BaselineStart Baseline1Start - Baseline10Start ConstraintDate Created Date1 - Date10 EarlyStart LateStart PreleveledStart Resume Start Start1 - Start10
	ETC Complete	Task	ActualFinish BaselineFinish Baseline1Finish - Baseline10Finish ConstraintDate Date1 - Date10 Deadline EarlyFinish Finish Finish1 - Finish10 LateFinish PreleveledFinish Stop
	Early Start	Task	ActualStart BaselineStart Baseline1Start - Baseline10Start ConstraintDate Created Date1 - Date10 EarlyStart LateStart PreleveledStart Resume Start Start1 - Start10
	Early Finish	Task	ActualFinish BaselineFinish Baseline1Finish - Baseline10Finish ConstraintDate Date1 - Date10 Deadline EarlyFinish Finish Finish1 - Finish10 LateFinish PreleveledFinish Stop
	Late Start	Task	ActualStart BaselineStart Baseline1Start - Baseline10Start ConstraintDate Created Date1 - Date10 EarlyStart LateStart PreleveledStart Resume Start Start1 - Start10
	Late Finish	Task	ActualFinish BaselineFinish Baseline1Finish - Baseline10Finish ConstraintDate Date1 - Date10 Deadline EarlyFinish Finish Finish1 - Finish10 LateFinish PreleveledFinish Stop
Estimates
	*Resource Code	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30
		Resource	Code CostRateTable Group Initials Notes Number1 - Number20 Text1 - Text30
		Assignment	Notes Number1 - Number20 Text1 - Text30
	Resource Department	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30
		Resource	Cost Cost1 - Cost10 Group ID Initials Notes Number1 - Number20 Text1 - Text30
		Assignment	Cost Cost1 - Cost10 Notes Number1 - Number20 Text1 - Text30
	XREF-EST	Task	ID Name Notes Number1 – Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 – Text30
		Resource	Group Initials Notes Number1 - Number20 OvertimeRate Text1 - Text30 Type
		Assignment	Notes Number1 - Number20 Text1 - Text30
	Overtime Factor	Resource	Cost Cost1 - Cost10 Group Initials Notes Number1 - Number20 OvertimeRate Text1 - Text30 Type
	Overtime Factor	Assignment	Cost Cost1 - Cost10 Notes Number1 - Number20 Text1 - Text30
	Rate Table	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30
		Resource	Cost Cost1 - Cost10 Group ID Initials Notes Number1 - Number20 Text1 - Text30
		Assignment	Cost Cost1 - Cost10 Notes Number1 - Number20 Text1 - Text30
	Burden Template	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30
		Resource	Cost Cost1 - Cost10 Group ID Initials Notes Number1 - Number20 Text1 - Text30
		Assignment	Cost Cost1 - Cost10 Notes Number1 - Number20 Text1 - Text30
	Estimate Identifier Required when using both time-phased and autospread.	Task	Contact ID Name Notes Number1 - Number20 Priority Text1 - Text30 Unique ID WBS
Time-Phased Estimates
	Time-phased Labor	Assignment	BaselineWork Baseline1Work - Baseline10Work Work
	Time-phased Material	Assignment	BaselineWork Baseline1Work - Baseline10Work Work Cost Cost1 - Cost10 CostRateTable CostVariance Work
Autospread Estimates
	Autospread Labor	Task	ActualCost ActualOvertimeCost ActualOvertimeWork ActualWork ACWP AssignmentUnits BaselineCost BaselineWork Baseline1Cost - Baseline10Cost Baseline1Work - Baseline10Work BCWP BCWS Cost Cost1 - Cost10 CostRateTable EAC FixedCost FixedCostAccrual Number1 - Number20 OvertimeCost OvertimeWork RegularWork RemainingCost RemainingDuration RemainingOvertimeCost RemainingOvertimeWork RemainingWork Text1 - Text30 Work
	Autospread Labor	Assignment	ActualCost ActualOvertimeCost ActualOvertimeWork ActualWork ACWP BaselineCost BaselineWork Baseline1Cost - Baseline10Cost Baseline1Work - Baseline10Work BCWP BCWS Cost Cost1 - Cost10 CostRateTable FixedMaterialAssignment Number1 - Number20 OvertimeCost OvertimeWork RegularWork RemainingCost RemainingOvertimeCost RemainingOvertimeWork RemainingWork Text1 - Text30 Units Work
	Autospread Material	Task	ActualCost ActualOvertimeCost ActualOvertimeWork ActualWork ACWP AssignmentUnits BaselineCost BaselineWork Baseline1Cost - Baseline10Cost Baseline1Work - Baseline10Work BCWP BCWS Cost Cost1 - Cost10 CostRateTable EAC FixedCost FixedCostAccrual Number1 - Number20 OvertimeCost OvertimeWork RegularWork RemainingCost RemainingDuration RemainingOvertimeCost RemainingOvertimeWork RemainingWork Text1 - Text30 Work
	Autospread Material	Assignment	ActualCost ActualOvertimeCost ActualOvertimeWork ActualWork ACWP BaselineCost BaselineWork Baseline1Cost - Baseline10Cost Baseline1Work - Baseline10Work BCWP BCWS Cost Cost1 - Cost10 CostRateTable FixedMaterialAssignment Number1 - Number20 OvertimeCost OvertimeWork RegularWork RemainingCost RemainingOvertimeCost RemainingOvertimeWork RemainingWork Text1 - Text30 Units Work
	Spread Curve If no mapping default to linear. If mapped field is blank default to 1. The numeric value for each type of spread curve is: Linear 1 Bell Curve 2 Front Load #1 3 Front Load #2 4 Back Load #1 5 Back Load #2 6 Double Peak 7 Early Peak 8 Late Peak 9 Trapezoid 10	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30 Unique ID WBS
		Resource	Cost Cost1 - Cost10 Group ID Initials Notes Number1 - Number20 Text1 - Text30
		Assignment	Cost Cost1 - Cost10 Notes Number1 - Number20 Text1 - Text30
	Estimate Type If blank then we will use todaydefaults labor is B (hours) and material is C (prime).	Task	ID Name Notes Number1 - Number20 ResourceGroup ResourceInitials ResourceNames ResourcePhonetics Text1 - Text30
		Resource	Cost Cost1 - Cost10 Group ID Initials Notes Number1 - Number20 Text1 - Text30
		Assignment	Cost Cost1 - Cost10 Notes Number1 - Number20 Text1 - Text30
	* Estimate Start	Task	ActualStart BaselineStart Baseline1Start - Baseline10Start ConstraintDate Created Date1 - Date10 EarlyStart LateStart PreleveledStart Resume Start Start1 - Start10
	* Estimate Complete	Task	ActualFinish BaselineFinish Baseline1Finish -Baseline10Finish ConstraintDate Date1 - Date10 Deadline EarlyFinish Finish Finish1 - Finish10 LateFinish PreleveledFinish Stop
BCWP
	*EV %Complete Task Flag If this field is blank in MSP, it will be ignored and will not be added to the generated file. If mapped to a Flag field, then No is ignored and Yes is used. If mapped to a numeric field, then value <>0 is used. If mapped to a Text field, and any value is in the text field, then it is used. If flagged, then MPM looks at the task for BCWP information.	Task	Flag1 - Flag20 Marked Milestone Name Notes Number1 - Number20 Text1 - Text30 UniqueID WBS
	Task BAC This is a required field if Cum Percent Complete is mapped and you have multiple tasks for the same WBS ID. We recommend that this field is mapped to the same field used for Estimates Time-phased Resource Plan	Task	BaselineWork Baseline1Work - Baseline10Work Work
	Cumulative Percent Complete Cum Percent Complete and/or BCWP Amount must be mapped if importing BCWP.	Task	BCWP Number1 - Number20 PercentComplete PercentWorkComplete PhysicalPercentComplete Text1 - Text30
	Cumulative BCWP Cum Percent Complete and/or BCWP Amount must be mapped if importing Milestone Flag.	Task	BCWP Cost Cost1 - Cost10 Number1 - Number20 Text1 - Text30
Milestones
	Milestone Flag If this field is blank in MSP, it will be ignored and will not be added to the generated file. If mapped to a Flag field, then No is ignored and Yes is used. If mapped to a numeric field, then value <>0 is a milestone. If mapped to a Text field, and any value is in the text field, then it is used. We recommend that this field is mapped to the same field used for Milestone ID. If flagged, then MPM looks at the task for Milestone information.	Task	Flag1 - Flag20 Marked Milestone Name Notes Number1 - Number20 Text1 - Text30 UniqueID WBS
	Milestone ID This is a required field if identifying milestones by ID.	Task	ID Name Notes Number1 - Number20 Text1 - Text30 Unique ID
	Milestone Symbol This is a required field if identifying milestones by Symbol/Description/Scheduled Date.	Task	Name Notes Text1 - Text30
	Milestone Description This is a required field if identifying milestones by Symbol/Description/Scheduled Date OR Description.	Task	EarnedValueMethod ID Name Notes Number1 - Number20 ParentTask Priority Summary Text1 - Text30 UniqueID WBS
	Milestone Weight If the Milestone Wight field is mapped to a task work field, then the weight will be calculated based on the work values. For import, only hours or cost can be used to weight milestones. Both cannot be imported at the same time. If Milestone Weight is mapped to a task work field, then the BCWP Base Unit should be set to Hours for labor tasks and Prime for non-labor tasks in order for the weight to be calculated. If mapping Milestone weights to a user-defined field, we suggest entering Hours for labor tasks and Prime for non-labor tasks in order for the milestone to be weighted correctly.	Task	BaselineWork Baseline1Work - Baseline10Work Cost Cost1 - Cost10 Number1 - Number20 Text1 - Text30 Work
	Scheduled Date This is a required field if identifying milestones by Symbol/Description/Scheduled Date.	Task	ActualStart ActualFinish ActualStart BaselineFinish BaselineStart Baseline1Finish - Baseline10Finish Baseline1Start - Baseline10Start ConstraintDate Date1 - Date10 EarlyFinish EarlyStart Finish LateFinish LateStart Start
	Forecast Date	Task	ActualStart BaselineFinish BaselineStart Baseline1Finish - Baseline10Finish Baseline1Start - Baseline10Start ConstraintDate Date1 - Date10 EarlyFinish EarlyStart Finish LateFinish LateStart Start
	Milestone Complete Flag If mapped, and any value is in the Text field, then Milestone is imported as complete.	Task	Flag1 - Flag20 Marked Text1 - Text30
	Percent Complete	Task	BCWP Number1 - Number20 PercentComplete PercentWorkComplete PhysicalPercentComplete Text1 - Text30

*Required Fields

Mappings Field Descriptions

Field Level Summary

Detailed Field Level Description

Required when using both time-phased and autospread.

If no mapping default to linear. If mapped field is blank default to 1.

If blank then we will use todaydefaults labor is B (hours) and material is C (prime).

If this field is blank in MSP, it will be ignored and will not be added to the generated file.

If mapped to a Flag field, then No is ignored and Yes is used.

If mapped to a numeric field, then value <>0 is used.

If mapped to a Text field, and any value is in the text field, then it is used.

If flagged, then MPM looks at the task for BCWP information.

This is a required field if Cum Percent Complete is mapped and you have multiple tasks for the same WBS ID.

We recommend that this field is mapped to the same field used for Estimates Time-phased Resource Plan

Cum Percent Complete and/or BCWP Amount must be mapped if importing BCWP.

Cum Percent Complete and/or BCWP Amount must be mapped if importing Milestone Flag.

If this field is blank in MSP, it will be ignored and will not be added to the generated file.

If mapped to a Flag field, then No is ignored and Yes is used.

If mapped to a numeric field, then value <>0 is a milestone.

If mapped to a Text field, and any value is in the text field, then it is used.

We recommend that this field is mapped to the same field used for Milestone ID.

If flagged, then MPM looks at the task for Milestone information.

This is a required field if identifying milestones by ID.

This is a required field if identifying milestones by Symbol/Description/Scheduled Date.

This is a required field if identifying milestones by Symbol/Description/Scheduled Date OR Description.

If the Milestone Wight field is mapped to a task work field, then the weight will be calculated based on the work values.

For import, only hours or cost can be used to weight milestones. Both cannot be imported at the same time.

If Milestone Weight is mapped to a task work field, then the BCWP Base Unit should be set to Hours for labor tasks and Prime for non-labor tasks in order for the weight to be calculated.

If mapping Milestone weights to a user-defined field, we suggest entering Hours for labor tasks and Prime for non-labor tasks in order for the milestone to be weighted correctly.

This is a required field if identifying milestones by Symbol/Description/Scheduled Date.

If mapped, and any value is in the Text field, then Milestone is imported as complete.

Related Topics