RD_CTCP_EMAL_VW (SQL View)	Index Back
contact snapshot email vw This is the record for the view that shows the Primary Email for the Business Object by Relationship.

RD_CTCP_EMAL_VW

(SQL View)

contact snapshot email vw

This is the record for the view that shows the Primary Email for the Business Object by Relationship.

SELECT P.PERSON_ID , E.EMAIL_ADDR FROM PS_BO_REL A , PS_BO_NAME B , PS_BO_CM_USE C , PS_BO_CM D , PS_CM E , PS_RD_PERSON P WHERE B.BO_ID = C.BO_ID AND C.PROFILE_CM_SEQ = D.PROFILE_CM_SEQ AND A.REL_TYPE_ID = 9 AND A.BO_ID_2 = C.BO_ID AND C.ROLE_TYPE_ID = 2 AND C.PRIMARY_IND = 'Y' AND D.CM_ID = E.CM_ID AND A.BO_ID_1 = P.BO_ID AND D.CM_TYPE_ID = 4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.