RD_CTCP_PHNE_VW (SQL View)	Index Back
contact snapshot phone vw This record is for the view that shows the primary Phone numbers of a Business Object by relationship.

RD_CTCP_PHNE_VW

(SQL View)

contact snapshot phone vw

This record is for the view that shows the primary Phone numbers of a Business Object by relationship.

SELECT P.PERSON_ID , E.PHONE 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 = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.