| Column |
|---|
| 
Groups |
| Column |
|---|
|
TODO_TASK_CHANGES| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments | 1 |
|---|
ID | NUMBER | 22 | N | | Primary key2 | TODO_TASK_ID | NUMBER | 22 | N | | | | 3 | CHANGE_DATE | DATE | 7 | Y | | 4 | NEW_SUBJECT | VARCHAR2 | 50 | Y | | | | 5 | NEW_TYPE_OF_TODO_TASK | NUMBER | 22 | Y | | 6 | NEW_ASSIGNED_TO_OPERATOR_ID | NUMBER | 22 | Y | | 7 | NEW_CREATION_DATE | DATE | 7 | Y | | 8 | NEW_SCHEDULED_END_TIME | DATE | 7 | Y | | 9 | NEW_ACTUAL_END | DATE | 7 | Y | | 10 | NEW_DESCRIPTION | VARCHAR2 | 1000 | Y | | | | 11 | NEW_TROUBLE_TICKET_ID | NUMBER | 22 | Y | | 12 | NEW_USERS_ID | NUMBER | 22 | Y | | | | 13 | NEW_RELATED_SERVICE_ID | NUMBER | 22 | Y | | | | 14 | NEW_STATUS_ID | NUMBER | 22 | Y | | 15 | NEW_REMINDER_TIME | NUMBER | 22 | Y | | 16 | NEW_TIMESTAMP_ALERT | DATE | 7 | Y | | 17 | NEW_REFERENCE_ID | NUMBER | 22 | Y | | | | 18 | NEW_CREATOR_ID | NUMBER | 22 | Y | | 19 | NEW_STATUS_CHANGED_BY_ID | NUMBER | 22 | Y | | | | 20 | NEW_CLOSING_COMMENT | VARCHAR2 | 4000 | Y | | | | 21 | NEW_CONTACT_PHONE_NUMBER | VARCHAR2 | 20 | Y | | | | 22 | NEW_CHANGED_BY_OPERATOR | NUMBER | 22 | Y | | 23 | NEW_CATOGERY_ID | NUMBER | 22 | Y | | | | 24 | OLD_SUBJECT | VARCHAR2 | 50 | Y | | 25 | OLD_TYPE_OF_TODO_TASK | NUMBER | 22 | Y | | 26 | OLD_ASSIGNED_TO_OPERATOR_ID | NUMBER | 22 | Y | | | | 27 | OLD_CREATION_DATE | DATE | 7 | Y | | 28 | OLD_SCHEDULED_END_TIME | DATE | 7 | Y | | 29 | OLD_ACTUAL_END | DATE | 7 | Y | | 30 | OLD_DESCRIPTION | VARCHAR2 | 1000 | Y | | 31 | OLD_TROUBLE_TICKET_ID | NUMBER | 22 | Y | | 32 | OLD_USERS_ID | NUMBER | 22 | Y | | | | 33 | OLD_RELATED_SERVICE_ID | NUMBER | 22 | Y | | 34 | OLD_STATUS_ID | NUMBER | 22 | Y | | | | 35 | OLD_REMINDER_TIME | NUMBER | 22 | Y | | 36 | OLD_TIMESTAMP_ALERT | DATE | 7 | Y | | 37 | OLD_REFERENCE_ID | NUMBER | 22 | Y | | 38 | OLD_CREATOR_ID | NUMBER | 22 | Y | | 39 | OLD_STATUS_CHANGED_BY_ID | NUMBER | 22 | Y | | | | 40 | OLD_CLOSING_COMMENT | VARCHAR2 | 4000 | Y | | 41 | OLD_CONTACT_PHONE_NUMBER | VARCHAR2 | 20 | Y | | | | 42 | OLD_CHANGED_BY_OPERATOR | NUMBER | 22 | Y | | | | 43 | OLD_CATOGERY_ID | NUMBER | 22 | Y | | Misspelled CATOGERY, should be CATEGORY | | NEW_TODO_TASK_STEP_KEY | VARCHAR2 | 50 | | | Added with 10.3.1 to track to-do task progress through to-do task flow (see TODO_TASK). | | NEW_RELATED_OBJECT_TYPE | VARCHAR2 | 20 | | | Same as above | | NEW_RELATED_OBJECT_ID | NUMBER | | | | Same as above | | OLD_TODO_TASK_STEP_KEY | VARCHAR2 | 50 | | | Same as above | | OLD_RELATED_OBJECT_TYPE | VARCHAR2 | 20 | | | Same as above | | OLD_RELATED_OBJECT_ID | NUMBER | | | | Same as above |
|
| Column |
|---|
|
|
|