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 following table lists Oracle data types. For information
about the differences in data types between database vendors, see Table 3.
Table 22 SBYN_USER_CODE Table Description
Column Name
|
Data Type
|
Description
|
CODE_LIST
|
VARCHAR2(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)
|
The processing code of each user code element.
|
DESCRIPTION
|
VARCHAR2(50)
|
A brief description or name for the user code. This is the value
that appears in the drop-down list.
|
FORMAT
|
VARCHAR2(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)
|
A mask used by the MIDM 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)
|
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.
|