systemcode
|
The unique processing code of the system. This field accepts any of the following
characters:
|
description
|
A brief description of the system, or the system name.
Tip –
It is best to keep this short if possible; these values appear in the
tree views on the Enterprise Data Manager and can cause the box containing the tree views
to increase in width to accommodate all characters.
|
status
|
The status of the system in the master index system. Specify A for active or D for deactivated.
|
id_length
|
The length of the local
identifiers assigned by the system. This length does not include any additional
characters added by the input mask (see below).
Note –
The default maximum length of the LID database columns is 25.
If the system generates longer local IDs, be sure to increase the length of
all LID columns in the database.
|
format
|
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 Java. Note that the pattern specified here might
be further restricted by the input mask described below.
|
input_mask
|
A mask used by the EDM to add punctuation to the local ID. For
example, you can add an input mask to display the local IDs with hyphens or
constant characters. To define an input mask, enter a character type for each
character in the field and place any necessary punctuation between the types.
For example, to insert a hyphen after the second and fifth characters in an
8-digit ID, the input mask would be DD-DDD-DDD.
The following character types can be used; any other characters are treated
as constants.
-
D - indicates a numeric
character.
-
L - indicates an alphabetic
character.
-
A - indicates an alphanumeric
character.
If you use an input mask, you should also define a value mask to remove
the punctuation from the stored value.
|
value_mask
|
A mask used to strip any extra characters that were added by the input
mask. This mask ensures that data is stored in the database in the correct
format.
To specify a value mask, type the same value entered for the input mask,
but type an “x” in place of each punctuation mark. Using the 8-digit
input mask described above, you would specify a value mask of DDxDDDxDDD. This strips the hyphens before storing
the ID in the database.
|
create_date
|
The date the system information was inserted into the database. You
can specify “sysdate” for this column, or use the variables defined
in of the sample script.
|
create_userid
|
The logon ID of the user who inserted the system information into the
database. You can enter the logon ID or use the variables defined in of the
sample script.
|