CST_Query (ver6.2.1.1)
This table is to be used for state reporting. It identifies the queries to be run for each report.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ExitAllQueriesOnDepFail | 6.2.2.2 | Number(1,0) | Indicates whether to exit all remaining queries in sequence if the query in question fails to have all its dependencies met. |
ID | 6.1.0 | Number(19,0) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
IsDatabaseSpecific | 6.1.0 | Number(1,0) | 1 indicates database specific syntax or functionality used in the SQL statement identified by QueryName. If QueryName is blank the SQL is found in the class identified by QueryClass. Defaults to 1. |
PhaseType | 6.2.1.1 | Number(6,0) | Indicates which subtype the record is representing. Valid values: 10 = Pre-process, 20 = Sub-process, 30 = Post-process, 40 = Post-render. |
QueryClass | 6.1.0 | Varchar2(255) | The name of the class associated with the type of query. |
QueryName | 6.1.0 | Varchar2(50) | The identifier of the SQL statement to be from the IBATIS SQL configuration maps. |
QuerySequence | 6.1.0 | Number(6,0) | Identifies to IBATIS the type of SQL statement. Valid values: Insert, Delete, Update, Select. |
QueryType | 6.1.0 | Varchar2(20) | Identifies to IBATIS the type of SQL statement, such as insert, delete, update, and select. |
ReportConfigID | 6.1.0 | Number(19,0) | The internal ID for the CST_ReportConfig record to which the record is associated. |
SortIndex | 6.1.0 | Number(6,0) | Indexing field used by Hibernate. |
WhenCreated | 6.2.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.2.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |