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) >

Source Data History Tables

Oracle Customer Hub (UCM) Source Data History tables (SDH tables) contain the transactional contact and account data records pertaining to Oracle Customer Hub (UCM) and registered external systems. These tables hold incoming and historical data records and provide the content for Oracle Customer Hub (UCM) administration views. The storage of this data allows for Oracle Customer Hub (UCM) features, such as incoming duplicates resolution, merge and unmerge, list import, and so on.

The SDH tables are named with the S_UCM_* prefix, such as S_UCM_CONTACT and S_UCM_ORG_EXT. The UCM base tables are visible from the Siebel application, such as S_PARTY, S_CONTACT, S_USER, and store the master copy of the record. The SDH tables contain a large amount of data and must be purged at regularly. For more information on this task, see Purging Source Oracle Customer Hub (UCM) Data.