Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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.

VARCHAR2

255

RT_TICKET_REQUESTOR_KEY

Use this field to join between RT TICKET REQUESTOR and RT TICKET DETAIL

VARCHAR2

255

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

255

RT_TRANSACTION_TYPE_KEY

Use this field to join between RT TRANSACTION TYPE and RT TRANSACTION DETAIL

VARCHAR2

255

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

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_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_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_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_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

TRANS_COUNTER

Used to count transaction records within a group on a report for Request Tracker Transaction. Always contains a value of 1.

NUMBER

1

TRANS_CREATED_DATE

Date when the Request Tracker transaction was created.

DATE

8

TRANS_DESCRIPTION

Description of a transaction in Request Trackcer.

VARCHAR2

4000

TRANS_FIELD

Custom field of a transaction in Request Tracker.

VARCHAR2

160

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

4000

TRANS_OLD_VALUE

For a transaction representing a change in a field value, this is the old value.

VARCHAR2

4000

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

8