Target Column	Business Definition	Database Data Type	Source Name	Source Column
BUSINESS_PURPOSE_KEY	Unique internal identification number of the business purpose.	NUMBER	FTPBPORT	FTTVPURP_ID
BUSINESS_PURPOSE_LONG_DESC	Business purpose long description.	VARCHAR2(255)	FTTVPURP	DESCRIPTION
BUSINESS_PURPOSE_NAME	Name assigned to the business purpose. As an example, Recruiting Visit, Faculty Conference, Monthly Expenses, Business Meeting.	VARCHAR2(60)	FTTVPURP	NAME
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
ENCUMBRANCE_NUMBER	Generated encumbrance number used to post an authorization in the portfolio.	VARCHAR2(8)	FTPBPORT	FGBENCH_NUM
END_DATE	Last date of travel date or the last date of a non-travel expense.	DATE	FTPBPORT	END_DATE
EVENT_KEY	Unique internal identification number of the event record.	NUMBER	FTPBPORT	FTTVEVNT_ID
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
OWNER_UID	Unique identification of the person who owns this portfolio and the expenses within it.	NUMBER	FTPBPORT	OWNER_PIDM
PORTFOLIO	System generated code identifying the portfolio. The prefix is defined by the client for system ID TRAVPORT in the table fobfseq.	VARCHAR2(8)	FTPBPORT	PORTFOLIO_NUMBER
PORTFOLIO_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTPBPORT	ACTIVITY_DATE
PORTFOLIO_CREATE_DATE	Date and time when the new portfolio record was created.	DATE	FTPBPORT	CREATE_DATE
PORTFOLIO_CREATE_SOURCE	Source system that created the data.	VARCHAR2(30)	FTPBPORT	CREATE_SOURCE
PORTFOLIO_CREATE_USER	ID of the person who created this new record.	VARCHAR2(30)	FTPBPORT	CREATE_USER
PORTFOLIO_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTPBPORT	DATA_ORIGIN
PORTFOLIO_DESC	Portfolio long description.	VARCHAR2(255)	FTPBPORT	DESCRIPTION
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER	FTPBPORT	ID
PORTFOLIO_NAME	Name assigned to the Portfolio. As an example, Office expenses for year 2008 or Recruiting Trip in Southern California.	VARCHAR2(60)	FTPBPORT	NAME
PORTFOLIO_STATUS	Valid values are OPEN, or CLOSED.	VARCHAR2(10)	FTPBPORT	PORTFOLIO_STATUS_ENUM
PORTFOLIO_TYPE	Indicates if the portfolio is travel related or non-travel related. Valid hard coded values are TRAVEL, NON-TRAVEL.	VARCHAR2(10)	FTPBPORT	PORTFOLIO_TYPE_ENUM
PORTFOLIO_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTPBPORT	USER_ID
PRIMARY_DEST	The primary destination for a trip.	VARCHAR2(35)	FTPBPORT	PRIMARY_DEST
REFERENCE	Free form information for reference purposes as determined by the institution or user.	VARCHAR2(35)	FTPBPORT	REFERENCE
RELOCATION_IND	Indicates if the portfolio is being set up for relocation expenses. Values (Y)es means this is a relocation portfolio, (N)o means that it is not a relocation portfolio.	VARCHAR2(1)	FTPBPORT	RELOCATION_IND
START_DATE	Initial travel date or the first date of non-travel expense.	DATE	FTPBPORT	START_DATE
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: