Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACA_4980H_SAFE_HARBOR_CODE	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
ACA_4980H_SAFE_HARBOR_DESC	ACA 4980H Safe Harbor Code Description	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
ACA_HEALTH_PROVIDER_IND	ACA Health Provider Indicator	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
ACA_MONTHLY_PREMIUM_SELF_AMT	ACA Monthly Premium Self Amount	Monthly Premium Amount for Employee self-coverage.	NUMBER	PTRBDCA	PTRBDCA_ACA_MLY_PREM_SELF_AMT
ACA_OFFER_COVERAGE_CODE	ACA Offer Coverage Code	Offer Coverage Code reported for year-end reporting.	VARCHAR2(63)	PTRBDCA	PTRBDCA_ACA_OFFER_COVERAGE_CDE
ACA_OFFER_COVERAGE_CODE_DESC	ACA Offer Coverage Code Description	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
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AMOUNT1	Amount 1	First amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT1
AMOUNT1_TITLE	Amount 1 Title	Long description associated with amount 1.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT1_TITLE
AMOUNT2	Amount 2	Second amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT2
AMOUNT2_TITLE	Amount 2 Title	Long description associated with amount 2.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT2_TITLE
AMOUNT3	Amount 3	Third amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT3
AMOUNT3_TITLE	Amount 3 Title	Long description associated with amount 3.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT3_TITLE
AMOUNT4	Amount 4	Fourth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT4
AMOUNT4_TITLE	Amount 4 Title	Long description associated with amount 1.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT4_TITLE
AMOUNT5	Amount 5	Fifth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT5
AMOUNT5_TITLE	Amount 5 Title	Long description associated with amount 5.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT5_TITLE
AMOUNT6	Amount 6	Sixth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT6
AMOUNT6_TITLE	Amount 6 Title	Long description associated with amount 6.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT6_TITLE
AMOUNT7	Amount 7	Seventh amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT7
AMOUNT7_TITLE	Amount 7 Title	Long description associated with amount 7.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT7_TITLE
AMOUNT8	Amount 8	Eighth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT8
AMOUNT8_TITLE	Amount 8 Title	Long description associated with amount 8.	VARCHAR2(255)	PTRBDCA	PTRBDCA_AMT8_TITLE
APPLICABLE_GROSS_QTR1	Applicable Gross Quarter 1	Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR2	Applicable Gross Quarter 2	Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR3	Applicable Gross Quarter 3	Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR4	Applicable Gross Quarter 4	Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
ARREARS_BALANCE	Arrears Balance	Arrears balance due the employer.	NUMBER	PDRBDED	PDRBDED_ARR_BALANCE
BENEFICIARY_COUNT	Beneficiary Count	Count of beneficiaries.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_BENEFICIARY
BENEFIT_DEDUCTION_IND	Benefit Deduction Indicator	Indicates if this is a benefit deduction.	VARCHAR2(2)	FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
BENEFIT_DEDUCTION_TYPE	Benefit Deduction Type	Benefit deduction type.	VARCHAR2(63)	PTRBDCA	PTRBDCA_BDTY_CODE
BENEFIT_DEDUCTION_TYPE_DESC	Benefit Deduction Type Description	Benefit deduction type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
BENEFIT_GROUP	Benefit Group	Benefit group.	VARCHAR2(255)	PTRBDCA	PTRBDCA_BDTY_CODE
BOND_BALANCE	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
CALCULATION_RULE	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
CARRIER	Carrier	Identifies the specific benefit/deduction provider.	VARCHAR2(63)	PDRBDED	PDRBDED_BDCA_CODE
CARRIER_LONG_DESC	Carrier Long Description	Benefit/deduction long description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_LONG_DESC
CARRIER_SHORT_DESC	Carrier Short Description	Benefit/deduction short description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_SHORT_DESC
COVERAGE_BEGIN_DATE	Coverage Begin Date	Date the benefit/deduction begins.	DATE	PDRBDED	PDRBDED_BEGIN_DATE
COVERAGE_END_DATE	Coverage End Date	Date the benefit/deduction ends.	DATE	PDRBDED	PDRBDED_END_DATE
COVERAGE_OPTION	Coverage Option	Coverage option associated with this benefit.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE1
COVERAGE_OPTION_DESC	Coverage Option Description	Coverage option description.	VARCHAR2(255)	PTRBDPL PXRFSTA	PTRBDPL_DESC PXRFSTA_DESC
EFFECTIVE_DATE	Effective Date	Date the benefit/deduction becomes effective.	DATE	PDRDEDN	PDRDEDN_EFFECTIVE_DATE
EFFECTIVE_END_DATE	Effective End Date	End effective date.	DATE	FUNCTION	POKODSF.F_GET_END_PDRDEDN_DATE
EFFECTIVE_START_DATE	Effective Start Date	Start effective date.	DATE	PDRDEDN	PDRDEDN_EFFECTIVE_DATE
EMPLOYEE_ANNUAL_DEDN_LIMIT	Employee Annual Dedn Limit	Maximum annual employee cost for benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_BOND_PURCHASE_AMOUNT	Employee Bond Purchase Amount	Bond amount increment in which the employee desires to purchase Savings Bonds.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_CONTRIBUTION_QTR1	Employee Contribution Quarter 1	Quarter 1 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QTR2	Employee Contribution Quarter 2	Quarter 2 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QTR3	Employee Contribution Quarter 3	Quarter 3 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QTR4	Employee Contribution Quarter 4	Quarter 4 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_YTD	Employee Contribution Year to Date	Year to date employee contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
EMPLOYEE_DEDN_LTD_LIMIT	Employee Dedn Ltd Limit	Maximum life-to-date employee cost.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_DEDN_MTD_LIMIT	Employee Dedn Mtd Limit	Maximum month-to-date employee cost.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_DEDUCTION_AMOUNT	Employee Deduction Amount	Employee cost or deduction amount per pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_DEDUCTION_PERCENT	Employee Deduction Percent	Employee cost; percentage of gross pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_MINIMUM_EARNINGS	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
EMPLOYEE_MINIMUM_YTD_GROSS	Employee Minimum Year to Date Gross	Minimum amount the employee must earn in a calendar year before this deduction is taken.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYER_ANNUAL_DEDN_LIMIT	Employer Annual Dedn Limit	Maximum employer cost on annual basis.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYER_CONTRIBUTION_QTR1	Employer Contribution Quarter 1	Quarter 1 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR2	Employer Contribution Quarter 2	Quarter 2 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR3	Employer Contribution Quarter 3	Quarter 3 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR4	Employer Contribution Quarter 4	Quarter 4 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_YTD	Employer Contribution Year to Date	Year to date employer contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
EMPLOYER_DEDN_MTD_LIMIT	Employer Dedn Mtd Limit	Maximum month-to-date employer cost.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYER_DEDUCTION_AMOUNT	Employer Deduction Amount	Employer cost; flat amount deduction per pay.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYER_DEDUCTION_PERCENT	Employer Deduction Percent	Employer cost; percentage of gross pay	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYER_IDENTIFICATION_NUMBER	Employer ID Number	Employer identification number.	VARCHAR2(255)	NA	NA
GROSS_COMPENSATION_YTD	Gross Compensation Year to Date	Year to date gross contribution.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
ID	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
LIFE_INSURANCE_OVERRIDE_AMOUNT	Life Insurance Override Amount	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
LIFE_INSURANCE_PREMIUM	Life Insurance Premium	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
LIFE_INSURANCE_SALARY	Life Insurance Salary	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
LIFE_INSURANCE_TYPE_IND	Life Insurance Type Indicator	First amount field for the benefit/deduction.	VARCHAR2(2)	FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
LIFE_INSURANE_COVERAGE_AMOUNT	Life Insurane Coverage Amount	First amount field for the benefit/deduction.	NUMBER	FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
MAXIMUM_ARREARS_RECOVERY	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
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OPTION1	Option 1	First option code for the benefit/deduction code.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE1
OPTION1_TITLE	Option 1 Title	Option 1 description. Six character title that prompts user for what option to enter.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION1_TITLE
OPTION2	Option 2	Second option code for the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE2
OPTION2_TITLE	Option 2 Title	Option 2 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION2_TITLE
OPTION3	Option 3	Third option code for the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE3
OPTION3_TITLE	Option 3 Title	Option 3 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION3_TITLE
OPTION4	Option 4	Fourth option code for the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE4
OPTION4_TITLE	Option 4 Title	Option 4 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION4_TITLE
OPTION5	Option 5	Fifth option code for the benefit/deduction code.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE5
OPTION5_TITLE	Option 5 Title	Option 5 description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_OPTION5_TITLE
PAYROLL_DEDUCTION_YEAR	Payroll Deduction Year	Deduction year.	NUMBER	NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBDED	PDRBDED_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROFILE_DATE	Profile Date	Profile Date associated with this record.	DATE	FUNCTION	F_YEAR
REFERENCE_NUMBER	Reference Number	An optional alpha/numeric field.	VARCHAR2(10)	PDRDEDN	PDRDEDN_REF_NO
STATUS	Status	Status of the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_STATUS
STATUS_DESC	Status Description	Status description.	VARCHAR2(255)	CALCULATION	DECODE(PDRDEDN_STATUS,'A','ACTIVE','B','EXEMPT','W','WAIVE','T','TERMINATED',')
W4_NAME_CHANGE_IND	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
W4_SIGNED_DATE	W4 Signed DATE	Employee electronic signature date and time captured from Self service.	DATE	PDRDEDN	PDRDEDN_W4_SIGNED_DATE
W4_SIGNED_PIDM	W4 Signed PIDM	Internal identification number of the user that electronically signed W4 in Self service.	NUMBER	PDRDEDN	PDRDEDN_W4_SIGNED_PIDM

Ver: 9.2