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

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

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
APPLICABLE_GROSS_AMOUNT Monthly 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

NO

NO
BENEFIT_GROUP Benefit group. VARCHAR2(63)

PTRBDCA

PTRBDCA_BDTY_CODE

NO

NO
CARRIER Identifies the specific benefit/deduction provider. VARCHAR2(63)

PERDTOT

PERDTOT_BDCA_CODE

NO

NO
CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COVERAGE_OPTION Coverage option associated with this benefit. VARCHAR2(63)

NA

NA

NO

NO
COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(255)

NA

NA

NO

NO
EMPLOYEE_CONTRIBUTION_AMOUNT Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

NO

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

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

NO

NO
EMPLOYER Employer identification code. VARCHAR2(63)

PERDTOT

PERDTOT_EMPR_CODE

NO

NO
EMPLOYER_CONTRIBUTION_AMOUNT Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

NO

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

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

NO

NO
GROSS_COMPENSATION_FYTD Fiscal year to date gross contribution. NUMBER

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

NO

NO
ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PAYROLL_DEDUCTION_MONTH Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

NO

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

PERDTOT

PERDTOT_YEAR

NO

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

PERDTOT

PERDTOT_PIDM

NO

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

NA

NA

NO

NO


Ver: 9.2