| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| FTVORGN_ACTV_CODE_DEF |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL |
ACTIVITY_DEFAULT ACTIVITY_DEFAULT |
NO NO |
|
| FTVORGN_COAS_CODE |
FTMORGN |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL |
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS |
NO NO NO |
NA |
| FTVORGN_DATA_ENTRY_IND |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY_FISCAL ORGANIZATION_HIERARCHY VALIDATION |
DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED DATA_ENTRY_IND |
NO NO NO |
NA |
| FTVORGN_DESC |
FTMORGN |
NO |
REPORTING VIEW |
FACULTY_TRACKING FACULTY_SABBATICAL_HISTORY FACULTY_TRACKING FACULTY_RANK_HISTORY FACULTY_APPOINTMENT_HISTORY |
APPOINTMENT_ORGANIZATION_DESC ORGANIZATION_DESC SABBATICAL_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC |
NO NO NO NO NO |
NA |
| FTVORGN_EFF_DATE |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY_FISCAL |
EFFECTIVE_DATE |
NO |
|
| FTVORGN_FMGR_CODE_PIDM |
NA |
NO |
REPORTING VIEW |
BUDGET_AVAILABILITY_LEDGER INVOICE_ACCOUNTING REIMBURSEMENT_ACCOUNTING INVOICE_ITEM_ACCOUNTING ORGANIZATION_HIERARCHY FIXED_ASSET_FUNDING_SOURCE ORGANIZATION_HIERARCHY_FISCAL FIXED_ASSET_ACCOUNTING_SOURCE GRANT_DEFERRED_COST OPERATING_LEDGER PURCHASE_ORDER_ITEM_ACCOUNTING TRANSACTION_HISTORY BUDGET_DETAIL PURCHASE_ORDER_ACCOUNTING AUTHORIZATION_ACCOUNTING GRANT_VIEW |
ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVORGN_FUND_CODE_DEF |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL |
FUND_DEFAULT FUND_DEFAULT |
NO NO |
|
| FTVORGN_LOCN_CODE_DEF |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY_FISCAL ORGANIZATION_HIERARCHY |
LOCATION_DEFAULT LOCATION_DEFAULT |
NO NO |
|
| FTVORGN_NCHG_DATE |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY_FISCAL |
NEXT_CHANGE_DATE |
NO |
NA |
| FTVORGN_ORGN_CODE |
FTMORGN |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY ORGANIZATION_HIERARCHY_FISCAL TRANSACTION_HISTORY |
FOAPAL_ELEMENT ORGANIZATION_CODE ACTUAL_ORGANIZATION_LEVEL_7 ACTUAL_ORGANIZATION_LEVEL_8 ACTUAL_ORGANIZATION_LEVEL_5 ACTUAL_ORGANIZATION_LEVEL_2 ACTUAL_ORGANIZATION_LEVEL_3 ACTUAL_ORGANIZATION_LEVEL_1 ACTUAL_ORGANIZATION_LEVEL_4 ORGANIZATION_CODE ACTUAL_ORGANIZATION_LEVEL_6 |
NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVORGN_STATUS_IND |
FTMORGN |
NO |
REPORTING VIEW |
BUDGET_AVAILABILITY_LEDGER ORGANIZATION_HIERARCHY TRANSACTION_HISTORY GRANT_DEFERRED_COST OPERATING_LEDGER ORGANIZATION_ATTRIBUTES TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY_FISCAL PURCHASE_ORDER TRANSACTION_HISTORY TRANSACTION_HISTORY ENDOWMENT_UNITS GRANT_LEDGER TRANSACTION_HISTORY TRANSACTION_HISTORY FIXED_ASSET_ITEM GRANT_DEFERRED_COST TRANSACTION_HISTORY PROPOSAL GRANT_PERSONNEL TRANSACTION_HISTORY |
ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_8 ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_4 FOAPAL_ELEMENT_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_1 ACTUAL_ORGANIZATION_STATUS_7 ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_2 ACTUAL_ORGANIZATION_STATUS_6 ORGANIZATION_STATUS ORIG_ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_3 ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_5 |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVORGN_TERM_DATE |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL |
TERMINATION_DATE TERMINATION_DATE |
NO NO |
NA |
| FTVORGN_TITLE |
FTMORGN |
NO |
REPORTING VIEW |
ORGANIZATION_HIERARCHY BUDGET_AVAILABILITY_LEDGER LABOR_COST_DISTRIBUTION REIMBURSEMENT_ACCOUNTING ORGANIZATION_ATTRIBUTES ORGANIZATION_HIERARCHY_FISCAL FUND_HIERARCHY_FISCAL GRANT_DEFERRED_COST PERSONNEL_ACTION_LABOR_DIST AUTHORIZATION_ACCOUNTING GRANT_DEFERRED_COST PAYROLL_LABOR_DIST_OVERRIDE GRANT_PERSONNEL LABOR_COST_DISTRIBUTION PAYROLL_DISTRIBUTION PROFILE_DEFAULT_ACCOUNTING FOAPAL_NO_ATTRIBUTES FUND_HIERARCHY OPERATING_LEDGER |
ORGANIZATION_DESC ORGANIZATION_DESC FRINGE_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORIG_ORGANIZATION_DESC POSITION_ORGANIZATION_DESC ORGANIZATION_DESC ASSIGNMENT_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_DESC FOAPAL_ELEMENT_DESC ORGANIZATION_DESC ORGANIZATION_DESC |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| MGKFUNC.F_GET_PERSON_INFO |
FTMORGN |
NO |
REPORTING VIEW |
GRANT_DEFERRED_COST |
ORIG_ORGANIZATION_FMGR_ID |
NO |
|