RB_MAILREAD_LOG(SQL Table) |
Index Back |
---|---|
Mail Reader Process LogThis table logs the processing information of all the instance of Mail Reader Process |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | MAIL_READ_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Instance of Mail Reader Process for logging information which can be used for Analytics purposes in the future |
2 | START_DTTM | DateTime(26) | TIMESTAMP |
start date time
Default Value: %datetime |
3 | END_DTTM | DateTime(26) | TIMESTAMP |
end date time
Default Value: %datetime |
4 | STRCT_EMAIL_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Counter to Store the Number of Structured E-mail process Per instance of Mail Reader |
5 | UNSTRCT_EMAIL_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Counter to Store Number Of Un Strucutrued E-mails Process Per Instance of Mail Reader |
6 | MAILBOX_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Counter to Store Number Of Un Strucutrued E-mails Process Per Instance of Mail Reader |
7 | EXCPT_EMAIL_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Counter to Store Number Of Exception E-mails Process Per Instance of Mail Reader |
8 | ATTCH_EMAIL_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Counter to Store the Number of E-mails taht has Attachments process Per instance of Mail Reader |
9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |