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_ITINERARY

AUTHORIZATION_ITEM

AUTHORIZATION_APPROVAL_HISTORY

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION

AUTHORIZATION_ACCOUNTING

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

AUTHORIZATION_DESC

 
DOC_CODE NA

REPORTING VIEW

AUTHORIZATION

AUTHORIZATION_ITINERARY

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION_ACCOUNTING

AUTHORIZATION_ITEM

AUTHORIZATION_APPROVAL_HISTORY

REIMBURSEMENT

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

AUTHORIZATION

 
EMAIL_ADDRESS NA

REPORTING VIEW

AUTHORIZATION

OWNER_EMAIL

 
FTPBPORT_ID TBD

REPORTING VIEW

AUTHORIZATION_STATUS_HISTORY

AUTHORIZATION

AUTHORIZATION_ITEM

AUTHORIZATION_ACCOUNTING

PORTFOLIO_KEY

PORTFOLIO_KEY

PORTFOLIO_KEY

PORTFOLIO_KEY

 
FTRBAUTH_OWNER_PIDM NA

REPORTING VIEW

AUTHORIZATION_APPROVAL_HISTORY

OWNER_UID

 
FTTVAFFL_ID TBD

REPORTING VIEW


REPORTING VIEW

AUTHORIZATION

AUTHORIZATION

AFFILIATION_KEY

AFFILIATION_KEY

 
ID NA

REPORTING VIEW

REIMBURSEMENT

AUTHORIZATION

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

PORTFOLIO

AUTHORIZATION_ITINERARY

AUTHORIZATION_ITEM

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

AUTHORIZATION_STATUS

 
SENT_TO_TRAVELER_BY NA

REPORTING VIEW

AUTHORIZATION

DELEGATE_ASSIGNMENT

DELEGATE_UID

PERSON_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.4.1