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 the Object Definition file. Columns to store standardized or phonetic versions of certain fields are automatically added when you specify certain match types in the wizard.
The differences in data types between Oracle and SQL Server are noted in Table 4. The Oracle type is on the first line, and the SQL Server type is on the second.
Table 4 SBYN_OBJECT_NAME Table Description
Column Name |
Data Type |
Column Description |
---|---|---|
VARCHAR2(20) Varchar(20) |
The system code for the system record. |
|
VARCHAR2(25) Varchar(25) |
A local identification code assigned by the specified system. |
|
OBJECT_NAMEID |
VARCHAR2(20) Varchar(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”. |
FIELD_NAME |
Varies |
The name of each field in the parent object. A database column is created for each field, and the data type depends on the type specified in the Object Definition file. |