RY_BULK_JOB(SQL Table) |
Index Back |
|---|---|
Bulk Email JobDetail Information for Bulk EMail Job |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RY_BULK_JOB_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 2 | RY_ACTION_ID | Number(18,0) | DECIMAL(18) NOT NULL | Id for a dialog element for the dialog designer. |
| 3 | ADD_TO_QUEUE_DTTM | DateTime(26) | TIMESTAMP | This is the date and time it was added to the queue. |
| 4 | RY_JOB_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
FAIL=Failed FINS=Finished INTR=Interrupted PASD=Parent Assigned PASG=Parent Assigning PFAL=Parent Failed PFIN=Parent Finished PPFN=Parent Partial Finished PQUE=Parent Queued QUED=Queued QUEG=Queuing RCVD=Recovered RCVG=Recovering RUNG=Running STPD=Stopped STPG=Stopping STPQ=Stopped while queued STPR=Stopped while running SUSP=Suspended |
| 5 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 6 | RY_MESSAGE_QUEUED | Number(19,0) | DECIMAL(19) NOT NULL | Field used by Online Marketing. |
| 7 | RY_MESSAGE_SENT | Number(19,0) | DECIMAL(19) NOT NULL | Field used by Online Marketing. |
| 8 | RY_INSTANCE_ID | Number(4,0) | SMALLINT NOT NULL | Runtime Mail Engine Instance ID |
| 9 | RY_PRNT_JOB_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 10 | REPEAT_SEQ_NUMBER | Number(18,0) | DECIMAL(18) NOT NULL | Repeat Number |
| 11 | RY_BEGIN_RECORD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 12 | RY_END_RECORD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing, used for end of record. |
| 13 | RY_RECOVER_JOB_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 14 | IS_SMALL_JOB | Character(1) | VARCHAR2(1) NOT NULL |
If This Bulk Job is a Small Job
N=No Y=Yes |
| 15 | RY_LOCK_MAILER_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 16 | RY_CREATOR_CLS_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 17 | RY_MSG_CLS_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |