Groups
TODO_TASK
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
SUBJECT | VARCHAR2 | 50 | Y | ||
TYPE_OF_TODO_TASK | NUMBER | 22 | Y | ||
ASSIGNED_TO_OPERATOR_ID | NUMBER | 22 | Y | ||
CREATION_DATE | DATE | 7 | Y | ||
SCHEDULED_END_TIME | DATE | 7 | Y | ||
ACTUAL_END | DATE | 7 | Y | ||
DESCRIPTION | VARCHAR2 | 1000 | Y | ||
TROUBLE_TICKET_ID | NUMBER | 22 | Y | ||
USERS_ID | NUMBER | 22 | Y | ||
RELATED_SERVICE_ID | NUMBER | 22 | Y | ||
STATUS_ID | NUMBER | 22 | Y | ||
REMINDER_TIME | NUMBER | 22 | Y | ||
TIMESTAMP_ALERT | DATE | 7 | Y | ||
REFERENCE_ID | NUMBER | 22 | Y | ||
CREATOR_ID | NUMBER | 22 | Y | ||
STATUS_CHANGED_BY_ID | NUMBER | 22 | Y | ||
CLOSING_COMMENT | VARCHAR2 | 4000 | Y | ||
CONTACT_PHONE_NUMBER | VARCHAR2 | 20 | Y | ||
CATEGORY_ID | NUMBER | 22 | Y | ||
CHANGED_BY_OPERATOR | NUMBER | 22 | Y | ||
| TODO_TASK_STEP_KEY | VARCHAR2 | 50 | Added with 10.3.1 to track progress through the to-do task flow | ||
| RELATED_OBJECT_TYPE | VARCHAR2 | 20 | Added with 10.3.1 to track progress through the to-do task flow | ||
| RELATED_OBJECT_ID | NUMBER | Added with 10.3.1 to track progress through the to-do task flow |