Configuring Required Values

The following table describes the values you must provide if you configure a Workflow Policy program that inserts a new record. For more information, see Siebel Data Model Reference on My Oracle Support.

Required Values	Values Not Required
If you configure a Workflow Policy program that inserts a new record, then you must provide a value for each field that Siebel CRM requires to add this record. If you configure a default value for a column, and if the Workflow Policy program does not specify a value, then Siebel CRM uses that default value on the insert. For example, the S_EVT_ACT table includes the following required columns: NAME ROW_STATUS Siebel CRM sets ROW_STATUS to Y by default.	Siebel CRM does not require a value for a system column. For example, the following columns are system columns: CREATED CREATED BY LAST_UPD LAST_UPD_BY ROW_ID MODIFICTION_NUM CONFLICT_ID

Required Values

Values Not Required

If you configure a Workflow Policy program that inserts a new record, then you must provide a value for each field that Siebel CRM requires to add this record.

If you configure a default value for a column, and if the Workflow Policy program does not specify a value, then Siebel CRM uses that default value on the insert. For example, the S_EVT_ACT table includes the following required columns:

NAME
ROW_STATUS

Siebel CRM sets ROW_STATUS to Y by default.

Siebel CRM does not require a value for a system column. For example, the following columns are system columns:

CREATED
CREATED BY
LAST_UPD
LAST_UPD_BY
ROW_ID
MODIFICTION_NUM
CONFLICT_ID