Oracle Customer Hub (UCM) Master Data Management Reference > Schema Changes for Oracle Customer Hub (UCM) Version 8.2 > New Tables for Oracle Customer Hub (UCM) Version 8.2 >

S_PARTY_REL_UPD Table


Table 413 shows details for the new S_PARTY_REL_UPD table which is used to configure survivorship attribute settings for address entity records.

Table 413. S_PARTY_REL_UPD table details
Column Name
Data Type
Comments

ROW_ID

Varchar (15)

Required. Siebel system field.

ADDR_ID

Varchar (15)

Required. The row ID of the Address object. The foreign key table is S_ADDR_PER.

FLD_VAL_RULE_ID

Varchar (15)

The field value row ID. The foreign key table is S_FLD_VAL_RULE.

PAR_CON_ID

Varchar (15)

The parent row ID for the Contact table. The foreign key table is S_CONTACT.

PAR_ACCNT_ID

Varchar (15)

The parent row ID for the Account table. The foreign key table is S_ORG_EXT.

PAR_ORGGRP_ID

Varchar (15)

The row ID of the Household table. The foreign key table is S_ORG_GROUP.

PAR_ASSET_ID

Varchar (15)

The parent row ID of the FINCORP Account table. The foreign key table is S_ASSET.

EXT_SYS_ID

Varchar (15)

The external system ID. The foreign key table is S_CIF_EXT_SYS.

LAST_MOD_TS

UTC Date Time (7)

The last modified date and time.

DESC_TXT

Varchar (250)

Description.

CONFLICT_ID

Varchar (15)

Required. Siebel system field.

CREATED

UTC Date Time (7)

Required. Siebel system field.

CREATED_BY

Varchar (15)

Required. Siebel system field. The foreign key table is S_USER.

DB_LAST_UPD

UTC Date Time (7)

Required. Siebel system field.

DB_LAST_UPD_SRC

Varchar (50)

Siebel system field.

LAST_UPD

UTC Date Time (7)

Siebel system field.

LAST_UPD_BY

Varchar (15)

Required. Siebel system field. The foreign key table is S_USER.

MODIFICATION_NUM

Number (22)

Required. Siebel system field.

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