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 differences in data types between Oracle and SQL Server are noted in Table 12. The Oracle type is on the first line, and the SQL Server type is on the second.
Table 12 SBYN_COMMON_HEADER Table Description
Column Name |
Data Type |
Description |
---|---|---|
VARCHAR2(10) Varchar(10) |
The unique identification code of the common table data type. |
|
VARCHAR2(10) Varchar(10) |
The application ID from sbyn_appl that corresponds to the application for which the common table data type is used. |
|
VARCHAR2(8) Varchar(8) |
A unique processing code for the common table data type. |
|
VARCHAR2(50) Varchar(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) numeric(10, 0) |
The maximum number of characters allowed in the code column for the common table data type. |
|
VARCHAR2(3) Varchar(3) |
This column is not currently used. |
|
DATE datetime |
The date the common table data type record was created. |
|
VARCHAR2(20) Varchar(20) |
The user ID of the person who created the common table data type record. |