Target Column	Business Definition	Database Data Type	Source Name	Source Column
CREATE_ASSIGNMENT_USER_UID	Personal identification number of the person who created the delegate assignment.	NUMBER(8)	FTORDLAS	USER_PIDM
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DELEGATE_ASSIGN_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	TIMESTAMP(6)	FTORDLAS	ACTIVITY_DATE
DELEGATE_ASSIGN_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTORDLAS	DATA_ORIGIN
DELEGATE_ASSIGN_KEY	Unique internal identification number of the delegate assignment record.	NUMBER(19)	FTORDLAS	ID
DELEGATE_ASSIGN_USER_ID	Unique identification code of the user who entered or last touched the record.	VARCHAR2(30)	FTORDLAS	USER_ID
DELEGATE_KEY	Unique internal identification number of the delegate record.	NUMBER(19)	FTORDLAS	FTOBDLGT_ID
DELEGATE_TRAVELER_REVIEW_IND	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).	CHAR(1)	FTOBDLGT	BYPASS_TRAVELER_REVIEW_IND
DELEGATE_UID	Personal identification number of the delegate.	NUMBER(8)	FTOBDLGT	DELEGATE_PIDM
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PERSON_UID	Personal identification number of the assigned expense report user.	NUMBER(8)	FTOBPROF	OWNER_PIDM
PROFILE_KEY	Unique internal identification number of the expense profile record for the assigned traveler.	NUMBER(19)	FTORDLAS	FTOBPROF_ID
TRAVELER_REVIEW_IND	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). This might be the same as the delegate_traveler_review_ind or it may be an override.	CHAR(1)	FTORDLAS	BYPASS_TRAVELER_REVIEW_IND
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: