Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
BUSINESS_PURPOSE_KEY	Unique internal identification number of the business purpose.	NUMBER	FTPBPORT	FTTVPURP_ID	NO	NO
BUSINESS_PURPOSE_LONG_DESC	Business purpose long description.	VARCHAR2(255)	FTTVPURP	DESCRIPTION	NO	NO
BUSINESS_PURPOSE_NAME	Name assigned to the business purpose. As an example, Recruiting Visit, Faculty Conference, Monthly Expenses, Business Meeting.	VARCHAR2(60)	FTTVPURP	NAME	NO	NO
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
ENCUMBRANCE_NUMBER	Generated encumbrance number used to post an authorization in the portfolio.	VARCHAR2(8)	FTPBPORT	FGBENCH_NUM	NO	NO
END_DATE	Last date of travel date or the last date of a non-travel expense.	DATE	FTPBPORT	END_DATE	NO	NO
EVENT_KEY	Unique internal identification number of the event record.	NUMBER	FTPBPORT	FTTVEVNT_ID	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
OWNER_UID	Unique identification of the person who owns this portfolio and the expenses within it.	NUMBER	FTPBPORT	OWNER_PIDM	NO	NO
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	NO	NO
PORTFOLIO_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTPBPORT	ACTIVITY_DATE	NO	NO
PORTFOLIO_CREATE_DATE	Date and time when the new portfolio record was created.	DATE	FTPBPORT	CREATE_DATE	NO	NO
PORTFOLIO_CREATE_SOURCE	Source system that created the data.	VARCHAR2(30)	FTPBPORT	CREATE_SOURCE	NO	NO
PORTFOLIO_CREATE_USER	ID of the person who created this new record.	VARCHAR2(30)	FTPBPORT	CREATE_USER	NO	NO
PORTFOLIO_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTPBPORT	DATA_ORIGIN	NO	NO
PORTFOLIO_DESC	Portfolio long description.	VARCHAR2(255)	FTPBPORT	DESCRIPTION	NO	NO
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER	FTPBPORT	ID	NO	NO
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	NO	NO
PORTFOLIO_STATUS	Valid values are OPEN, or CLOSED.	VARCHAR2(10)	FTPBPORT	PORTFOLIO_STATUS_ENUM	NO	NO
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	NO	NO
PORTFOLIO_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTPBPORT	USER_ID	NO	NO
PRIMARY_DEST	The primary destination for a trip.	VARCHAR2(35)	FTPBPORT	PRIMARY_DEST	NO	NO
REFERENCE	Free form information for reference purposes as determined by the institution or user.	VARCHAR2(35)	FTPBPORT	REFERENCE	NO	NO
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	NO	NO
START_DATE	Initial travel date or the first date of non-travel expense.	DATE	FTPBPORT	START_DATE	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: