Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT Custom Field


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_QUEUE

Contains information about the existing queues 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_CUSTOM_FIELD_DETAIL

Contains all custom field names and the values used in Request Tracker's tickets.

Fact

Request Tracker

SENSITIVE

Daily

08-JAN-2020

RT_CUSTOM_FIELD

Contains the custom fields used in Request Tracker's tickets.

Dimension

Request Tracker

SENSITIVE

Daily

08-JAN-2020