RB_CASE_IBEM_VW (SQL View)	Index Back
Case linked Email Inbound view View for inbound Email information using Case Id.

RB_CASE_IBEM_VW

(SQL View)

Case linked Email Inbound view

View for inbound Email information using Case Id.

SELECT a.case_id , b.interaction_id , b.reply_to_address FROM PS_RI_SUB_INTERACT a , ps_rb_in_email b , ps_ri_interaction c WHERE a.interaction_id = b.interaction_id AND a.interaction_id = c.interaction_id AND c.rb_mcf_detail_type = 'IBEM'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

2 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id

3 REPLY_TO_ADDRESS Character(254) VARCHAR2(254) NOT NULL Email Address associated with the Reply To Person

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
2	INTERACTION_ID	Character(15)	VARCHAR2(15) NOT NULL	interaction id
3	REPLY_TO_ADDRESS	Character(254)	VARCHAR2(254) NOT NULL	Email Address associated with the Reply To Person