RB_MAILREAD_LOG

(SQL Table)
Index Back

Mail Reader Process Log

This 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