Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_PORTFOLIO

Description Portfolios used to group all expenses, authorizations, reimbursements and advances for a person.
Key & Frequency One row per portfolio.

Target Column Business Definition Database Data Type Source Name Source Column
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(60)

FTTVPURP

NAME

CURRENT_DATE This is a the system current date (sysdate). DATE

NA

SYSDATE

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

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

FTPBPORT

FGBENCH_NUM

END_DATE Last date of travel date or the last date of a non-travel expense. DATE

FTPBPORT

END_DATE

EVENT_KEY Unique internal identification number of the event record. NUMBER

FTPBPORT

FTTVEVNT_ID

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

NA

NA

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

NA

NA

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(8)

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(30)

FTPBPORT

CREATE_SOURCE

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

FTPBPORT

CREATE_USER

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

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(60)

FTPBPORT

NAME

PORTFOLIO_STATUS Valid values are OPEN, or CLOSED. VARCHAR2(10)

FTPBPORT

PORTFOLIO_STATUS_ENUM

PORTFOLIO_TYPE Indicates if the portfolio is travel related or non-travel related. Valid hard coded values are TRAVEL, NON-TRAVEL. VARCHAR2(10)

FTPBPORT

PORTFOLIO_TYPE_ENUM

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

FTPBPORT

USER_ID

PRIMARY_DEST The primary destination for a trip. VARCHAR2(35)

FTPBPORT

PRIMARY_DEST

REFERENCE Free form information for reference purposes as determined by the institution or user. VARCHAR2(35)

FTPBPORT

REFERENCE

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

START_DATE Initial travel date or the first date of non-travel expense. DATE

FTPBPORT

START_DATE

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: