Reporting View Target: MONTHLY_DEDUCT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: MONTHLY_DEDUCT_SLOT

Description Uses data from the MONTHLY_DEDUCTION view, displays 12 months of employee and employer deductions from payroll and summarizes those amounts by quarter.
Key & Frequency One row per person per payroll deduction year per carrier.
Recommended Search Columns PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

NA

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.5

Description	Uses data from the MONTHLY_DEDUCTION view, displays 12 months of employee and employer deductions from payroll and summarizes those amounts by quarter.
Key & Frequency	One row per person per payroll deduction year per carrier.
Recommended Search Columns	PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER ACTIVITY_DATE

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	NA
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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