| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | ID | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 2 | VERSION | FDT: Version | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | FIRST_OPERAND | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 4 | SECOND_OPERAND | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | THIRD_OPERAND | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 6 | OPERATION | FDT: Boolean Operation | char | 1 | 0 | | | | Allow NULL? |
| 7 | FIRST_INVERT | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 8 | SECOND_INVERT | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 9 | THIRD_INVERT | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 10 | INVERT | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 11 | FIRST_RANGE_P | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 12 | SECOND_RANGE_P | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 13 | THIRD_RANGE_P | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 14 | SELECT_1302 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 15 | SELECT_1303 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 16 | SELECT_1304 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 17 | OPTIMIZED_SELECT | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |