RT CUSTOM FIELD DETAIL Table
Contains all custom field names and the values used in Request Tracker's tickets.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CUSTOM_FIELD_COUNTER |
Used to count custom fields within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
CUSTOM_FIELD_VALUE |
Value for the custom field stored in the ticket. |
VARCHAR2 |
4000 |
RT_CUSTOM_FIELD_KEY |
Use this field to join between RT CUSTOM FIELD and RT CUSTOM FIELD DETAIL |
VARCHAR2 |
200 |
RT_QUEUE_KEY |
Use this field to join RT QUEUE with RT TICKET DETAIL, RT TRANSACTION DETAIL, or RT CUSTOM FIELD DETAIL. |
NUMBER |
11 |
RT_TICKET_KEY |
Use this field to join between RT CUSTOM FIELD DETAIL and RT TICKET to get more information about the tickets and their custom fields. |
NUMBER |
11 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |