Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT CUSTOM FIELD Table


Contains the custom fields used in Request Tracker's tickets.


Field Name

Description

Data Type

Length

RT_CUSTOM_FIELD_KEY

Use this field to join between RT CUSTOM FIELD and RT CUSTOM FIELD DETAIL

VARCHAR2

200

RT_CUSTOM_FIELD_NAME

The name of a custom field asscoiated with a ticket in Request Tracker.

VARCHAR2

200

WAREHOUSE_LOAD_DATE

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

DATE

8