Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AUTHORIZED_NONREIMB_REMAINING	Authorized Nonreimb Remaining	Total amount of all non-reimbursable authorized expense items remaining. This could be expense amounts on requests that have statuses of (A)pproved, (S)ubmitted, (C)ompleted and ready to pay because they are grouped with reimbursable expense, or marked as (P)aid for the same reason.	NUMBER	FTRPEXPS	MEKFUNC.F_AUTHORIZED_REMAINING
AUTHORIZED_REIMBURSE_REMAINING	Authorized Reimburse Remaining	Total amount of all reimbursable authorized expense items remaining to be paid.	NUMBER	FUNCTION	MEKFUNC.F_AUTHORIZED_REMAINING
AUTHORIZED_TOTAL_NONREIMBURSE	Authorized Total Nonreimburse	Total amount of all non-reimbursable expenses for this expense type in the portfolio authorization request regardless of status.	NUMBER	FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL
AUTHORIZED_TOTAL_REIMBURSE	Authorized Total Reimburse	Total amount of all reimbursable expenses for this expense type in the portfolio authorization request regardless of status.	NUMBER	FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL
COMMODITY	Commodity	User defined code associated with this commodity known in Banner Finance. This is associated with the expense group item and used to populate the commodity code on the generated invoice.	VARCHAR2(63)	FTTVEXPG	COMMODITY_CODE
COMMODITY_DESC	Commodity Description	Commodity description.	VARCHAR2(255)	FTVCOMM	FTVCOMM_DESC
EXPENSE_ADVANCE_CLEARED_IND	Expense Advance Cleared Indicator	Indicates whether the expense type is for an advance cleared amount	VARCHAR2(1)	CALCULATION	DECODE(EXPENSE_TYPE_CODE,'9900ADVC')
EXPENSE_GROUP_ITEM	Expense Group Item	Groups expense items into one encumbrance line item or one invoice line item. Enables the liquidation of an encumbrance (travel authorization) by an invoice (travel reimbursement) line item by line item.	NUMBER	FTTVEXPG	EXPENSE_GROUP_ITEM
EXPENSE_GROUP_NAME	Expense Group Name	Unique internal identification number of the expense group record. Used to group expense types.	VARCHAR2(255)	FTTVEXPG	NAME
EXPENSE_TYPE	Expense Type	Expense type unique code identification identifying the type of expense.	VARCHAR2(63)	FTTVEXPT	EXPENSE_TYPE_CODE
EXPENSE_TYPE_NAME	Expense Type Name	Name assigned to the expense type.	VARCHAR2(255)	FTTVEXPT	NAME
EXPENSE_TYPE_SHORT_DESC	Expense Type Short Description	Expense type short description.	VARCHAR2(255)	FTTVEXPT	SHORT_NAME
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PORTFOLIO	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
PORTFOLIO_DESC	Portfolio Description	Portfolio long description.	VARCHAR2(255)	FTPBPORT	DESCRIPTION
PORTFOLIO_KEY	Portfolio KEY	Unique internal identification number of the portfolio record.	NUMBER	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(63)	FTPBPORT	NAME
PORTFOLIO_TYPE	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
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
TOTAL_NONREIMBURSE_SUBMITTED	Total Nonreimburse Submitted	Total amount of all non-reimbursable expense items for reimbursement requests for this expense type in the portfolio. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED
TOTAL_NONREIMB_NOT_SUBMITTED	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
TOTAL_REIMBURSE_NOT_PAID	Total Reimburse Not Paid	Total amount of all reimbursement expense requests for this expense type in the 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
TOTAL_REIMBURSE_NOT_SUBMITTED	Total Reimburse Not Submitted	Total amount of all reimbursable expense items for all reimbursement requests for this expense type 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
TOTAL_REIMBURSE_PAID	Total Reimburse Paid	Total amount of all reimbursement expense requests for this expense type in the portfolio that have been (P)aid.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_REIMBURSE_PAID
TOTAL_REIMBURSE_SUBMITTED	Total Reimburse Submitted	Total amount of all reimbursable expense items for all reimbursement requests for this expense type in the portfolio. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.	NUMBER	FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED
UNITS	Units	Typically used as distance in number of mile or kilometers, etc. driven from and to a location. May also be used for other type of units like per diem.	NUMBER	FTPREXPS	DISTANCE

Ver: 9.2