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