RY_MAILJOB_VW

(SQL View)
 Index Back

Bulk mail job report SQL view

Dialog mail job report SQL view

SELECT bjob.RY_BULK_JOB_ID , bjob.RY_ACTION_ID , bjob.ADD_TO_QUEUE_DTTM , bjob.RY_JOB_STATUS , bjob.RY_PRNT_JOB_ID , bjob.ROW_LASTMANT_DTTM , bjob.RY_MESSAGE_QUEUED , bjob.RY_MESSAGE_SENT , bjob.RY_INSTANCE_ID , bjob.REPEAT_SEQ_NUMBER , act.IS_EXEC_IMMEDIATE , dlg.RY_DIALOG_NAME , act.LABEL_TEXT ACTION_LABEL , 0 RY_NUMBEROFJOBS , act.RY_MILESTN_ID , ms.LABEL_TEXT TIGGER_LABEL , bjob.IS_SMALL_JOB , CASE WHEN bjob.RY_PRNT_JOB_ID=0 THEN 'N' WHEN bjob.RY_PRNT_JOB_ID=bjob.RY_BULK_JOB_ID THEN 'N' ELSE 'Y' END , ' ' ACTION FROM PS_RY_BULK_JOB bjob ,PS_RY_ACT_TASK act ,PS_RY_DIALOG dlg ,PS_RY_ACT_TASK ms WHERE bjob.RY_ACTION_ID=act.RY_ACTION_ID AND act.DIALOG_ID=dlg.DIALOG_ID AND act.RY_MILESTN_ID=ms.RY_ACTION_ID

  • Related Language Record: RY_MAILJOB_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_BULK_JOB_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    2 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.
    3 ADD_TO_QUEUE_DTTM DateTime(26) TIMESTAMP This is the date and time it was added to the queue.
    4 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
    5 RY_PRNT_JOB_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    6 RY_LASTMODIFY_DT DateTime(26) TIMESTAMP Online Marketing Last Modified Date
    7 RY_MESSAGE_QUEUED Number(19,0) DECIMAL(19) NOT NULL Field used by Online Marketing.
    8 RY_MESSAGE_SENT Number(19,0) DECIMAL(19) NOT NULL Field used by Online Marketing.
    9 RY_INSTANCE_ID Number(4,0) SMALLINT NOT NULL Runtime Mail Engine Instance ID
    10 REPEAT_SEQ_NUMBER Number(18,0) DECIMAL(18) NOT NULL Repeat Number
    11 IS_EXEC_IMMEDIATE Character(1) VARCHAR2(1) NOT NULL IS_EXEC_IMMEDIATE
    12 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
    13 LABEL_TEXT Character(254) VARCHAR2(254) NOT NULL Activity Name
    14 RY_NUMBEROFJOBS Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    15 RY_MILESTN_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    16 RY_NAME254 Character(254) VARCHAR2(254) NOT NULL 254 character name field for names.
    17 IS_SMALL_JOB Character(1) VARCHAR2(1) NOT NULL If This Bulk Job is a Small Job
    N=No
    Y=Yes
    18 RY_INCLUDE_CHILD Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.
    N=No Children Job
    Y=Children Job Only

    Default Value: Y

    19 RY_CC_ACTION Character(10) VARCHAR2(10) NOT NULL Field used by Online Marketing.