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_FLD_VAL_RULE Table


Table 406 shows details for the new S_FLD_VAL_RULE table which contains field value rule definitions for all entities.

Table 406. S_FLD_VAL_RULE table details
Column Name
Data Type
Comments

ROW_ID

Varchar (15)

Required. Siebel system field.

SEQ_NUM

Number (22)

The sequence number to set priority as required.

NAME

Varchar (100)

Rule name.

RULE_SET_ID

Varchar (30)

Not required. The foreign key table is S_UCM_RULE_SET.

COMP_FIELD_NAME

Varchar (75)

Field name for the comparison value of Type in a business address.

COMP_FIELD_VALUE

Varchar (140)

The values of the comparison column Business Personal.

COMP_RULE_CD

Varchar (75)

The comparison rule used for Source, Recent, Master, and External records.

STATUS_CD

Varchar (75)

Status. Values are active or inactive.

BUS_SERVICE_NAME

Varchar (75)

The external rule business service.

METHOD_NAME

Varchar (75)

The external rule business service method.

RULE_MODULE_NAME

Varchar (150)

The external rule module.

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.

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.

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.