Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACA_REPORTABLE_CHILD_IND1	Indicates if the child is reportable under the current definition of child dependent. Valid values are (Y)es or (N)o.	VARCHAR2(1)	PDRBENE	PDRBENE_ACA_CHILD_REPORT_IND	NO	NO
ACA_REPORTABLE_CHILD_IND2	Indicates if the child is reportable under the current definition of child dependent. Valid values are (Y)es or (N)o.	VARCHAR2(1)	PDRBENE	PDRBENE_ACA_CHILD_REPORT_IND	NO	NO
ACA_REPORTABLE_CHILD_IND3	Indicates if the child is reportable under the current definition of child dependent. Valid values are (Y)es or (N)o.	VARCHAR2(1)	PDRBENE	PDRBENE_ACA_CHILD_REPORT_IND	NO	NO
ACA_REPORTABLE_CHILD_IND4	Indicates if the child is reportable under the current definition of child dependent. Valid values are (Y)es or (N)o.	VARCHAR2(1)	PDRBENE	PDRBENE_ACA_CHILD_REPORT_IND	NO	NO
ACA_REPORTABLE_CHILD_IND5	Indicates if the child is reportable under the current definition of child dependent. Valid values are (Y)es or (N)o.	VARCHAR2(1)	PDRBENE	PDRBENE_ACA_CHILD_REPORT_IND	NO	NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BENEFICIARY_BIRTH_DATE1	Birth date of beneficiary.	DATE	PDRBENE	PDRBENE_BIRTH_DATE	NO	NO
BENEFICIARY_BIRTH_DATE2	Birth date of beneficiary.	DATE	PDRBENE	PDRBENE_BIRTH_DATE	NO	NO
BENEFICIARY_BIRTH_DATE3	Birth date of beneficiary.	DATE	PDRBENE	PDRBENE_BIRTH_DATE	NO	NO
BENEFICIARY_BIRTH_DATE4	Birth date of beneficiary.	DATE	PDRBENE	PDRBENE_BIRTH_DATE	NO	NO
BENEFICIARY_BIRTH_DATE5	Birth date of beneficiary.	DATE	PDRBENE	PDRBENE_BIRTH_DATE	NO	NO
BENEFICIARY_FIRST_NAME1	Beneficiary first name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_FIRST_NAME	NO	NO
BENEFICIARY_FIRST_NAME2	Beneficiary first name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_FIRST_NAME	NO	NO
BENEFICIARY_FIRST_NAME3	Beneficiary first name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_FIRST_NAME	NO	NO
BENEFICIARY_FIRST_NAME4	Beneficiary first name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_FIRST_NAME	NO	NO
BENEFICIARY_FIRST_NAME5	Beneficiary first name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_FIRST_NAME	NO	NO
BENEFICIARY_LAST_NAME1	Beneficiary last name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_LAST_NAME	NO	NO
BENEFICIARY_LAST_NAME2	Beneficiary last name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_LAST_NAME	NO	NO
BENEFICIARY_LAST_NAME3	Beneficiary last name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_LAST_NAME	NO	NO
BENEFICIARY_LAST_NAME4	Beneficiary last name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_LAST_NAME	NO	NO
BENEFICIARY_LAST_NAME5	Beneficiary last name.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_LAST_NAME	NO	NO
BENEFICIARY_MIDDLE_INITIAL1	Beneficiary middle initial.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_MI	NO	NO
BENEFICIARY_MIDDLE_INITIAL2	Beneficiary middle initial.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_MI	NO	NO
BENEFICIARY_MIDDLE_INITIAL3	Beneficiary middle initial.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_MI	NO	NO
BENEFICIARY_MIDDLE_INITIAL4	Beneficiary middle initial.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_MI	NO	NO
BENEFICIARY_MIDDLE_INITIAL5	Beneficiary middle initial.	VARCHAR2(63)	PDRBENE	PDRBENE_BENE_PIDM	NO	NO
BENEFICIARY_TAX_ID1	Tax ID or federal social security number for the beneficiary.	VARCHAR2(63)	PDRBENE	PDRBENE_SSN	NO	NO
BENEFICIARY_TAX_ID2	Tax ID or federal social security number for the beneficiary.	VARCHAR2(63)	PDRBENE	PDRBENE_SSN	NO	NO
BENEFICIARY_TAX_ID3	Tax ID or federal social security number for the beneficiary.	VARCHAR2(63)	PDRBENE	PDRBENE_SSN	NO	NO
BENEFICIARY_TAX_ID4	Tax ID or federal social security number for the beneficiary.	VARCHAR2(63)	PDRBENE	PDRBENE_SSN	NO	NO
BENEFICIARY_TAX_ID5	Tax ID or federal social security number for the beneficiary.	VARCHAR2(63)	PDRBENE	PDRBENE_SSN	NO	NO
BENEFICIARY_UID1	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBENE	PDRBENE_BENE_PIDM	NO	NO
BENEFICIARY_UID2	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBENE	PDRBENE_BENE_PIDM	NO	NO
BENEFICIARY_UID3	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBENE	PDRBENE_BENE_PIDM	NO	NO
BENEFICIARY_UID4	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBENE	PDRBENE_BENE_PIDM	NO	NO
BENEFICIARY_UID5	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBENE	PDRBENE_BENE_PIDM	NO	NO
CARRIER	Identifies the specific benefit/deduction provider.	VARCHAR2(63)	PDRBCOV	PDRBCOV_BDCA_CODE	NO	NO
COVERAGE_BEGIN_DATE1	Date the benefit/deduction begins.	DATE	PDRBCOV	PDRBCOV_BEGIN_DATE	NO	NO
COVERAGE_BEGIN_DATE2	Date the benefit/deduction begins.	DATE	PDRBCOV	PDRBCOV_BEGIN_DATE	NO	NO
COVERAGE_BEGIN_DATE3	Date the benefit/deduction begins.	DATE	PDRBCOV	PDRBCOV_BEGIN_DATE	NO	NO
COVERAGE_BEGIN_DATE4	Date the benefit/deduction begins.	DATE	PDRBCOV	PDRBCOV_BEGIN_DATE	NO	NO
COVERAGE_BEGIN_DATE5	Date the benefit/deduction begins.	DATE	PDRBCOV	PDRBCOV_BEGIN_DATE	NO	NO
COVERAGE_END_DATE1	Date the benefit/deduction ends.	DATE	PDRBCOV	PDRBCOV_END_DATE	NO	NO
COVERAGE_END_DATE2	Date the benefit/deduction ends.	DATE	PDRBCOV	PDRBCOV_END_DATE	NO	NO
COVERAGE_END_DATE3	Date the benefit/deduction ends.	DATE	PDRBCOV	PDRBCOV_END_DATE	NO	NO
COVERAGE_END_DATE4	Date the benefit/deduction ends.	DATE	PDRBCOV	PDRBCOV_END_DATE	NO	NO
COVERAGE_END_DATE5	Date the benefit/deduction ends.	DATE	PDRBCOV	PDRBCOV_END_DATE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
OTHER_COVERAGE_IND1	Indicator which indicates whether Beneficiary is otherwise covered.	VARCHAR2(1)	PDRBCOV	PDRBCOV_OTHER_COV_IND	NO	NO
OTHER_COVERAGE_IND2	Indicator which indicates whether Beneficiary is otherwise covered.	VARCHAR2(1)	PDRBCOV	PDRBCOV_OTHER_COV_IND	NO	NO
OTHER_COVERAGE_IND3	Indicator which indicates whether Beneficiary is otherwise covered.	VARCHAR2(1)	PDRBCOV	PDRBCOV_OTHER_COV_IND	NO	NO
OTHER_COVERAGE_IND4	Indicator which indicates whether Beneficiary is otherwise covered.	VARCHAR2(1)	PDRBCOV	PDRBCOV_OTHER_COV_IND	NO	NO
OTHER_COVERAGE_IND5	Indicator which indicates whether Beneficiary is otherwise covered.	VARCHAR2(1)	PDRBCOV	PDRBCOV_OTHER_COV_IND	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBENE	PDRBENE_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
RELATIONSHIP1	Code used to identify the relationship of the beneficiary to the employee.	VARCHAR2(63)	PDRBENE	PDRBENE_BREL_CODE	NO	NO
RELATIONSHIP2	Code used to identify the relationship of the beneficiary to the employee.	VARCHAR2(63)	PDRBENE	PDRBENE_BREL_CODE	NO	NO
RELATIONSHIP3	Code used to identify the relationship of the beneficiary to the employee.	VARCHAR2(63)	PDRBENE	PDRBENE_BREL_CODE	NO	NO
RELATIONSHIP4	Code used to identify the relationship of the beneficiary to the employee.	VARCHAR2(63)	PDRBENE	PDRBENE_BREL_CODE	NO	NO
RELATIONSHIP5	Code used to identify the relationship of the beneficiary to the employee.	VARCHAR2(63)	PDRBENE	PDRBENE_BREL_CODE	NO	NO
RELATIONSHIP_DESC1	Relationship description. Identifies the various types of beneficiary relationships to an employee.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
RELATIONSHIP_DESC2	Relationship description. Identifies the various types of beneficiary relationships to an employee.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
RELATIONSHIP_DESC3	Relationship description. Identifies the various types of beneficiary relationships to an employee.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
RELATIONSHIP_DESC4	Relationship description. Identifies the various types of beneficiary relationships to an employee.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
RELATIONSHIP_DESC5	Relationship description. Identifies the various types of beneficiary relationships to an employee.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO

Ver: 9.2