This table stores the processing codes and descriptions for all of the common maintenance data elements. This is the detail table for sbyn_common_header. Each data element in sbyn_common_detail is associated with a data type in sbyn_common_header by the common_header_id column. None of the columns in this table can be null. The differences in data types between Oracle and SQL Server are noted in Table 11. The Oracle type is on the first line, and the SQL Server type is on the second.
Table 11 SBYN_COMMON_DETAIL Table Description
Column Name |
Data Type |
Description |
---|---|---|
NUMBER(10) numeric(10, 0) |
The unique identification code of the common table data element. |
|
NUMBER(10) numeric(10, 0) |
The unique identification code of the common table data type associated with the data element (as stored in the common_header_id column of the sbyn_common_header table). |
|
VARCHAR2(20) Varchar(20) |
The processing code for the common table data element. |
|
VARCHAR2(50) Varchar(50) |
A description of the common table data element. |
|
CHAR(1) |
An indicator of whether the common table data element can be modified. |
|
DATE datetime |
The date the data element record was created. |
|
VARCHAR2(20) Varchar(20) |
The user ID of the person who created the data element record. |