Reporting View Source: FTPRITIN

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: FTPRITIN Travel And Expense Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
ACTIVITY_DATE	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	ITINERARY_ACTIVITY_DATE ITINERARY_ACTIVITY_DATE
CREATE_DATE	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	ITINERARY_CREATE_DATE ITINERARY_CREATE_DATE
CREATE_SOURCE	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	ITINERARY_CREATE_SOURCE ITINERARY_CREATE_SOURCE
CREATE_USER	NA	REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY	ITINERARY_CREATE_USER ITINERARY_CREATE_USER
DATA_ORIGIN	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	DATA_ORIGIN DATA_ORIGIN
END_DATE	NA	REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY	TRAVEL_END_DATE TRAVEL_END_DATE
FROM_CITY	NA	REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY	TRAVEL_FROM_CITY TRAVEL_FROM_CITY
FROM_NATN_CODE	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	TRAVEL_FROM_NATION TRAVEL_FROM_NATION
FROM_STAT_CODE	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	TRAVEL_FROM_STATE_PROVINCE TRAVEL_FROM_STATE_PROVINCE
FTPBPORT_ID	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	PORTFOLIO_KEY PORTFOLIO_KEY
FTRBAUTH_ID	NA	AUTHORIZATION_ITINERARY	AUTHORIZATION_KEY
FTRBREMB_ID	NA	REIMBURSEMENT_ITINERARY	REIMBURSEMENT_KEY
ID	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	ITINERARY_KEY ITINERARY_KEY
START_DATE	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	TRAVEL_START_DATE TRAVEL_START_DATE
TO_CITY	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	TRAVEL_TO_CITY TRAVEL_TO_CITY
TO_NATN_CODE	NA	REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY	TRAVEL_TO_NATION TRAVEL_TO_NATION
TO_STAT_CODE	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	TRAVEL_TO_STATE_PROVINCE TRAVEL_TO_STATE_PROVINCE
USER_ID	NA	AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY	ITINERARY_USER_ID ITINERARY_USER_ID

Ver: 8.3