RT TICKET REQUESTOR Table
Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who submitted the request in Request Tracker.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TICKET_REQUESTOR_KEY |
Use this field to join between RT TICKET REQUESTOR and RT TICKET DETAIL |
VARCHAR2 |
255 |
TKT_REQUESTOR_FIRST_NAME |
First name of the person who submitted the ticket. |
VARCHAR2 |
30 |
TKT_REQUESTOR_FULL_NAME |
Full Name of the person who submitted the ticket. |
VARCHAR2 |
100 |
TKT_REQUESTOR_KRB_NAME |
Kerberos name of the person who submitted the ticket in Request Tracker |
VARCHAR2 |
9 |
TKT_REQUESTOR_LAST_NAME |
Last name of the person who submitted the ticket. |
VARCHAR2 |
30 |
TKT_REQUESTOR_MIDDLE_NAME |
Middle name of the person who submitted the ticket. |
VARCHAR2 |
30 |
TKT_REQUESTOR_MIT_ID |
MIT ID number of the person who submitted the ticket in Request Tracker |
VARCHAR2 |
9 |
TKT_REQUESTOR_OFFICE_LOCATION |
The office address of the person who submitted the ticket. |
VARCHAR2 |
33 |
TKT_REQUESTOR_OFFICE_PHONE |
The office phone number of the person who submitted the ticket. |
VARCHAR2 |
20 |
TKT_REQUESTOR_PERSON_TYPE |
XXX |
VARCHAR2 |
30 |
TKT_REQUESTOR_UNIT_ID |
The lab/department/center ID with which the person who submitted the ticket is associated. |
VARCHAR2 |
50 |
TKT_REQUESTOR_UNIT_NAME |
The name of the lab/department/center with which the person who submitted 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 |