RT TICKET CREATOR Table
View exposing Request Tracker ticket creator person records including MIT identifiers, Kerberos usernames, names, organizational attributes, and contact information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TICKET_CREATOR_KEY |
Surrogate key identifying the rt ticket creator. |
VARCHAR2 |
200 |
TKT_CREATOR_FIRST_NAME |
Tkt creator first name associated with the record. |
VARCHAR2 |
40 |
TKT_CREATOR_FULL_NAME |
Tkt creator full name associated with the person. |
VARCHAR2 |
113 |
TKT_CREATOR_KRB_NAME |
Tkt creator krb name associated with the record. |
VARCHAR2 |
8 |
TKT_CREATOR_LAST_NAME |
Tkt creator last name associated with the record. |
VARCHAR2 |
40 |
TKT_CREATOR_MIDDLE_NAME |
Tkt creator middle name associated with the record. |
VARCHAR2 |
30 |
TKT_CREATOR_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_CREATOR_OFFICE_LOCATION |
Tkt creator office location associated with the record. |
VARCHAR2 |
33 |
TKT_CREATOR_OFFICE_PHONE |
Tkt creator office phone associated with the record. |
VARCHAR2 |
20 |
TKT_CREATOR_PERSON_TYPE |
Tkt creator person type associated with the record. |
VARCHAR2 |
30 |
TKT_CREATOR_UNIT_ID |
Business identifier for the tkt creator unit. |
VARCHAR2 |
6 |
TKT_CREATOR_UNIT_NAME |
Tkt creator unit name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |