| 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.AUTHORIZATION_KEY
PORTFOLIO_KEY
AUTHORIZATION, AUTHORIZATION_STATUS
OWNER_UID
BUSINESS_PURPOSE_NAME
FISCAL_YEAR
FISCAL_PERIOD | | |
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, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ACCOUNT
EXPENSE_ITEM_KEY
PORTFOLIO_KEY
AUTHORIZATION_KEY
AUTHORIZATION, AUTHORIZATION_STATUS
CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD | | |
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
AUTHORIZATION_KEY
CIRCULATION_KEY, CIRCULATION_STEP_KEY
CIRCULATION_NOTIFICATION_KEY
CIRCULATION_STEP_KEY, NOTIFICATION_STATUS_DATE | | |
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 insitution card.One row per authorization per expense item.EXPENSE_ITEM_KEY
PORTFOLIO_KEY
AUTHORIZATION_KEY
AUTHORIZATION, AUTHORIZATION_STATUS
EXPENSE_TYPE
FISCAL_YEAR
FISCAL_PERIOD | | |
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.AUTHORIZATION_KEY
PORTFOLIO_KEY
AUTHORIZATION, AUTHORIZATION_STATUS
ITINERARY_KEY
TRAVEL_START_DATE
OWNER_UID | | |
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.AUTHORIZATION_KEY
PORTFOLIO_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 | | |
NEU_SCHEDULE_DATA
| This folder contains information about course sections in the universities schedule. | | |
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
AUTHORIZATION_STATUS
OWNER_UID
BUSINESS_PURPOSE_KEY
BUSINESS_PURPOSE_NAME | | |
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.PORTFOLIO_KEY
EXPENSE_TYPE | | |
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.AUTHORIZATION_KEY
PORTFOLIO_KEY
OWNER_UID
BUSINESS_PURPOSE_NAME
REIMBURSEMENT_KEY
PORTFOLIO_KEY, REIMBURSEMENT_STATUS
REIMBURSEMENT, REIMBURSEMENT_STATUS
PAYEE_UID | | |
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, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ACCOUNT
EXPENSE_ITEM_KEY
PORTFOLIO_KEY
REIMBURSEMENT_KEY
PORTFOLIO_KEY, REIMBURSEMENT_STATUS
REIMBURSEMENT, REIMBURSEMENT_STATUS
CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD | | |
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 reimbursment per circulation step per circulation approver per circulation notification.CIRCULATION_KEY
CIRCULATION_KEY, CIRCULATION_STEP_KEY
CIRCULATION_NOTIFICATION_KEY
CIRCULATION_STEP_KEY, NOTIFICATION_STATUS_DATE
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.EXPENSE_ITEM_KEY
PORTFOLIO_KEY
REIMBURSEMENT_KEY
EXPENSE_TYPE
PORTFOLIO_KEY, REIMBURSEMENT_STATUS
REIMBURSEMENT, REIMBURSEMENT_STATUS
FISCAL_YEAR
FISCAL_PERIOD | | |
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.ITINERARY_KEY
PORTFOLIO_KEY
REIMBURSEMENT_KEY
TRAVEL_START_DATE
OWNER_UID
PORTFOLIO_KEY, REIMBURSEMENT_STATUS
REIMBURSEMENT, 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_KEY
PORTFOLIO_KEY, REIMBURSEMENT_STATUS
REIMBURSEMENT, 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 | | |