Understanding Sun Master Index Processing

SBYN_MERGE

This table maintains a record of each merge transaction that occurs in the master index application, both through the MIDM and from external systems. It also records any unmerges that occur. The following table lists Oracle data types. For information about the differences in data types between database vendors, see Table 3.

Table 13 SBYN_MERGE Table Description

Column Name 

Data Type 

Description 

MERGE_ID

VARCHAR2(20) 

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

KEPT_EUID

VARCHAR2(20) 

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

MERGED_EUID

VARCHAR2(20) 

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

MERGE_TRANSACTIONNUM

VARCHAR2(20) 

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

UNMERGE_TRANSACTIONNUM

VARCHAR2(20) 

The transaction number associated with the unmerge transaction.