Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST


Travel and Expense Composite View Meta Data Reports

Target Reports:

Composite ViewDescription
AE_ACCOUNTING
Contains general expense authorization accounting data including, fiscal year/period, accounting distribution, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per accounting key.
AE_APPROVAL_HISTORY
History of requests for authorization or reimbursement approvals.One row per authorization or reimbursement request.
AE_AUTHORIZATION
Contains information about the request for an authorization, its current status, encumbrance number if generated, expense owner information, and amounts for the authorization as reimbursable and non-reimbursable. When the authorization is associated to requests for reimbursements, the reimbursement amounts are also totaled for reimbursable and non-reimbursable.One row per authorization.
AE_CIRC_HEADER_STEP
Approval circulation header records and steps.One row per circulation header per circulation step.
AE_CIRC_RECIP_NOTIF
Approval circulation recipients and notifications.One row per circulation recipient per circulation notification.
AE_DELEGATE_ASSIGNMENT
Contains personnel assigned to the delegate who is responsible for the creation of authorizations and expense reports.One row per delegate UID per person UID.
AE_EXPENSE_ITEM
Expenses for the plan to be authorized, reimbursed, or advanced to the traveler.One row per expense item.
AE_EXPENSE_ITEM_TAX
Contains a breakdown of the taxes used on the authorization or expense report item. The tax rate code, tax rate, receipt tax portion, tax amount in base currency, and tax amount in pay currency.
AE_ITINERARY
Itineraries which define the various segments of a trip with the travel plan.One row per travel itinerary.
AE_PORTFOLIO
Portfolios used to group all expenses, authorizations, reimbursements and advances for a person.One row per portfolio.
AE_PROFILE
Contains data pertaining to a user's profile.One row per profile.
AE_REIMBURSEMENT
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.One row per reimbursement.
AE_STATUS_HISTORY
Contains status and status date history as the authorization / reimbursement request migrates through various stages of completion.One row per authorization or reimbursement per change in status.

Source Reports:

CALCULATION
FOBCIRH
FORCIRN
FORCIRR
FORCIRS
FTCRACTG
FTOBPROF
FTORDLAS
FTPBPORT
FTPRETAX
FTPREXPS
FTPRITIN
FTRBAUTH
FTRBREMB
FTRPEXPS
FTRRACIR
FTRRRCIR
FTRRSTHS
FTTVDRAT
FTTVEXPG
FTTVEXPT
FTTVPAYM
FTTVPURP
GTVCURR
GUACURR
NA
NULL
SPRADDR
SPRIDEN


Ver: