Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
PDRDEDN_1042S_LIMIT_BEN_CDE |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_TAX |
LIMIT_BEN_1042S_CODE |
NO |
NA |
PDRDEDN_AMOUNT1 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_TAX |
AMOUNT1 AMOUNT1 |
NO NO |
NA |
PDRDEDN_AMOUNT2 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_TAX |
AMOUNT2 AMOUNT2 |
NO NO |
NA |
PDRDEDN_AMOUNT3 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_TAX |
AMOUNT3 AMOUNT3 |
NO NO |
NA |
PDRDEDN_AMOUNT4 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_TAX |
AMOUNT4 AMOUNT4 |
NO NO |
NA |
PDRDEDN_AMOUNT5 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
AMOUNT5 |
NO |
NA |
PDRDEDN_AMOUNT6 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
AMOUNT6 |
NO |
NA |
PDRDEDN_AMOUNT7 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
AMOUNT7 |
NO |
NA |
PDRDEDN_AMOUNT8 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
AMOUNT8 |
NO |
NA |
PDRDEDN_BDCA_CODE |
PDADEDN |
NO |
COMPOSITE VIEW |
AN_PAYROLL_DISTRIBUTION AP_BENEFIT_DEDUCTION |
TAX_DEDUCTION CARRIER |
NO NO |
NA |
PDRDEDN_COVERAGE_DATE |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_TAX |
COVERAGE_DATE |
NO |
NA |
PDRDEDN_EFFECTIVE_DATE |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_TAX AP_TAX |
EFFECTIVE_START_DATE EFFECTIVE_DATE EFFECTIVE_START_DATE EFFECTIVE_DATE |
NO NO NO NO |
NA |
PDRDEDN_OPT_CODE1 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_TAX AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION |
STATE_INCOME_TAX_INDICATOR1 COVERAGE_OPTION COVERAGE_OPTION_DESC OPTION1 |
NO NO NO NO |
NA |
PDRDEDN_OPT_CODE2 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_TAX AP_BENEFIT_DEDUCTION |
STATE_INCOME_TAX_INDICATOR2 OPTION2 |
NO NO |
NA |
PDRDEDN_OPT_CODE3 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_TAX |
OPTION3 STATE_INCOME_TAX_INDICATOR3 |
NO NO |
NA |
PDRDEDN_OPT_CODE4 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_TAX AP_BENEFIT_DEDUCTION |
STATE_INCOME_TAX_INDICATOR4 OPTION4 |
NO NO |
NA |
PDRDEDN_OPT_CODE5 |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_TAX |
OPTION5 STATE_INCOME_TAX_INDICATOR5 |
NO NO |
NA |
PDRDEDN_PIDM |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
PERSON_UID |
NO |
NA |
PDRDEDN_REF_NO |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_TAX AP_BENEFIT_DEDUCTION |
REFERENCE_NUMBER REFERENCE_NUMBER |
NO NO |
NA |
PDRDEDN_STATUS |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION AP_TAX |
STATUS STATUS |
NO NO |
NA |
PDRDEDN_W4_NAME_CHANGE_IND |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
W4_NAME_CHANGE_IND |
NO |
NA |
PDRDEDN_W4_SIGNED_DATE |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
W4_SIGNED_DATE |
NO |
NA |
PDRDEDN_W4_SIGNED_PIDM |
PDADEDN |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
W4_SIGNED_PIDM |
NO |
NA |