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

Banner Operational Data Store
Reporting View Target: PAYROLL_DEDUCTION

Description Contains payroll deduction information specific to each payroll.
Key & Frequency One row per payroll identifier per calendar year per payroll number per event sequence number per deduction per person.
Recommended Search Columns CALENDAR_YEAR,PAYROLL_IDENTIFIER,PAYROLL_NUMBER,EVENT_SEQUENCE_NUMBER,PERSON_UID
PERSON_UID,DEDUCTION

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 Total gross compensation toward which deduction is applicable. The applicable gross is calculated by taking the gross pay and reducing it by the pre-tax deductions and by adding to the gross pay taxable benefits. NUMBER

PHRDEDN

PHRDEDN_APPLICABLE_GROSS

NO

NO
ARREARAGE_RECOVERED_AMOUNT The amount of arrearage recovered this pay period. NUMBER

PHRDEDN

PHRDEDN_ARREAR_RECOVERED

NO

NO
ARREARAGE_TAKEN_AMOUNT The amount of arrearage generated during this pay period. NUMBER

PHRDEDN

PHRDEDN_ARREAR_TAKEN

NO

NO
CALENDAR_YEAR The Calendar Year associated with the Payroll Identifier. VARCHAR2(63)

PHRDEDN

PHRDEDN_YEAR

NO

NO
DEDUCTION Identifies the specific Benefit/deduction. VARCHAR2(63)

PHRDEDN

PHRDEDN_BDCA_CODE

NO

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

PTRBDCA

PTRBDCA_LONG_DESC

NO

NO
EFFECTIVE_DATE The effective date associated with the deduction for this pay period. DATE

PHRDEDN

PHRDEDN_EFFECTIVE_DATE

NO

NO
EMPLOYEE_DEDUCTION_AMOUNT Employee deduction amount. NUMBER

PHRDEDN

PHRDEDN_EMPLOYEE_AMT

NO

NO
EMPLOYER User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas. VARCHAR2(63)

PHRDEDN

PHRDEDN_EMPR_CODE

NO

NO
EMPLOYER_DEDUCTION_AMOUNT Employer deduction amount. NUMBER

PHRDEDN

PHRDEDN_EMPLOYER_AMT

NO

NO
EMPLOYER_DESC Employer_Code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
EVENT_SEQUENCE_NUMBER Sequence of the pay event. NUMBER

PHRDEDN

PHRDEDN_SEQ_NO

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 Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PAYROLL_IDENTIFIER Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

PHRDEDN

PHRDEDN_PICT_CODE

NO

NO
PAYROLL_IDENTIFIER_DESC Payroll code description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PAYROLL_NUMBER The Pay Number is used to uniquely identify a pay period within a fiscal year. NUMBER

PHRDEDN

PHRDEDN_PAYNO

NO

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

PHRDEDN

PHRDEDN_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
STATUS Status of the deduction. VARCHAR2(63)

PHRDEDN

PHRDEDN_STATUS

NO

NO
STATUS_DESC Status description. VARCHAR2(255)

PHRDEDN

PHRDEDN_STATUS

NO

NO
TAX_DEDUCTION_IND Indicates if the deduction is a tax deduction. VARCHAR2(63)

CALCULATION

DECODE(PTRBDCA_CALC_RULE)

NO

NO


Ver: 9.2