test

Understanding Sun Master Index Processing (Repository)

SBYN_MERGE

This table maintains a record of each merge transaction that occurs in the master index application, both through the EDM and from external systems. It also records any unmerges that occur. The differences in data types between Oracle and SQL Server are noted in Table 14. The Oracle type is on the first line, and the SQL Server type is on the second.

Table 14 SBYN_MERGE Table Description

Column Name 

Data Type 

Description 

MERGE_ID

VARCHAR2(20) 

Varchar(20) 

The unique, sequential identification code of merge record. This column cannot be null. 

KEPT_EUID

VARCHAR2(20) 

Varchar(20) 

The EUID of the record that was retained after the merge transaction. This column cannot be null. 

MERGED_EUID

VARCHAR2(20) 

Varchar(20) 

The EUID of the record that was not retained after the merge transaction. 

MERGE_TRANSACTIONNUM

VARCHAR2(20) 

Varchar(20) 

The transaction number associated with the merge transaction. This column cannot be null. 

UNMERGE_TRANSACTIONNUM

VARCHAR2(20) 

Varchar(20) 

The transaction number associated with the unmerge transaction.