SDH Type Codes

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

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.