TODO_TASK

ID

NUMBER

22

N

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