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

RD_DQ_S_EML_VW1

(SQL View)

Site Email for srch results

This view is used in Site,Service Location search result grid. It picks the first Email in the first address book entry.

SELECT A.BO_ID , A.PROFILE_CM_SEQ , A.CM_ID , A.EMAIL_ADDR FROM PS_RD_DQ_S_EML_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 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	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	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.