SBYN_USER_CODE
This table is
similar to the sbyn_common_header and sbyn_common_detail tables in that it
stores processing codes and drop-down list values. This table is used when
the value of one field is dependent on the value of another. For example,
if you store credit card information, you could list each credit card type
and specify a required format for the credit card number field. The data stored
in this table includes the processing code, a brief description, and the format
of the dependent fields.
The differences in data types between Oracle and SQL Server are noted
in Table 23. The Oracle type is on the
first line, and the SQL Server type is on the second.
Table 23 SBYN_USER_CODE Table Description
|
Column Name
|
Data Type
|
Description
|
|
CODE_LIST
|
VARCHAR2(20)
Varchar(20)
|
The code list name of the user code type (using the credit card example
above, this might be similar to “CREDCARD”). This column links
the values for each list.
|
|
CODE
|
VARCHAR2(20)
Varchar(20)
|
The processing code of each user code element.
|
|
DESCRIPTION
|
VARCHAR2(50)
Varchar(50)
|
A brief description or name for the user code. This is the value that
appears in the drop-down list.
|
|
FORMAT
|
VARCHAR2(60)
Varchar(60)
|
The required data pattern for the field that is constrained by the user
code. 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 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 constrained
field. 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.
|
