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

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

AE_ITINERARY

ITINERARY_ACTIVITY_DATE

 
CREATE_DATE NA COMPOSITE VIEW

AE_ITINERARY

ITINERARY_CREATE_DATE

 
CREATE_SOURCE NA COMPOSITE VIEW

AE_ITINERARY

ITINERARY_CREATE_SOURCE

 
CREATE_USER NA COMPOSITE VIEW

AE_ITINERARY

ITINERARY_CREATE_USER

 
DATA_ORIGIN NA COMPOSITE VIEW

AE_ITINERARY

ITINERARY_DATA_ORIGIN

 
END_DATE NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_END_DATE

 
FROM_CITY NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_FROM_CITY

 
FROM_NATN_CODE NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_FROM_NATION

 
FROM_STAT_CODE NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_FROM_STATE_PROVINCE

 
FTPBPORT_ID NA COMPOSITE VIEW

AE_ITINERARY

PORTFOLIO_KEY

 
FTRBAUTH_ID NA COMPOSITE VIEW

AE_ITINERARY

AUTHORIZATION_KEY

 
FTRBREMB_ID NA COMPOSITE VIEW

AE_ITINERARY

REIMBURSEMENT_KEY

 
ID NA COMPOSITE VIEW

AE_ITINERARY

ITINERARY_KEY

 
START_DATE NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_START_DATE

 
TO_CITY NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_TO_CITY

 
TO_NATN_CODE NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_TO_NATION

 
TO_STAT_CODE NA COMPOSITE VIEW

AE_ITINERARY

TRAVEL_TO_STATE_PROVINCE

 
USER_ID NA COMPOSITE VIEW

AE_ITINERARY

ITINERARY_USER_ID

 


Ver: