RT Transaction
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 |
|---|---|---|---|---|---|---|
Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who created the ticket in Request Tracker. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Contains information about the existing queues in Request Tracker. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
01-JAN-2025 |
|
Contains Request Tracker ticket transactions data. |
Fact |
Request Tracker |
SENSITIVE |
Daily |
01-JAN-2025 |
|
Contains all the type of transactions (eg. Create, Comment, Correspond, Take) added to the ticket in Request Tracker. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
01-JAN-2025 |
|
Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who created the Transacton for a ticket in Request Tracker. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
01-JAN-2025 |