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

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

Ver: 9.2