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.
|
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.
|