test

Understanding Sun Master Index Processing

SBYN_APPL

This table stores information about the applications used in the master index system. Currently, there is only one entry, “eView”. The following table lists Oracle data types. For information about the differences in data types between database vendors, see Table 3.

Table 7 SBYN_APPL Table Description

Column Name 

Data Type 

Description 

APPL_ID

NUMBER(10) 

The unique sequence number code for the listed application. 

CODE

VARCHAR2(8) 

A unique code for the application. 

DESCR

VARCHAR2(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 

The date the application entry was created. 

CREATE_USERID

VARCHAR2(20) 

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