Use this screen to create a link between a column you defined for the input file in the Configure Interface Settings screen and a column required for update in the Costpoint tables. To create a link, enter the column number in the Mapping Definition table. You can also supply default values for Costpoint columns and mark them so the data for those columns is captured during import.
This non-editable table displays data from the Row Definition subtask of the Configure Interface Settings screen.
This field displays the source name.
This field displays the source description.
This field displays the level at which the data is loaded into Costpoint. Valid levels are:
TOTAL
PERIOD
If the Type is ETC, this field must display TOTAL.
This field displays the type of data contained in the input file. Valid types are:
BUDGET
FORECAST
BOTH
ETC
This field displays the row type.
This field displays the row type description.
This field displays the type of data represented by this row. Record types are:
DLC — Direct labor
DNLC — Direct non-labor
INDC — Indirects
FEE — Manual Fee
ETC — Estimate-to-complete revenue amounts.
This non-editable table displays data from the Column Definition subtask on the Row Definition subtask of the Configure Interface Settings screen.
This field displays the column number. This column must start at 1 and cannot skip any numbers.
This field displays the column description.
If this non-editable check box is selected, this column is used for mapping.
If this non-editable check box is selected, this column is a repeating column.
This field defines the interval at which a repeating column repeats. If the column does not repeat, or if the repeating columns are adjacent to one another, this field displays 1.
This field displays the number of times a repeating column repeats. If the column does not repeat, this field displays 1.
The non-editable field displays the column description.
This column defaults from the target definition table, and you can override the values. The selections are:
Calculated
Default
File
Runtime
The Calculated options currently supported and their assigned values are:
Direct synthetic key is calculated based on the maximum key previously assigned.
Modified By is the Costpoint user ID.
Time Stamp is the system date and time.
Row Version is zero.
Last Update Date is the system date.
ORG_ID is set to the project's owning organization ID.
You must set all of the above fields to Calculated for the source, with the exception of ORG_ID, which can be set to Calculated, Runtime, File, or Default.
You must enter a column number if the Column Source is File. Only source column numbers whose Include check box is selected can be used when mapping. A column number is not required if the Column Source is Runtime.
You must enter a default value if the Column Source is Default. A default value is not required if the Column Source is Runtime.