TODO_TASK_CHANGES
- Søren Duusgaard (Deactivated)
Groups
TODO_TASK_CHANGES
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
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 | 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 |