RD_DQ_S_PHN_VW1 (SQL View)	Index Back
Site Phone for srch results This view is used in Site,Service Location search result grid. It picks the first phone in the first address book entry.

RD_DQ_S_PHN_VW1

(SQL View)

Site Phone for srch results

This view is used in Site,Service Location 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_S_PHN_VW 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.