RY_ACTLBL_VW (SQL View)	Index Back
Case Survey Action ID view Retrieves External Event Trigger values for Case Survey configuration page.

RY_ACTLBL_VW

(SQL View)

Case Survey Action ID view

Retrieves External Event Trigger values for Case Survey configuration page.

SELECT DISTINCT a.DIALOG_ID ,a.RY_ACTION_ID , a.LABEL_TEXT FROM PS_RY_ACT_TASK a , PS_RY_ACT_TYPE b , PS_RY_ACT_REL c , PS_RY_ACT_TASK d WHERE a.RY_ACTION_ID = c.RY_ACTION_ID AND c.RY_CHLD_ACTION_ID = d.RY_ACTION_ID AND d.RY_ACT_TYPE_ID = 2 AND b.RY_ACT_TYPE = 'eventtriggertask' AND a.RY_ACT_TYPE_ID = b.RY_ACT_TYPE_ID

# 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.
Default Value: RC_SRVY_CFG_WRK.DIALOG_ID

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 External Event Trigger Name
Default Value: RY_ACTLBL_VW.LABEL_TEXT

#	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. Default Value: RC_SRVY_CFG_WRK.DIALOG_ID
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	External Event Trigger Name Default Value: RY_ACTLBL_VW.LABEL_TEXT