Reporting View Target: PORTFOLIO

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Neu Schedule Data Reporting View Reports

SGHE 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
AUTHORIZATION_STATUS
OWNER_UID
BUSINESS_PURPOSE_KEY
BUSINESS_PURPOSE_NAME

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

AUTHORIZATION_STATUS Authorization Status Authorization request status. VARCHAR2(63)
FTRBAUTH

REQUEST_STATUS

AUTHORIZATION_STATUS_DESC Authorization Status Description Authorization request status description. VARCHAR2(255)
CONSTANT

HARDCODED DESCRIPTIONS

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

MEKFUNC.F_AUTHORIZED_TOTAL

AUTHORIZED_TOTAL_NONREIMBURSE 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 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 Business Purpose KEY Unique internal identification number of the business purpose. NUMBER
FTPBPORT

FTTVPURP_ID

BUSINESS_PURPOSE_LONG_DESC Business Purpose Long Description Business purpose long description. VARCHAR2(255)
FTTVPURP

DESCRIPTION

BUSINESS_PURPOSE_NAME 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 Encumbrance Number Generated encumbrance number used to post an authorization in the portfolio. VARCHAR2(63)
FTPBPORT

FGBENCH_NUM

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

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

MGKFUNC.F_GET_PERSON_INFO

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

MGKFUNC.F_GET_PERSON_INFO

OWNER_NAME 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 Owner UID Unique identification of the person who owns this portfolio and the expenses within it. NUMBER
FTPBPORT

OWNER_PIDM

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

ACTIVITY_DATE

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

CREATE_DATE

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

CREATE_SOURCE

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

CREATE_USER

PORTFOLIO_DATA_ORIGIN Portfolio Data Origin Source system that created or updated the data. VARCHAR2(63)
FTPBPORT

DATA_ORIGIN

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

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

USER_ID

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

NA

RELOCATION_IND Relocation Indicator 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 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 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 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 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 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 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 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 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 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 Travel Auth Start Date Initial travel date from the first leg of the authorized itinerary. DATE
FUNCTION

MEKFUNC.F_ITINERARY_DATE

Ver: 9.0

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 AUTHORIZATION_STATUS OWNER_UID BUSINESS_PURPOSE_KEY BUSINESS_PURPOSE_NAME

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AUTHORIZATION_STATUS	Authorization Status	Authorization request status.	VARCHAR2(63)	FTRBAUTH	REQUEST_STATUS
AUTHORIZATION_STATUS_DESC	Authorization Status Description	Authorization request status description.	VARCHAR2(255)	CONSTANT	HARDCODED DESCRIPTIONS
AUTHORIZED_TOTAL	Authorized Total	Total amount of all expenses for the authorization request regardless of status.	NUMBER	FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL
AUTHORIZED_TOTAL_NONREIMBURSE	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	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	Business Purpose KEY	Unique internal identification number of the business purpose.	NUMBER	FTPBPORT	FTTVPURP_ID
BUSINESS_PURPOSE_LONG_DESC	Business Purpose Long Description	Business purpose long description.	VARCHAR2(255)	FTTVPURP	DESCRIPTION
BUSINESS_PURPOSE_NAME	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	Encumbrance Number	Generated encumbrance number used to post an authorization in the portfolio.	VARCHAR2(63)	FTPBPORT	FGBENCH_NUM
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
OWNER_ENTITY_IND	Owner Entity Indicator	Indicates whether the expense owner is a person or an organization.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_ID	Owner ID	User-defined or system generated one-up number of the expense owner.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_NAME	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	Owner UID	Unique identification of the person who owns this portfolio and the expenses within it.	NUMBER	FTPBPORT	OWNER_PIDM
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_ACTIVITY_DATE	Portfolio Activity Date	Date information for this record in the table was entered or last updated.	DATE	FTPBPORT	ACTIVITY_DATE
PORTFOLIO_CREATE_DATE	Portfolio Create Date	Date and time when the new portfolio record was created.	DATE	FTPBPORT	CREATE_DATE
PORTFOLIO_CREATE_SOURCE	Portfolio Create Source	Source system that created the data.	VARCHAR2(63)	FTPBPORT	CREATE_SOURCE
PORTFOLIO_CREATE_USER	Portfolio Create User	Banner ID of the person who created this new record.	VARCHAR2(63)	FTPBPORT	CREATE_USER
PORTFOLIO_DATA_ORIGIN	Portfolio Data Origin	Source system that created or updated the data.	VARCHAR2(63)	FTPBPORT	DATA_ORIGIN
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
PORTFOLIO_USER_ID	Portfolio User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FTPBPORT	USER_ID
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RELOCATION_IND	Relocation Indicator	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 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 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 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 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 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 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 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 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	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	Travel Auth Start Date	Initial travel date from the first leg of the authorized itinerary.	DATE	FUNCTION	MEKFUNC.F_ITINERARY_DATE