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 Name Business Definition Database Data Type Domain Value Source Name Source Column

ACTIVITY_DATE Activity Date Date record was inserted or updated DATE
NA

NA

ADMINISTRATIVE_GROUP 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 Applicable Gross Amount 1 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 Applicable Gross Amount 10 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 Applicable Gross Amount 11 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 Applicable Gross Amount 12 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 Applicable Gross Amount 2 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 Applicable Gross Amount 3 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 Applicable Gross Amount 4 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 Applicable Gross Amount 5 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 Applicable Gross Amount 6 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 Applicable Gross Amount 7 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 Applicable Gross Amount 8 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 Applicable Gross Amount 9 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 Applicable Gross Quarter 1 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 Applicable Gross Quarter 2 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 Applicable Gross Quarter 3 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 Applicable Gross Quarter 4 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 Carrier Identifies the specific benefit/deduction provider. VARCHAR2(63)
PERDTOT

PERDTOT_BDCA_CODE

EMPLOYEE_CONTRIBUTION_AMOUNT1 Employee Contribution Amount 1 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT10 Employee Contribution Amount 10 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT11 Employee Contribution Amount 11 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT12 Employee Contribution Amount 12 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT2 Employee Contribution Amount 2 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT3 Employee Contribution Amount 3 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT4 Employee Contribution Amount 4 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT5 Employee Contribution Amount 5 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT6 Employee Contribution Amount 6 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT7 Employee Contribution Amount 7 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT8 Employee Contribution Amount 8 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT9 Employee Contribution Amount 9 Employee contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_QRT1 Employee Contribution Quarter 1 Employee contribution quarter 1. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT2 Employee Contribution Quarter 2 Employee contribution quarter 2. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT3 Employee Contribution Quarter 3 Employee contribution quarter 3. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT4 Employee Contribution Quarter 4 Employee contribution quarter 4. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_YTD Employee Contribution Year to Date Employee contribution year to date. NUMBER
FUNCTION

F_YEARLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_AMOUNT1 Employer Contribution Amount 1 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT10 Employer Contribution Amount 10 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT11 Employer Contribution Amount 11 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT12 Employer Contribution Amount 12 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT2 Employer Contribution Amount 2 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT3 Employer Contribution Amount 3 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT4 Employer Contribution Amount 4 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT5 Employer Contribution Amount 5 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT6 Employer Contribution Amount 6 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT7 Employer Contribution Amount 7 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT8 Employer Contribution Amount 8 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT9 Employer Contribution Amount 9 Employer contribution amount toward the deduction. NUMBER
PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_QTR1 Employer Contribution Quarter 1 Employer contribution quarter 1. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR2 Employer Contribution Quarter 2 Employer contribution quarter 2. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR3 Employer Contribution Quarter 3 Employer contribution quarter 3. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR4 Employer Contribution Quarter 4 Employer contribution quarter 4. NUMBER
FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_YTD Employer Contribution Year to Date Employer contribution year to date. NUMBER
FUNCTION

F_YEARLY_DEDUCTION_TOTAL

GROSS_COMPENSATION_YTD Gross Compensation Year to Date Gross Compensation year to date. NUMBER
FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PAYROLL_DEDUCTION_MONTH1 Payroll Deduction Month 1 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH10 Payroll Deduction Month 10 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH11 Payroll Deduction Month 11 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH12 Payroll Deduction Month 12 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH2 Payroll Deduction Month 2 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH3 Payroll Deduction Month 3 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH4 Payroll Deduction Month 4 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH5 Payroll Deduction Month 5 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH6 Payroll Deduction Month 6 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH7 Payroll Deduction Month 7 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH8 Payroll Deduction Month 8 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH9 Payroll Deduction Month 9 Calendar month in which the payroll deduction took place. NUMBER
PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_YEAR Payroll Deduction Year Payroll deduction year; calendar year in which the payroll deduction took place for this record. NUMBER
PERDTOT

PERDTOT_YEAR

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
PERDTOT

PERDTOT_PIDM

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

NA

Ver: 9.0

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