| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| FTVORGN_PROG_CODE_DEF |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL |
PROGRAM_DEFAULT PROGRAM_DEFAULT |
NO NO |
|
| FTVPROG_COAS_CODE |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL |
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS |
NO NO |
NA |
| FTVPROG_DATA_ENTRY_IND |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_VALIDATION AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY |
DATA_ENTRY_IND DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED |
NO NO NO |
NA |
| FTVPROG_EFF_DATE |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_PROGRAM_HIERARCHY_FISCAL |
EFFECTIVE_DATE |
NO |
|
| FTVPROG_NCHG_DATE |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_PROGRAM_HIERARCHY_FISCAL |
NEXT_CHANGE_DATE |
NO |
NA |
| FTVPROG_PROG_CODE |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY |
PROGRAM PROGRAM |
NO NO |
NA |
| FTVPROG_STATUS_IND |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY |
PROGRAM_STATUS PROGRAM_STATUS |
NO NO |
NA |
| FTVPROG_TERM_DATE |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY |
TERMINATION_DATE TERMINATION_DATE |
NO NO |
NA |
| FTVPROG_TITLE |
FTMPROG |
NO |
COMPOSITE VIEW |
AF_PROGRAM_ATTRIBUTES_ODS AN_PERSONNEL_ACTION_LABOR_DIST AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AP_PAYROLL_LABOR_DIST_OVERRIDE |
PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC POSITION_PROGRAM_DESC |
NO NO NO NO NO |
NA |