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**
Banner Source Column	Source Form	ODS Target	ODS Target Column
ACCI_CODE	NA	AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING	ACCOUNT_INDEX ACCOUNT_INDEX_DEFAULT ACCOUNT_INDEX
ACCT_CODE	NA	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	ACCOUNT_DEFAULT ACCOUNT ACCOUNT
ACTIVITY_DATE	NA	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	PROFILE_FUNDING_ACTIVITY_DATE FUNDING_ACTIVITY_DATE FUNDING_ACTIVITY_DATE
ACTV_CODE	NA	PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	ACTIVITY_DEFAULT ACTIVITY ACTIVITY
AMOUNT	NA	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	AMOUNT AMOUNT
BANK_CODE	NA	REIMBURSEMENT_ACCOUNTING	BANK
COAS_CODE	NA	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS_DEFAULT
CREATE_DATE	NA	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	FUNDING_CREATE_DATE FUNDING_CREATE_DATE
CREATE_SOURCE	NA	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	FUNDING_CREATE_SOURCE FUNDING_CREATE_SOURCE
CREATE_USER	NA	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	FUNDING_CREATE_USER FUNDING_CREATE_USER
DATA_ORIGIN	NA	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	PROFILE_FUNDING_DATA_ORIGIN FUNDING_DATA_ORIGIN FUNDING_DATA_ORIGIN
FTOBPROF_ID	TBD
FTPBPORT_ID	TBD
FTPREXPS_ID	NA	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	EXPENSE_ITEM_KEY EXPENSE_ITEM_KEY
FUND_CODE	NA	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING	FUND FUND FUND_DEFAULT
ID	NA
LOCN_CODE	NA	PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	LOCATION_DEFAULT LOCATION LOCATION
ORACLE_ID	NA	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	FINANCE_SECURITY_ID FINANCE_SECURITY_ID
ORGN_CODE	NA	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	ORGANIZATION_DEFAULT ORGANIZATION_CODE ORGANIZATION_CODE
PERCENT_OF_TOTAL	NA	PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING	DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT
PROG_CODE	NA	REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING	PROGRAM PROGRAM_DEFAULT PROGRAM
PROJ_CODE	NA	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING	PROJECT PROJECT PROJECT_DEFAULT
USER_ID	NA	PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	PROFILE_FUNDING_USER_ID FUNDING_USER_ID FUNDING_USER_ID

Ver: 8.3