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 Ticket |
Information about Request Tracker tickets, their status, queue assigned to, user's questions and problems notes, and IS&T staff members solution. |
||
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. |
