1. Configuring Siebel Business Applications
  2. System Columns of a Siebel Table

System Columns of a Siebel Table

A system column is a column that Siebel CRM displays in all tables, but it does not include the same set of system columns in every table. You can use the data in a system column for various reasons. For example, you can use the ROW_ID column to create a join. Most system columns are read-only. You typically must not modify the data in a system column. Some exceptions exist, such as using certain system columns in an interface table. For more information, see System Fields of a Business Component.

The following table describes some of the system columns that Siebel CRM commonly uses.

Column Description

ROW_ID

Stores a unique, base 36 alphanumeric identifier for the rows in the table. ROW_ID is present in all tables. It is the typical destination column of a foreign key relationship from another table. In a predefined data table, the Id field often represents ROW_ID for use in a join or link. For example, the Id field in the Account business component represents the ROW_ID column in the S_ORG_EXT table. For more information, see Relationship Between a System Field and a System Column.

CREATED

Stores the creation date and time of each record.

CREATED_BY

Stores the ROW_ID of the S_USER record of the person who created the record. This is not the user name that the user enters when the user logs in to Siebel CRM.

LAST_UPD

Stores the date of the last update that Siebel CRM performed for the record.

LAST_UPD_BY

Stores the ROW_ID of the S_USER record of the person who last updated the record. This is not the user name that the user enters when the user logs in to Siebel CRM.

DB_LAST_UPD

Stores the date of each record that Siebel CRM updates in the database. DB_LAST_UPD is different than LAST_UPD. For example, if the user updates a record, then Siebel CRM updates the LAST_UPD and DB_LAST_UPD columns in the local database. If the user synchronizes with a Server database, then Siebel CRM only updates the DB_LAST_UPD column.

PAR_ROW_ID

Stores a foreign key to the ROW_ID column of the base table. Siebel CRM includes the PAR_ROW_ID column in extension tables, file attachment tables, and tables whose name contains a _T suffix.

Siebel CRM updates the following columns:

  • CREATED

  • CREATED_BY

  • LAST_UPD

  • LAST_UPD_BY

  • ROW_ID

The following columns store the date, time, and user values for the client. They do not store the date, time, and user values for the Siebel database:

  • CREATED

  • CREATED_BY

  • LAST_UPD

  • LAST_UPD_BY