|
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 |
|