Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Travel And Expense Reporting View Reports

Banner Operational Data Store
Reporting View Target: PORTFOLIO_SUMMARY

Description Contains summarized totals per portfolio by expense type for authorized and reimbursed expense items. Used to reconcile authorization expense types to reimbursement expense types within the portfolio.
Key & Frequency One row per portfolio per expense type.
Recommended Search Columns EXPENSE_TYPE
PORTFOLIO_KEY

Target Column Business Definition Database Data Type Source Name Source Column
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 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 Total amount of all reimbursable authorized expense items remaining to be paid. NUMBER

FUNCTION

MEKFUNC.F_AUTHORIZED_REMAINING

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 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 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. VARCHAR2(255)

FTVCOMM

FTVCOMM_DESC

EXPENSE_ADVANCE_CLEARED_IND Indicates whether the expense type is for an advance cleared amount VARCHAR2(1)

CALCULATION

DECODE(EXPENSE_TYPE_CODE,'9900ADVC')

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 Unique internal identification number of the expense group record. Used to group expense types. VARCHAR2(255)

FTTVEXPG

NAME

EXPENSE_TYPE Expense type unique code identification identifying the type of expense. VARCHAR2(63)

FTTVEXPT

EXPENSE_TYPE_CODE

EXPENSE_TYPE_NAME Name assigned to the expense type. VARCHAR2(255)

FTTVEXPT

NAME

EXPENSE_TYPE_SHORT_DESC Expense type short description. VARCHAR2(255)

FTTVEXPT

SHORT_NAME

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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 long description. VARCHAR2(255)

FTPBPORT

DESCRIPTION

PORTFOLIO_KEY Unique internal identification number of the portfolio record. NUMBER

FTPBPORT

ID

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 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-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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 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 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 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 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 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 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.1