Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
Related Links:
 

Data and Reporting Services


Request Tracker

 

Business area which contains data from the Request Tracker (RT) Ticket Tracking System.

Follow the links in the Tables in Group column to see a list of all the tables used in the star/group, together with information on how to combine the tables in a query.

Follow the links in the Data Model Diagram column (if available) to see a pictorial representation of the star.

Star/Table Group

Description

Tables in Group

Data Model Diagram

RT Custom Field

Information about Request Tracker ticket's custom fields.

RT Custom Field tables

RT Custom Field data model

RT Ticket

Information about Request Tracker tickets, their status, queue assigned to, user's questions and problems notes, and IS&T staff members solution.

RT Ticket tables

RT Ticket data model

RT Transaction

Information about Transactions associated with a Request Tracker ticket. Some of the data included are Transaction Subject and Description, Start Date, Due Date, Resolved Date, Transfer to another Queue Date, and Days on Hold.

RT Transaction tables

RT Transaction data model

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.