MIT Data & Reporting Services

 

data warehouse logo 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_CUSTOM_FIELD

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

Dimension

Request Tracker

SENSITIVE

Daily

05-DEC-2009

RT_QUEUE

Contains information about the existing queues in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

05-DEC-2009

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

05-DEC-2009

RT_CUSTOM_FIELD_DETAIL

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

Fact

Request Tracker

SENSITIVE

Daily

05-DEC-2009