TaskInstanceRecurrence (ver24.10.0)
This table holds the task reminder configuration created from the My Tasks or Task Management pages or copied from the NotificationTaskDefinition table while created from a notification.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DayOfMonth | 24.10.0 | NUMBER(2,0) | The numbered day of the month in which a monthly or yearly recurring task will be due each month. Optional |
DayOfWeekForMonthYear | 24.10.0 | NUMBER(2,0) | The number representation (0-6) of the day of the week in which a monthly or yearly recurring task will be due. Optional. |
DaysOfWeek | 24.10.0 | VARCHAR2(16 CHAR) | A comma delimited list of numbers (0-6), representing the desired days of the week in which a weekly recurring task will be due. Optional. |
EndDate | 24.10.0 | DATE | The last date on which the recurring task could be due. Optional. |
EndOption | 24.10.0 | VARCHAR2(1 CHAR) | The selected option to determine how to end the recurring task. “D” for date, 'O' for after occurrences. Required. |
EndsAfterOccurrences | 24.10.0 | NUMBER(4,0) | The number of times the task should re-occur. Optional. |
ExcludeWeekends | 24.10.0 | NUMBER(1,0) | Indicate if weekends should be excluded from all calculations. Default 0. |
Frequency | 24.10.0 | NUMBER(3,0) | The number of RecurrencePattern iterations until the next occurrence of a task. Required. |
IterationOfWeekday | 24.10.0 | NUMBER(2,0) | The number representing which iteration of DayOfWeekForMonthYear a monthly or yearly task due date will re-occur within a given month. Optional. |
MonthOfYear | 24.10.0 | NUMBER(2,0) | The number representation of the month (1-12) in which a yearly recurring task will be due. Optional. |
RecurrencePattern | 24.10.0 | VARCHAR2(1 CHAR) | The period length for which the task should re-occur. ‘D' for daily, ’W' for weekly, 'M' for monthly, 'Y' for yearly. Required. |
StartDate | 24.10.0 | DATE | The earliest date in which the recurring task could be due. Required. |
TaskInstanceRecurrenceId | 24.10.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
WhenCreated | 24.10.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 24.10.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 24.10.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
WhoModifed | 24.10.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |