IM Relationship Resolution Information Center, Version 4.2

Data Mappings- General tab

Use the General tab to specify the details of the data mapping.

Segment
Type the name of the segment you want to create a data mapping for. The segment name must be entered in uppercase.
Table
From the drop-down list, select the table for the data mapping you want to create.
Table Column name
Type the name of the table column you want to create.
Table column type
From the drop-down list, select the table column type for the table column name..
Unique ID
The table column is an automatically incrementing unique key generated by the database engine. Only one table column can be configured with this value.
Entity Key
If selected, the table column is always set to the ENTITY_ID.
Business Key
The table column along with other designated business key table columns make up a composite lookup key to determine the existence of the same record
Attribute
The table column is used to simply store data and does not have any functional effect on the insert/update/delete of the table.
Key Attribute
The table column value is used to determine if there is an existing record with the same value. The database keeps track of changes to these values through time. For example: if you want to keep a version of the record if the ADDR1 value changes, you would identify the ADDR1 value as a key attribute.
This value has nothing to do with indexes.
History Sequence
The table column is used to determine which record provided by a given source is the most recent current and which are historical.
History Sequence is always assigned to the HIST_STAT table column.
Delete Timestamp
The table column is used to store the last date/time the record was deleted.
Update Timestamp
The table column is used to store the last date/time the record was updated.
Data type
From the drop-down list, select the data type for the table column.
CHAR
Character data (alphanumeric).
INT
Integer data.
DATE
Date data. For example: yyyy-mm-dd or mm-dd-yyyy.
DATE/TIME
Date/time data. For example: yyyy-mm-dd hh:mm:ss or mm-dd-yyyy hh:mm:ss.
UMF Data Path
Type the XPath location of the UMF tag.
Update Method
From the drop-down list, select the update method for the data mapping you want to create. The update method determines which value, between the inbound value and the previously stored value, will be retained.
Never
If a value for the UMF element exists in the database table, that value cannot be updated.
Always
If a value for the UMF element exists in the database table, that value can be updated.
Maximum Value
The greater value, incoming or stored, will be retained or updated.
Restricted to Table Column Data Types equal to INT, DATE, or DATE/TIME.
Minimum Value
The lesser value, incoming or stored, will be retained or updated.
Restricted to Table Column Data Types equal to INT, DATE, or DATE/TIME.
Status
From the drop-down list, select the status for the data mapping you want to create.
Active
The data mapping is active.
Inactive
The data mapping is inactive.


Feedback

Last updated: 2009