RA_LB_ACTTSK4VW

(SQL View)
 Index Back

Dialog Web Link Actions

Lookup list of Dialog Actions for defining Dialog History - Web Link Clicked audience builder criteria.

SELECT O.RY_VC_OBJ_ID RY_ACTION_ID , D.RY_DIALOG_NAME , O.RY_NAME LABEL_TEXT , %TrimSubstr(%TrimSubstr(D.RY_DIALOG_NAME, 1, 254) %Concat '.' %Concat O.RY_NAME , 1 , 254) RY_ACTION_FULLPATH FROM PS_RY_DIALOG D , PS_RYEDIALOG E , PS_RY_VC_OBJECT O WHERE E.DIALOG_ID = D.DIALOG_ID AND O.DIALOG_ID = D.DIALOG_ID AND O.RY_VC_TYPE_ID = 2 AND D.RY_DIALOG_STATUS IN ('A', 'P', 'S', 'I', 'C') AND E.RY_DIALOG_STATUS IN ('A', 'P', 'S', 'I', 'C')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.
2 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
3 LABEL_TEXT Character(254) VARCHAR2(254) NOT NULL Activity Name
4 RY_ACTION_FULLPATH Character(254) VARCHAR2(254) NOT NULL Field used by Online Marketing.