Oracle Customer Hub (UCM) Master Data Management Reference > Configuring Source Data History and Cross-Reference Functionality > Administering Source Data and Cross-Reference Functionality for Oracle Customer Hub (UCM) >

SDH Type Codes


Table 25 lists the type codes for Source Data History and when they are used by Oracle Customer Hub (UCM).

Table 25. Source Data History Type Codes
Type
Description

Batch

Records loaded by Siebel Enterprise Integration Manager into the SDH tables for batch processing.

Cleansed

A cleansed record from a manual match operation, which is stored temporarily for a Promote or Link and Update operation.

Deleted

Not used.

History

The Best Version Record prior to any modifications.

Incomplete

A record fails to process completely because of an error during real-time or batch-mode processing.

Merged

A version of the victim record before it is merged and deleted.

Queued

Not used.

Queued-Insert

The insert request record was queued in SDH for batch-mode processing.

Queued-Update

The update request record was queued in SDH for batch-mode processing.

Queued-Upsert

The upsert request record was queued in SDH for batch processing.

Source

The request in its original state from an external system after it is processed in real-time.

Source-Insert

The insert request in its original state from an external system after it is processed. When the Batch workflow is run the record type is changed from from Queued-Insert to Source-Insert.

Source-Update

The update request in its original state from an external system after it is processed. When the Batch workflow is run the record type is changed from Queued-Update to Source-Update.

Source-Upsert

The upsert request in its original state from an external system after it is processed. When the Batch workflow is run the record type is changed from Queued-Upsert to Source-Upsert.

UnMerged

A version of the victim record that has been unmerged or reactivated.

Oracle Customer Hub (UCM) Master Data Management Reference Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.