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 Reporting View Source: FTCRACTG - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
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