Domain Type Definitions

The following table provides descriptions for the domain types of certain columns in the Siebel database.

Domain Type	Meaning	Domain Contains
FK	Foreign Key column	The name of the table referenced by this Foreign Key column.
PC	Primary Child	The name of the table in which the Primary Child is found. For example, an account (S_ORG_EXT) can be associated with multiple industries (S_INDUST) through the intersection table S_ORG_INDUST. One of these industries is the primary industry of the account: column S_ORG_EXT.PR_INDUST_ID points to the foreign key column INDUST_ID of the primary child table S_ORG_INDUST (the column S_ORG_INDUST.INDUST_ID is a foreign key to the base table S_INDUST and so it points to S_INDUST.ROW_ID).
LOV	List of Values	The intended List of Values type for this column. List of values types are defined in the table S_LST_OF_VAL accessible through Siebel Tools: Screens > System Administration > List of Values.
LOVB	List of Values Bounded	The List of Values type against which this column is validated. In the LOVB case, end users must specify a value from the list, whereas in the LOV case, the user can enter a value not contained in the list.
MLOV	Multilingual List of Values	The List of Values type against which this column is validated, in multiple languages. End users must specify a value from the list, but see the values in their preferred language.
MLS	Multiple Language Support	The name of the table in which the translation in an alternate language can be found.
DNRM	Denormalized	The path to the original column, used by the Object Manager to synchronize the values, in the form of [foreign key column].[original column]. For example, the ACCNT_NAME column of table S_ACCNT_POSTN is denormalized; its domain is [OU_EXT_ID].[NAME]. In other words, the contents of column NAME of the table referenced by OU_EXT_ID (S_ORG_EXT) are replicated into column ACCNT_NAME of table S_ACCNT_POSTN. Denormalization is used to improve query performance.
(blank)		There is no domain specified for this column.