RY_SM_ERR_VW(SQL View) |
Index Back |
|---|---|
Single Email SQL viewDialog Single Email failure and recovery report SQL view |
| SELECT doc.RY_DOC_ID ,que.RY_ERROR_CODE ,docvar.RY_NAME254 ,que.START_DTTM ,que.ROW_LASTMANT_DTTM FROM PS_RY_DOC doc ,PS_RY_ACT_TASK act ,PS_RY_SINGLE_QUE que ,PS_RY_DOC_VAR docvar WHERE doc.RY_MD_ID =act.RY_MD_ID AND act.RY_ACTION_ID=que.RY_ACTION_ID AND doc.RY_MD_ID=docvar.RY_MD_ID AND docvar.RY_DOC_TYPE >=20 AND docvar.RY_DOC_TYPE <=22 AND RY_ERROR_CODE<>' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RY_DOC_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Document ID - Dialog Document Main Sys ID |
| 2 | 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 |
| 3 | RY_TITLE254 | Character(254) | VARCHAR2(254) NOT NULL | Document Title - Dialog Document |
| 4 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 5 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |