| 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 |
|