RY_FM_QUE_VW

(SQL View)
 Index Back

Frequency Email Queue SQL view

Dialog Frequency Email Queue report SQL view

SELECT que.RY_RECORD_ID ,que.START_DTTM ,que.ROW_LASTMANT_DTTM ,que.RY_EMAIL_254 ,que.RY_FMAIL_STATUS ,md.RY_DATA_NAME ,doc.RY_DOC_ID ,doc.RY_MD_ID ,act.RY_ACTION_ID ,que.RY_FRQ_ERROR_CODE ,que.RY_BUK_SNGL_MAILER ,que.RY_QUE_END_DT ,dlg.RY_DIALOG_NAME ,que.RY_INSTANCE_ID FROM PS_RY_DOC doc ,PS_RY_MDATA md , PS_RY_ACT_TASK act ,PS_RY_FREQUE_QUE que ,PS_RY_DIALOG dlg WHERE md.RY_GROUP_ID='D' AND md.RY_MD_ID =doc.RY_MD_ID AND doc.RY_MD_ID=act.RY_MD_ID AND act.RY_ACTION_ID=que.RY_ACTION_ID AND dlg.DIALOG_ID=act.DIALOG_ID

  • Related Language Record: RY_FMQUE_LNG_VW

    • # 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 START_DTTM DateTime(26) TIMESTAMP start date time
    3 RY_LASTMODIFY_DT DateTime(26) TIMESTAMP Online Marketing Last Modified Date
    4 RY_EMAIL_254 Character(254) VARCHAR2(254) NOT NULL Email Address field to use as work field.
    5 RY_FMAIL_STATUS Character(4) VARCHAR2(4) NOT NULL Field used by Online Marketing for Frequency email status.
    FAIL=Failed
    PAUS=Paused
    QUE=Queued
    SEND=Sending
    STAG=Staged
    STOP=Stopped
    WAIT=Waiting
    6 RY_DATA_NAME Character(80) VARCHAR2(80) NOT NULL Document Name - Dialog Document, OLM
    7 RY_DOC_ID Number(18,0) DECIMAL(18) NOT NULL Document ID - Dialog Document Main Sys ID
    8 RY_MD_ID Number(18,0) DECIMAL(18) NOT NULL Metadata ID - Dialog document metadata table
    9 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.
    10 RY_FRQ_ERROR_CODE Character(4) VARCHAR2(4) NOT NULL Field used by Online Marketing for Frequency email error code.
    BEA=Bad Email Address
    BPF=Build Program Failed
    CDN=Campaign or Document is Null
    DNA=Data Not Accepted
    EAIN=Email Address is Null
    FLCD=Failed to Load Campaign or Doc
    FSME=Fail Mail Exception
    IOE=IO Exception
    MIN=Message is Null
    MSNR=Mail Server Not Running
    PE=Persistent Exception
    RNA=Recipient Not Accepted
    SNA=Sender Not Accepted
    TFE=Tag Format Exception
    VCRE=VC Rendering Exception
    11 RY_BUK_SNGL_MAILER Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.
    B=Mailcaster
    S=Single Emailer
    12 RY_QUE_END_DT Date(10) DATE Use for Online Marketing
    13 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
    14 RY_INSTANCE_ID Number(4,0) SMALLINT NOT NULL Runtime Mail Engine Instance ID