RY_SCH_EVENT(SQL Table) |
Index Back |
---|---|
Schedule EventDetail 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. |