TODO_TASK_CHANGES

ID

NUMBER

22

N

TODO_TASK_ID

NUMBER

22

N

CHANGE_DATE

DATE

7

Y

NEW_SUBJECT

VARCHAR2

50

Y

NEW_TYPE_OF_TODO_TASK

NUMBER

22

Y

NEW_ASSIGNED_TO_OPERATOR_ID

NUMBER

22

Y

NEW_CREATION_DATE

DATE

7

Y

NEW_SCHEDULED_END_TIME

DATE

7

Y

NEW_ACTUAL_END

DATE

7

Y

NEW_DESCRIPTION

VARCHAR2

1000

Y

NEW_TROUBLE_TICKET_ID

NUMBER

22

Y

NEW_USERS_ID

NUMBER

22

Y

NEW_RELATED_SERVICE_ID

NUMBER

22

Y

NEW_STATUS_ID

NUMBER

22

Y

NEW_REMINDER_TIME

NUMBER

22

Y

NEW_TIMESTAMP_ALERT

DATE

7

Y

NEW_REFERENCE_ID

NUMBER

22

Y

NEW_CREATOR_ID

NUMBER

22

Y

NEW_STATUS_CHANGED_BY_ID

NUMBER

22

Y

NEW_CLOSING_COMMENT

VARCHAR2

4000

Y

NEW_CONTACT_PHONE_NUMBER

VARCHAR2

20

Y

NEW_CHANGED_BY_OPERATOR

NUMBER

22

Y

NEW_CATOGERY_ID

NUMBER

22

Y

OLD_SUBJECT

VARCHAR2

50

Y

OLD_TYPE_OF_TODO_TASK

NUMBER

22

Y

OLD_ASSIGNED_TO_OPERATOR_ID

NUMBER

22

Y

OLD_CREATION_DATE

DATE

7

Y

OLD_SCHEDULED_END_TIME

DATE

7

Y

OLD_ACTUAL_END

DATE

7

Y

OLD_DESCRIPTION

VARCHAR2

1000

Y

OLD_TROUBLE_TICKET_ID

NUMBER

22

Y

OLD_USERS_ID

NUMBER

22

Y

OLD_RELATED_SERVICE_ID

NUMBER

22

Y

OLD_STATUS_ID

NUMBER

22

Y

OLD_REMINDER_TIME

NUMBER

22

Y

OLD_TIMESTAMP_ALERT

DATE

7

Y

OLD_REFERENCE_ID

NUMBER

22

Y

OLD_CREATOR_ID

NUMBER

22

Y

OLD_STATUS_CHANGED_BY_ID

NUMBER

22

Y

OLD_CLOSING_COMMENT

VARCHAR2

4000

Y

OLD_CONTACT_PHONE_NUMBER

VARCHAR2

20

Y

OLD_CHANGED_BY_OPERATOR

NUMBER

22

Y

OLD_CATOGERY_ID

NUMBER

22

Y