Reporting View Source: FTPREXPS

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: FTPREXPS Travel And Expense Reporting View Meta Data Reports

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

Ver: 8.3