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.