Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT TICKET STATUS Table


Contains the status of the tickets in Request Tracker.


Field Name

Description

Data Type

Length

RT_TICKET_STATUS_KEY

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

VARCHAR2

10

TKT_STATUS_CODE

Status code (eg. "new", "open", "deleted", "resolved", "rejected", "stalled") of a ticket in Request Tracker.

VARCHAR2

10

TKT_STATUS_NAME

Status of a ticket in Request Tracker. See also TKT_STATUS_CODE.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

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

DATE

8