RT TRANSACTION DETAIL Table
Contains Request Tracker ticket transactions data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_QUEUE_KEY |
Use this field to join RT QUEUE with RT TICKET DETAIL, RT TRANSACTION DETAIL, or RT CUSTOM FIELD DETAIL. |
NUMBER |
11 |
RT_TICKET_CREATOR_KEY |
Use this field to join between RT TICKET CREATOR and RT TICKET DETAIL |
VARCHAR2 |
200 |
RT_TICKET_ID |
ID number of a Request Tracker's ticket. |
NUMBER |
11 |
RT_TICKET_REQUESTOR_KEY |
Use this field to join between RT TICKET REQUESTOR and RT TICKET DETAIL |
VARCHAR2 |
200 |
RT_TICKET_STATUS_KEY |
Use this field to join between RT TICKET STATUS and RT TICKET DETAIL |
VARCHAR2 |
10 |
RT_TRANSACTION_CREATOR_KEY |
Use this field to join between RT TRANSACTION CREATOR and RT TRANSACTION DETAIL |
VARCHAR2 |
200 |
RT_TRANSACTION_TYPE_KEY |
Use this field to join between RT TRANSACTION TYPE and RT TRANSACTION DETAIL |
VARCHAR2 |
20 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
TKT_1ST_OPENED_DATE |
Date and time on which the ticket's status was first set to "open". |
DATE |
|
TKT_1ST_QUEUE_TRANSFER_DATE |
Date and time on which the ticket was first transferred to another queue. If the ticket has never been transferred to another queue, this field will be blank. |
DATE |
|
TKT_1ST_RESOLVED_DATE |
Date on which the ticket was first resolved. |
DATE |
|
TKT_CREATED_DATE |
Date and Time on which the ticket was created. |
DATE |
|
TKT_DAYS_BEFORE_1ST_OPENED |
Number of days from the ticket's creation to the first time it was opened. |
NUMBER |
11 |
TKT_DAYS_CREATE_LAST_RESOLV |
Number of days from the ticket's creation to the last time it was resolved. |
NUMBER |
11 |
TKT_DAYS_ON_HOLD |
Number of days that the ticket was in the "waiting" status. |
NUMBER |
11 |
TKT_DAYS_QUE_TRNSF_LAST_RESOLV |
Number of days from the ticket's transfer to another queue, to the last time it was resolved. |
NUMBER |
11 |
TKT_DUE_DATE |
Date on which the work described in the ticket is due to be complete. |
DATE |
|
TKT_FINAL_PRIORITY |
The priority that the ticket should have when its DueDate arrives. |
NUMBER |
11 |
TKT_INITIAL_PRIORITY |
The priority that the ticket had when it was created. |
NUMBER |
11 |
TKT_LAST_CONTACT_DATE |
The most recent date/time that the requestor was contacted. |
DATE |
|
TKT_LAST_UPDATED_BY |
The person who last updated the ticket. |
VARCHAR2 |
200 |
TKT_LAST_UPDATED_DATE |
Date/time on which the ticket was last updated. |
DATE |
|
TKT_ORIGINATING_QUEUE_ID |
The queue in which the ticket was created. |
NUMBER |
11 |
TKT_OWNER |
The owner of the ticket. The owner is usually the person currently responsible for working on the ticket. |
VARCHAR2 |
200 |
TKT_PRIORITY |
Indicates the level of importance of the issue represented by the ticket. |
NUMBER |
11 |
TKT_RESOLVED_DATE |
Date/time on which the ticket was last resolved. |
DATE |
|
TKT_STARTED_DATE |
Date/time on which work on the ticket was started. |
DATE |
|
TKT_STARTS_DATE |
Date/time on which work on the ticket was estimated to start. |
DATE |
|
TKT_SUBJECT |
Subject of a ticket in Request Tracker. |
VARCHAR2 |
510 |
TKT_TIME_ESTIMATED |
Estimated number of minutes spent working on the ticket. |
NUMBER |
11 |
TKT_TIME_WORKED |
Actual number of minutes spent working on the ticket. |
NUMBER |
11 |
TRANS_COUNTER |
Used to count transaction records within a group on a report for Request Tracker Transaction. Always contains a value of 1. |
NUMBER |
|
TRANS_CREATED_DATE |
Date when the Request Tracker transaction was created. |
DATE |
|
TRANS_DESCRIPTION |
Description of a transaction in Request Trackcer. |
VARCHAR2 |
4000 |
TRANS_FIELD |
Custom field of a transaction in Request Tracker. |
VARCHAR2 |
40 |
TRANS_ID |
ID number of a transaction in Request Tracker. |
NUMBER |
11 |
TRANS_NEW_VALUE |
For a transaction representing a change in a field value, this is the new value. |
VARCHAR2 |
400 |
TRANS_OLD_VALUE |
For a transaction representing a change in a field value, this is the old value. |
VARCHAR2 |
400 |
TRANS_SUBJECT |
Subject of a transaction in Request Tracker. |
VARCHAR2 |
510 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |