RD_DQ_W_EMLSVW1 (SQL View)	Index Back
Worker Email for search result This view is used in worker search result grid. It picks the first email in the first address book entry.

RD_DQ_W_EMLSVW1

(SQL View)

Worker Email for search result

This view is used in worker 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_W_EML_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 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.