| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
DELEGATE_ASSIGN_ACTIVITY_DATE
 | 
Delegate Assignment Activity Date 
 | 
Date information for this record in the table was entered or last updated.
 | 
DATE
 | 
 
 | 
 FTORDLAS
 
 | 
 ACTIVITY_DATE
 
 | 
| 
DELEGATE_ASSIGN_CREATE_ID
 | 
Delegate Assignment Create ID 
 | 
User-defined or system generated one-up number of the person who created the delegate assignment
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
DELEGATE_ASSIGN_CREATE_NAME
 | 
Delegate Assignment Create Name 
 | 
Combination of the person's last, first, and middle initial into one value.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
DELEGATE_ASSIGN_CREATE_UID
 | 
Delegate Assignment Create UID 
 | 
Personal identification number of the person who created the delegate assignment.
 | 
NUMBER
 | 
 
 | 
 FTORDLAS
 
 | 
 USER_PIDM
 
 | 
| 
DELEGATE_ASSIGN_DATA_ORIGIN
 | 
Delegate Assignment Data Origin 
 | 
Source system that created or updated the data.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTORDLAS
 
 | 
 DATA_ORIGIN
 
 | 
| 
DELEGATE_ASSIGN_KEY
 | 
Delegate Assignment KEY 
 | 
Unique internal identification number of the delegate assignment record.
 | 
NUMBER
 | 
 
 | 
 FTORDLAS
 
 | 
 ID
 
 | 
| 
DELEGATE_ASSIGN_USER_ID
 | 
Delegate Assignment User ID 
 | 
Unique identification code of the user who entered or last touched the record.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTORDLAS
 
 | 
 USER_ID
 
 | 
| 
DELEGATE_ID
 | 
Delegate ID 
 | 
User-defined or system generated one-up number of the delegate.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
DELEGATE_KEY
 | 
Delegate KEY 
 | 
Unique internal identification number of the delegate record.
 | 
NUMBER
 | 
 
 | 
 FTORDLAS
 
 | 
 FTOBDLGT_ID
 
 | 
| 
DELEGATE_NAME
 | 
Delegate Name 
 | 
Combination of the delegate's last, first, and middle initial into one value.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
DELEGATE_TRAVELER_REVIEW_IND
 | 
Delegate Traveler Review Indicator 
 | 
Indicates delegate profile setup requires traveler to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N).
 | 
VARCHAR2(1)
 | 
 
 | 
 FTOBDLGT
 
 | 
 BYPASS_TRAVELER_REVIEW_IND
 
 | 
| 
DELEGATE_UID
 | 
Delegate UID 
 | 
Personal identification number of the delegate.
 | 
NUMBER
 | 
 
 | 
 FTOBDLGT
 
 | 
 DELEGATE_PIDM
 
 | 
| 
MULTI_SOURCE
 | 
Multi Source 
 | 
Institution value for the record when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(63)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
Institution description when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
PERSON_ID
 | 
Person ID 
 | 
User-defined or system generated one-up number of the assigned expense report user.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
PERSON_NAME
 | 
Person Name 
 | 
Combination of the expense report user's last, first, and middle initial into one value.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
PERSON_UID
 | 
Person UID 
 | 
Personal identification number of the assigned expense report user.
 | 
NUMBER
 | 
 
 | 
 FTRBAUTH
 
 | 
 SENT_TO_TRAVELER_BY
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
PROFILE_KEY
 | 
Profile KEY 
 | 
Unique internal identification number of the expense profile record for the assigned traveler.
 | 
NUMBER
 | 
 
 | 
 FTORDLAS
 
 | 
 FTOBPROF_ID
 
 | 
| 
TRAVELER_REVIEW_IND
 | 
Traveler Review Indicator 
 | 
Inidcates whether traveler does not need to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N).
 | 
VARCHAR2(1)
 | 
 
 | 
 FTORDLAS
 
 | 
 BYPASS_TRAVELER_REVIEW_IND
 
 |