RT TICKET REQUESTOR Table
View exposing Request Tracker ticket requestor person records including MIT identifiers, Kerberos usernames, names, organizational attributes, and contact information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TICKET_REQUESTOR_KEY |
Surrogate key identifying the rt ticket requestor. |
VARCHAR2 |
200 |
TKT_REQUESTOR_FIRST_NAME |
Tkt requestor first name associated with the record. |
VARCHAR2 |
40 |
TKT_REQUESTOR_FULL_NAME |
Tkt requestor full name associated with the person. |
VARCHAR2 |
113 |
TKT_REQUESTOR_KRB_NAME |
Tkt requestor krb name associated with the record. |
VARCHAR2 |
8 |
TKT_REQUESTOR_LAST_NAME |
Tkt requestor last name associated with the record. |
VARCHAR2 |
40 |
TKT_REQUESTOR_MIDDLE_NAME |
Tkt requestor middle name associated with the record. |
VARCHAR2 |
30 |
TKT_REQUESTOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
TKT_REQUESTOR_OFFICE_LOCATION |
Tkt requestor office location associated with the record. |
VARCHAR2 |
33 |
TKT_REQUESTOR_OFFICE_PHONE |
Tkt requestor office phone associated with the record. |
VARCHAR2 |
20 |
TKT_REQUESTOR_PERSON_TYPE |
Tkt requestor person type associated with the record. |
VARCHAR2 |
30 |
TKT_REQUESTOR_UNIT_ID |
Business identifier for the tkt requestor unit. |
VARCHAR2 |
6 |
TKT_REQUESTOR_UNIT_NAME |
Tkt requestor unit name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |