CST_QueryResultColumn (ver6.2.2)
This table allows the columns of a result to be specified for the purposes of consumption by a specific query class implementation associated with the query. Each record represents a query column. Not all query columns need to be called out in this table, only the ones that need to be operated on by the query class implementation.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 6.2.2 | Number(19,0) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
QueryResultID | 6.2.2 | Number(19,0) | The internal number for the associated CST_QueryResult record. |
SortIndex | 6.2.2 | Number(6,0) | Indexing field used by Hibernate. |
ColumnName | 6.2.2 | Varchar2(50) | The name of a column in the query result. |
SortOrder | 6.2.2 | Number(6,0) | Indicates the order by which results are arranged. |
WhenCreated | 6.2.2 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.2 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.2 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.2.2 | Varchar2(100) | The user login that modified the record. Defaults to database user. |