Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACA_4980H_SAFE_HARBOR_CODE	4980H Safe Harbor Code issued by the IRS for year-end.	VARCHAR2(63)	PTRBDCA	PTRBDCA_ACA_4980H_SAFE_HBR_CDE	NO	NO
ACA_4980H_SAFE_HARBOR_DESC	Description of 4980H Safe Harbor Code issued by the IRS for year-end.	VARCHAR2(255)	FUNCTION	SELECT MTVPARM_DESC FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'ODS VAL CODES' AND MTVPARM_INTERNAL_CODE = 'ACA_4980H_SAFE_HBR_CDE' AND MTVPARM_INTERNAL_CODE_2 = PTRBDCA_ACA_4980H_SAFE_HBR_CDE	NO	NO
ACA_HEALTH_PROVIDER_IND	This indicator signifies that this Benefit Code is a core Health Care Provider, for ACA offers and coverage.	VARCHAR2(1)	PTRBDCA	PTRBDCA_ACA_HEALTH_PROVIDR_IND	NO	NO
ACA_MONTHLY_PREMIUM_SELF_AMT	Monthly Premium Amount for Employee self-coverage.	NUMBER	PTRBDCA	PTRBDCA_ACA_MLY_PREM_SELF_AMT	NO	NO
ACA_OFFER_COVERAGE_CODE	Offer Coverage Code reported for year-end reporting.	VARCHAR2(63)	PTRBDCA	PTRBDCA_ACA_OFFER_COVERAGE_CDE	NO	NO
ACA_OFFER_COVERAGE_CODE_DESC	Description of Offer Coverage Code reported for year-end reporting.	VARCHAR2(255)	FUNCTION	SELECT MTVPARM_DESC FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'ODS VAL CODES' AND MTVPARM_INTERNAL_CODE = 'ACA_OFFER_COVERAGE_CDE' AND MTVPARM_INTERNAL_CODE_2 = PTRBDCA_ACA_OFFER_COVERAGE_CDE	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
AMOUNT1	First amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT1	NO	NO
AMOUNT1_TITLE	Long description associated with amount 1.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT1_TITLE	NO	NO
AMOUNT2	Second amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT2	NO	NO
AMOUNT2_TITLE	Long description associated with amount 2.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT2_TITLE	NO	NO
AMOUNT3	Third amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT3	NO	NO
AMOUNT3_TITLE	Long description associated with amount 3.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT3_TITLE	NO	NO
AMOUNT4	Fourth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT4	NO	NO
AMOUNT4_TITLE	Long description associated with amount 1.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT4_TITLE	NO	NO
AMOUNT5	Fifth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT5	NO	NO
AMOUNT5_TITLE	Long description associated with amount 5.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT5_TITLE	NO	NO
AMOUNT6	Sixth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT6	NO	NO
AMOUNT6_TITLE	Long description associated with amount 6.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT6_TITLE	NO	NO
AMOUNT7	Seventh amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT7	NO	NO
AMOUNT7_TITLE	Long description associated with amount 7.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT7_TITLE	NO	NO
AMOUNT8	Eighth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT8	NO	NO
AMOUNT8_TITLE	Long description associated with amount 8.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT8_TITLE	NO	NO
APPLICABLE_GROSS_QTR1	Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
APPLICABLE_GROSS_QTR2	Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
APPLICABLE_GROSS_QTR3	Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
APPLICABLE_GROSS_QTR4	Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
ARREARS_BALANCE	Arrears balance due the employer.	NUMBER	PDRBDED	PDRBDED_ARR_BALANCE	NO	NO
BENEFICIARY_COUNT	Count of beneficiaries.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_BENEFICIARY	NO	NO
BENEFIT_DEDUCTION_IND	Indicates if this is a benefit deduction.	VARCHAR2(2)	FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS	NO	NO
BENEFIT_DEDUCTION_TYPE	Benefit deduction type.	VARCHAR2(63)	PTRBDCA	PTRBDCA_BDTY_CODE	NO	NO
BENEFIT_DEDUCTION_TYPE_DESC	Benefit deduction type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
BENEFIT_GROUP	Benefit group.	VARCHAR2(255)	PTRBDCA	PTRBDCA_BDTY_CODE	NO	NO
BOND_BALANCE	If the deduction is for savings bonds this field contains the balance available toward the purchase of a bond.	NUMBER	PDRBDED	PDRBDED_BOND_BALANCE	NO	NO
CALCULATION_RULE	Defines how a benefit/deduction is processed by the system. The calc rule selected also determines how the deduction form and the deduction set-up form function.	VARCHAR2(63)	PTRBDCA	PTRBDCA_CALC_RULE	NO	NO
CARRIER	Identifies the specific benefit/deduction provider.	VARCHAR2(63)	PDRBDED	PDRBDED_BDCA_CODE	NO	NO
CARRIER_LONG_DESC	Benefit/deduction long description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_LONG_DESC	NO	NO
CARRIER_SHORT_DESC	Benefit/deduction short description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_SHORT_DESC	NO	NO
COVERAGE_BEGIN_DATE	Date the benefit/deduction begins.	DATE	PDRBDED	PDRBDED_BEGIN_DATE	NO	NO
COVERAGE_END_DATE	Date the benefit/deduction ends.	DATE	PDRBDED	PDRBDED_END_DATE	NO	NO
COVERAGE_OPTION	Coverage option associated with this benefit.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE1	NO	NO
COVERAGE_OPTION_DESC	Coverage option description.	VARCHAR2(255)	PTRBDPL PXRFSTA	PTRBDPL_DESC PXRFSTA_DESC	NO NO	NO
EFFECTIVE_DATE	Date the benefit/deduction becomes effective.	DATE	PDRDEDN	PDRDEDN_EFFECTIVE_DATE	NO	NO
EFFECTIVE_END_DATE	End effective date.	DATE	FUNCTION	POKODSF.F_GET_END_PDRDEDN_DATE	NO	NO
EFFECTIVE_START_DATE	Start effective date.	DATE	PDRDEDN	PDRDEDN_EFFECTIVE_DATE	NO	NO
EMPLOYEE_ANNUAL_DEDN_LIMIT	Maximum annual employee cost for benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYEE_BOND_PURCHASE_AMOUNT	Bond amount increment in which the employee desires to purchase Savings Bonds.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYEE_CONTRIBUTION_QTR1	Quarter 1 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_QTR2	Quarter 2 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_QTR3	Quarter 3 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_QTR4	Quarter 4 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_YTD	Year to date employee contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_DEDN_LTD_LIMIT	Maximum life-to-date employee cost.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYEE_DEDN_MTD_LIMIT	Maximum month-to-date employee cost.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYEE_DEDUCTION_AMOUNT	Employee cost or deduction amount per pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYEE_DEDUCTION_PERCENT	Employee cost; percentage of gross pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYEE_MINIMUM_EARNINGS	Minimum amount the employee can be paid per pay. Used to determine if deduction, or portion thereof, can be processed in current pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYEE_MINIMUM_YTD_GROSS	Minimum amount the employee must earn in a calendar year before this deduction is taken.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYER_CONTRIBUTION_QTR1	Quarter 1 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_QTR2	Quarter 2 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_QTR3	Quarter 3 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_QTR4	Quarter 4 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_YTD	Year to date employer contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_DEDUCTION_AMOUNT	Employer cost; flat amount deduction per pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYER_DEDUCTION_PERCENT	Employer cost; percentage of gross pay	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYER_IDENTIFICATION_NUMBER	Employer identification number.	VARCHAR2(255)	NA	NA	NO	NO
GROSS_COMPENSATION_YTD	Year to date gross contribution.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
LIFE_INSURANCE_OVERRIDE_AMOUNT	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
LIFE_INSURANCE_PREMIUM	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
LIFE_INSURANCE_SALARY	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
LIFE_INSURANCE_TYPE_IND	First amount field for the benefit/deduction.	VARCHAR2(2)	FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS	NO	NO
LIFE_INSURANE_COVERAGE_AMOUNT	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
MAXIMUM_ARREARS_RECOVERY	Maximum amount of arrears allowed to be recovered in a pay event. This is the maximum amount to be recovered during a pay period when an arrears balance exists.	NUMBER	PDRBDED	PDRBDED_ARR_RECOVER_MAX	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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OPTION1	First option code for the benefit/deduction code.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE1	NO	NO
OPTION1_TITLE	Option 1 description. Six character title that prompts user for what option to enter.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION1_TITLE	NO	NO
OPTION2	Second option code for the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE2	NO	NO
OPTION2_TITLE	Option 2 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION2_TITLE	NO	NO
OPTION3	Third option code for the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE3	NO	NO
OPTION3_TITLE	Option 3 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION3_TITLE	NO	NO
OPTION4	Fourth option code for the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE4	NO	NO
OPTION4_TITLE	Option 4 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION4_TITLE	NO	NO
OPTION5	Fifth option code for the benefit/deduction code.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE5	NO	NO
OPTION5_TITLE	Option 5 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION5_TITLE	NO	NO
PAYROLL_DEDUCTION_YEAR	Deduction year.	NUMBER	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBDED	PDRBDED_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
PROFILE_DATE	Profile Date associated with this record.	DATE	FUNCTION	F_YEAR	NO	NO
REFERENCE_NUMBER	An optional alpha/numeric field.	VARCHAR2(10)	PDRDEDN	PDRDEDN_REF_NO	NO	NO
STATUS	Status of the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_STATUS	NO	NO
STATUS_DESC	Status description.	VARCHAR2(255)	CALCULATION	DECODE(PDRDEDN_STATUS,'A','ACTIVE','B','EXEMPT','W','WAIVE','T','TERMINATED',')	NO	NO
W4_NAME_CHANGE_IND	Indicator checked from Self Service for W4 signifying last name of employee differs from Social Security card name. Valid values are N(o) and Y(es). Default value is N.	VARCHAR2(1)	PDRDEDN	PDRDEDN_W4_NAME_CHANGE_IND	NO	NO
W4_SIGNED_DATE	Employee electronic signature date and time captured from Self service.	DATE	PDRDEDN	PDRDEDN_W4_SIGNED_DATE	NO	NO
W4_SIGNED_PIDM	Internal identification number of the user that electronically signed W4 in Self service.	VARCHAR2(8)	PDRDEDN	PDRDEDN_W4_SIGNED_PIDM	NO	NO

Ver: 9.2