This table stores a description of each type of common maintenance data and is the header table for sbyn_common_detail. Together, these tables store the processing codes and drop-down menu descriptions for each common table data type. For a person index, common table data types might include Religion, Language, Marital Status, and so on. For a business index, common table data types might include Address Type, Phone Type, and so on. None of the columns in this table can be null.
The following table lists Oracle data types. For information about the differences in data types between database vendors, see Table 3.
Table 11 SBYN_COMMON_HEADER Table Description
Column Name |
Data Type |
Description |
---|---|---|
VARCHAR2(10) |
The unique identification code of the common table data type. |
|
VARCHAR2(10) |
The application ID from sbyn_appl that corresponds to the application for which the common table data type is used. |
|
VARCHAR2(8) |
A unique processing code for the common table data type. |
|
VARCHAR2(50) |
A description of the common table data type. |
|
CHAR(1) |
An indicator of whether an entry in the table is read-only (if this column is set to “Y”, the entry is read-only). |
|
NUMBER(10) |
The maximum number of characters allowed in the code column for the common table data type. |
|
VARCHAR2(3) |
This column is not currently used. |
|
DATE |
The date the common table data type record was created. |
|
VARCHAR2(20) |
The user ID of the person who created the common table data type record. |