RY_DEDUP_VW

(SQL View)
 Index Back

SQL View for Email Dedup page

SQL View for Dialog Email Dedup page

SELECT jobnum.RY_RECORD_ID , jobnum.RY_BULK_JOB_ID , jobnum.CNT_TOTAL , jobnum.CNT_TOTAL_NO_EMAIL , jobnum.CNT_USED , aud.RA_LIST_NAME , aud.ROW_CNT , bjob.ADD_TO_QUEUE_DTTM , act.RY_MILESTN_ID , act.LABEL_TEXT , dlg.RY_DIALOG_NAME , bjob.RY_ACTION_ID , dlg.DIALOG_ID , bjob.RY_JOB_STATUS , bjob.ROW_LASTMANT_DTTM ,ms.LABEL_TEXT TRIGGER_LABEL , 0 RY_CNT_DUPL FROM PS_RY_BULK_DED_CNT jobnum , PS_RY_AUDIENCE aud , PS_RY_BULK_JOB bjob , PS_RY_ACT_TASK act , PS_RY_DIALOG dlg , PS_RY_ACT_TASK ms WHERE jobnum.RY_BULK_JOB_ID=bjob.RY_BULK_JOB_ID AND jobnum.RY_LIST_ID=aud.RY_LIST_ID AND bjob.RY_ACTION_ID=act.RY_ACTION_ID AND act.DIALOG_ID=dlg.DIALOG_ID AND ms.RY_ACTION_ID=act.RY_MILESTN_ID

  • Related Language Record: RY_DEDUP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_RECORD_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    2 RY_BULK_JOB_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    3 CNT_TOTAL Number(18,0) DECIMAL(18) NOT NULL Total Audience Count
    4 CNT_TOTAL_NO_EMAIL Number(18,0) DECIMAL(18) NOT NULL Total Do Not Email Count
    5 CNT_USED Number(18,0) DECIMAL(18) NOT NULL Total to be sent
    6 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name
    7 ROW_CNT Number(18,0) DECIMAL(18) NOT NULL Audience Row Count
    8 ADD_TO_QUEUE_DTTM DateTime(26) TIMESTAMP This is the date and time it was added to the queue.
    9 RY_MILESTN_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    10 LABEL_TEXT Character(254) VARCHAR2(254) NOT NULL Activity Name
    11 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
    12 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.
    13 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
    14 RY_JOB_STATUS Character(4) VARCHAR2(4) NOT NULL Field used by Online Marketing.
    FAIL=Failed
    FINS=Finished
    INTR=Interrupted
    PASD=Parent Assigned
    PASG=Parent Assigning
    PFAL=Parent Failed
    PFIN=Parent Finished
    PPFN=Parent Partial Finished
    PQUE=Parent Queued
    QUED=Queued
    QUEG=Queuing
    RCVD=Recovered
    RCVG=Recovering
    RUNG=Running
    STPD=Stopped
    STPG=Stopping
    STPQ=Stopped while queued
    STPR=Stopped while running
    SUSP=Suspended
    15 RY_LASTMODIFY_DT DateTime(26) TIMESTAMP Online Marketing Last Modified Date
    16 RY_NAME254 Character(254) VARCHAR2(254) NOT NULL 254 character name field for names.
    17 RY_CNT_DUPL Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.