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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date record was inserted or updated    

NA

NA

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
APPLICABLE_GROSS_AMOUNT1 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT10 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT11 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT12 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT2 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT3 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT4 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT5 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT6 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT7 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT8 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_AMOUNT9 Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_QTR1 Applicable gross quarter 1.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
APPLICABLE_GROSS_QTR2 Applicable gross quarter 2    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
APPLICABLE_GROSS_QTR3 Applicable gross quarter 3.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
APPLICABLE_GROSS_QTR4 Applicable gross quarter 4.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
CARRIER Identifies the specific benefit/deduction provider.    

PERDTOT

PERDTOT_BDCA_CODE

 
EMPLOYEE_CONTRIBUTION_AMOUNT1 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT10 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT11 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT12 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT2 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT3 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT4 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT5 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT6 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT7 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT8 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_AMOUNT9 Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_QRT1 Employee contribution quarter 1.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_QRT2 Employee contribution quarter 2.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_QRT3 Employee contribution quarter 3.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_QRT4 Employee contribution quarter 4.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_YTD Employee contribution year to date.    

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_AMOUNT1 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT10 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT11 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT12 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT2 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT3 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT4 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT5 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT6 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT7 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT8 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_AMOUNT9 Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_QTR1 Employer contribution quarter 1.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_QTR2 Employer contribution quarter 2.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_QTR3 Employer contribution quarter 3.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_QTR4 Employer contribution quarter 4.    

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_YTD Employer contribution year to date.    

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

 
GROSS_COMPENSATION_YTD Gross Compensation year to date.    

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
PAYROLL_DEDUCTION_MONTH1 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH10 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH11 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH12 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH2 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH3 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH4 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH5 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH6 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH7 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH8 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_MONTH9 Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

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

PERDTOT

PERDTOT_YEAR

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

PERDTOT

PERDTOT_PIDM

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3