Composite View Source: FTPREXPS

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: FTPREXPS Travel And Expense

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
ACTIVITY_DATE	NA	AE_EXPENSE_ITEM	ITEM_ACTIVITY_DATE
ACTUAL_AMOUNT	NA	AE_EXPENSE_ITEM	ENTERED_AMOUNT
ALT_PROVIDER_NAME	NA	AE_EXPENSE_ITEM	PROVIDER_NAME
CALCULATED_AMOUNT	NA	AE_EXPENSE_ITEM	CALCULATED_AMOUNT
CREATE_DATE	NA	AE_EXPENSE_ITEM	ITEM_CREATE_DATE
CREATE_SOURCE	NA	AE_EXPENSE_ITEM	ITEM_CREATE_SOURCE
CREATE_USER	NA	AE_EXPENSE_ITEM	ITEM_CREATE_USER
CURRENCY_CODE	NA	AE_EXPENSE_ITEM	CURRENCY
CURRENCY_CONVERSION_RATE	NA	AE_EXPENSE_ITEM	CURRENCY_RATE
DATA_ORIGIN	NA	AE_EXPENSE_ITEM	ITEM_DATA_ORIGIN
DESCRIPTION	NA	AE_EXPENSE_ITEM	ITEM_DESC
DISTANCE	NA	AE_EXPENSE_ITEM	UNITS
EXPENSE_RECEIPT_DATE	NA	AE_EXPENSE_ITEM	EXPECTED_EXPENSE_DATE
FTPRITIN_ID	NA	AE_EXPENSE_ITEM	ITINERARY_KEY
FTRBAUTH_ID	NA	AE_EXPENSE_ITEM	AUTHORIZATION_KEY
FTRBREMB_ID	NA	AE_EXPENSE_ITEM	REIMBURSEMENT_KEY
FTTVDRAT_ID	NA	AE_EXPENSE_ITEM	UNIT_RATE_KEY
FTTVEXPT_ID	NA	AE_EXPENSE_ITEM	EXPENSE_TYPE_KEY
FTTVPAYM_ID	NA	AE_EXPENSE_ITEM	PAYMENT_METHOD_KEY
FTTVPROV_ID	NA	AE_EXPENSE_ITEM	PROVIDER_KEY
ID	NA	AE_EXPENSE_ITEM	EXPENSE_ITEM_KEY
LOCATION	NA	AE_EXPENSE_ITEM	EXPENSE_LOCATION
PCARD_ID	NA	AE_EXPENSE_ITEM	PCARD_ID
PER_DIEM_IND	NA	AE_EXPENSE_ITEM	PER_DIEM_IND
USER_ID	NA	AE_EXPENSE_ITEM	ITEM_USER_ID

Ver: 8.3