Target Column	Business Definition	Database Data Type	Source Name	Source Column
APPLICABLE_GROSS_AMOUNT	Total gross compensation toward which deduction is applicable.	NUMBER(11, 2)	PERDTOT	PERDTOT_APPL_GRS
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
APPLICABLE_GROSS_QTR12	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	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	Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
BENEFIT_GROUP	Benefit group.	VARCHAR2(2)	PTRBDCA	PTRBDCA_BDTY_CODE
CARRIER	Identifies the specific benefit/deduction provider.	VARCHAR2(3)	PERDTOT	PERDTOT_BDCA_CODE
CARRIER_LONG_DESC	Benefit/deduction long description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
CARRIER_SHORT_DESC	Benefit/deduction short description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
COVERAGE_OPTION	Coverage option associated with this benefit.	VARCHAR2(0)	NA	NA
COVERAGE_OPTION_DESC	Coverage option description.	VARCHAR2(0)	NA	NA
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EMPLOYEE_CONTRIBUTION_AMOUNT	Employee contribution amount toward the deduction.	NUMBER(11, 2)	PERDTOT	PERDTOT_EMPL_AMT
EMPLOYEE_CONTRIBUTION_FYTD	Fiscal year to date employee contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_CALC_DEDUCTIONS_FYTD
EMPLOYEE_CONTRIBUTION_QRT1	Quarter 1 employee total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QRT2	Quarter 2 employee total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QRT3	Quarter 3 employee total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QRT4	Quarter 4 employee total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_YTD	Year to date employee contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
EMPLOYER	Employer identification code.	VARCHAR2(4)	PERDTOT	PERDTOT_EMPR_CODE
EMPLOYER_CONTRIBUTION_AMOUNT	Employer contribution amount toward the deduction.	NUMBER(11, 2)	PERDTOT	PERDTOT_EMPR_AMT
EMPLOYER_CONTRIBUTION_FYTD	Fiscal year to date employer contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_CALC_DEDUCTIONS_FYTD
EMPLOYER_CONTRIBUTION_QTR1	Quarter 1 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR2	Quarter 2 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR3	Quarter 3 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR4	Quarter 4 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_YTD	Year to date employer contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
GROSS_COMPENSATION_FYTD	Fiscal year to date gross contribution (total employee contribution plus total employee contribution) for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_CALC_DEDUCTIONS_FYTD
GROSS_COMPENSATION_YTD	Year to date gross contribution (total employee contribution plus total employee contribution) for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PAYROLL_DEDUCTION_MONTH	Calendar month in which the payroll deduction took place.	NUMBER(2)	PERDTOT	PERDTOT_MONTH
PAYROLL_DEDUCTION_YEAR	Payroll deduction year; calendar year in which the payroll deduction took place for this record.	NUMBER(4)	PERDTOT	PERDTOT_YEAR
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	PERDTOT	PERDTOT_PIDM
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: 8.1