| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| ACTIVITY_DATE |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
PORTFOLIO_ACTIVITY_DATE |
NO |
|
| CREATE_DATE |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
PORTFOLIO_CREATE_DATE |
NO |
|
| CREATE_SOURCE |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
PORTFOLIO_CREATE_SOURCE |
NO |
|
| CREATE_USER |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
PORTFOLIO_CREATE_USER |
NO |
|
| DATA_ORIGIN |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
PORTFOLIO_DATA_ORIGIN |
NO |
|
| DESCRIPTION |
NA |
NO |
REPORTING VIEW |
PORTFOLIO PORTFOLIO_SUMMARY |
PORTFOLIO_DESC PORTFOLIO_DESC |
NO NO |
|
| END_DATE |
NA |
NO |
|
|
|
|
|
| FGBENCH_NUM |
NA |
NO |
REPORTING VIEW |
PORTFOLIO REIMBURSEMENT AUTHORIZATION |
ENCUMBRANCE_NUMBER ENCUMBRANCE_NUMBER ENCUMBRANCE_NUMBER |
NO NO NO |
|
| FTTVEVNT_ID |
NA |
NO |
|
|
|
|
|
| FTTVPURP_ID |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
BUSINESS_PURPOSE_KEY |
NO |
|
| ID |
NA |
NO |
REPORTING VIEW |
PORTFOLIO_SUMMARY PORTFOLIO |
PORTFOLIO_KEY PORTFOLIO_KEY |
NO NO |
|
| NAME |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT PORTFOLIO_SUMMARY REIMBURSEMENT_STATUS_HISTORY AUTHORIZATION AUTHORIZATION_STATUS_HISTORY PORTFOLIO REIMBURSEMENT_ITEM |
PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME PORTFOLIO_NAME |
NO NO NO NO NO NO NO NO NO NO NO NO |
|
| OWNER_PIDM |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY PORTFOLIO REIMBURSEMENT_ITINERARY |
OWNER_UID OWNER_UID OWNER_UID |
NO NO NO |
|
| PORTFOLIO_NUMBER |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY PORTFOLIO PORTFOLIO_SUMMARY REIMBURSEMENT_ACCOUNTING AUTHORIZATION_STATUS_HISTORY REIMBURSEMENT_ITEM AUTHORIZATION_ITINERARY AUTHORIZATION REIMBURSEMENT REIMBURSEMENT_STATUS_HISTORY AUTHORIZATION_ACCOUNTING AUTHORIZATION_ITEM |
PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO PORTFOLIO |
NO NO NO NO NO NO NO NO NO NO NO NO |
|
| PORTFOLIO_STATUS_ENUM |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION REIMBURSEMENT |
PORTFOLIO_STATUS PORTFOLIO_STATUS |
NO NO |
|
| PORTFOLIO_TYPE_ENUM |
NA |
NO |
REPORTING VIEW |
PORTFOLIO PORTFOLIO_SUMMARY AUTHORIZATION REIMBURSEMENT |
PORTFOLIO_TYPE PORTFOLIO_TYPE PORTFOLIO_TYPE PORTFOLIO_TYPE |
NO NO NO NO |
|
| PRIMARY_DEST |
NA |
NO |
|
|
|
|
|
| REFERENCE |
NA |
NO |
|
|
|
|
|
| RELOCATION_IND |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
RELOCATION_IND |
NO |
|
| START_DATE |
NA |
NO |
|
|
|
|
|
| USER_ID |
NA |
NO |
REPORTING VIEW |
PORTFOLIO |
PORTFOLIO_USER_ID |
NO |
|