Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RT CUSTOM FIELD DETAIL Table


View exposing Request Tracker custom-field values by ticket and queue including field keys, values, and record counter attributes.


Field Name

Description

Data Type

Length

CUSTOM_FIELD_COUNTER

Custom field counter associated with the record.

NUMBER

CUSTOM_FIELD_VALUE

Custom field value associated with the record.

VARCHAR2

255

RT_CUSTOM_FIELD_KEY

Surrogate key identifying the rt custom field.

VARCHAR2

200

RT_QUEUE_KEY

Surrogate key identifying the rt queue.

NUMBER

11

RT_TICKET_KEY

Surrogate key identifying the rt ticket.

NUMBER

11

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE