| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | SET_ID | Unique ID - hex 16 - raw format | varbinary | 16 | 0 | | | | |
| 2 | OBJ_NAME | Object Name in Object Directory | nvarchar | 40 | 0 | | | | Allow NULL? |
| 3 | OBJ_TYPE | Object Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | MODULE_ID | Module key / ID | varbinary | 16 | 0 | | | | |
| 5 | MODULE_MSG_KEY | Module message key | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | CHECKSUM | Checksum based on CRC32 | int | 10 | 0 | | | | Allow NULL? |
| 7 | DB_STATE | CHAR01 data element for SYST | char | 1 | 0 | | | | Allow NULL? |
| 8 | NDX_PACKAGE | Natural Number | int | 10 | 0 | | | | Allow NULL? |
| 9 | HAS_BASIC_INFO | Boolean Variable (X=True, Space=False) | char | 1 | 0 | | | | Allow NULL? |
| 10 | ERROR_OBJ_TYPE | Object Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | ERROR_OBJ_NAME | Object Name in Object Directory | nvarchar | 40 | 0 | | | | Allow NULL? |
| 12 | KIND | Kind of verdict: 'Passed' , 'Not Passed', 'Inconclusive' | char | 1 | 0 | | | | Allow NULL? |
| 13 | PRIORITY | Priority | tinyint | 3 | 0 | | | | |
| 14 | NAVIG_DATA_LEN | Length of serialized data in bytes | smallint | 5 | 0 | | | | |
| 15 | NAVIG_DATA_CHK_1 | Serialized data (chunk of 255 bytes) | varbinary | 255 | 0 | | | | |
| 16 | NAVIG_DATA_CHK_2 | Serialized data (chunk of 255 bytes) | varbinary | 255 | 0 | | | | |
| 17 | DESCR_DATA_LEN | Length of serialized data in bytes | smallint | 5 | 0 | | | | |
| 18 | DESCR_DATA_CHK_1 | Serialized data (chunk of 255 bytes) | varbinary | 255 | 0 | | | | |
| 19 | DESCR_DATA_CHK_2 | Serialized data (chunk of 255 bytes) | varbinary | 255 | 0 | | | | |
| 20 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 21 | HOST | Host where execution was carried out | nvarchar | 32 | 0 | | | | Allow NULL? |
| 22 | EXCSTATE_CHKTIME | Exemption time | char | 1 | 0 | | | | Allow NULL? |
| 23 | EXCSTATE_ASSTIME | Exemption processing state | char | 1 | 0 | | | | Allow NULL? |
| 24 | EXC_KIND | Exemption kind | char | 1 | 0 | | | | Allow NULL? |
| 25 | EXC_VALIDITY | Validity of exemption | char | 1 | 0 | | | | Allow NULL? |
| 26 | EXC_APPROVAL | Exemption approval state | char | 1 | 0 | | | | Allow NULL? |
| 27 | EXC_GRANULARITY | Exemption granularity | char | 1 | 0 | | | | Allow NULL? |