RY_ACTION_IDDNQ=Per Policy, Do Not Queue
POL=Per Policy
SEND=Override Policy
D=Do Not Increment
I=Increment
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
M=Not Repeating
R=Repeating
RY_ACT_TRIG_VW(SQL View) |
Index Back |
|---|---|
Action Task TableRY_ View that combines the Action Task table and the Milestone table in order to get both information in the same select. |
| SELECT %subrec(RY_ACT_TASK_SBR, A) , A.RYE_SYNCID , A.RYE_SYNCDTTM , B.RY_MILESTN_TYPE FROM PS_RY_ACT_TASK A , PS_RY_MILESTN B WHERE A.RY_ACTION_ID = B.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_MILESTN_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 3 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 4 | ACT_SUBTYPE | Number(4,0) | SMALLINT NOT NULL | ACT_SUBTYPE |
| 5 | LABEL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Activity Name |
| 6 | ORDER_INDEX | Number(6,0) | INTEGER NOT NULL | ORDER_INDEX |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 8 | ACT_DETAIL | Character(254) | VARCHAR2(254) NOT NULL | ACT_DETAIL |
| 9 | IS_RESPONSE_TASK | Character(1) | VARCHAR2(1) NOT NULL | IS_RESPONSE_TASK |
| 10 | RY_IS_TESTING | Character(1) | VARCHAR2(1) NOT NULL | Field used by Online Marketing. |
| 11 | RY_MD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata ID - Dialog document metadata table |
| 12 | IS_EXEC_IMMEDIATE | Character(1) | VARCHAR2(1) NOT NULL | IS_EXEC_IMMEDIATE |
| 13 | DELAY | Number(18,0) | DECIMAL(18) NOT NULL | Number for delay |
| 14 | RY_DELAY_UNITS | Character(3) | VARCHAR2(3) NOT NULL | Delay Units for timing in the dialog designer. |
| 15 | DELAY_DIRECTION | Character(1) | VARCHAR2(1) NOT NULL | DELAY_DIRECTION |
| 16 | EXACT_TIME | DateTime(26) | TIMESTAMP | EXACT_TIME |
| 17 | RY_GOTO_MILESTN_ID | Number(19,0) | DECIMAL(19) NOT NULL | Field used by Online Marketing. |
| 18 | RY_QUERY_SPEC_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 19 | RY_EMAIL_LIST_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 20 | RY_VC_REFER_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 21 | RY_CHARSET | Character(40) | VARCHAR2(40) NOT NULL | Character Set for Dialogs, used with emails. |
| 22 | RY_ACT_TYPE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Used to determine the type of Element for the Dialog. |
| 23 | RY_USE_DONOT_EMAIL | Character(1) | VARCHAR2(1) NOT NULL | Use the Do Not Email flag or not. "Y" is use, "N" is ignore. |
| 24 | RY_QUE_END_DT | Date(10) | DATE | Use for Online Marketing |
| 25 | RY_QUE_RULES | Character(4) | VARCHAR2(4) NOT NULL |
Default queue rules for the Email Frequency Policy.
DNQ=Per Policy, Do Not Queue POL=Per Policy SEND=Override Policy |
| 26 | RY_QUE_SHELF | Number(10,0) | DECIMAL(10) NOT NULL | Default queue shelf life for the Email Frequency Policy. |
| 27 | RY_CNT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Default counter action for the Email Frequency Policy.
D=Do Not Increment I=Increment |
| 28 | RY_EMAIL_OPEN_TRAC | Character(1) | VARCHAR2(1) NOT NULL |
Track email open rate. Y for track, N for don't track.
Y/N Table Edit Default Value: N |
| 29 | RY_TRIGER_ONDEMAND | Character(1) | VARCHAR2(1) NOT NULL |
Indecate the currect Dialog Datetime trigger is trigger on demand type.
Y/N Table Edit Default Value: N |
| 30 | RY_BM_EVENT_UPDATE | Character(1) | VARCHAR2(1) NOT NULL |
Indecate after send email, OLM sould ark the invited flag in the Event component.
Y/N Table Edit Default Value: N |
| 31 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 32 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 33 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 34 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 35 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 36 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 37 | RYE_SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | Online Marketing SYNCID for Dialog activity |
| 38 | RYE_SYNCDTTM | DateTime(26) | TIMESTAMP | SYNCDTTM for Dialog action, trigger. |
| 39 | RY_MILESTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Milestone Type, should be M: Milestone, R: Repeating
M=Not Repeating R=Repeating |