Understanding Sun Master Index Processing

SBYN_AUDIT

This table maintains a log of each instance in which any of the master index database tables are accessed through the MIDM. This includes each time a record appears on a search results page, a comparison page, the Record Details page, and so on. This log is only maintained if the MIDM is configured for it. This table can grow very large over time and might require periodic archiving.

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

Table 9 SBYN_AUDIT Table Description

Column Name 

Data Type 

Description 

AUDIT_ID

VARCHAR2(20) 

The unique identification code for the audit record. This column cannot be null. 

PRIMARY_OBJECT_TYPE

VARCHAR2(20) 

The name of the parent object as defined in object.xml.

EUID

VARCHAR2(15) 

The EUID whose information was accessed during an MIDM transaction. 

EUID_AUX

VARCHAR2(15) 

The second EUID whose information was accessed during an MIDM transaction. A second EUID appears when viewing information about merge and unmerge transactions, comparisons, and so on. 

FUNCTION (Oracle)

OPERATION (SQL Server)

VARCHAR2(32) 

The type of transaction that caused the audit record to be written. This column cannot be null. 

DETAIL

VARCHAR2(120) 

A brief description of the transaction that caused the audit record to be written. 

CREATE_DATE

DATE 

The date the transaction that created the audit record was performed. This column cannot be null. 

CREATE_BY

VARCHAR2(20) 

The user ID of the person who performed the transaction that caused the audit log. This column cannot be null.