Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FTCRACTG Travel And Expense
SGHE Banner Operational Data Store Composite View Source: FTCRACTG - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
ACCI_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

ACCOUNT_INDEX

 
ACCT_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

ACCOUNT

 
ACTIVITY_DATE NA COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_ACTIVITY_DATE

 
ACTV_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

ACTIVITY

 
AMOUNT NA COMPOSITE VIEW

AE_ACCOUNTING

AMOUNT

 
APPR_AMOUNT NA        
BANK_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

BANK

 
COAS_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

CHART_OF_ACCOUNTS

 
CREATE_DATE NA COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_CREATE_DATE

 
CREATE_SOURCE NA COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_CREATE_SOURCE

 
CREATE_USER NA COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_CREATE_USER

 
DATA_ORIGIN NA COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_DATA_ORIGIN

 
FTOBPROF_ID TBD COMPOSITE VIEW

AE_ACCOUNTING

PROFILE_KEY

 
FTPBPORT_ID TBD COMPOSITE VIEW

AE_ACCOUNTING

PORTFOLIO_KEY

 
FTPREXPS_ID NA COMPOSITE VIEW

AE_ACCOUNTING

EXPENSE_ITEM_KEY

 
FUND_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

FUND

 
ID NA COMPOSITE VIEW

AE_ACCOUNTING

ACCOUNTING_KEY

 
LOCN_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

LOCATION

 
ORACLE_ID NA COMPOSITE VIEW

AE_ACCOUNTING

FINANCE_SECURITY_ID

 
ORGN_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

ORGANIZATION_CODE

 
PAY_AMOUNT NA        
PAY_APPR_AMOUNT NA        
PERCENT_OF_TOTAL NA COMPOSITE VIEW

AE_ACCOUNTING

DISTRIBUTION_PERCENT

 
PROG_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

PROGRAM

 
PROJ_CODE NA COMPOSITE VIEW

AE_ACCOUNTING

PROJECT

 
USER_ID NA COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_USER_ID

 


Ver: