Reporting View Source: FTCRACTG

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
ACCI_CODE	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING	ACCOUNT_INDEX ACCOUNT_INDEX_DEFAULT ACCOUNT_INDEX
ACCT_CODE	NA	REPORTING VIEW	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	ACCOUNT_DEFAULT ACCOUNT ACCOUNT
ACTIVITY_DATE	NA	REPORTING VIEW	PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	PROFILE_FUNDING_ACTIVITY_DATE FUNDING_ACTIVITY_DATE FUNDING_ACTIVITY_DATE
ACTV_CODE	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING	ACTIVITY ACTIVITY_DEFAULT ACTIVITY
AMOUNT	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	AMOUNT AMOUNT
APPR_AMOUNT	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	CALCULATED_AMOUNT_NO_TAX CALCULATED_AMOUNT_NO_TAX
BANK_CODE	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING	BANK
COAS_CODE	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS_DEFAULT CHART_OF_ACCOUNTS
CREATE_DATE	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	FUNDING_CREATE_DATE FUNDING_CREATE_DATE
CREATE_SOURCE	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	FUNDING_CREATE_SOURCE FUNDING_CREATE_SOURCE
CREATE_USER	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	FUNDING_CREATE_USER FUNDING_CREATE_USER
DATA_ORIGIN	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING	FUNDING_DATA_ORIGIN PROFILE_FUNDING_DATA_ORIGIN FUNDING_DATA_ORIGIN
FTOBPROF_ID	TBD
FTPBPORT_ID	TBD
FTPREXPS_ID	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	EXPENSE_ITEM_KEY EXPENSE_ITEM_KEY
FUND_CODE	NA	REPORTING VIEW	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	FUND_DEFAULT FUND FUND
ID	NA
LOCN_CODE	NA	REPORTING VIEW	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	LOCATION_DEFAULT LOCATION LOCATION
ORACLE_ID	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	FINANCE_SECURITY_ID FINANCE_SECURITY_ID
ORGN_CODE	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING	ORGANIZATION_CODE ORGANIZATION_DEFAULT ORGANIZATION_CODE
PAY_AMOUNT	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	PAY_CURRENCY_AMOUNT PAY_CURRENCY_AMOUNT
PAY_APPR_AMOUNT	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	PAY_CURRENCY_AMOUNT_NO_TAX PAY_CURRENCY_AMOUNT_NO_TAX
PERCENT_OF_TOTAL	NA	REPORTING VIEW	PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT
PROG_CODE	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING	PROGRAM PROGRAM_DEFAULT PROGRAM
PROJ_CODE	NA	REPORTING VIEW	PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	PROJECT_DEFAULT PROJECT PROJECT
USER_ID	NA	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING	FUNDING_USER_ID FUNDING_USER_ID PROFILE_FUNDING_USER_ID

Ver: 8.5