CST_ReportProcess (ver6.1.0)
This table is to be used for state reporting. It contains metadata about pending and completed report requests.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CreationTime | 6.1.0 | Timestamp(6) | The time the request was originated. |
EndTime | 6.1.0 | Timestamp(6) | The time that processing of the request completed. |
ErrorOutput | 6.2.1 | BLOB | A serialized java object that represents the error or exception that occurred while trying to generate the report. |
ExitAllQueries | 6.2.2 | Number(1,0) | This is the "exit all remaining queries" flag for an actual report request instance. If it is set to true (1), and a query dependency condition for a specific query step is failed to be met, then all subsequent query steps are automatically skipped. |
FileOutputData | 6.2.0 | BLOB | The output of report generation. Formats include csv, excel, html, jpeg, pdf, png, and rtf. |
FileOutputPath | 6.1.0 | Varchar2(500) | The fully qualified path of the output file generated as a result of this report request. |
| HostAddress | 8.1.0 | Varchar2(100) | Used to track which ReportWorks node instance is servicing a report request. In server array environments, there may be multiple nodes that service SRP report requests. |
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. |
IsEmptyRecordSet | 6.2.1.1 | Number(1,0) | Indicates whether or not at least one record was returned. 1 = At least one record was returned. 0 = No records were returned. |
PartitionType | 6.1.0 | Varchar2(50) | The partition type to use for sub-processing. This would typically be set to School. |
ReportName | 6.1.0 | Varchar2(50) | A unique identifier for the report. Required. |
ResultTableName | 6.1.0 | Varchar2(50) | The name of the result table generated for the report request. |
StartTime | 6.1.0 | Timestamp(6) | The time that processing of the request began. |
StateCode | 6.1.0 | Varchar2(10) | The state code associated with the report. Required. |
Status | 6.2.0 | Number(19,0) | The numeric code of the state of the report request Valid values: -0 = Pending, 11 = Pre-Process Querying, 12 = Sub-Process Querying, 13 = Post-Process Querying, 20 = Rendering, 14 = Post-Render Querying, 30 = Complete, 100 = Error. |
StatusDesc | 6.2.0 | Varchar2(50) | A descriptive string of the state of the report request. Valid values: Pending, Pre-Process Querying, Sub-Process Querying, Post-Process Querying, Rendering, Post-Render Querying, Complete, and Error. |
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. |