Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
APPLICABLE_GROSS_AMOUNT1	Month 1 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	NO	NO
APPLICABLE_GROSS_AMOUNT10	Month 10 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	NO	NO
APPLICABLE_GROSS_AMOUNT11	Month 11 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	NO	NO
APPLICABLE_GROSS_AMOUNT12	Month 12 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	NO	NO
APPLICABLE_GROSS_AMOUNT2	Month 2 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	NO	NO
APPLICABLE_GROSS_AMOUNT3	Month 3 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	NO	NO
APPLICABLE_GROSS_AMOUNT4	Month 4 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	NO	NO
APPLICABLE_GROSS_AMOUNT5	Month 5 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	NO	NO
APPLICABLE_GROSS_AMOUNT6	Month 6 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	NO	NO
APPLICABLE_GROSS_AMOUNT7	Month 7 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	NO	NO
APPLICABLE_GROSS_AMOUNT8	Month 8 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	NO	NO
APPLICABLE_GROSS_AMOUNT9	Month 9 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	NO	NO
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	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
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	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
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	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
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	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
CARRIER	Identifies the specific benefit/deduction provider.	VARCHAR2(63)	PERDTOT	PERDTOT_BDCA_CODE	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT1	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT10	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT11	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT12	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT2	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT3	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT4	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT5	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT6	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT7	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT8	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_AMOUNT9	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT	NO	NO
EMPLOYEE_CONTRIBUTION_QRT1	Employee contribution quarter 1.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_QRT2	Employee contribution quarter 2.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_QRT3	Employee contribution quarter 3.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_QRT4	Employee contribution quarter 4.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYEE_CONTRIBUTION_YTD	Employee contribution year to date.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT1	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT10	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT11	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT12	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT2	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT3	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT4	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT5	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT6	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT7	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT8	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_AMOUNT9	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT	NO	NO
EMPLOYER_CONTRIBUTION_QTR1	Employer contribution quarter 1.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_QTR2	Employer contribution quarter 2.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_QTR3	Employer contribution quarter 3.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_QTR4	Employer contribution quarter 4.	NUMBER	FUNCTION	F_QUATERLY_DEDUCTION_TOTAL	NO	NO
EMPLOYER_CONTRIBUTION_YTD	Employer contribution year to date.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL	NO	NO
GROSS_COMPENSATION_YTD	Gross Compensation year to date.	NUMBER	FUNCTION	POKODSF.F_CALC_DEDUCTIONS_FYTD	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PAYROLL_DEDUCTION_MONTH1	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH10	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH11	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH12	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH2	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH3	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH4	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH5	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH6	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH7	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH8	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_MONTH9	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH	NO	NO
PAYROLL_DEDUCTION_YEAR	Payroll deduction year; calendar year in which the payroll deduction took place for this record.	NUMBER	PERDTOT	PERDTOT_YEAR	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERDTOT	PERDTOT_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2