Target Column	Business Definition	Database Data Type	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 associated with this benefit.	VARCHAR2(30)	FUNCTION	POKODSF.F_GET_COVERAGE_OPTION
COVERAGE_OPTION_DESC	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	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	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	PERDTOT	PERDTOT_MONTH
PAYROLL_DEDUCTION_YEAR	Payroll deduction year; calendar year in which the payroll deduction took place for this record.	NUMBER	PERDTOT	PERDTOT_YEAR
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	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: