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

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

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_ACTIVITY_DATE

NO

 
ADVANCE_STATUS TBD NO

REPORTING VIEW

AUTHORIZATION

ADVANCE_STATUS

NO

 
COMPLETE_USER NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_COMPLETE_USER

NO

 
CREATE_DATE NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_CREATE_DATE

NO

 
CREATE_SOURCE NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_CREATE_SOURCE

NO

 
CREATE_USER NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_CREATE_USER

NO

 
DATA_ORIGIN NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_DATA_ORIGIN

NO

 
DESCRIPTION NA NO

REPORTING VIEW

AUTHORIZATION_ITEM

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION_ITINERARY

AUTHORIZATION_ACCOUNTING

AUTHORIZATION

AUTHORIZATION_APPROVAL_HISTORY

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

NO

NO

NO

NO

NO

NO

 
DOC_CODE NA NO

REPORTING VIEW

AUTHORIZATION

REIMBURSEMENT

AUTHORIZATION_ACCOUNTING

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION_ITEM

AUTHORIZATION_APPROVAL_HISTORY

AUTHORIZATION_ITINERARY

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

NO

NO

NO

NO

NO

NO

NO

 
EMAIL_ADDRESS NA NO

REPORTING VIEW

AUTHORIZATION

OWNER_EMAIL

NO

 
FTPBPORT_ID TBD NO

REPORTING VIEW

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION_ITEM

AUTHORIZATION

AUTHORIZATION_ACCOUNTING

PORTFOLIO_KEY

PORTFOLIO_KEY

PORTFOLIO_KEY

PORTFOLIO_KEY

NO

NO

NO

NO

 
FTRBAUTH_OWNER_PIDM NA NO

REPORTING VIEW

AUTHORIZATION_APPROVAL_HISTORY

OWNER_UID

NO

 
FTTVAFFL_ID NA NO

REPORTING VIEW

AUTHORIZATION

AFFILIATION_KEY

NO

 
ID NA NO

REPORTING VIEW

AUTHORIZATION

REIMBURSEMENT

AUTHORIZATION_KEY

AUTHORIZATION_KEY

NO

NO

 
NAME NA NO

REPORTING VIEW

AUTHORIZATION

REPORT_NAME

NO

 
OUTSTANDING_ADVANCE_AMOUNT TBD NO

REPORTING VIEW

AUTHORIZATION

OUTSTANDING_ADVANCE_AMOUNT

NO

 
OWNER_PIDM NA NO

REPORTING VIEW

AUTHORIZATION

OWNER_UID

NO

 
REQUEST_STATUS NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_ACCOUNTING

AUTHORIZATION_ITINERARY

PORTFOLIO

AUTHORIZATION_ITEM

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

NO

NO

NO

NO

NO

 
SENT_TO_TRAVELER_BY NA NO

REPORTING VIEW

DELEGATE_ASSIGNMENT

AUTHORIZATION

PERSON_UID

DELEGATE_UID

NO

NO

 
SENT_TO_TRAVELER_DATE NA NO

REPORTING VIEW

AUTHORIZATION

REVIEW_SUBMIT_DATE

NO

 
STATUS_DATE NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_STATUS_DATE

NO

 
TRANSACTION_DATE NA NO

REPORTING VIEW

AUTHORIZATION_ITEM

AUTHORIZATION_ACCOUNTING

AUTHORIZATION

TRANSACTION_DATE

TRANSACTION_DATE

TRANSACTION_DATE

NO

NO

NO

 
USER_COMMENT NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_COMMENT

NO

 
USER_ID NA NO

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_USER_ID

NO

 


Ver: 9.2