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

Description Contains information about the travel and expense portfolio, whether or not this is travel or non-travel related, and the expense owner. The portfolio is used to relate information between an authorization and any expense reimbursements generated from that authorization.
Key & Frequency One row per portfolio.
Recommended Search Columns PORTFOLIO_KEY
OWNER_UID
BUSINESS_PURPOSE_KEY
BUSINESS_PURPOSE_NAME
AUTHORIZATION_STATUS

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

AUTHORIZATION_STATUS Authorization request status. VARCHAR2(63)

FTRBAUTH

REQUEST_STATUS

AUTHORIZATION_STATUS_DESC Authorization request status description. VARCHAR2(255)

CONSTANT

HARDCODED DESCRIPTIONS

AUTHORIZED_TOTAL Total amount of all expenses for the authorization request regardless of status. NUMBER

FUNCTION

MEKFUNC.F_AUTHORIZED_TOTAL

AUTHORIZED_TOTAL_NONREIMBURSE Total amount of all non-reimbursable expenses for the authorization request regardless of status. NUMBER

FUNCTION

MEKFUNC.F_AUTHORIZED_TOTAL

AUTHORIZED_TOTAL_REIMBURSE Total amount of all reimbursable expenses for the authorization request regardless of status. NUMBER

FUNCTION

MEKFUNC.F_AUTHORIZED_TOTAL

BUSINESS_PURPOSE_KEY Unique internal identification number of the business purpose. NUMBER

FTPBPORT

FTTVPURP_ID

BUSINESS_PURPOSE_LONG_DESC Business purpose long description. VARCHAR2(255)

FTTVPURP

DESCRIPTION

BUSINESS_PURPOSE_NAME Name assigned to the business purpose. As an example, Recruiting Visit, Faculty Conference, Monthly Expenses, Business Meeting. VARCHAR2(63)

FTTVPURP

NAME

ENCUMBRANCE_NUMBER Generated encumbrance number used to post an authorization in the portfolio. VARCHAR2(63)

FTPBPORT

FGBENCH_NUM

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

OWNER_ENTITY_IND Indicates whether the expense owner is a person or an organization. VARCHAR2(1)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OWNER_ID User-defined or system generated one-up number of the expense owner. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OWNER_NAME Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OWNER_UID Unique identification of the person who owns this portfolio and the expenses within it. NUMBER

FTPBPORT

OWNER_PIDM

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_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FTPBPORT

ACTIVITY_DATE

PORTFOLIO_CREATE_DATE Date and time when the new portfolio record was created. DATE

FTPBPORT

CREATE_DATE

PORTFOLIO_CREATE_SOURCE Source system that created the data. VARCHAR2(63)

FTPBPORT

CREATE_SOURCE

PORTFOLIO_CREATE_USER Banner ID of the person who created this new record. VARCHAR2(63)

FTPBPORT

CREATE_USER

PORTFOLIO_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(63)

FTPBPORT

DATA_ORIGIN

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

PORTFOLIO_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FTPBPORT

USER_ID

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

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

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_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

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

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

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

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

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

TRAVEL_AUTH_END_DATE Ending travel date from the last leg of the authorized itinerary. DATE

FUNCTION

MEKFUNC.F_ITINERARY_DATE

TRAVEL_AUTH_START_DATE Initial travel date from the first leg of the authorized itinerary. DATE

FUNCTION

MEKFUNC.F_ITINERARY_DATE



Ver: 9.1