RT TICKET DETAIL Table
View exposing Request Tracker ticket detail records by queue, status, creator, requestor, and fiscal month including subject, owner, priority, work and estimate times, dates, and counter attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_QUEUE_KEY |
Surrogate key identifying the rt queue. |
NUMBER |
11 |
RT_TICKET_CREATOR_KEY |
Surrogate key identifying the rt ticket creator. |
VARCHAR2 |
200 |
RT_TICKET_REQUESTOR_KEY |
Surrogate key identifying the rt ticket requestor. |
VARCHAR2 |
200 |
RT_TICKET_STATUS_KEY |
Surrogate key identifying the rt ticket status. |
VARCHAR2 |
10 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
TKT_1ST_OPENED_DATE |
Date associated with tkt 1st opened. |
DATE |
|
TKT_1ST_QUEUE_TRANSFER_DATE |
Date associated with tkt 1st queue transfer. |
DATE |
|
TKT_1ST_RESOLVED_DATE |
Date associated with tkt 1st resolved. |
DATE |
|
TKT_COUNTER |
Tkt counter associated with the record. |
VARCHAR2 |
1 |
TKT_CREATED_DATE |
Date associated with tkt created. |
DATE |
|
TKT_DAYS_BEFORE_1ST_OPENED |
Tkt days before 1st opened associated with the record. |
NUMBER |
11 |
TKT_DAYS_CREATE_LAST_RESOLVED |
Tkt days create last resolved associated with the record. |
NUMBER |
11 |
TKT_DAYS_ON_HOLD |
Tkt days on hold associated with the record. |
NUMBER |
11 |
TKT_DAYS_QUE_TRNSF_LAST_RESOLV |
Tkt days que trnsf last resolv associated with the record. |
NUMBER |
11 |
TKT_DUE_DATE |
Date associated with tkt due. |
DATE |
|
TKT_FINAL_PRIORITY |
Tkt final priority associated with the record. |
NUMBER |
11 |
TKT_ID |
Business identifier for the tkt. |
NUMBER |
11 |
TKT_INITIAL_PRIORITY |
Tkt initial priority associated with the record. |
NUMBER |
11 |
TKT_LAST_CONTACT_DATE |
Date associated with tkt last contact. |
DATE |
|
TKT_LAST_UPDATED_BY |
Tkt last updated by associated with the record. |
VARCHAR2 |
200 |
TKT_LAST_UPDATED_DATE |
Date associated with tkt last updated. |
DATE |
|
TKT_ORIGINATING_QUEUE_ID |
Business identifier for the tkt originating queue. |
NUMBER |
11 |
TKT_OWNER |
Tkt owner associated with the record. |
VARCHAR2 |
200 |
TKT_PRIORITY |
Tkt priority associated with the record. |
NUMBER |
11 |
TKT_RESOLVED_DATE |
Date associated with tkt resolved. |
DATE |
|
TKT_STARTED_DATE |
Date associated with tkt started. |
DATE |
|
TKT_STARTS_DATE |
Date associated with tkt starts. |
DATE |
|
TKT_SUBJECT |
Tkt subject associated with the record. |
VARCHAR2 |
510 |
TKT_TIME_ESTIMATED |
Tkt time estimated associated with the record. |
NUMBER |
11 |
TKT_TIME_WORKED |
Tkt time worked associated with the record. |
NUMBER |
11 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |