| Column |
|---|
| 
Groups |
| Column |
|---|
|
TODO_TASK| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments | 1 |
|---|
ID | NUMBER | 22 | N | | Primary key2 | SUBJECT | VARCHAR2 | 50 | Y | | 3 | TYPE_OF_TODO_TASK | NUMBER | 22 | Y | | 4 | ASSIGNED_TO_OPERATOR_ID | NUMBER | 22 | Y | | 5 | CREATION_DATE | DATE | 7 | Y | | 6 | SCHEDULED_END_TIME | DATE | 7 | Y | | | | 7 | ACTUAL_END | DATE | 7 | Y | | 8 | DESCRIPTION | VARCHAR2 | 1000 | Y | | 9 | TROUBLE_TICKET_ID | NUMBER | 22 | Y | | 10 | USERS_ID | NUMBER | 22 | Y | | | | 11 | RELATED_SERVICE_ID | NUMBER | 22 | Y | | 12 | STATUS_ID | NUMBER | 22 | Y | | | | 13 | REMINDER_TIME | NUMBER | 22 | Y | | 14 | TIMESTAMP_ALERT | DATE | 7 | Y | | 15 | REFERENCE_ID | NUMBER | 22 | Y | | 16 | CREATOR_ID | NUMBER | 22 | Y | | 17 | STATUS_CHANGED_BY_ID | NUMBER | 22 | Y | | 18 | CLOSING_COMMENT | VARCHAR2 | 4000 | Y | | 19 | CONTACT_PHONE_NUMBER | VARCHAR2 | 20 | Y | | 20 | CATEGORY_ID | NUMBER | 22 | Y | | 21 | 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 (see also TODO_TASK_CHANGES) | | RELATED_OBJECT_TYPE | VARCHAR2 | 20 | | | Same as above | | RELATED_OBJECT_ID | NUMBER | | | | Same as above |
|
| Column |
|---|
|
|
|