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

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.
Recommended Search Columns PORTFOLIO_KEY
OWNER_UID
BUSINESS_PURPOSE_NAME
AUTHORIZATION_KEY
REIMBURSEMENT, REIMBURSEMENT_STATUS
PAYEE_UID
REIMBURSEMENT_KEY
PORTFOLIO_KEY, REIMBURSEMENT_STATUS

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ADVANCE_CLEARED Advance Cleared Total amount of the advance cleared for this expense report once it has been submitted. NUMBER

CALCULATION

MEKFUNC.F_TOTAL_SUBMITTED(R.PORTFOLIO_KEY, '9900ADVC', '%','Y')

AFFILIATION_KEY Affiliation KEY Unique internal identification number of the affiliation record. NUMBER

FTRBREMB

FTTVAFFL_ID

AUTHORIZATION Authorization System generated code identifying the reimbursement with the prefix as defined by the client for system id TRAVREIM in the table fobfseq. VARCHAR2(63)

FTRBAUTH

DOC_CODE

AUTHORIZATION_KEY Authorization KEY Unique internal identification number of the authorization record. NUMBER

FTRBAUTH

ID

AUTHORIZED_TOTAL Authorized Total Total amount of all expenses that were authorized regardless of status. NUMBER

FUNCTION

MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', '%')

AUTHORIZED_TOTAL_NONREIMBURSE Authorized Total Nonreimburse Total amount of all reimbursable expenses for the request authorization. NUMBER

FUNCTION

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

AUTHORIZED_TOTAL_REIMBURSE Authorized Total Reimburse Total amount of all reimbursable expenses for the request authorization. NUMBER

FUNCTION

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

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

CURRENCY_DESC Currency Description Currency code description or title. VARCHAR2(255)

GTVCURR

GTVCURR_TITLE

CURRENCY_KEY Currency KEY Unique internal identification number of the currency record. NUMBER

FTRBREMB

FTTVCURR_ID

DELEGATE_ID Delegate ID User-defined or system generated one-up number of the delegate. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

DELEGATE_NAME Delegate Name Combination of the delegate's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI

DELEGATE_UID Delegate UID Personal identification number of the user who submitted this request for traveler review. NUMBER

FTRBREMB

SENT_TO_TRAVELER_BY

DIRECT_DEPOSIT_OVERRIDE_IND Direct Deposit Override Indicator 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. VARCHAR2(1)

FTRBREMB

DIRECT_DEPOSIT_OVERRIDE_IND

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

ORIGINAL_APPROVER_ID Original Approver ID User-defined or system generated one-up number of the workflow approver. VARCHAR2(63)

FUNCTION

MAKFUNC.F_GET_PERSON_INFO

ORIGINAL_APPROVER_NAME Original Approver Name Combination of the workflow approver's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MAKFUNC.F_GET_PERSON_INFO

ORIGINAL_APPROVER_UID Original Approver UID Personal identification number of the workflow approver for this request. NUMBER

FTOBPROF

APPROVER_PIDM

OWNER_ADDRESS_NUMBER Owner Address Number Sequence used to identify different addresses within the same address type. NUMBER

FTRBREMB

OWNER_ADDRESS_SEQ_NUM

OWNER_ADDRESS_TYPE Owner Address Type Unique code used with a sequence number to determine the actual address of the expense owner. VARCHAR2(63)

FTRBREMB

OWNER_ADDRESS_TYPE_CODE

OWNER_EMAIL Owner Email Email address of the expense owner as contact information for workflow approvals. VARCHAR2(255)

FTRBREMB

EMAIL_ADDRESS

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

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

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 Personal identification number of the expense owner. NUMBER

FTRBREMB

OWNER_PIDM

PAYEE_ADDRESS_NUMBER Payee Address Number Sequence used to identify different addresses within the same address type. NUMBER

FTRBREMB

PAYEE_ADDRESS_SEQ_NUM

PAYEE_ADDRESS_TYPE Payee Address Type Unique code use with a sequence number to determine the actual address of the expense payee. VARCHAR2(63)

FTRBREMB

PAYEE_ADDRESS_TYPE_CODE

PAYEE_ENTITY_IND Payee Entity Indicator Indicates whether the payee is a person or an organization. VARCHAR2(1)

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

PAYEE_ID Payee ID User-defined or system generated one-up number of the person to be reimbursed. VARCHAR2(63)

FUNCTION

MAKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MAKFUNC.F_GET_PERSON_INFO

PAYEE_UID 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. NUMBER

FTRBREMB

PAYEE_PIDM

