| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| PDRBENE_ACA_CHILD_REPORT_IND |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_DEPENDENT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT |
ACA_REPORTABLE_CHILD_IND3 ACA_REPORTABLE_CHILD_IND ACA_REPORTABLE_CHILD_IND5 ACA_REPORTABLE_CHILD_IND1 ACA_REPORTABLE_CHILD_IND2 ACA_REPORTABLE_CHILD_IND4 |
NO NO NO NO NO NO |
NA |
| PDRBENE_BENE_FIRST_NAME |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT |
BENEFICIARY_FIRST_NAME5 BENEFICIARY_FIRST_NAME3 BENEFICIARY_FIRST_NAME4 BENEFICIARY_FIRST_NAME1 BENEFICIARY_FIRST_NAME2 |
NO NO NO NO NO |
NA |
| PDRBENE_BENE_LAST_NAME |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT |
BENEFICIARY_LAST_NAME4 BENEFICIARY_LAST_NAME3 BENEFICIARY_LAST_NAME1 BENEFICIARY_LAST_NAME5 BENEFICIARY_LAST_NAME2 |
NO NO NO NO NO |
NA |
| PDRBENE_BENE_MI |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT |
BENEFICIARY_MIDDLE_INITIAL2 BENEFICIARY_MIDDLE_INITIAL3 BENEFICIARY_MIDDLE_INITIAL1 BENEFICIARY_MIDDLE_INITIAL4 |
NO NO NO NO |
NA |
| PDRBENE_BENE_PIDM |
PDADEDN |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_DEPENDENT BENEFICIARY_SLOT BENEFICIARY_SLOT |
BENEFICIARY_UID3 BENEFICIARY_UID5 BENEFICIARY_UID2 BENEFICIARY_UID1 BENEFICIARY_UID BENEFICIARY_MIDDLE_INITIAL5 BENEFICIARY_UID4 |
NO NO NO NO NO NO NO |
NA |
| PDRBENE_BIRTH_DATE |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_DEPENDENT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT |
BENEFICIARY_BIRTH_DATE2 BENEFICIARY_BIRTH_DATE5 BENEFICIARY_BIRTH_DATE BENEFICIARY_BIRTH_DATE1 BENEFICIARY_BIRTH_DATE3 BENEFICIARY_BIRTH_DATE4 |
NO NO NO NO NO NO |
NA |
| PDRBENE_BREL_CODE |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_DEPENDENT BENEFICIARY_SLOT |
RELATIONSHIP2 RELATIONSHIP3 RELATIONSHIP1 RELATIONSHIP5 RELATIONSHIP RELATIONSHIP4 |
NO NO NO NO NO NO |
NA |
| PDRBENE_PIDM |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_DEPENDENT |
PERSON_UID PERSON_UID |
NO NO |
NA |
| PDRBENE_SEQ_NO |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_DEPENDENT |
SEQUENCE_NUMBER |
NO |
NA |
| PDRBENE_SSN |
PDABENE |
NO |
REPORTING VIEW |
BENEFICIARY_SLOT BENEFICIARY_DEPENDENT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT BENEFICIARY_SLOT |
BENEFICIARY_TAX_ID4 BENEFICIARY_TAX_ID BENEFICIARY_TAX_ID1 BENEFICIARY_TAX_ID5 BENEFICIARY_TAX_ID3 BENEFICIARY_TAX_ID2 |
NO NO NO NO NO NO |
NA |