test

Understanding Sun Master Index Processing (Repository)

SBYN_SYSTEMSBR

This table stores transactional information about the system records for the SBR, such as the create or update date and function. The sbyn_systemsbr table is indirectly linked to the sbyn_systemobjects table through sbyn_enterprise. The differences in data types between Oracle and SQL Server are noted in Table 21. The Oracle type is on the first line, and the SQL Server type is on the second.

Table 21 SBYN_SYSTEMSBR Table Description

Column Name 

Data Type 

Description 

EUID

VARCHAR2(20) 

Varchar(20) 

The EUID associated with system record (the associated system and local ID are found in sbyn_enterprise). This column cannot be null. 

CHILDTYPE

VARCHAR2(20) 

Varchar(20) 

The type of object being processed (currently only the name of the parent object). This column is reserved for future use. 

CREATESYSTEM

VARCHAR2(20) 

Varchar(20) 

The system in which the system record was created. 

CREATEUSER

VARCHAR2(30) 

Varchar(30) 

The user ID of the person who created the system record. 

CREATEFUNCTION

VARCHAR2(20) 

Varchar(20) 

The type of transaction that created the system record. 

CREATEDATE

DATE 

datetime 

The date the system object was created. 

UPDATEUSER

VARCHAR2(30) 

Varchar(30) 

The user ID of the person who last updated the system record. 

UPDATEFUNCTION

VARCHAR2(20) 

Varchar(20) 

The type of transaction that last updated the system record. 

UPDATEDATE

DATE 

datetime 

The date the system object was last updated. 

STATUS

VARCHAR2(15) 

Varchar(15) 

The status of the enterprise record. The status can be one of these values: 

  • active

  • inactive

  • merged

REVISIONNUMBER

NUMBER(38) 

numeric(38, 0) 

The revision number of the SBR. This is used for version control.