OPRIDPrompt Table: RB_MAILBOX_DEFN
1=Days
2=Hours
3=Minutes
Default Value: 2
Y/N Table Edit
00=Queued
01=Scheduled
02=Processing
03=Completed
04=Cancelled
05=Failed
06=All
Prompt Table: RB_EMAIL_FILTER
RB_MAILREAD_MTR(SQL Table) |
Index Back |
|---|---|
Mailreader MonitorMailreader Monitor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | FROM_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 |
| 3 | TO_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 |
| 4 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL |
Mail Box Id is an Id associated with Mail Boxes
Prompt Table: RB_MAILBOX_DEFN |
| 5 | FILTERVALUE4 | Number(4,0) | SMALLINT NOT NULL | Filter Value |
| 6 | FILTERUNIT4 | Character(1) | VARCHAR2(1) NOT NULL |
Filter Unit added for MCF
1=Days 2=Hours 3=Minutes Default Value: 2 |
| 7 | EXCP_EMAIL_ALONE | Character(1) | VARCHAR2(1) NOT NULL |
Flag for filtering the instances with Exception Emails Alone
Y/N Table Edit |
| 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 | MAIL_FILTER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Id filed of Mail filter Table
Prompt Table: RB_EMAIL_FILTER |