RA_LE_DIALOG_VW (SQL View)	Index Back
Lead Dialog association Association between a Lead ID and a Dialog ID

RA_LE_DIALOG_VW

(SQL View)

Lead Dialog association

Association between a Lead ID and a Dialog ID

SELECT L.LEAD_ID , L.DIALOG_ID , D.RY_DIALOG_NAME FROM PS_RSF_ASSOCIATION L , PS_RY_DIALOG D WHERE L.LEAD_ID <> ' ' AND L.TYPE = 'DLG' AND D.DIALOG_ID = L.DIALOG_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

2 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

3 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
3	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name.