TRAVEL DELEGATE DETAIL Table
View exposing travel delegate assignments including travel profile, delegate identity, delegate contact information, and delegate permissions used in travel and expense workflow processing.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CAN_APPROVE |
Indicator identifying whether the delegate can approve travel documents (Y/N). |
VARCHAR2 |
48 |
CAN_APPROVE_TEMPORARILY |
Indicator identifying whether the delegate can approve temporarily (Y/N). |
VARCHAR2 |
48 |
CAN_PREPARE |
Indicator identifying whether the delegate can prepare travel documents (Y/N). |
VARCHAR2 |
48 |
CAN_RECEIVE_APPROVAL_EMAIL |
Indicator identifying whether the delegate can receive approval emails (Y/N). |
VARCHAR2 |
48 |
CAN_RECEIVE_EMAIL |
Indicator identifying whether the delegate can receive workflow emails (Y/N). |
VARCHAR2 |
48 |
CAN_SUBMIT |
Indicator identifying whether the delegate can submit travel documents (Y/N). |
VARCHAR2 |
48 |
CAN_VIEW_RECEIPT_IMAGE |
Indicator identifying whether the delegate can view receipt images (Y/N). |
VARCHAR2 |
48 |
DELEGATE_EMAIL |
Email address associated with the delegate. |
VARCHAR2 |
100 |
DELEGATE_MIT_ID |
MIT ID number of the delegate. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
48 |
DELEGATE_NAME |
Name of the delegate associated with the travel profile. |
VARCHAR2 |
100 |
TRAVEL_PROFILE_ID |
Unique identifier for the travel profile. |
VARCHAR2 |
100 |