Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
FTVORGN_ACTV_CODE_DEF |
FTMORGN |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY |
ACTIVITY_DEFAULT ACTIVITY_DEFAULT |
|
FTVORGN_COAS_CODE |
FTMORGN |
COMPOSITE VIEW |
AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL |
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS |
NA |
FTVORGN_DATA_ENTRY_IND |
FTMORGN |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY AF_VALIDATION |
DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED DATA_ENTRY_IND |
NA |
FTVORGN_DESC |
FTMORGN |
COMPOSITE VIEW |
AP_FACULTY_SABBATICAL_HISTORY |
ORGANIZATION_DESC |
NA |
FTVORGN_EFF_DATE |
FTMORGN |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL |
EFFECTIVE_DATE |
|
FTVORGN_FMGR_CODE_PIDM |
NA |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY |
FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID |
NA |
FTVORGN_FUND_CODE_DEF |
FTMORGN |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY |
FUND_DEFAULT FUND_DEFAULT |
|
FTVORGN_LOCN_CODE_DEF |
FTMORGN |
COMPOSITE VIEW |
AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL |
LOCATION_DEFAULT LOCATION_DEFAULT |
|
FTVORGN_NCHG_DATE |
FTMORGN |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL |
NEXT_CHANGE_DATE |
NA |
FTVORGN_ORGN_CODE |
FTMORGN |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY |
ORGANIZATION_CODE ORGANIZATION_CODE |
NA |
FTVORGN_STATUS_IND |
FTMORGN |
COMPOSITE VIEW |
AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL |
ORGANIZATION_STATUS ORGANIZATION_STATUS |
NA |
FTVORGN_TERM_DATE |
FTMORGN |
COMPOSITE VIEW |
AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL |
TERMINATION_DATE TERMINATION_DATE |
NA |
FTVORGN_TITLE |
FTMORGN |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL AP_PAYROLL_LABOR_DIST_OVERRIDE AN_PERSONNEL_ACTION_LABOR_DIST AF_ORGANIZATION_ATTRIBUTES_ODS AF_ORGANIZATION_HIERARCHY |
ORGANIZATION_DESC POSITION_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC |
NA |
MGKFUNC.F_GET_PERSON_INFO |
FTMORGN |
|
|
|
|