RT TICKET Table
View exposing Request Tracker ticket summary records including ticket identifiers, status, requestor, subject, owner, priority, work and estimate times, key dates, creator, and lifecycle measures.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TICKET_KEY |
Surrogate key identifying the rt ticket. |
NUMBER |
11 |
TKT_1ST_OPENED_DATE |
Date associated with tkt 1st opened. |
DATE |
|
TKT_1ST_QUEUE_TRANSFER_DATE |
Date associated with tkt 1st queue transfer. |
DATE |
|
TKT_1ST_RESOLVED_DATE |
Date associated with tkt 1st resolved. |
DATE |
|
TKT_CREATED_DATE |
Date associated with tkt created. |
DATE |
|
TKT_CREATOR_KRB_NAME |
Tkt creator krb name associated with the record. |
VARCHAR2 |
8 |
TKT_CREATOR_UNIT_ID |
Business identifier for the tkt creator unit. |
VARCHAR2 |
6 |
TKT_DAYS_BEFORE_1ST_OPENED |
Tkt days before 1st opened associated with the record. |
NUMBER |
11 |
TKT_DAYS_CREATE_LAST_RESOLV |
Tkt days create last resolv associated with the record. |
NUMBER |
11 |
TKT_DAYS_ON_HOLD |
Tkt days on hold associated with the record. |
NUMBER |
11 |
TKT_DAYS_QUE_TRNSF_LAST_RESOLV |
Tkt days que trnsf last resolv associated with the record. |
NUMBER |
11 |
TKT_DUE_DATE |
Date associated with tkt due. |
DATE |
|
TKT_FINAL_PRIORITY |
Tkt final priority associated with the record. |
NUMBER |
11 |
TKT_ID |
Business identifier for the tkt. |
NUMBER |
11 |
TKT_INITIAL_PRIORITY |
Tkt initial priority associated with the record. |
NUMBER |
11 |
TKT_LAST_CONTACT_DATE |
Date associated with tkt last contact. |
DATE |
|
TKT_LAST_UPDATED_BY |
Tkt last updated by associated with the record. |
VARCHAR2 |
200 |
TKT_LAST_UPDATED_DATE |
Date associated with tkt last updated. |
DATE |
|
TKT_ORIGINATING_QUEUE_ID |
Business identifier for the tkt originating queue. |
NUMBER |
11 |
TKT_OWNER |
Tkt owner associated with the record. |
VARCHAR2 |
200 |
TKT_PRIORITY |
Tkt priority associated with the record. |
NUMBER |
11 |
TKT_REQUESTOR |
Tkt requestor associated with the record. |
VARCHAR2 |
200 |
TKT_RESOLVED_DATE |
Date associated with tkt resolved. |
DATE |
|
TKT_STARTED_DATE |
Date associated with tkt started. |
DATE |
|
TKT_STARTS_DATE |
Date associated with tkt starts. |
DATE |
|
TKT_STATUS |
Tkt status associated with the record. |
VARCHAR2 |
64 |
TKT_SUBJECT |
Tkt subject associated with the record. |
VARCHAR2 |
510 |
TKT_TIME_ESTIMATED |
Tkt time estimated associated with the record. |
NUMBER |
11 |
TKT_TIME_WORKED |
Tkt time worked associated with the record. |
NUMBER |
11 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |