| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | DETAILNO | Link between master and detail result table | int | 10 | 0 | | | | Allow NULL? |
| 2 | PARAM | Informix/OS parameter name (to check): LTXHWM, ... | nvarchar | 50 | 0 | | | | Allow NULL? |
| 3 | PERFORMANC | Performance check or not ('Y'/'N') ? | char | 1 | 0 | | | | Allow NULL? |
| 4 | CKDETAILNO | (Serial) detail number of logical check (LTXHWM: 1 & 2) | smallint | 5 | 0 | | | | |
| 5 | ONCFGFLAG | Check tool: got param from oncfg table or file | char | 1 | 0 | | | | Allow NULL? |
| 6 | OCLASS | Origin class of parameter: 'ONCONFIG','OS',... | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | SEVERITY | Check severity: 'A'...abort, 'E'...error, 'W'...warning | char | 1 | 0 | | | | Allow NULL? |
| 8 | CHECKOP | Check operator: '=','!=','<','>','<=','>=' or 'D' -> dynamic | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | CHECKVAL | Absolute check value or 'D' (-> dynamic check) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 10 | ACTVAL | Actual (absolute) value (found by infcfgcheck) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 11 | BYTEUNIT | Byte unit of check value: T...tera, G...giga, M...mega, ... | char | 1 | 0 | | | | Allow NULL? |
| 12 | MODTIME | Modification (or inserting) timestamp (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 13 | MODUSER | Normal SAP User or Special User '#SAP#' | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | MSGTEXT | Detail message text for check | nvarchar | 80 | 0 | | | | Allow NULL? |