Description
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_EXPENSE_ITEM
| Expenses for the plan to be authorized, reimbursed, or advanced to the traveler.One row per expense item. | | |
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. | | |