test

Understanding Sun Master Index Processing (Repository)

SBYN_SYSTEMS

This table stores information about each system integrated into the master index environment, including the system’s processing code and name, a brief description, the format of the local IDs, and whether any of the system information should be masked. The differences in data types between Oracle and SQL Server are noted in Table 20. The Oracle type is on the first line, and the SQL Server type is on the second.

Table 20 SBYN_SYSTEMS Table Description

Column Name 

Data Type 

Description 

SYSTEMCODE

VARCHAR2(20) 

Varchar(20) 

The unique processing code of the system. 

DESCRIPTION

VARCHAR2(120) 

Varchar(120) 

A brief description of the system, or the system name. This is the value that appears in the tree view panes of the EDM for each system and local ID pair. 

STATUS

CHAR(1) 

The status of the system in the master index application. “A” indicates active and “D” indicates deactivated. 

ID_LENGTH

NUMBER 

numeric(38, 0) 

The length of the local identifiers assigned by the system. This length does not include any additional characters added by the input mask. 

FORMAT

VARCHAR2(60) 

Varchar(60) 

The required data pattern for the local IDs assigned by the system. For more information about possible values and using Java patterns, see “Patterns” in the class list for java.util.regex in the Javadocs provided with the Java™ 2 Platform, Standard Edition (J2SE™ platform). Note that the data pattern is also limited by the input mask described below. All regex patterns are supported if there is no input mask.

INPUT_MASK

VARCHAR2(60) 

Varchar(60) 

A mask used by the EDM to add punctuation to the local ID. For example, the input mask DD-DDD-DDD inserts a hyphen after the second and fifth characters in an 8-digit ID. These character types can be used.

  • D – Numeric character

  • L – Alphabetic character

  • A – Alphanumeric character

VALUE_MASK

VARCHAR2(60) 

Varchar(60) 

A mask used to strip any extra characters that were added by the input mask for database storage. The value mask is the same as the input mask, but with an “x” in place of each punctuation mark. Using the input mask described above, the value mask is DDxDDDxDDD. This strips the hyphens before storing the ID.

CREATE_DATE

DATE 

datetime 

The date the system information was inserted into the database. 

CREATE_USERID

VARCHAR2(20) 

Varchar(20) 

The logon ID of the user who inserted the system information into the database. 

UPDATE_DATE

DATE 

datetime 

The most recent date the system’s information was updated. 

UPDATE_USERID

VARCHAR2(20) 

Varchar(20) 

The logon ID of the user who last updated the system’s information.