Relationship Between a System Field and a System Column

The Id field that represents the ROW_ID column in a business component is an implicit field, and Siebel Tools does not display it in the Object Explorer as a child field of a business component. Every business component includes an Id field that represents the ROW_ID column of the base table of the business component, as defined in the Table property of the business component. The Siebel schema references the Id field in various properties throughout Siebel CRM. For example, in the Source Field property of a link where an empty value indicates the Id field.

You must not explicitly create a system field for a business component. If you create a business component field that references a system column, then Siebel CRM attempts to write a value to the column twice in the insert statement, which causes a duplicate column SQL error.

The following table describes the relationship that exists between a system field and a system column. Each field is predefined. You do not explicitly define it. You can configure Siebel CRM to reference a system field in the Field property of a control, list column, or other object, even though Siebel Tools does not display the field in the Business Components list.

System Field Name	System Column Name	Description
Id (or empty)	ROW_ID	Stores the primary key for the table.
Created	CREATED	Stores the date and time of when Siebel CRM created the row.
Created By	CREATED_BY	Stores the ROW_ID of the row from the S_USER table that references the person who created the record.
Updated	LAST_UPD	Stores the date of the most recent update that Siebel CRM performed on the row.
Updated By	LAST_UPD_BY	Stores the ROW_ID of the row from the S_USER table that references the person who last updated the record. In some situations, Siebel CRM updates this field even though the user does not actively update the record. For example, if Siebel CRM configures a multi-value link with a primary join. For more information, see Defining the Primary ID Field of a Multi-Value Link.
(varies)	DB_LAST_UPD	Stores the date of the most recent update that Siebel CRM performed on the row in the Siebel database. The system field name varies.