PSM_ReportRuntimeRequestView (ver9.0.0)

CronExpression

Varchar2(255)

[From PSM_ReportRuntimeRequest] The complex schedule option using cron expression format made up of seven sub-expressions that describe individual details of the schedule.

ID

Number(19)

[From PSM_ReportRuntimeRequest] Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required.

IsParent

Number(1)

[From PSM_ReportRuntimeRequest] This value is set to 1 if and only if this request is a parent representing a group of subreports to run.

IsScheduled

Number(3)

[From PSM_ReportRuntimeRequest] 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

Number(19)

[From PSM_ReportRuntimeRequest] 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.

Parent_ScheduleStartTimestamp

Timestamp(6)

[From PSM_ReportRuntimeRequest] The schedule start timestamp of the related parent request. Only contains a value if the request record is a child of a parent that represents a group of subreports to run.

RepeatCount

Number(10)

[From PSM_ReportRuntimeRequest] Number of time the scheduled report will be ran.

RepeatInterval

Number(19)

[From PSM_ReportRuntimeRequest] How frequently the reports will run in milliseconds.

ReportApplicationID

Number(19)

[From PSM_ReportRuntimeRequest] The report application entity to which the report runtime request record is related. Required.

ReportContext

BLOB

[From PSM_ReportRuntimeRequest] The context of the submitted report needed to run the report.

ReportGenUserI D

Number(19)

[From PSM_ReportRuntimeRequest] The report gen user entity to which the report run time request record is related. Required.

ReportPubID

Number(19)

[From PSM_ReportRuntimeRequest] The report publication identifier to which the report publication application category is related. Required.

ReportQueueDesc

Varchar2(1000)

[From PSM_ReportRuntimeRequest] Descriptive dynamic text about a particular report job that is displayed in the report queue.

ScheduleEndTimeStamp

Timestamp(6)

[From PSM_ReportRuntimeRequest] Date and time the job is last scheduled to run for multiple jobs.

ScheduleRequestID

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

Timestamp(6)

[From PSM_ReportRuntimeRequest] Date and time the job is first scheduled to run for multiple jobs.

ScheduleType

Varchar2(20)

[From PSM_ReportRuntimeRequest] Saved Report context Scheduling option: Immediate, ASAP, At Night, On Weekend, or Specific Time.