RD_DIALG_ACT_VW (SQL View)	Index Back
Dialog Entry Point View View of External Event Triggers for an online dialog.

RD_DIALG_ACT_VW

(SQL View)

Dialog Entry Point View

View of External Event Triggers for an online dialog.

SELECT A.DIALOG_ID , B.RY_ACTION_ID , B.LABEL_TEXT FROM PS_RY_DIALOG A , PS_RY_ACT_TASK B WHERE A.DIALOG_ID = B.DIALOG_ID AND B.RY_ACT_TYPE_ID = 5

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.

3 LABEL_TEXT Character(254) VARCHAR2(254) NOT NULL Activity Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
2	RY_ACTION_ID	Number(18,0)	DECIMAL(18) NOT NULL	Id for a dialog element for the dialog designer.
3	LABEL_TEXT	Character(254)	VARCHAR2(254) NOT NULL	Activity Name