RT TICKET CREATOR Table
Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who created the ticket in Request Tracker.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TICKET_CREATOR_KEY |
Use this field to join between RT TICKET CREATOR and RT TICKET DETAIL |
VARCHAR2 |
200 |
TKT_CREATOR_FIRST_NAME |
First name of the person who created the ticket. |
VARCHAR2 |
30 |
TKT_CREATOR_FULL_NAME |
Full Name of the person who created the ticket. |
VARCHAR2 |
100 |
TKT_CREATOR_KRB_NAME |
Kerberos principal/name of the person who created the ticket. |
VARCHAR2 |
10 |
TKT_CREATOR_LAST_NAME |
Last name of the person who created the ticket. |
VARCHAR2 |
30 |
TKT_CREATOR_MIDDLE_NAME |
Middle name of the person who created the ticket. |
VARCHAR2 |
30 |
TKT_CREATOR_MIT_ID |
MIT ID number of the person who created the ticket. |
VARCHAR2 |
9 |
TKT_CREATOR_OFFICE_LOCATION |
The office address of the person who created the ticket. |
VARCHAR2 |
33 |
TKT_CREATOR_OFFICE_PHONE |
The office phone number of the person who created the ticket. |
VARCHAR2 |
20 |
TKT_CREATOR_PERSON_TYPE |
XXX |
VARCHAR2 |
30 |
TKT_CREATOR_UNIT_ID |
The lab/department/center ID with which the person who created the ticket is associated. |
VARCHAR2 |
50 |
TKT_CREATOR_UNIT_NAME |
The name of the lab/department/center with which the person who created the ticket is associated. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |