RY_SM_QUE_VW

(SQL View)
 Index Back

Single Email Queue SQL view

Dialog Single Email Queue report SQL view

SELECT que.RY_RECORD_ID ,que.START_DTTM ,que.ROW_LASTMANT_DTTM ,que.RY_EMAIL_254 ,que.RY_SMAIL_STATUS ,md.RY_DATA_NAME ,doc.RY_DOC_ID ,doc.RY_MD_ID ,act.RY_ACTION_ID ,que.RY_ERROR_CODE ,que.RY_INSTANCE_ID FROM PS_RY_DOC doc ,PS_RY_MDATA md , PS_RY_ACT_TASK act ,PS_RY_SINGLE_QUE que 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

# 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_SMAIL_STATUS Character(4) VARCHAR2(4) NOT NULL Field used by Online Marketing.
FAIL=Failed
PAUS=Paused
QUE=Queued
SCHD=Scheduled
SEND=Sending
STOP=Stopped
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_ERROR_CODE Character(4) VARCHAR2(4) NOT NULL Field used by Online Marketing.
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
REM=Individual has been removed
RNA=Recipient Not Accepted
SNA=Sender Not Accepted
TFE=Tag Format Exception
VCRE=VC Rendering Exception
11 RY_INSTANCE_ID Number(4,0) SMALLINT NOT NULL Runtime Mail Engine Instance ID