MAILBOX_IDRUNDTTM00=Queued
01=Scheduled
02=Processing
03=Completed
04=Cancelled
05=Failed
06=All
RB_MLSCHDL_RQST(SQL Table) |
Index Back |
|---|---|
Scheduled Process TimesThis table stores all the Future Time for the MailBox_Id by deriving from Mailbox_poll_Freq of RB_MAILBOX_DEFN table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MAILBOX_ID |
Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 2 | RUNDTTM |
DateTime(26) | TIMESTAMP | Run Date/Time |
| 3 | RQSTDTTM | DateTime(26) | TIMESTAMP | Request Date/Time |
| 4 | CANCEL_DTTM | DateTime(26) | TIMESTAMP | Canceled Date Time |
| 5 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 6 | ADD_MAILREAD_INST | Number(16,0) | DECIMAL(16) NOT NULL | Instance of Mail Reader Process for logging information which can be used for Analytics purposes in the future |
| 7 | UPD_MAILREAD_INST | Number(16,0) | DECIMAL(16) NOT NULL | Instance of Mail Reader Process for logging information which can be used for Analytics purposes in the future |
| 8 | RQST_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Requested status code.................
00=Queued 01=Scheduled 02=Processing 03=Completed 04=Cancelled 05=Failed 06=All |
| 9 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Used to store the identification number for the reason code. |
| 10 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |