Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
APPLICABLE_GROSS_AMOUNT		Monthly applicable gross amount for each deduction is the sum of applicable gross amounts for all the payrolls processed within the month. The applicable gross amount for each deduction is calculated by the payroll process taking the gross pay and reducing it by the deductions that are considered to be pre-tax and by adding to the gross pay those benefits that are considered to be taxable.	NUMBER		PERDTOT	PERDTOT_APPL_GRS
APPLICABLE_GROSS_QTR1		Quarter 1 (sum months 1,2,3 for the pay year) applicable gross is derived from the deduction's applicable gross (monthly amount) resulting from the payroll process.	NUMBER		FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR2		Quarter 2 (sum months 4,5,6 for the pay year) applicable gross is derived from the deduction's applicable gross (monthly amount) resulting from the payroll process.	NUMBER		FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR3		Quarter 3 (sum months 7,8,9 for the pay year) applicable gross is derived from the deduction's applicable gross (monthly amount) resulting from the payroll process.	NUMBER		FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR4		Quarter 4 (sum months 10,11,12 for the pay year) applicable gross is derived from the deduction's applicable gross (monthly amount) resulting from the payroll process.	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	Coverage option associated with this benefit.	VARCHAR2(30)		FUNCTION	POKODSF.F_GET_COVERAGE_OPTION
COVERAGE_OPTION_DESC	Coverage Option Description	Coverage option description.	VARCHAR2(30)		FUNCTION	POKODSF.F_GET_COVERAGE_OPTION_DESC
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: