RY_ACTION_IDRY_SING_EM_VW(SQL View) |
Index Back |
|---|---|
Sub-Record for Single Emailconnects the single email records together. |
| SELECT A.RY_ACTION_ID , B.RY_EMAIL_RESP_ID , C.RY_RECORD_ID FROM PS_RY_ACT_TASK A , PS_RY_SEND_RESP B , PS_RY_SEND_SPEC_AD C WHERE A.RY_ACTION_ID = B.RY_ACTION_ID AND B.RY_ACTION_ID = C.RY_ACTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_ACTION_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Id for a dialog element for the dialog designer. |
| 2 | RY_EMAIL_RESP_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 3 | RY_RECORD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |