ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
AUTHORIZATION	System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq.			FTRBAUTH	DOC_CODE
AUTHORIZATION_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.			FTRBAUTH	ACTIVITY_DATE
AUTHORIZATION_COMMENT	Free-form comment for the authorization.			FTRBAUTH	USER_COMMENT
AUTHORIZATION_COMPLETE_USER	Banner ID of the person who completed this reimbursement.			FTRBAUTH	COMPLETE_USER
AUTHORIZATION_CREATE_DATE	Date and time when the new reimbursement record was created.			FTRBAUTH	CREATE_DATE
AUTHORIZATION_CREATE_SOURCE	Source system that created the data.			FTRBAUTH	CREATE_SOURCE
AUTHORIZATION_CREATE_USER	Banner ID of the person who created this new record.			FTRBAUTH	CREATE_USER
AUTHORIZATION_DATA_ORIGIN	Source system that created or updated the data.			FTRBAUTH	DATA_ORIGIN
AUTHORIZATION_DESC	Authorization request description.			FTRBAUTH	DESCRIPTION
AUTHORIZATION_KEY	Unique internal identification number of the authorization record.			FTRBAUTH	ID
AUTHORIZATION_STATUS	Authorization request status.			FTRBAUTH	REQUEST_STATUS
AUTHORIZATION_STATUS_DATE	Date and time the status was updated.			FTRBAUTH	STATUS_DATE
AUTHORIZATION_STATUS_DESC	Authorization request status description.			FUNCTION	SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS
AUTHORIZATION_USER_ID	Unique identification code of the user who entered or last touched the transaction.			FTRBAUTH	USER_ID
AUTHORIZED_TOTAL	Total amount of all expenses for the authorization regardless of status.			FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', '%')
AUTHORIZED_TOTAL_NONREIMBURSE	Total amount of all reimbursable expenses for the request authorization.			FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', 'N')
AUTHORIZED_TOTAL_REIMBURSE	Total amount of all reimbursable expenses for the request authorization.			FUNCTION	MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', 'Y')
BUSINESS_PURPOSE_NAME	Name assigned to the business purpose. As an example, Recruiting Visit, Faculty Conference, Monthly Expenses, Business Meeting.			FTTVPURP	NAME
ENCUMBRANCE_NUMBER	Generated encumbrance number used to post an authorization in the portfolio.			FTPBPORT	FGBENCH_NUM
FISCAL_PERIOD	Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.			FUNCTION	SELECT DISTINCT(SUBSTR(FISCAL_PERIOD1,63)) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE
FISCAL_YEAR	Unique identifier or code for the fiscal year.			FUNCTION	SELECT DISTINCT(SUBSTR(FISCAL_YEAR,1,63)) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
ORIGINAL_APPROVER_ID	User-defined or system generated one-up number of the workflow approver.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ORIGINAL_APPROVER_UID	Personal identification number of the workflow approver for this request.			FTOBPROF	APPROVER_PIDM
ORIGNAL_APPROVER_NAME	Combination of the workflow approver's last, first, and middle initial into one value.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_EMAIL	Email address of the expense owner as contact information for workflow approvals.			FTRBAUTH	EMAIL_ADDRESS
OWNER_ENTITY_IND	Indicates whether the expense owner is a person or an organization.			FUNCTION	MAKFUNC.F_GET_ENTITY_IND
OWNER_ID	User-defined or system generated one-up number of the expense owner.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_NAME	Combination of the person's last, first, and middle initial into one value.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_UID	Personal identification number of the expense owner when the funding source is saved as part of the profile.			FTRBAUTH	OWNER_PIDM
PORTFOLIO	System generated code identifying the portfolio. The prefix is defined by the client for system ID TRAVPORT in the table fobfseq.			FTPBPORT	PORTFOLIO_NUMBER
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.			FTRBAUTH	FTPBPORT_ID
PORTFOLIO_NAME	Name assigned to the Portfolio. As an example, Office expenses for year 2008 or Recruiting Trip in Southern California.			FTPBPORT	NAME
PORTFOLIO_STATUS	Determines if the portfolio is still open for activity or closed to any further activity. Valid values are OPEN, or CLOSED.			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.			FTPBPORT	PORTFOLIO_TYPE_ENUM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
REPORT_NAME	Owner assigned expense report name.			FTRBAUTH	NAME
TOTAL_NONREIMBURSE_SUBMITTED	Total amount of all non-reimbursable expense items for reimbursement requests within this authorization. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.			FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N')
TOTAL_NONREIMB_NOT_SUBMITTED	Total amount of all non-reimbursable expense items for all reimbursement requests within this authorization that are (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review.			FUNCTION	MEKFUNC.F_TOTAL_NOT_SUBMITTED(PORTFOLIO_KEY, '%', 'N')
TOTAL_NOT_SUBMITTED	Total amount of all expense items for all reimbursement requests within this authorization 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.			FUNCTION	MEKFUNC.F_TOTAL_NOT_SUBMITTED(PORTFOLIO_KEY, '%', '%')
TOTAL_REIMBURSE_NOT_PAID	Total amount of all reimbursement expense requests for this authorization that are in process and are waiting to be paid. This includes request statuses of (A)pproved, (S)ubmitted, or (C)ompleted and ready to pay.			FUNCTION	MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID(PORTFOLIO_KEY, '%')
TOTAL_REIMBURSE_NOT_SUBMITTED	Total amount of all reimbursable expense items for all reimbursement requests within this authorization. This includes (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review.			FUNCTION	MEKFUNC.F_TOTAL_NOT_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')
TOTAL_REIMBURSE_PAID	Total amount of all reimbursement expense requests for this authorization that have been paid.			FUNCTION	MEKFUNC.F_TOTAL_REIMBURSE_PAID(PORTFOLIO_KEY, '%')
TOTAL_REIMBURSE_SUBMITTED	Total amount of all reimbursable expense items for all reimbursement requests within this authorization. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.			FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')
TOTAL_SUBMITTED	Total amount of all expense items for all reimbursement requests within this authorization. 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.			FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', '%')
TRANSACTION_DATE	Date used to post the invoice into the ledgers for payment, determining the fiscal year and posting period. Represents the create date of the reimbursement.			FTRBAUTH	TRANSACTION_DATE

Ver: 8.3