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 AUTHORIZATION_ITINERARY AUTHORIZATION_STATUS_HISTORY AUTHORIZATION_APPROVAL_HISTORY AUTHORIZATION_ACCOUNTING AUTHORIZATION_ITEM |
AUTHORIZATION_DESC AUTHORIZATION_DESC AUTHORIZATION_DESC AUTHORIZATION_DESC AUTHORIZATION_DESC AUTHORIZATION_DESC |
|
DOC_CODE |
NA |
REPORTING VIEW |
AUTHORIZATION_ITINERARY AUTHORIZATION_APPROVAL_HISTORY AUTHORIZATION_STATUS_HISTORY AUTHORIZATION REIMBURSEMENT AUTHORIZATION_ACCOUNTING AUTHORIZATION_ITEM |
AUTHORIZATION AUTHORIZATION AUTHORIZATION AUTHORIZATION AUTHORIZATION AUTHORIZATION AUTHORIZATION |
|
EMAIL_ADDRESS |
NA |
REPORTING VIEW |
AUTHORIZATION |
OWNER_EMAIL |
|
FTPBPORT_ID |
TBD |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING AUTHORIZATION_STATUS_HISTORY AUTHORIZATION_ITEM AUTHORIZATION |
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_ITINERARY AUTHORIZATION_ACCOUNTING AUTHORIZATION_ITEM PORTFOLIO |
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 AUTHORIZATION_ACCOUNTING AUTHORIZATION_ITEM |
TRANSACTION_DATE TRANSACTION_DATE TRANSACTION_DATE |
|
USER_COMMENT |
NA |
REPORTING VIEW |
AUTHORIZATION |
AUTHORIZATION_COMMENT |
|
USER_ID |
NA |
REPORTING VIEW |
AUTHORIZATION |
AUTHORIZATION_USER_ID |
|