| Reporting View | Description | Key & Frequency | Recommended Search Columns |
| 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.FISCAL_YEAR
FISCAL_PERIOD
PORTFOLIO_KEY
OWNER_UID
BUSINESS_PURPOSE_NAME
AUTHORIZATION_KEY
AUTHORIZATION, AUTHORIZATION_STATUS | | |
AUTHORIZATION_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 authorization per expense item per account distribution.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, PROGRAM
EXPENSE_ITEM_KEY
AUTHORIZATION_KEY
PORTFOLIO_KEY
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
AUTHORIZATION, AUTHORIZATION_STATUS | | |
AUTHORIZATION_APPROVAL_HISTORY
| Contains approval history information for the reimbursement for each change in notification. This includes the person who is approving the document, what action was taken and when, and when email notification was sent.One row per authorization per circulation step per circulation approver per circulation notification.CIRCULATION_KEY
CIRCULATION_NOTIFICATION_KEY
CIRCULATION_STEP_KEY, NOTIFICATION_STATUS_DATE
CIRCULATION_KEY, CIRCULATION_STEP_KEY
AUTHORIZATION_KEY | | |
AUTHORIZATION_ITEM
| Contains estimated detail level information for the authorization expense item. What the expense description is, receipt date, the expense type, unit rate for distance calculations or per diem calculations, payment method, if the expense is reimbursable or not, the calculated amount for the expense, and if the expense will be paid for by personal credit card or institution card.One row per authorization per expense item.FISCAL_YEAR
FISCAL_PERIOD
EXPENSE_ITEM_KEY
AUTHORIZATION_KEY
EXPENSE_TYPE
PORTFOLIO_KEY
AUTHORIZATION, AUTHORIZATION_STATUS | | |
AUTHORIZATION_ITEM_TAX
| Contains a breakdown of the taxes used on the authorization item. The tax rate code, tax rate, receipt tax portion, tax amount in base currency, and tax amount in pay currency.One row per authorization per authorization item per tax_rate.EXPENSE_ITEM_KEY
EXPENSE_TAX_ITEM_KEY
RATE | | |
AUTHORIZATION_ITINERARY
| Contains information about where a person or group plans to travel with their start and end dates of travel as well as each start and ending locations.One row per authorization per itinerary segment.PORTFOLIO_KEY
AUTHORIZATION_KEY
TRAVEL_START_DATE
ITINERARY_KEY
OWNER_UID
AUTHORIZATION, AUTHORIZATION_STATUS | | |
AUTHORIZATION_STATUS_HISTORY
| Contains status and status date history as the authorization request migrates through various stages of completion.One row per authorization per change in status.PORTFOLIO_KEY
AUTHORIZATION_KEY
AUTHORIZATION, AUTHORIZATION_STATUS | | |
DELEGATE_ASSIGNMENT
| Contains personnel assigned to the delegate who is responsible for the creation of authorizations and expense reports. The delegate's name and ID and the personnel's name and ID.One row per delegate_UID per person_UID.| DELEGATE_UID | | |
PORTFOLIO
| 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.One row per portfolio.PORTFOLIO_KEY
OWNER_UID
BUSINESS_PURPOSE_KEY
BUSINESS_PURPOSE_NAME
AUTHORIZATION_STATUS | | |
PORTFOLIO_SUMMARY
| Contains summarized totals per portfolio by expense type for authorized and reimbursed expense items. Used to reconcile authorization expense types to reimbursement expense types within the portfolio.One row per portfolio per expense type.EXPENSE_TYPE
PORTFOLIO_KEY | | |
PROFILE_DEFAULT_ACCOUNTING
| Contains default accounting information for a travel and expense owner profile.One row per profile owner per accounting distribution.| PROFILE_KEY | | |
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.PORTFOLIO_KEY
OWNER_UID
BUSINESS_PURPOSE_NAME
AUTHORIZATION_KEY
REIMBURSEMENT, REIMBURSEMENT_STATUS
PAYEE_UID
REIMBURSEMENT_KEY
PORTFOLIO_KEY, REIMBURSEMENT_STATUS | | |
REIMBURSEMENT_ACCOUNTING
| Contains general expense reimbursement 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 reimbursement per expense item per account distribution.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, PROGRAM
EXPENSE_ITEM_KEY
REIMBURSEMENT_KEY
PORTFOLIO_KEY
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
REIMBURSEMENT, REIMBURSEMENT_STATUS
PORTFOLIO_KEY, REIMBURSEMENT_STATUS | | |
REIMBURSEMENT_APPROVAL_HISTORY
| Contains approval history information for the reimbursement for each change in notification. This includes the person who is approving the document, what action was taken and when, and when email notification was sent.One row per reimbursement per circulation step per circulation approver per circulation notification.CIRCULATION_KEY
CIRCULATION_NOTIFICATION_KEY
CIRCULATION_STEP_KEY, NOTIFICATION_STATUS_DATE
CIRCULATION_KEY, CIRCULATION_STEP_KEY
REIMBURSEMENT
REIMBURSEMENT_KEY | | |
REIMBURSEMENT_ITEM
| Contains detail level information for the reimbursement expense item. What the expense description is, receipt date, the expense type, unit rate for distance calculations or per diem calculations, payment method, if the expense is reimbursable or not, the calculated amount for the expense, and if the expense was paid for by personal credit card or institution card.One row per reimbursement per expense item.FISCAL_YEAR
FISCAL_PERIOD
EXPENSE_ITEM_KEY
REIMBURSEMENT_KEY
EXPENSE_TYPE
PORTFOLIO_KEY
REIMBURSEMENT, REIMBURSEMENT_STATUS
PORTFOLIO_KEY, REIMBURSEMENT_STATUS | | |
REIMBURSEMENT_ITEM_TAX
| Contains a breakdown of the taxes used on the expense report item. The tax rate code, tax rate, receipt tax portion, tax amount in base currency, and tax amount in pay currency.One row per reimbursement per reimbursement item per tax_rate.EXPENSE_ITEM_KEY
EXPENSE_TAX_ITEM_KEY
RATE | | |
REIMBURSEMENT_ITINERARY
| Contains information about where a person or group traveled with their start and end dates of travel as well as each start and ending locations.One row per reimbursement per itinerary segment.PORTFOLIO_KEY
REIMBURSEMENT_KEY
TRAVEL_START_DATE
ITINERARY_KEY
OWNER_UID
REIMBURSEMENT, REIMBURSEMENT_STATUS
PORTFOLIO_KEY, REIMBURSEMENT_STATUS | | |
REIMBURSEMENT_STATUS_HISTORY
| Contains status and status date history as the reimbursement request migrates through various stages of completion.One row per reimbursement per status change.PORTFOLIO_KEY
REIMBURSEMENT, REIMBURSEMENT_STATUS
REIMBURSEMENT_KEY
PORTFOLIO_KEY, REIMBURSEMENT_STATUS | | |
TRAVEL_AND_EXPENSE_PROFILE
| Contains current and default information on a travel and expense owner profile. Also provides a total of all expenses paid to date for the profile owner.One row per profile owner.PROFILE_KEY
PERSON_UID
APPROVER_UID | | |