CST_QueryResult (ver6.2.1.7)
This table provides information regarding a set of one or more results that may be associated with a query step.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 6.2.1.7 | Number(19,0) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
QueryID | 6.2.1.7 | Number(19,0) | The internal number for the associated CST_Query record. |
ResultName | 6.2.1.7 | Varchar2(255) | Unique (within the context of a report) name used to distinguish a particular result returned from a query. |
SortIndex | 6.2.1.7 | Number(6,0) | Indexing field used by Hibernate. |
SortOrder | 6.2.1.7 | Number(6,0) | Indicates the order by which results are arranged. |
WhenCreated | 6.2.1.7 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.1.7 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.1.7 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.2.1.7 | Varchar2(100) | The user login that modified the record. Defaults to database user. |