Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

Banner Operational Data Store
Composite View Target: AE_EXPENSE_ITEM

Description Expenses for the plan to be authorized, reimbursed, or advanced to the traveler.
Key & Frequency One row per expense item.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
AUTHORIZATION_KEY Unique internal identification number of the authorization record. NUMBER

FTPREXPS

FTRBAUTH_ID

NO

NO
CALCULATED_AMOUNT Depending on the expense type format, could represent the base currency amount for the expense item represented by dividing the entered foreign amount by the conversion rate, rounded to 2 decimals. Could represent calculated per diem rate. Could represent number of units times the rate if using distance rate. NUMBER

FTPREXPS

CALCULATED_AMOUNT

NO

NO
CALCULATED_AMOUNT_NO_TAX   NUMBER       NO
COMMODITY User defined code associated with this commodity. This is associated with the expense group item and used to populate the commodity code on the generated invoice. VARCHAR2(10)

FTTVEXPG

COMMODITY_CODE

NO

NO
COMMODITY_DESC Commodity description. VARCHAR2(50)

FTVCOMM

FTVCOMM_DESC

NO

NO
CURRENCY Foreign currency code used for the entered expense amount. VARCHAR2(4)

FTPREXPS

CURRENCY_CODE

NO

NO
CURRENCY_DESC Currency code description or title. VARCHAR2(35)

GTVCURR

GTVCURR_TITLE

NO

NO
CURRENCY_KEY   NUMBER       NO
CURRENCY_RATE Conversion rate on which to base the currency amount determined by the expense receipt date. NUMBER

FTPREXPS

CURRENCY_CONVERSION_RATE

NO

NO
CURRENT_DATE This is a the system current date (sysdate). DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO
ENTERED_AMOUNT Actual amount entered for the expense item, that can be entered in foreign currency. NUMBER

FTPREXPS

ACTUAL_AMOUNT

NO

NO
EXPECTED_EXPENSE_DATE Expected expense date of the expense item. DATE

FTPREXPS

EXPENSE_RECEIPT_DATE

NO

NO
EXPENSE_ADVANCE_CLEARED_IND   VARCHAR2(1)       NO
EXPENSE_GROUP_ITEM Groups expense items into one encumbrance line item or one invoice line item. Enables the liquidation of an encumbrance (travel authorization) by an invoice (travel reimbursement) line item by line item. NUMBER

FTTVEXPG

EXPENSE_GROUP_ITEM

NO

NO
EXPENSE_GROUP_KEY Unique internal identification number of the expense group record. NUMBER

FTTVEXPT

FTTVEXPG_ID

NO

NO
EXPENSE_GROUP_NAME Unique internal identification number of the expense group record. Used to group expense types. VARCHAR2(50)

FTTVEXPG

NAME

NO

NO
EXPENSE_ITEM_KEY Unique internal identification number of the expense item record. NUMBER

FTPREXPS

ID

NO

NO
EXPENSE_LOCATION Location where the expense is incurred. VARCHAR2(60)

FTPREXPS

LOCATION

NO

NO
EXPENSE_TYPE Expense type unique code identification identifying the type of expense. VARCHAR2(8)

FTTVEXPT

FTTVEXPT_ID

NO

NO
EXPENSE_TYPE_DESC Expense type long description. VARCHAR2(255)

FTTVEXPT

DESCRIPTION

NO

NO
EXPENSE_TYPE_KEY Unique internal identification number of the expense type record. NUMBER

FTPREXPS

FTTVEXPT_ID

NO

NO
EXPENSE_TYPE_NAME Name assigned to the expense type. VARCHAR2(60)

FTTVEXPT

NAME

NO

NO
EXPENSE_TYPE_SHORT_DESC Expense type short description. VARCHAR2(25)

FTTVEXPT

SHORT_NAME

NO

NO
INSTITUTION_CREDIT_CARD_IND Determines if the payment method uses the institution's credit card. (Y)es, the payment method uses the institutions credit card. (N)o, the payment method does not use the institutions credit card. If (Y)es, then the expense is not reimbursable. VARCHAR2(1)

FTTVPAYM

INSTITUTION_CARD_IND

NO

NO
ITEM_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FTPREXPS

ACTIVITY_DATE

NO

NO
ITEM_CREATE_DATE Date and time when the new expense detail record was created. DATE

FTPREXPS

CREATE_DATE

NO

NO
ITEM_CREATE_SOURCE Source system that created the data. VARCHAR2(30)

FTPREXPS

CREATE_SOURCE

NO

NO
ITEM_CREATE_USER ID of the person who created this new record. VARCHAR2(30)

