{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
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).