RT TICKET Table
This is a dimension table with information about tickets in Request Tracker, to be used in the RT Custom Field Detail and RT Transaction Detail stars for ticket information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TICKET_KEY |
Use this field to join between RT CUSTOM FIELD DETAIL and RT TICKET to get more information about the tickets and their custom fields. |
NUMBER |
11 |
TKT_1ST_OPENED_DATE |
Date and time on which the ticket's status was first set to "open". |
DATE |
8 |
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 |
8 |
TKT_1ST_RESOLVED_DATE |
Date on which the ticket was first resolved. |
DATE |
8 |
TKT_CREATED_DATE |
Date and Time on which the ticket was created. |
DATE |
8 |
TKT_CREATOR_KRB_NAME |
Kerberos principal/name of the person who created the ticket. |
VARCHAR2 |
10 |
TKT_CREATOR_UNIT_ID |
The lab/department/center ID with which the person who created the ticket is associated. |
VARCHAR2 |
50 |
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 |
8 |
TKT_FINAL_PRIORITY |
The priority that the ticket should have when its DueDate arrives. |
NUMBER |
11 |
TKT_ID |
ID Number of a Request Tracker's ticket. |
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 |
8 |
TKT_LAST_UPDATED_BY |
The person who last updated the ticket. |
VARCHAR2 |
50 |
TKT_LAST_UPDATED_DATE |
Date/time on which the ticket was last updated. |
DATE |
8 |
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 |
50 |
TKT_PRIORITY |
Indicates the level of importance of the issue represented by the ticket. |
NUMBER |
11 |
TKT_REQUESTOR |
Kerberos Name or email address of a person who made the ticket request. |
VARCHAR2 |
255 |
TKT_RESOLVED_DATE |
Date/time on which the ticket was last resolved. |
DATE |
8 |
TKT_STARTED_DATE |
Date/time on which work on the ticket was started. |
DATE |
8 |
TKT_STARTS_DATE |
Date/time on which work on the ticket was estimated to start. |
DATE |
8 |
TKT_STATUS |
Status of a Request Tracker's ticket. |
VARCHAR2 |
10 |
TKT_SUBJECT |
Subject of a ticket in Request Tracker. |
VARCHAR2 |
500 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |