Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT Transaction


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_TICKET

This is a dimension table with information about tickets in Request Tracker, to be used in the RT Custom Field Detail and RT Transaction Detail stars for ticket information.

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_TRANSACTION_DETAIL

Contains Request Tracker ticket transactions data.

Fact

Request Tracker

SENSITIVE

Daily

08-JAN-2020

RT_TRANSACTION_TYPE

Contains all the type of transactions (eg. Create, Comment, Correspond, Take) added to the ticket in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

08-JAN-2020

RT_TRANSACTION_CREATOR

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

Dimension

Request Tracker

SENSITIVE

Daily

08-JAN-2020