PSM_ReportRunTimeRequest (ver6.0.0)
An entity that contains the parameters and attributes for a report request.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CronExpression | 6.0.0 | Varchar2(255) | The complex schedule option using cron expression format made up of seven sub-expressions that describe individual details of the schedule. |
ID | 6.0.0 | Number(19) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
IsParent | 9.0.0 | Number(1) | This value is set to 1 if and only if this request is a parent representing a group of subreports to run. |
IsScheduled | 6.0.0 | Number(3) | Flag to tell the ReportWorks scheduler if the request is scheduled or not: 0-not scheduled, 1-scheduled, 2-error scheduling, 3-expired schedule, 4-deleted schedule. |
ParentID | 9.0.0 | Number(19) | Unique ID of the parent request. Only populated if this record is a child request spawned from a parent request representing a group of subreports to run. |
RepeatCount | 6.0.0 | Number(10) | Number of time the scheduled report will be ran. |
RepeatInterval | 6.0.0 | Number(19) | How frequently the reports will run in milliseconds. |
ReportApplicationID | 6.0.0 | Number(19) | The report application entity to which the report runtime request record is related. Required. |
ReportContext | 6.0.0 | BLOB | The context of the submitted report needed to run the report. |
ReportGenUserID | 6.0.0 | Number(19) | The report gen user entity to which the report run time request record is related. Required. |
ReportPubID | 6.0.0 | Number(19) | The report publication identifier to which the report publication application category is related. Required. |
| ReportQueueDesc | 9.2.2 | Varchar2(2000) | Descriptive dynamic text about a particular report job that is displayed in the report queue. |
ScheduleEndTimestamp | 6.0.0 | Timestamp(6) | Date and time the job is last scheduled to run for multiple jobs. |
| ScheduleRequestID | 10.0.0 | Number(19) | The ID of the report runtime request record that represents the schedule which spawned this single request instance. If this instance was started immediately by a user, as opposed to being triggered by a schedule, then this value is left null. |
ScheduleStartTimestamp | 6.0.0 | Timestamp(6) | Date and time the job is first scheduled to run for multiple jobs. |
ScheduleType | 6.0.0 | Varchar2(20) | Saved Report context Scheduling option: Immediate, ASAP, At Night, On Weekend, or Specific Time. |