Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
BUSINESS_PURPOSE_KEY	Business Purpose KEY	Unique internal identification number of the business purpose.	NUMBER(19)		FTPBPORT	FTTVPURP_ID
BUSINESS_PURPOSE_LONG_DESC	Business Purpose Long Description	Business purpose long description.	VARCHAR2(255)		FTTVPURP	DESCRIPTION
BUSINESS_PURPOSE_NAME	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	Current Date	This is a the system current date (sysdate).	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
ENCUMBRANCE_NUMBER	Encumbrance Number	Generated encumbrance number used to post an authorization in the portfolio.	VARCHAR2(8)		FTPBPORT	FGBENCH_NUM
END_DATE	End Date	Last date of travel date or the last date of a non-travel expense.	DATE		FTPBPORT	END_DATE
EVENT_KEY	Event KEY	Unique internal identification number of the event record.	NUMBER(19)		FTPBPORT	FTTVEVNT_ID
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
OWNER_UID	Owner UID	Unique identification of the person who owns this portfolio and the expenses within it.	NUMBER(8)		FTPBPORT	OWNER_PIDM
PORTFOLIO	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	Portfolio Activity Date	Date information for this record in the table was entered or last updated.	DATE		FTPBPORT	ACTIVITY_DATE
PORTFOLIO_CREATE_DATE	Portfolio Create Date	Date and time when the new portfolio record was created.	DATE		FTPBPORT	CREATE_DATE
PORTFOLIO_CREATE_SOURCE	Portfolio Create Source	Source system that created the data.	VARCHAR2(30)		FTPBPORT	CREATE_SOURCE
PORTFOLIO_CREATE_USER	Portfolio Create User	ID of the person who created this new record.	VARCHAR2(30)		FTPBPORT	CREATE_USER
PORTFOLIO_DATA_ORIGIN	Portfolio Data Origin	Source system that created or updated the data.	VARCHAR2(30)		FTPBPORT	DATA_ORIGIN
PORTFOLIO_DESC	Portfolio Description	Portfolio long description.	VARCHAR2(255)		FTPBPORT	DESCRIPTION
PORTFOLIO_KEY	Portfolio KEY	Unique internal identification number of the portfolio record.	NUMBER(19)		FTPBPORT	ID
PORTFOLIO_NAME	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	Portfolio Status	Valid values are OPEN, or CLOSED.	VARCHAR2(10)		FTPBPORT	PORTFOLIO_STATUS_ENUM
PORTFOLIO_TYPE	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	Portfolio User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		FTPBPORT	USER_ID
PRIMARY_DEST	Primary Dest	The primary destination for a trip.	VARCHAR2(35)		FTPBPORT	PRIMARY_DEST
REFERENCE	Reference	Free form information for reference purposes as determined by the institution or user.	VARCHAR2(35)		FTPBPORT	REFERENCE
RELOCATION_IND	Relocation Indicator	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	Start Date	Initial travel date or the first date of non-travel expense.	DATE		FTPBPORT	START_DATE
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: