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

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

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_ACTIVITY_DATE

 
ADVANCE_STATUS TBD

REPORTING VIEW

AUTHORIZATION

ADVANCE_STATUS

 
COMPLETE_USER NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_COMPLETE_USER

 
CREATE_DATE NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_CREATE_DATE

 
CREATE_SOURCE NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_CREATE_SOURCE

 
CREATE_USER NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_CREATE_USER

 
DATA_ORIGIN NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_DATA_ORIGIN

 
DESCRIPTION NA

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

 
DOC_CODE NA

REPORTING VIEW

AUTHORIZATION

REIMBURSEMENT

AUTHORIZATION_ACCOUNTING

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION_ITEM

AUTHORIZATION_APPROVAL_HISTORY

AUTHORIZATION_ITINERARY

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

 
EMAIL_ADDRESS NA

REPORTING VIEW

AUTHORIZATION

OWNER_EMAIL

 
FTPBPORT_ID TBD

REPORTING VIEW

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION_ITEM

AUTHORIZATION

AUTHORIZATION_ACCOUNTING

PORTFOLIO_KEY

PORTFOLIO_KEY

PORTFOLIO_KEY

PORTFOLIO_KEY

 
FTRBAUTH_OWNER_PIDM NA

REPORTING VIEW

AUTHORIZATION_APPROVAL_HISTORY

OWNER_UID

 
FTTVAFFL_ID NA

REPORTING VIEW

AUTHORIZATION

AFFILIATION_KEY

 
ID NA

REPORTING VIEW

AUTHORIZATION

REIMBURSEMENT

AUTHORIZATION_KEY

AUTHORIZATION_KEY

 
NAME NA

REPORTING VIEW

AUTHORIZATION

REPORT_NAME

 
OUTSTANDING_ADVANCE_AMOUNT TBD

REPORTING VIEW

AUTHORIZATION

OUTSTANDING_ADVANCE_AMOUNT

 
OWNER_PIDM NA

REPORTING VIEW

AUTHORIZATION

OWNER_UID

 
REQUEST_STATUS NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_ACCOUNTING

AUTHORIZATION_ITINERARY

PORTFOLIO

AUTHORIZATION_ITEM

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

 
SENT_TO_TRAVELER_BY NA

REPORTING VIEW

DELEGATE_ASSIGNMENT

AUTHORIZATION

PERSON_UID

DELEGATE_UID

 
SENT_TO_TRAVELER_DATE NA

REPORTING VIEW

AUTHORIZATION

REVIEW_SUBMIT_DATE

 
STATUS_DATE NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_STATUS_DATE

 
TRANSACTION_DATE NA

REPORTING VIEW

AUTHORIZATION_ITEM

AUTHORIZATION_ACCOUNTING

AUTHORIZATION

TRANSACTION_DATE

TRANSACTION_DATE

TRANSACTION_DATE

 
USER_COMMENT NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_COMMENT

 
USER_ID NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_USER_ID

 


Ver: 8.5