		Home About IS&T Contact IS&T Site Map	Search Advanced Search

	Related Links:
	Data and Reporting Services

RT Transaction Detail

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_QUEUE	Contains information about the existing queues in Request Tracker.	Dimension	Request Tracker	SENSITIVE	Daily	04-SEP-2008
RT_TRANSACTION_CREATOR	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	04-SEP-2008
RT_TRANSACTION_DETAIL	Contains Request Tracker ticket transactions data.	Fact	Request Tracker	SENSITIVE	Daily	04-SEP-2008
RT_TRANSACTION_TYPE	Contains all the type of transactions (eg. Create, Comment, Correspond, Take) added to the ticket in Request Tracker.	Dimension	Request Tracker	SENSITIVE	Daily	04-SEP-2008
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	04-SEP-2008
RT_TICKET_CREATOR	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	04-SEP-2008


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