RY_SCH_EVENT

(SQL Table)
Index Back

Schedule Event

Detail Inforamtion for Schedule Events

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_EVENT_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
2 EVENT_START_DTTM DateTime(26) TIMESTAMP Scheduler Events Start Date Time
3 RY_EVENT_STATUS Character(4) VARCHAR2(4) NOT NULL Field used by Online Marketing.
DUPL=Duplicated
FAIL=Failed
FINS=Finished
OVLP=Overlapped
QUED=Queued
RUNG=Running
SCHG=Scheduling
SKIP=Skipped
STPD=Stopped
STPQ=Stopped while queued
SUSP=Suspended
SUSR=Suspended while running
4 RY_EVENT_OP_CODE Character(4) VARCHAR2(4) NOT NULL Field used by Online Marketing.
CALL=Outbound Calls
EXMI=Execute
PRCM=Print Letters
SBEM=Send E-mails
SMS=Send Text Messages
5 RY_PARAM_LIST_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
7 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
8 REPEAT_SEQ_NUMBER Number(18,0) DECIMAL(18) NOT NULL Repeat Number
9 RY_SCHEDULER_ID Character(50) VARCHAR2(50) NOT NULL Field used by Online Marketing.
10 RY_SCH_DTTM DateTime(26) TIMESTAMP Field used by Online Marketing.