Reporting View Target: REIMBURSEMENT

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

SGHE Banner Operational Data Store
Reporting View Target: REIMBURSEMENT

Description Contains information about the request for a reimbursement, its current status, expense owner and payee information, and reimbursement summary amounts for reimbursable and non-reimbursable expenses. If the reimbursement is associated to an authorization, this also contains summary amounts for the authorization as reimbursable and non-reimbursable.
Key & Frequency One row per reimbursement.

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 reimbursement with the prefix as defined by the client for system id TRAVREIM in the table fobfseq.
FTRBAUTH

DOC_CODE

AUTHORIZATION_KEY Unique internal identification number of the authorization record.
FTRBAUTH

ID

AUTHORIZED_TOTAL Total amount of all expenses that were authorized 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

CURRENCY_DESC Currency code description or title.
GUACURR

GTVCURR_TITLE

DIRECT_DEPOSIT_OVERRIDE_IND Indicates if the reimbursement will be paid with a check versus direct deposit when the expense owner is set up for direct deposit. (Y)es, override the direct deposit and pay with a check. (N)o, do not override the direct deposit.
FTRBREMB

DIRECT_DEPOSIT_OVERRIDE_IND

ENCUMBRANCE_NUMBER Generated encumbrance number used to post an authorization in the portfolio.
FTPBPORT

FGBENCH_NUM

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

MAKFUNC.F_GET_PERSON_INFO

ORIGINAL_APPROVER_NAME Combination of the workflow approver's last, first, and middle initial into one value.
FUNCTION

MAKFUNC.F_GET_PERSON_INFO

ORIGINAL_APPROVER_UID Personal identification number of the workflow approver for this request.
FTOBPROF

APPROVER_PIDM

OWNER_ADDRESS_NUMBER Sequence used to identify different addresses within the same address type.
FTRBREMB

OWNER_ADDRESS_SEQ_NUM

OWNER_ADDRESS_TYPE Unique code used with a sequence number to determine the actual address of the expense owner.
FTRBREMB

OWNER_ADDRESS_TYPE_CODE

OWNER_EMAIL Email address of the expense owner as contact information for workflow approvals.
FTRBREMB

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

OWNER_PIDM

PAYEE_ADDRESS_NUMBER Sequence used to identify different addresses within the same address type.
FTRBREMB

PAYEE_ADDRESS_SEQ_NUM

PAYEE_ADDRESS_TYPE Unique code use with a sequence number to determine the actual address of the expense payee.
FTRBREMB

PAYEE_ADDRESS_TYPE_CODE

PAYEE_ENTITY_IND Indicates whether the payee is a person or an organization.
FUNCTION

MAKFUNC.F_GET_ENTITY_IND

PAYEE_ID User-defined or system generated one-up number of the person to be reimbursed.
FUNCTION

MAKFUNC.F_GET_PERSON_INFO

PAYEE_NAME Combination of the person's last, first, and middle initial into one value.
FUNCTION

MAKFUNC.F_GET_PERSON_INFO

PAYEE_UID Personal identification number of the payee when the funding source is saved as part of the profile. This is who the check will be cut to for the invoice.
FTRBREMB

PAYEE_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.
FTRBREMB

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

REIMBURSEMENT System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.
FTRBREMB

DOC_CODE

REIMBURSEMENT_ACTIVITY_DATE Date information for this record in the table was entered or last updated.
FTRBREMB

ACTIVITY_DATE

REIMBURSEMENT_COMMENT Free-form comment for the reimbursement.
FTRBREMB

USER_COMMENT

REIMBURSEMENT_COMPLETE_USER Banner ID of the person who completed this reimbursement.
FTRBREMB

COMPLETE_USER

REIMBURSEMENT_CREATE_DATE Date and time when the new reimbursement record was created.
FTRBREMB

CREATE_DATE

REIMBURSEMENT_CREATE_SOURCE Source system that created the data.
FTRBREMB

CREATE_SOURCE

REIMBURSEMENT_CREATE_USER Banner ID of the person who created this new record.
FTRBREMB

CREATE_USER

REIMBURSEMENT_DATA_ORIGIN Source system that created or updated the data.
FTRBREMB

DATA_ORIGIN

REIMBURSEMENT_DESC Reimbursement request description.
FTRBREMB

DESCRIPTION

REIMBURSEMENT_KEY Unique internal identification number of the reimbursement record.
FTRBREMB

ID

REIMBURSEMENT_STATUS Reimbursement request status.
FTRBREMB

REQUEST_STATUS

REIMBURSEMENT_STATUS_DATE Date and time the status was updated.
FTRBREMB

STATUS_DATE

REIMBURSEMENT_STATUS_DESC Reimbursement request status description.
FUNCTION

SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS

REIMBURSEMENT_USER_ID Unique identification code of the user who entered or last touched the transaction.
FTRBREMB

USER_ID

REIMBURSE_CURRENCY Currency code used to indicate the base currency in which to be reimbursed.
FTRBREMB

CURRENCY_CODE

REPORT_NAME Owner assigned expense report name.
FTRBREMB

NAME

TOTAL_NONREIMBURSE_SUBMITTED Total amount of all non-reimbursable expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid.
FUNCTION

MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N')

