Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: BENEFIT_DEDUCTION

Description Contains employee benefit deduction detail.
Key & Frequency One row per person per carrier per effective date.
Recommended Search Columns PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER
PERSON_UID, CARRIER, EFFECTIVE_DATE

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

NA

NA

AMOUNT1 First amount field for the benefit/deduction. NUMBER

PDRDEDN

PDRDEDN_AMOUNT1

AMOUNT1_TITLE Long description associated with amount 1. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT1_TITLE

AMOUNT2 Second amount field for the benefit/deduction. NUMBER

PDRDEDN

PDRDEDN_AMOUNT2

AMOUNT2_TITLE Long description associated with amount 2. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT2_TITLE

AMOUNT3 Third amount field for the benefit/deduction. NUMBER

PDRDEDN

PDRDEDN_AMOUNT3

AMOUNT3_TITLE Long description associated with amount 3. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT3_TITLE

AMOUNT4 Fourth amount field for the benefit/deduction. NUMBER

PDRDEDN

PDRDEDN_AMOUNT4

AMOUNT4_TITLE Long description associated with amount 1. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT4_TITLE

APPLICABLE_GROSS_QTR1 Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

APPLICABLE_GROSS_QTR2 Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

APPLICABLE_GROSS_QTR3 Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

APPLICABLE_GROSS_QTR4 Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

BENEFICIARY_COUNT Count of beneficiaries. NUMBER

FUNCTION

MPKFUNC.F_COUNT_BENEFICIARY

BENEFIT_DEDUCTION_IND Indicates if this is a benefit deduction. VARCHAR2(30)

FUNCTION

POKODSF.F_GET_DEDUCTION_OPTIONS

BENEFIT_DEDUCTION_TYPE Benefit deduction type. VARCHAR2(2)

PTRBDCA

PTRBDCA_BDTY_CODE

BENEFIT_DEDUCTION_TYPE_DESC Benefit deduction type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BENEFIT_GROUP Benefit group. VARCHAR2(255)

PTRBDCA

PTRBDCA_BDTY_CODE

BOND_BALANCE If the deduction is for savings bonds this field contains the balance available toward the purchase of a bond. NUMBER

PDRBDED

PDRBDED_BOND_BALANCE

CALCULATION_RULE Defines how a benefit/deduction is processed by the system. The calc rule selected also determines how the deduction form and the deduction set-up form function. VARCHAR2(63)

PTRBDCA

PTRBDCA_CALC_RULE

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

PDRBDED

PDRBDED_BDCA_CODE

CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

PTRBDCA

PTRBDCA_LONG_DESC

CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

PTRBDCA

PTRBDCA_SHORT_DESC

COVERAGE_BEGIN_DATE Date the benefit/deduction begins. DATE

PDRBDED

PDRBDED_BEGIN_DATE

COVERAGE_END_DATE Date the benefit/deduction ends. DATE

PDRBDED

PDRBDED_END_DATE

COVERAGE_OPTION Coverage option associated with this benefit. VARCHAR2(255)

PDRDEDN

PDRDEDN_OPT_CODE1

COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(255)

PTRBDPL

PXRFSTA

PTRBDPL_DESC

PXRFSTA_DESC

EFFECTIVE_DATE Date the benefit/deduction becomes effective. DATE

PDRDEDN

PDRDEDN_EFFECTIVE_DATE

EFFECTIVE_END_DATE End effective date. DATE

FUNCTION

POKODSF.F_GET_END_PDRDEDN_DATE

EFFECTIVE_START_DATE Start effective date. DATE

PDRDEDN

PDRDEDN_EFFECTIVE_DATE

EMPLOYEE_ANNUAL_DEDN_LIMIT Maximum annual employee cost for benefit/deduction. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_BOND_PURCHASE_AMOUNT Bond amount increment in which the employee desires to purchase Savings Bonds. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_CONTRIBUTION_QTR1 Quarter 1 employee contribution. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QTR2 Quarter 2 employee contribution. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QTR3 Quarter 3 employee contribution. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QTR4 Quarter 4 employee contribution. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_YTD Year to date employee contribution for a specific deduction. NUMBER

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

EMPLOYEE_DEDN_LTD_LIMIT Maximum life-to-date employee cost. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_DEDN_MTD_LIMIT Maximum month-to-date employee cost. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_DEDUCTION_AMOUNT Employee cost or deduction amount per pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_DEDUCTION_PERCENT Employee cost; percentage of gross pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_MINIMUM_EARNINGS Minimum amount the employee can be paid per pay. Used to determine if deduction, or portion thereof, can be processed in current pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_MINIMUM_YTD_GROSS Minimum amount the employee must earn in a calendar year before this deduction is taken. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYER_CONTRIBUTION_QTR1 Quarter 1 employer total contribution for a specific deduction. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR2 Quarter 2 employer total contribution for a specific deduction. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR3 Quarter 3 employer total contribution for a specific deduction. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR4 Quarter 4 employer total contribution for a specific deduction. NUMBER

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_YTD Year to date employer contribution for a specific deduction. NUMBER

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

EMPLOYER_DEDUCTION_AMOUNT Employer cost; flat amount deduction per pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYER_IDENTIFICATION_NUMBER Employer identification number. VARCHAR2(255)

NA

NA

GROSS_COMPENSATION_YTD Year to date gross contribution. NUMBER

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

LIFE_INSURANCE_OVERRIDE_AMOUNT First amount field for the benefit/deduction. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

LIFE_INSURANCE_PREMIUM First amount field for the benefit/deduction. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

LIFE_INSURANCE_SALARY First amount field for the benefit/deduction. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

LIFE_INSURANCE_TYPE_IND First amount field for the benefit/deduction. VARCHAR2(30)

FUNCTION

POKODSF.F_GET_DEDUCTION_OPTIONS

LIFE_INSURANE_COVERAGE_AMOUNT First amount field for the benefit/deduction. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

MAXIMUM_REARS_RECOVERY Maximum amount of arrears allowed to be recovered in a pay event. This is the maximum amount to be recovered during a pay period when an arrears balance exists. NUMBER

PDRBDED

PDRBDED_ARR_RECOVER_MAX

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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OPTION1 First option code for the benefit/deduction code. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE1

OPTION1_TITLE Option 1 description. Six character title that prompts user for what option to enter. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION1_TITLE

OPTION2 Second option code for the benefit/deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE2

OPTION2_TITLE Option 2 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION2_TITLE

OPTION3 Third option code for the benefit/deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE3

OPTION3_TITLE Option 3 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION3_TITLE

OPTION4 Fourth option code for the benefit/deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE4

OPTION4_TITLE Option 4 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION4_TITLE

OPTION5 Fifth option code for the benefit/deduction code. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE5

OPTION5_TITLE Option 5 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION5_TITLE

PAYROLL_DEDUCTION_YEAR Deduction year. NUMBER

NA

NA

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

PDRBDED

PDRBDED_PIDM

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

NA

NA

PROFILE_DATE Profile Date associated with this record. DATE

FUNCTION

F_YEAR

REARS_BALANCE Arrears balance due the employer. NUMBER

PDRBDED

PDRBDED_ARR_BALANCE

STATUS Status of the benefit/deduction. VARCHAR2(63)

PDRDEDN

PDRDEDN_STATUS

STATUS_DESC Status description. VARCHAR2(255)

CALCULATION

DECODE(PDRDEDN_STATUS,'A','ACTIVE','B','EXEMPT','W','WAIVE','T','TERMINATED',')



Ver: 8.0