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(2)	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(2000)	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(2)	PTRBDCA	PTRBDCA_ACA_OFFER_COVERAGE_CDE	NO	NO
ACA_OFFER_COVERAGE_CODE_DESC	Description of Offer Coverage Code reported for year-end reporting.	VARCHAR2(2000)	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
AMOUNT1	First amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT1	NO	NO
AMOUNT1_TITLE	Long description associated with amount 1.	VARCHAR2(8)	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(8)	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(8)	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(8)	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(8)	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(8)	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(8)	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(8)	PTRBDCA	PTRBDCA_AMT8_TITLE	NO	NO
ARREARS_BALANCE		NUMBER				NO
BENEFIT_DEDUCTION_IND	Indicates if this is a benefit deduction.	VARCHAR2(30)	FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS	NO	NO
BENEFIT_DEDUCTION_TYPE	Benefit deduction type.	VARCHAR2(2)	PTRBDCA	PTRBDCA_BDTY_CODE	NO	NO
BENEFIT_DEDUCTION_TYPE_DESC	Benefit deduction type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
BENEFIT_GROUP	Benefit group.	VARCHAR2(2)	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	This rule defines how a benefit or deduction is processed by the system.	VARCHAR2(2)	PTRBDCA	PTRBDCA_CALC_RULE	NO	NO
CARRIER	Identifies the specific benefit/deduction provider.	VARCHAR2(3)	PDRDEDN	PDRDEDN_BDCA_CODE	NO	NO
CARRIER_LONG_DESC	Benefit/deduction long description.	VARCHAR2(30)	PTRBDCA	PTRBDCA_LONG_DESC	NO	NO
CARRIER_SHORT_DESC	Benefit/deduction short description.	VARCHAR2(8)	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(2)	PDRDEDN	PDRDEDN_OPT_CODE1	NO	NO
COVERAGE_OPTION_DESC	Coverage option description.	VARCHAR2(30)	PDRDEDN	PDRDEDN_OPT_CODE1	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	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_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_DEDUCTION_AMOUNT	Employer cost; flat amount deduction per pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
EMPLOYER_IDENTIFICATION_NUMBER	Employer identification number.	VARCHAR2(0)	NA	NA	NO	NO
LIFE_INSURANCE_OVERRIDE_AMOUNT	Manually entered life insurance coverage amount for employee.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
LIFE_INSURANCE_PREMIUM	Employee or employer cost of the life insurance benefit.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
LIFE_INSURANCE_SALARY	Employee salary used to calculated the insurance coverage.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
LIFE_INSURANCE_TYPE_IND	Indicates whether the life insurance deduction is employee or employer paid.	VARCHAR2(30)	FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS	NO	NO
LIFE_INSURANE_COVERAGE_AMOUNT	Coverage amount of the employees life insurance when no override is entered.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS	NO	NO
MAXIMUM_ARREARS_RECOVERY		NUMBER				NO
MAXIMUM_REARS_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
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
OPTION1	First option code for the benefit/deduction code. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.	VARCHAR2(2)	PDRDEDN	PDRDEDN_OPT_CODE1	NO	NO
OPTION1_TITLE	Option 1 description. Six character title that prompts user for what option to enter.	VARCHAR2(8)	PTRBDCA	PTRBDCA_OPTION1_TITLE	NO	NO
OPTION2	Second option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.	VARCHAR2(2)	PDRDEDN	PDRDEDN_OPT_CODE2	NO	NO
OPTION2_TITLE	Option 2 description.	VARCHAR2(8)	PTRBDCA	PTRBDCA_OPTION2_TITLE	NO	NO
OPTION3	Third option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.	VARCHAR2(2)	PDRDEDN	PDRDEDN_OPT_CODE3	NO	NO
OPTION3_TITLE	Option 3 description.	VARCHAR2(8)	PTRBDCA	PTRBDCA_OPTION3_TITLE	NO	NO
OPTION4	Fourth option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.	VARCHAR2(2)	PDRDEDN	PDRDEDN_OPT_CODE4	NO	NO
OPTION4_TITLE	Option 4 description.	VARCHAR2(8)	PTRBDCA	PTRBDCA_OPTION4_TITLE	NO	NO
OPTION5	Fifth option code for the benefit/deduction code. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.	VARCHAR2(2)	PDRDEDN	PDRDEDN_OPT_CODE5	NO	NO
OPTION5_TITLE	Option 5 description.	VARCHAR2(8)	PTRBDCA	PTRBDCA_OPTION5_TITLE	NO	NO
PAYROLL_DEDUCTION_YEAR	Deduction year.	VARCHAR2(0)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRDEDN	PDRDEDN_PIDM	NO	NO
PROFILE_DATE	Profile Date associated with this record.	VARCHAR2(0)	FUNCTION	F_YEAR	NO	NO
REARS_BALANCE	Arrears balance due the employer.	NUMBER	PDRBDED	PDRBDED_ARR_BALANCE	NO	NO
REFERENCE_NUMBER	An optional alpha/numeric field.	VARCHAR2(10)	PDRDEDN	PDRDEDN_REF_NO	NO	NO
STATUS	Status of the benefit/deduction.	VARCHAR2(1)	PDRDEDN	PDRDEDN_STATUS	NO	NO
STATUS_DESC	Status description.	VARCHAR2(30)	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
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: