Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT TICKET STATUS Table


View exposing Request Tracker ticket status reference records including status codes and descriptions.


Field Name

Description

Data Type

Length

RT_TICKET_STATUS_KEY

Surrogate key identifying the rt ticket status.

VARCHAR2

64

TKT_STATUS_CODE

Code identifying tkt status.

VARCHAR2

64

TKT_STATUS_NAME

Tkt status name associated with the record.

VARCHAR2

64

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE