Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT QUEUE Table


Contains information about the existing queues in Request Tracker.


Field Name

Description

Data Type

Length

QUEUE_DESC

Description of a queue in Request Tracker, currently the same as the name of the queue.

VARCHAR2

255

QUEUE_ID

ID Number of a queue in Request Tracker

NUMBER

11

QUEUE_NAME

The name of a queue in Request Tracker

VARCHAR2

255

RT_QUEUE_KEY

Use this field to join RT QUEUE with RT TICKET DETAIL, RT TRANSACTION DETAIL, or RT CUSTOM FIELD DETAIL.

NUMBER

11

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8