PAY_AMOUNT_NOT_SUBMITTED Pay Amount Not Submitted Total amount of all reimbursable expense items including the advance cleared amount for this expense report when the status is either (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review. NUMBER

CALCULATION

MEKFUNC.F_AUTHORIZED_TOTAL (R.PORTFOLIO_KEY, '%', 'Y') + MEKFUNC.F_TOTAL_NOT_SUBMITTED(R.PORTFOLIO_KEY, '%', 'Y','Y')

PAY_AMOUNT_SUBMITTED Pay Amount Submitted Total amount of all reimbursable xpense items including the advance cleared amount for this expense report when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted, (P)aid, or (U)pdated. NUMBER

CALCULATION

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

PAY_CURRENCY_EXCHANGE_RATE Pay Currency Exchange Rate Conversion rate to base currency amount. NUMBER

FTRBREMB

PAY_TO_BASE_EXCHNG_RATE

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_KEY Portfolio KEY Unique internal identification number of the portfolio record. NUMBER

FTRBREMB

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_STATUS Portfolio Status Determines if the portfolio is still open for activity or closed to any further activity. Valid values are OPEN, or CLOSED. VARCHAR2(63)

FTPBPORT

PORTFOLIO_STATUS_ENUM

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

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

NA

NA

REIMBURSEMENT Reimbursement System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq. VARCHAR2(63)

FTRBREMB

DOC_CODE

REIMBURSEMENT_ACTIVITY_DATE Reimbursement Activity Date Date information for this record in the table was entered or last updated. DATE

FTRBREMB

ACTIVITY_DATE

REIMBURSEMENT_COMMENT Reimbursement Comment Free-form comment for the reimbursement. VARCHAR2(4000)

FTRBREMB

USER_COMMENT

REIMBURSEMENT_COMPLETE_USER Reimbursement Completion User Banner ID of the person who completed this reimbursement. VARCHAR2(63)

FTRBREMB

COMPLETE_USER

REIMBURSEMENT_CREATE_DATE Reimbursement Create Date Date and time when the new reimbursement record was created. DATE

FTRBREMB

CREATE_DATE

REIMBURSEMENT_CREATE_SOURCE Reimbursement Create Source Source system that created the data. VARCHAR2(63)

FTRBREMB

CREATE_SOURCE

REIMBURSEMENT_CREATE_USER Reimbursement Create User Banner ID of the person who created this new record. VARCHAR2(63)

FTRBREMB

CREATE_USER

REIMBURSEMENT_DATA_ORIGIN Reimbursement Data Origin Source system that created or updated the data. VARCHAR2(63)

FTRBREMB

DATA_ORIGIN

REIMBURSEMENT_DESC Reimbursement Description Reimbursement request description. VARCHAR2(255)

FTRBREMB

DESCRIPTION

REIMBURSEMENT_KEY Reimbursement KEY Unique internal identification number of the reimbursement record. NUMBER

FTRBREMB

ID

REIMBURSEMENT_STATUS Reimbursement Status Reimbursement request status. VARCHAR2(63)

FTRBREMB

REQUEST_STATUS

REIMBURSEMENT_STATUS_DATE Reimbursement Status Date Date and time the status was updated. DATE

FTRBREMB

STATUS_DATE

REIMBURSEMENT_STATUS_DESC Reimbursement Status Description Reimbursement request status description. VARCHAR2(255)

FUNCTION

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

REIMBURSEMENT_USER_ID Reimbursement User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FTRBREMB

USER_ID

REIMBURSE_CURRENCY Reimburse Currency Currency code used to indicate the base currency in which to be reimbursed. VARCHAR2(63)

FTTVCURR

CURRENCY_CODE

REPORT_NAME Report Name Owner assigned expense report name. VARCHAR2(63)

FTRBREMB

NAME

REVIEW_SUBMIT_DATE Review Submit Date Date on which the authorization was submitted for traveler review. DATE

FTRBREMB

SENT_TO_TRAVELER_DATE

TOTAL_NONREIMBURSE_SUBMITTED 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. NUMBER

FUNCTION

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

TOTAL_NONREIMB_NOT_SUBMITTED 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. NUMBER

FUNCTION

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

TOTAL_NOT_SUBMITTED 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. NUMBER

FUNCTION

MEKFUNC.F_TOTAL_NOT_SUBMITTED(PORTFOLIO_KEY, '%', '%')

TOTAL_REIMBURSE_NOT_SUBMITTED 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. NUMBER

FUNCTION

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

TOTAL_REIMBURSE_SUBMITTED 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. NUMBER

FUNCTION

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

TOTAL_SUBMITTED 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. NUMBER

FUNCTION

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

TRANSACTION_DATE 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. DATE

FTRBREMB

TRANSACTION_DATE

TRAVELER_AFFILIATION Traveler Affiliation Traveler affliation used to determine if rebate taxes are used or may be used to quantify travelers for reporting or insurance purposes. VARCHAR2(63)

FTTVAFFL

AFFILIATION

TRAVELER_AFFILIATION_DESC Traveler Affiliation Description Traveler affiliation description. VARCHAR2(255)

FTTVAFFL

DESCRIPTION

WIRE_AMOUNT Wire Amount Wire transfer transaction amount. NUMBER

FTRBREMB

WIRE_BASE_AMOUNT

WIRE_DATE Wire Date Date which the wire transfer transaction occurs. DATE

FTRBREMB

WIRE_DATE

WIRE_REFERENCE_NUMBER Wire Reference Number Associated reference number for the wire transfer transaction. VARCHAR2(63)

FTRBREMB

WIRE_REF_NUM

WIRE_REIMBURSEMENT_IND Wire Reimbursement Indicator Indicates whether reimbursement is paid to the traveler using a bank wire transfer. VARCHAR2(1)

FTRBREMB

PAY_BY_WIRE_IND



Ver: 9.2