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
|
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
|
NO
|
NO
|
AUTHORIZED_REIMBURSE_REMAINING
|
Total amount of all reimbursable authorized expense items remaining to be paid.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_AUTHORIZED_REMAINING
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
COMMODITY_DESC
|
Commodity description.
|
VARCHAR2(255)
|
FTVCOMM
|
FTVCOMM_DESC
|
NO
|
NO
|
EXPENSE_ADVANCE_CLEARED_IND
|
Indicates whether the expense type is for an advance cleared amount
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(EXPENSE_TYPE_CODE,'9900ADVC')
|
NO
|
NO
|
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
|
NO
|
NO
|
EXPENSE_GROUP_NAME
|
Unique internal identification number of the expense group record. Used to group expense types.
|
VARCHAR2(255)
|
FTTVEXPG
|
NAME
|
NO
|
NO
|
EXPENSE_TYPE
|
Expense type unique code identification identifying the type of expense.
|
VARCHAR2(63)
|
FTTVEXPT
|
EXPENSE_TYPE_CODE
|
NO
|
NO
|
EXPENSE_TYPE_NAME
|
Name assigned to the expense type.
|
VARCHAR2(255)
|
FTTVEXPT
|
NAME
|
NO
|
NO
|
EXPENSE_TYPE_SHORT_DESC
|
Expense type short description.
|
VARCHAR2(255)
|
FTTVEXPT
|
SHORT_NAME
|
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
|
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_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
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
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_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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|