FTPREXPS

CREATE_USER

NO

NO
ITEM_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(30)

FTPREXPS

DATA_ORIGIN

NO

NO
ITEM_DESC Expense item description. VARCHAR2(255)

FTPREXPS

DESCRIPTION

NO

NO
ITEM_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

FTPREXPS

USER_ID

NO

NO
ITINERARY_KEY Unique internal identification number of the itinerary record. NUMBER

FTPREXPS

FTPRITIN_ID

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
PAYMENT_METHOD Payment method unique code identification. VARCHAR2(8)

FTTVPAYM

PAYMENT_METHOD_CODE

NO

NO
PAYMENT_METHOD_DESC Payment method long description. VARCHAR2(255)

FTTVPAYM

DESCRIPTION

NO

NO
PAYMENT_METHOD_KEY Unique internal identification number of the payment method record. NUMBER

FTPREXPS

FTTVPAYM_ID

NO

NO
PAYMENT_METHOD_NAME Name assigned to the payment method. As an example, Ghost Card, Personal Credit Card. VARCHAR2(60)

FTTVPAYM

NAME

NO

NO
PAY_CONVERSION_EXCHANGE_RATE   NUMBER       NO
PAY_CURRENCY_AMOUNT   NUMBER       NO
PAY_CURRENCY_AMOUNT_NO_TAX   NUMBER       NO
PAY_CURRENCY_IND   VARCHAR2(1)       NO
PCARD_ID The last four digits of the institution procurement card. The procurement card maintained by the institutution and billed to the institution. VARCHAR2(4)

FTPREXPS

PCARD_ID

NO

NO
PERSONAL_CREDIT_CARD_IND Determines if the payment method uses the expense owner's personal credit card. (Y)es, the payment method uses a personal credit card. (N)o, the payment method does not use a personal credit card. If (Y)es, then the expense is not reimbursable. VARCHAR2(1)

FTTVPAYM

INDIVIDUAL_CARD_IND

NO

NO
PER_DIEM_IND Indicates if the expense was for per diem. This expense uses per diem rates. VARCHAR2(1)

FTPREXPS

PER_DIEM_IND

NO

NO
PROVIDER_KEY Unique internal identification number of the provider record. NUMBER

FTPREXPS

FTTVPROV_ID

NO

NO
PROVIDER_NAME Name of a provider for an expense that is used instead of a predefined provider name. VARCHAR2(60)

FTPREXPS

ALT_PROVIDER_NAME

NO

NO
PURCHASE_CARD_ID Information only. The last four digits of the institution procurement card. The procurement card is maintained by the institution and billed to the institution. VARCHAR2(4)

CALCULATION

NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID)

NO

NO
REIMBURSABLE_IND Determines if the payment method is expense reimbursable or not. (Y)es, payment method is reimbursable. (N)o, payment method is not reimbursable. VARCHAR2(1)

FTTVPAYM

REIMBURSE_IND

NO

NO
REIMBURSEMENT_KEY Unique internal identification number of the reimbursement record. NUMBER

FTPREXPS

FTRBREMB_ID

NO

NO
TAX_GROUP   VARCHAR2(4)       NO
TAX_GROUP_DESC   VARCHAR2(35)       NO
TAX_LOCALE   VARCHAR2(25)       NO
TAX_LOCALE_DESC   VARCHAR2(255)       NO
TAX_LOCALE_KEY   NUMBER       NO
UNITS Typically used as distance in the number of miles or kilometers, etc. driven from and to a location. May also be used for other types of units like per diem. NUMBER

FTPREXPS

DISTANCE

NO

NO
UNIT_RATE Rate to use multiplied by the distance units calculating a total amount for the expense item. Typically used to determine costs when using ones own vehicle. May be used for other types of expense like per diem rates. NUMBER

FTTVDRAT

RATE

NO

NO
UNIT_RATE_END_DATE End date that applies to the rate. DATE

FTTVDRAT

END_DATE

NO

NO
UNIT_RATE_KEY Unique internal identification number of the unit rate record. NUMBER

FTPREXPS

FTTVDRAT_ID

NO

NO
UNIT_RATE_LONG_DESC Unit rate long description. VARCHAR2(255)

FTTVDRAT

DESCRIPTION

NO

NO
UNIT_RATE_NAME Unit rate name. VARCHAR2(60)

FTTVDRAT

NAME

NO

NO
UNIT_RATE_START_DATE Effective date that applies to the rate. DATE

FTTVDRAT

START_DATE

NO

NO
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO


Ver: