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_DEDUCTION

Description Contains monthly details regarding all employee deductions.
Key & Frequency One row per person per employer per payroll deduction month per payroll deduction year per carrier.
Recommended Search Columns PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER, PAYROLL_DEDUCTION_MONTH
PERSON_UID, PAYROLL_DEDUCTION_YEAR, EMPLOYER, CARRIER, PAYROLL_DEDUCTION_MONTH
PAYROLL_DEDUCTION_YEAR, PAYROLL_DEDUCTION_MONTH

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
APPLICABLE_GROSS_AMOUNT Total gross compensation toward which deduction is applicable.    

PERDTOT

PERDTOT_APPL_GRS

 
BENEFIT_GROUP Benefit group.    

PTRBDCA

PTRBDCA_BDTY_CODE

 
CARRIER Identifies the specific benefit/deduction provider.    

PERDTOT

PERDTOT_BDCA_CODE

 
CARRIER_LONG_DESC Benefit/deduction long description.    

FUNCTION

GOKODSF.F_GET_DESC

 
CARRIER_SHORT_DESC Benefit/deduction short description.    

FUNCTION

GOKODSF.F_GET_DESC

 
COVERAGE_OPTION Coverage option associated with this benefit.    

NA

NA

 
COVERAGE_OPTION_DESC Coverage option description.    

NA

NA

 
EMPLOYEE_CONTRIBUTION_AMOUNT Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_FYTD Fiscal year to date employee contribution for a specific deduction.    

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

 
EMPLOYER Employer identification code.    

PERDTOT

PERDTOT_EMPR_CODE

 
EMPLOYER_CONTRIBUTION_AMOUNT Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_FYTD Fiscal year to date employer contribution for a specific deduction.    

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

 
GROSS_COMPENSATION_FYTD Fiscal year to date gross contribution.    

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
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

 
NAME Name of the person (last name, first name, middle initial) or organization.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
PAYROLL_DEDUCTION_MONTH 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