RT TRANSACTION DETAIL Table
View exposing Request Tracker transaction detail records by ticket, queue, creator, requestor, and transaction type including subject, description, changed fields, old and new values, transaction 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_ID |
Business identifier for the rt ticket. |
NUMBER |
11 |
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 |
RT_TRANSACTION_CREATOR_KEY |
Surrogate key identifying the rt transaction creator. |
VARCHAR2 |
200 |
RT_TRANSACTION_TYPE_KEY |
Surrogate key identifying the rt transaction type. |
VARCHAR2 |
20 |
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_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_RESOLV |
Tkt days create last resolv 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_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 |
TRANS_COUNTER |
Trans counter associated with the record. |
NUMBER |
|
TRANS_CREATED_DATE |
Date associated with trans created. |
DATE |
|
TRANS_DESCRIPTION |
Description of trans. |
VARCHAR2 |
4000 |
TRANS_FIELD |
Trans field associated with the record. |
VARCHAR2 |
40 |
TRANS_ID |
Business identifier for the trans. |
NUMBER |
11 |
TRANS_NEW_VALUE |
Trans new value associated with the record. |
VARCHAR2 |
400 |
TRANS_OLD_VALUE |
Trans old value associated with the record. |
VARCHAR2 |
400 |
TRANS_SUBJECT |
Trans subject associated with the record. |
VARCHAR2 |
510 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |