test

Understanding Sun Master Index Processing (Repository)

SBYN_APPL

This table stores information about the applications used in the master index system. The differences in data types between Oracle and SQL Server are noted in Table 8. The Oracle type is on the first line, and the SQL Server type is on the second.

Table 8 SBYN_APPL Table Description

Column Name 

Data Type 

Description 

APPL_ID

NUMBER(10) 

Numeric(10, 0) 

The unique sequence number code for the listed application. 

CODE

VARCHAR2(8) 

Varchar(8) 

A unique code for the application. 

DESCR

VARCHAR2(30) 

Varchar(30) 

A brief description of the application. 

READ_ONLY

CHAR(1) 

An indicator of whether the current entry can be modified. If the value of this column is “Y”, the entry cannot be modified. 

CREATE_DATE

DATE 

datetime 

The date the application entry was created. 

CREATE_USERID

VARCHAR2(20) 

Varchar(20) 

The logon ID of the user who created the application entry.