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

Ver: 8.3