RB_MAILREAD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	MAILBOX_ATTACH_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Counter to Store Number Of E-mails with Attachment Process Per Mailbox Per Instance of Mail Reader
3	MAILBOX_ERR_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Counter to Store Number Of Errored E-mails Process Per Mailbox Per Instance of Mail Reader
4	MAILBOX_EXCPT_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Counter to Store Number Of Exception E-mails Process Per Mailbox Per Instance of Mail Reader
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	RUNDTTM	DateTime(26)	TIMESTAMP	Run Date/Time
8	MAILBOX_ID	Character(30)	VARCHAR2(30) NOT NULL	Mail Box Id is an Id associated with Mail Boxes
9	CURR_SCHEDULE_DTTM	DateTime(26)	TIMESTAMP	Datetime of the Current Process
10	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
11	MAIL_SERVER_NAME	Character(250)	VARCHAR2(250) NOT NULL	Mail Server Name
12	EMAIL_ACCOUNT	Character(120)	VARCHAR2(120) NOT NULL	Email Address associated with a Mail Box Id
13	MAILBOX_POLL_FREQ	Number(3,0)	SMALLINT NOT NULL	Polling Frequency
14	POLLING_TIME_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Unit of time to use in getting Polling Frequency times for Mailbox D=Day(s) H=Hour(s) M=Minute(s)
15	PASSWORD	Character(254)	VARCHAR2(254) NOT NULL	Password
16	EMAILS_PER_FETCH	Number(10,0)	DECIMAL(10) NOT NULL	Parameter that controls the number of E-mails to be read in a Single Fetch
17	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
18	FUTR_SCHEDULE_DTTM	DateTime(26)	TIMESTAMP	Datetime of the Future Process
19	MAILBOX_STRCT_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Counter to Store Number Of Exception E-mails Process Per Mailbox Per Instance of Mail Reader
20	MAILBOX_USTRCT_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Counter to Store Number Of UnStructured E-mails Process Per Mailbox Per Instance of Mail Reader
21	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
22	EXCPT_EMAIL_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Counter to Store Number Of Exception E-mails Process Per Instance of Mail Reader
23	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
24	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
25	START_DTTM	DateTime(26)	TIMESTAMP	start date time
26	END_DTTM	DateTime(26)	TIMESTAMP	end date time
27	MAILBOX_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Counter to Store Number Of Un Strucutrued E-mails Process Per Instance of Mail Reader
28	FUTR_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Future Process Instance
29	RB_DUMMY1	Character(3)	VARCHAR2(3) NOT NULL	Multi-purpose Dummy field-----
30	CDH	Character(1)	VARCHAR2(1) NOT NULL	This is the field for the Customer Data Hub installed indicator. N=No Y=Yes
31	MCF_EMAIL_ID	Number(16,0)	DECIMAL(16) NOT NULL	Email Id
32	ROW_CNT	Number(18,0)	DECIMAL(18) NOT NULL	Audience Row Count
33	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
34	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
35	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
36	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
37	INTERACTION_ID	Character(15)	VARCHAR2(15) NOT NULL	interaction id
38	SQL_IN_LIST	Long Character	CLOB	Field is used to store In List for SQL