TOTAL_NONREIMB_NOT_SUBMITTED Total amount of all non-reimbursable expense items for this reimbursement request when the status is either (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 this reimbursement request when the status is either (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_SUBMITTED Total amount of all reimbursable expense items for this reimbursement request when the status is either (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_SUBMITTED Total amount of all reimbursable expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid.
FUNCTION

MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')

TOTAL_SUBMITTED Total amount of all expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid. This includes reimbursable and non-reimburseable 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.
FTRBREMB

TRANSACTION_DATE

Ver: 8.3

Description	Contains information about the request for a reimbursement, its current status, expense owner and payee information, and reimbursement summary amounts for reimbursable and non-reimbursable expenses. If the reimbursement is associated to an authorization, this also contains summary amounts for the authorization as reimbursable and non-reimbursable.
Key & Frequency	One row per reimbursement.

ODS Column	ODS Business Definition	Banner Source Name	Banner Source Column
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 reimbursement with the prefix as defined by the client for system id TRAVREIM in the table fobfseq.	FTRBAUTH	DOC_CODE
AUTHORIZATION_KEY	Unique internal identification number of the authorization record.	FTRBAUTH	ID
AUTHORIZED_TOTAL	Total amount of all expenses that were authorized 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
CURRENCY_DESC	Currency code description or title.	GUACURR	GTVCURR_TITLE
DIRECT_DEPOSIT_OVERRIDE_IND	Indicates if the reimbursement will be paid with a check versus direct deposit when the expense owner is set up for direct deposit. (Y)es, override the direct deposit and pay with a check. (N)o, do not override the direct deposit.	FTRBREMB	DIRECT_DEPOSIT_OVERRIDE_IND
ENCUMBRANCE_NUMBER	Generated encumbrance number used to post an authorization in the portfolio.	FTPBPORT	FGBENCH_NUM
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	MAKFUNC.F_GET_PERSON_INFO
ORIGINAL_APPROVER_NAME	Combination of the workflow approver's last, first, and middle initial into one value.	FUNCTION	MAKFUNC.F_GET_PERSON_INFO
ORIGINAL_APPROVER_UID	Personal identification number of the workflow approver for this request.	FTOBPROF	APPROVER_PIDM
OWNER_ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	FTRBREMB	OWNER_ADDRESS_SEQ_NUM
OWNER_ADDRESS_TYPE	Unique code used with a sequence number to determine the actual address of the expense owner.	FTRBREMB	OWNER_ADDRESS_TYPE_CODE
OWNER_EMAIL	Email address of the expense owner as contact information for workflow approvals.	FTRBREMB	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.	FTRBREMB	OWNER_PIDM
PAYEE_ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	FTRBREMB	PAYEE_ADDRESS_SEQ_NUM
PAYEE_ADDRESS_TYPE	Unique code use with a sequence number to determine the actual address of the expense payee.	FTRBREMB	PAYEE_ADDRESS_TYPE_CODE
PAYEE_ENTITY_IND	Indicates whether the payee is a person or an organization.	FUNCTION	MAKFUNC.F_GET_ENTITY_IND
PAYEE_ID	User-defined or system generated one-up number of the person to be reimbursed.	FUNCTION	MAKFUNC.F_GET_PERSON_INFO
PAYEE_NAME	Combination of the person's last, first, and middle initial into one value.	FUNCTION	MAKFUNC.F_GET_PERSON_INFO
PAYEE_UID	Personal identification number of the payee when the funding source is saved as part of the profile. This is who the check will be cut to for the invoice.	FTRBREMB	PAYEE_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.	FTRBREMB	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
REIMBURSEMENT	System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.	FTRBREMB	DOC_CODE
REIMBURSEMENT_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	FTRBREMB	ACTIVITY_DATE
REIMBURSEMENT_COMMENT	Free-form comment for the reimbursement.	FTRBREMB	USER_COMMENT
REIMBURSEMENT_COMPLETE_USER	Banner ID of the person who completed this reimbursement.	FTRBREMB	COMPLETE_USER
REIMBURSEMENT_CREATE_DATE	Date and time when the new reimbursement record was created.	FTRBREMB	CREATE_DATE
REIMBURSEMENT_CREATE_SOURCE	Source system that created the data.	FTRBREMB	CREATE_SOURCE
REIMBURSEMENT_CREATE_USER	Banner ID of the person who created this new record.	FTRBREMB	CREATE_USER
REIMBURSEMENT_DATA_ORIGIN	Source system that created or updated the data.	FTRBREMB	DATA_ORIGIN
REIMBURSEMENT_DESC	Reimbursement request description.	FTRBREMB	DESCRIPTION
REIMBURSEMENT_KEY	Unique internal identification number of the reimbursement record.	FTRBREMB	ID
REIMBURSEMENT_STATUS	Reimbursement request status.	FTRBREMB	REQUEST_STATUS
REIMBURSEMENT_STATUS_DATE	Date and time the status was updated.	FTRBREMB	STATUS_DATE
REIMBURSEMENT_STATUS_DESC	Reimbursement request status description.	FUNCTION	SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS
REIMBURSEMENT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	FTRBREMB	USER_ID
REIMBURSE_CURRENCY	Currency code used to indicate the base currency in which to be reimbursed.	FTRBREMB	CURRENCY_CODE
REPORT_NAME	Owner assigned expense report name.	FTRBREMB	NAME
TOTAL_NONREIMBURSE_SUBMITTED	Total amount of all non-reimbursable expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid.	FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N')
TOTAL_NONREIMB_NOT_SUBMITTED	Total amount of all non-reimbursable expense items for this reimbursement request when the status is either (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 this reimbursement request when the status is either (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_SUBMITTED	Total amount of all reimbursable expense items for this reimbursement request when the status is either (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_SUBMITTED	Total amount of all reimbursable expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid.	FUNCTION	MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')
TOTAL_SUBMITTED	Total amount of all expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid. This includes reimbursable and non-reimburseable 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.	FTRBREMB	TRANSACTION_DATE