SBYN_OBJECT_NAME (Understanding Sun Master Index Processing)

Understanding Sun Master Index Processing

SBYN_`OBJECT_NAME`

This table stores the parent object in each system record received by the master index application. It is linked to the tables that store each child object in the system record 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 you defined for the parent object in object.xml. 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 3 SBYN_OBJECT_NAME Table Description


Column Name	Data Type	Column Description
SYSTEMCODE	VARCHAR2(20)	The system code for the system record.
LID	VARCHAR2(25)	A local identification code assigned by the specified system.
`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”.