RY_SCH_EVENT(SQL Table) |
Index Back |
|---|---|
Schedule EventDetail Inforamtion for Schedule Events |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |