Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AUTHORIZATION_STATUS	Authorization request status.	VARCHAR2(63)	FTRBAUTH	REQUEST_STATUS	NO	NO
AUTHORIZATION_STATUS_DESC	Authorization request status description.	VARCHAR2(255)	CONSTANT	HARDCODED DESCRIPTIONS	NO	NO
AUTHORIZED_TOTAL	Total amount of all expenses for the authorization request regardless of status.	NUMBER	FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL	NO	NO
AUTHORIZED_TOTAL_NONREIMBURSE	Total amount of all non-reimbursable expenses for the authorization request regardless of status.	NUMBER	FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL	NO	NO
AUTHORIZED_TOTAL_REIMBURSE	Total amount of all reimbursable expenses for the authorization request regardless of status.	NUMBER	FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL	NO	NO
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(63)	FTTVPURP	NAME	NO	NO
ENCUMBRANCE_NUMBER	Generated encumbrance number used to post an authorization in the portfolio.	VARCHAR2(63)	FTPBPORT	FGBENCH_NUM	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
OWNER_ENTITY_IND	Indicates whether the expense owner is a person or an organization.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OWNER_ID	User-defined or system generated one-up number of the expense owner.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OWNER_NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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(63)	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(63)	FTPBPORT	CREATE_SOURCE	NO	NO
PORTFOLIO_CREATE_USER	Banner ID of the person who created this new record.	VARCHAR2(63)	FTPBPORT	CREATE_USER	NO	NO
PORTFOLIO_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	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(63)	FTPBPORT	NAME	NO	NO
PORTFOLIO_TYPE	Indicates if the portfolio is travel related or non-travel related. Valid hard coded values are TRAVEL, NON-TRAVEL.	VARCHAR2(63)	FTPBPORT	PORTFOLIO_TYPE_ENUM	NO	NO
PORTFOLIO_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FTPBPORT	USER_ID	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	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
TOTAL_NONREIMBURSE_SUBMITTED	Total amount of all non-reimbursable expense items for reimbursement requests within this portfolio. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED	NO	NO
TOTAL_NONREIMB_NOT_SUBMITTED	Total amount of all non-reimbursable expense items for all reimbursement requests within this portfolio that are (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_NOT_SUBMITTED	NO	NO
TOTAL_NOT_SUBMITTED	Total amount of all expense items for all reimbursement requests within this portfolio that are (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review. This includes reimbursable and non-reimbursable expense items.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_NOT_SUBMITTED	NO	NO
TOTAL_REIMBURSE_NOT_PAID	Total amount of all reimbursement expense requests within this portfolio that have been submitted and are waiting to be paid. This includes request statuses of (A)pproved, (S)ubmitted, or (C)ompleted and ready to pay.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID	NO	NO
TOTAL_REIMBURSE_NOT_SUBMITTED	Total amount of all reimbursable expense items for all reimbursement requests in the portfolio. This includes (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_NOT_SUBMITTED	NO	NO
TOTAL_REIMBURSE_PAID	Total amount of all reimbursement expense requests within this portfolio that have been (P)aid.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_REIMBURSE_PAID	NO	NO
TOTAL_REIMBURSE_SUBMITTED	Total amount of all reimbursable expense items for all reimbursement requests within this portfolio. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED	NO	NO
TOTAL_SUBMITTED	Total amount of all expense items for all reimbursement requests within this portfolio. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests. This includes reimbursable and non-reimbursable expense items.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED	NO	NO
TRAVEL_AUTH_END_DATE	Ending travel date from the last leg of the authorized itinerary.	DATE	FUNCTION	MEKFUNC.F_ITINERARY_DATE	NO	NO
TRAVEL_AUTH_START_DATE	Initial travel date from the first leg of the authorized itinerary.	DATE	FUNCTION	MEKFUNC.F_ITINERARY_DATE	NO	NO

Ver: 9.2