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

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

AE_AUTHORIZATION

AUTHORIZATION_ACTIVITY_DATE

 
ADVANCE_STATUS TBD        
COMPLETE_USER NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_COMPLETE_USER

 
CREATE_DATE NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_CREATE_DATE

 
CREATE_SOURCE NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_CREATE_SOURCE

 
CREATE_USER NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_CREATE_USER

 
DATA_ORIGIN NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_DATA_ORIGIN

 
DESCRIPTION NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_DESC

 
DOC_CODE NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION

 
EMAIL_ADDRESS NA COMPOSITE VIEW

AE_AUTHORIZATION

OWNER_EMAIL

 
FTPBPORT_ID TBD COMPOSITE VIEW

AE_AUTHORIZATION

PORTFOLIO_KEY

 
FTRBAUTH_OWNER_PIDM NA        
FTTVAFFL_ID NA        
ID NA COMPOSITE VIEW

AE_STATUS_HISTORY

AE_AUTHORIZATION

STATUS_HISTORY_KEY

AUTHORIZATION_KEY

 
NAME NA COMPOSITE VIEW

AE_AUTHORIZATION

REPORT_NAME

 
OUTSTANDING_ADVANCE_AMOUNT TBD        
OWNER_PIDM NA COMPOSITE VIEW

AE_AUTHORIZATION

OWNER_UID

 
REQUEST_STATUS NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_STATUS

 
SENT_TO_TRAVELER_BY NA        
SENT_TO_TRAVELER_DATE NA        
STATUS_DATE NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_STATUS_DATE

 
TRANSACTION_DATE NA COMPOSITE VIEW

AE_AUTHORIZATION

TRANSACTION_DATE

 
USER_COMMENT NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_COMMENT

 
USER_ID NA COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_USER_ID

 


Ver: