RD_DQ_P_PHNSVW1 (SQL View)	Index Back
Person Phone for search result This view is used in person search result grid. It picks the first phone in the first address book entry.

RD_DQ_P_PHNSVW1

(SQL View)

Person Phone for search result

This view is used in person search result grid. It picks the first phone in the first address book entry.

SELECT A.BO_ID , A.PROFILE_CM_SEQ , A.CM_ID , A.PHONE FROM PS_RD_DQ_P_PHN_SVW A , PS_BO_ABE_DTL B WHERE A.BO_ID = B.BO_ID AND A.PROFILE_CM_SEQ = B.PROFILE_CM_SEQ AND B.ABE_SEQ = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

3 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
3	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
4	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.