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

Ver: 8.1