S_COMM_ADDR_UPD Table

The following table shows details for the new S_COMM_ADDR_UPD table which is used to configure survivorship attribute settings for the email and alternate phone entities.

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
COMM_ID	Varchar (15)	Required. The entity row ID for the email and alternate phone fields. The foreign key table is S_PER_COMM_ADDR.
FLD_VAL_RULE_ID	Varchar (15)	Field value row ID. The foreign key table is S_FKD_VAL_RULE.
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)	Last modified date 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)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Required. 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.