RT TRANSACTION CREATOR Table
Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who created the Transacton for a ticket in Request Tracker.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RT_TRANSACTION_CREATOR_KEY |
Use this field to join between RT TRANSACTION CREATOR and RT TRANSACTION DETAIL |
VARCHAR2 |
255 |
TRANS_CREATOR_FIRST_NAME |
First name of the person who created the transaction. |
VARCHAR2 |
30 |
TRANS_CREATOR_FULL_NAME |
Full Name of the person who created the transaction. |
VARCHAR2 |
100 |
TRANS_CREATOR_KRB_NAME |
Kerberos name of the person who submitted the transaction in Request Tracker. |
VARCHAR2 |
9 |
TRANS_CREATOR_LAST_NAME |
Last name of the person who created the transaction. |
VARCHAR2 |
30 |
TRANS_CREATOR_MIDDLE_NAME |
Middle name of the person who created the transaction. |
VARCHAR2 |
30 |
TRANS_CREATOR_MIT_ID |
MIT ID number of the person who created the transaction. |
VARCHAR2 |
9 |
TRANS_CREATOR_OFFICE_LOCATION |
The office address of the person who created the transaction. |
VARCHAR2 |
33 |
TRANS_CREATOR_OFFICE_PHONE |
The office phone number of the person who created the transaction. |
VARCHAR2 |
20 |
TRANS_CREATOR_PERSON_TYPE |
XXX |
VARCHAR2 |
30 |
TRANS_CREATOR_UNIT_ID |
The lab/department/center ID with which the person who submitted the transaction is associated. |
VARCHAR2 |
50 |
TRANS_CREATOR_UNIT_NAME |
The name of the lab/department/center with which the person who created the transaction is associated. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |