Target Column	Business Name	Business Definition	Database Data Type	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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
DELEGATE_ASSIGN_CREATE_NAME	Delegate Assignment Create Name	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
PERSON_NAME	Person Name	Combination of the expense report user's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
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

Ver: 9.2