Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT Ticket


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

RT_TICKET_CREATOR

Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who created the ticket in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

08-JAN-2020

RT_QUEUE

Contains information about the existing queues in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

08-JAN-2020

RT_TICKET_REQUESTOR

Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who submitted the request in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

08-JAN-2020

RT_TICKET_DETAIL

Contains detail information about each ticket in Request Tracker.

Fact

Request Tracker

SENSITIVE

Daily

08-JAN-2020

RT_TICKET_STATUS

Contains the status of the tickets in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

08-JAN-2020