SYSTEMCODE
|
VARCHAR2(20)
|
The unique processing code of the system.
|
DESCRIPTION
|
VARCHAR2(120)
|
A brief description of the system, or the system name. This
is the value that appears in the tree view panes of the MIDM 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
|
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)
|
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)
|
A mask used by the MIDM 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.
|
VALUE_MASK
|
VARCHAR2(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
|
The date the system information was inserted into the database.
|
CREATE_USERID
|
VARCHAR2(20)
|
The logon ID of the user who inserted the system information
into the database.
|
UPDATE_DATE
|
DATE
|
The most recent date the system’s information was updated.
|
UPDATE_USERID
|
VARCHAR2(20)
|
The logon ID of the user who last updated the system’s
information.
|