RT TRANSACTION CREATOR Table
View exposing Request Tracker transaction creator person records including MIT identifiers, Kerberos usernames, names, organizational attributes, and contact information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TRANSACTION_CREATOR_KEY |
Surrogate key identifying the rt transaction creator. |
VARCHAR2 |
200 |
TRANS_CREATOR_FIRST_NAME |
Trans creator first name associated with the record. |
VARCHAR2 |
40 |
TRANS_CREATOR_FULL_NAME |
Trans creator full name associated with the person. |
VARCHAR2 |
113 |
TRANS_CREATOR_KRB_NAME |
Trans creator krb name associated with the record. |
VARCHAR2 |
8 |
TRANS_CREATOR_LAST_NAME |
Trans creator last name associated with the record. |
VARCHAR2 |
40 |
TRANS_CREATOR_MIDDLE_NAME |
Trans creator middle name associated with the record. |
VARCHAR2 |
30 |
TRANS_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 |
TRANS_CREATOR_OFFICE_LOCATION |
Trans creator office location associated with the record. |
VARCHAR2 |
33 |
TRANS_CREATOR_OFFICE_PHONE |
Trans creator office phone associated with the record. |
VARCHAR2 |
20 |
TRANS_CREATOR_PERSON_TYPE |
Trans creator person type associated with the record. |
VARCHAR2 |
30 |
TRANS_CREATOR_UNIT_ID |
Business identifier for the trans creator unit. |
VARCHAR2 |
6 |
TRANS_CREATOR_UNIT_NAME |
Trans creator unit name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |