RY_IMMED_CNT_VW

(SQL View)
 Index Back

Bulk mail job count.

This view provides a count of bulk e-mails per action for immediately type.

SELECT RY_MILESTN_ID ,COUNT(*) CHILD_NUM FROM PS_RY_ACT_TASK WHERE RY_MILESTN_ID IN ( SELECT RY_ACTION_ID FROM PS_RY_ACT_TASK WHERE RY_ACT_TYPE_ID=4 AND RY_MD_ID=0) AND IS_EXEC_IMMEDIATE='Y' AND RY_ACT_TYPE_ID=1 AND RY_ACTION_ID NOT IN ( SELECT RY_ACTION_ID FROM PS_RY_SCH_EVENT_VW) GROUP BY RY_MILESTN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_MILESTN_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
2 RY_NUMBEROFJOBS Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.