RA_LB_ACTTSK1VW

(SQL View)
 Index Back

Dialog Email Actions

Lookup list of Dialog Actions for defining Dialog History - Email Sent audience builder criteria.

SELECT A.RY_ACTION_ID , D.RY_DIALOG_NAME , A.LABEL_TEXT , %TrimSubstr(%TrimSubstr(D.RY_DIALOG_NAME, 1, 254) %Concat '.' %Concat A.LABEL_TEXT , 1 , 254) RY_ACTION_FULLPATH FROM PS_RY_DIALOG D , PS_RYEDIALOG E , PS_RY_ACT_TASK A WHERE E.DIALOG_ID = D.DIALOG_ID AND A.DIALOG_ID = D.DIALOG_ID AND A.RY_ACT_TYPE_ID IN (1, 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.