SBYN_OBJECT_NAMESBR (Understanding Sun Master Index Processing)

Understanding Sun Master Index Processing

SBYN_`OBJECT_NAME`SBR

This table stores the parent object of the SBR for each enterprise object in the master index database. It is linked to the tables that store each child object in the SBR by the object_nameid column (where object_name is the name of the parent object). This table contains the columns listed below regardless of the design of the object structure, and also contains a column for each field defined for the parent object in object.xml. In addition, columns to store standardized or phonetic versions of certain fields are automatically added when you specify certain match types in the wizard.

The following table lists Oracle data types. For information about the differences in data types between database vendors, see Table 3.

Table 4 SBYN_OBJECT_NAMESBR Table Description


Column Name	Data Type	Column Description
EUID	VARCHAR2(20)	The enterprise unique identifier assigned by the master index application.
`OBJECT_NAME`ID	VARCHAR2(20)	A unique ID for the parent object in a system record. This is named according to the parent object. For example, if the parent object is “Company”, the name of this column is “companyid”; if the parent object is “Person”, the name of this column is “personid”.