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

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

AE_AUTHORIZATION

AUTHORIZATION_ACTIVITY_DATE

NO

 
ADVANCE_STATUS TBD NO          
COMPLETE_USER NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_COMPLETE_USER

NO

 
CREATE_DATE NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_CREATE_DATE

NO

 
CREATE_SOURCE NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_CREATE_SOURCE

NO

 
CREATE_USER NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_CREATE_USER

NO

 
DATA_ORIGIN NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_DATA_ORIGIN

NO

 
DESCRIPTION NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_DESC

NO

 
DOC_CODE NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION

NO

 
EMAIL_ADDRESS NA NO COMPOSITE VIEW

AE_AUTHORIZATION

OWNER_EMAIL

NO

 
FTPBPORT_ID TBD NO COMPOSITE VIEW

AE_AUTHORIZATION

PORTFOLIO_KEY

NO

 
FTRBAUTH_OWNER_PIDM NA NO          
FTTVAFFL_ID NA NO          
ID NA NO COMPOSITE VIEW

AE_STATUS_HISTORY

AE_AUTHORIZATION

STATUS_HISTORY_KEY

AUTHORIZATION_KEY

NO

NO

 
NAME NA NO COMPOSITE VIEW

AE_AUTHORIZATION

REPORT_NAME

NO

 
OUTSTANDING_ADVANCE_AMOUNT TBD NO          
OWNER_PIDM NA NO COMPOSITE VIEW

AE_AUTHORIZATION

OWNER_UID

NO

 
REQUEST_STATUS NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_STATUS

NO

 
SENT_TO_TRAVELER_BY NA NO          
SENT_TO_TRAVELER_DATE NA NO          
STATUS_DATE NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_STATUS_DATE

NO

 
TRANSACTION_DATE NA NO COMPOSITE VIEW

AE_AUTHORIZATION

TRANSACTION_DATE

NO

 
USER_COMMENT NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_COMMENT

NO

 
USER_ID NA NO COMPOSITE VIEW

AE_AUTHORIZATION

AUTHORIZATION_USER_ID

NO

 


Ver: