MAINTAIN ELEMENT VALUE MAPPINGS

Use this application to define source element values to target element values translations. Use it when you are moving information between Costpoint and Deltek's CGR system.

This application builds records that are used by the Ascential-based interface system to assign Costpoint values to Deltek CGR values and vice versa. You must choose to activate mapping for each element where mapping is supported. If you use mapping, then you MUST define all source values in the mapping table.

Interface ID

Enter, or use Lookup to select, a valid interface ID. The interface IDs available for selection are pre-defined in the system and depend on the integration packages installed at your site.

Element ID

Enter, or use Lookup to select, a valid element ID. The element IDs available for selection are pre-defined in the system and depend on the integration packages installed at your site.

Source Information

The fields in this group box summarize the Source Value field.

Length

This non-editable field displays the length of the source element being processed.

Domain

This non-editable field displays the type of the source element being processed.

Target Information

The fields in this group box summarize the Target Value field.

Length

This non-editable field displays the length of the target element being processed.

Domain

This non-editable field displays the type of target element being processed.

Active

Select this checkbox to make the element mapping active; clear this checkbox to make the element mapping inactive. This checkbox is set as "Inactive" in the predefined Interface Element System table when you select an Element ID for the first time.

Element Value Mapping

Use this table window to view, edit, and create the interface element mapping for the available interface and element IDs. Once you make valid entries in the Interface ID and Element ID fields, this table window populates with the existing mapping information for the interface/element ID combination. If the combination is new, the table window will remain blank.

Line No.

This is a standard Deltek line number entry field. From the Line menu on the toolbar, select "New," "Insert," "Repeat," "Delete," or "Undelete" to enter/delete rows.

Source Value

Enter a source element value.

Target Value

Enter a target element value.

Table Information

Changes to this screen update the following tables:

S_INTFC_MSTR, a table that displays interface IDs and their definitions. This is a non-editable system table.
S_INTFC_ELEMENT, a table that displays element IDs and their definitions. This is a non-editable system table.
X_INTFC_ELEMENT, a table that displays the same information as the S_INTFC_ELEMENT table. The difference is the ACTIVE_FL. You can change the value of the flag in this table.
X_INTFC_ELEMENT_MAP, a table that displays the mapping information from the source values to target values for the elements.

Error Messages and Conditions

Message	Condition	Remedy
You must enter or look up a valid Interface ID.	Interface ID must be a valid interface in S_INTFC_ELEMENT.	Use Lookup to select a valid interface ID.
You must enter or look up a valid Element ID.	Element ID must be a valid element in S_INTFC_ELEMENT for the instance ID.	Use Lookup to select a valid element ID.
You must enter a unique line number.	If Interface ID, Element ID, and Line No. already exist in X_INTFC_ELEMENT.	Select a new number or select "New" from the Line menu on the toolbar to get a new number.
Element mapping cannot be active if no element value mappings exist.	If ACTIVE_FL is checked and no rows exist in X_INTFC_ELEMENT_MAP for the INTFC_ID and ELEM_ID being updated.	Enter one or more mapping lines before saving the screen information.
Warning - By inactivating element mapping, no translation of element values will occur during integration.	If ACTIVE_FL is unchecked and rows exist in X_INTFC_ELEMENT_MAP for the INTFC_ID and ELEM_ID being updated.	This is a warning.
Target value cannot be NULL when the Source value is not NULL.	If Source Value is not NULL and Target Value is NULL.	You must enter a value in the Target Value field.
Source value cannot be NULL when the Target value is not NULL.	If Source Value is NULL and Target Value is not NULL.	You must enter a value in the Source Value field.
Source value exceeds maximum length for element.	If length of Source Value > the value in the Source Information Length field.	The length of the Source Value field entry cannot exceed the Source Information Length value.
Target value exceeds maximum length for element.	If length of Target Value data > value in the Target Information Length field.	The length of the Target Value field entry cannot exceed the Target Information Length value.
Source value must be an INTEGER.	If the Source Information Domain type is an INTEGER and the Source Value is not an integer.	You must enter "number" in the Source Value field when the Source Information Domain value is an integer.
TARGET value must be an INTEGER.	If the Target Information Domain type is an INTEGER and the Target Value is not an integer.	You must enter "number" in the Target Value field when the Target Information Domain value is an integer.
The source value has been defined more then once in the mapping.	If the source value is defined multiple times on the screen.	Check the Source Value field to ascertain you are entering the same values.
Warning - The target value has been defined more then once in the mapping.	If the target value is defined multiple times on the screen.	Check the Target Value field to ascertain you are entering the same values.