Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT TRANSACTION TYPE Table


Contains all the type of transactions (eg. Create, Comment, Correspond, Take) added to the ticket in Request Tracker.


Field Name

Description

Data Type

Length

RT_TRANSACTION_TYPE_KEY

Use this field to join between RT TRANSACTION TYPE and RT TRANSACTION DETAIL

VARCHAR2

255

TRANSACTION_TYPE

Type of transactions in Request Tracker.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8