HPY_DED_SRCH_VW

(SQL View)
 Index Back

Deduction Definition

This view is used in Component Search for Create General Deductions

SELECT A.PLAN_TYPE , A.DEDCD , A.EFFDT , A.DESCR , A.DESCRSHORT , A.DED_PRIORITY , A.SPCL_PROCESS , A.MAX_PAYBACK , A.MAX_ARREARS_PAYBK , A.MAX_ARREARS_FACTOR , A.GVT_DIST_DEST , A.GVT_REPORTING_CD , A.GVT_TIME_SENSITIVE , A.PERMANENCY_NLD , A.TAX_CLASS_NLD , A.UNION_CD FROM PS_DEDUCTION_TBL A WHERE A.PLAN_TYPE='00' AND ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_DEDUCTION_TBL A_ED WHERE A.PLAN_TYPE = A_ED.PLAN_TYPE AND A.DEDCD = A_ED.DEDCD AND A_ED.EFFDT <=%CurrentDateIn) )

  • Related Language Record: DEDUCTION_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
    2 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DED_PRIORITY Number(3,0) SMALLINT NOT NULL Deduction Priority

    Default Value: 500

    7 SPCL_PROCESS Character(1) VARCHAR2(1) NOT NULL Special Process
    B=Bond
    G=Garnishment
    U=Union Dues
    8 MAX_PAYBACK Character(1) VARCHAR2(1) NOT NULL Maximum Arrears Payback
    F=Factor x Regular Deduction
    N=No Maximum
    Y=Flat Maximum for Payback

    Default Value: N

    9 MAX_ARREARS_PAYBK Number(11,2) DECIMAL(10,2) NOT NULL Maximum Arrears Payback
    10 MAX_ARREARS_FACTOR Number(4,2) DECIMAL(3,2) NOT NULL Max Payback - Factor x Reg Ded
    11 GVT_DIST_DEST Character(1) VARCHAR2(1) NOT NULL Distribution Destinations
    N=Not Applicable
    R=OPM/RITS Interface
    S=Thrift Savings Board Interface
    T=U.S. Department of Treasury

    Default Value: N

    12 GVT_REPORTING_CD Character(2) VARCHAR2(2) NOT NULL Reporting Code

    Default Value: NA

    13 GVT_TIME_SENSITIVE Character(1) VARCHAR2(1) NOT NULL Identify General Deductions that are processed by the Treasury Interface that are of time sensitive nature

    Y/N Table Edit

    Default Value: N

    14 PERMANENCY_NLD Character(1) VARCHAR2(1) NOT NULL Permanency is used for HR Netherlands to track for Earnings and Deductions which are incidental, permanent or both.
    B=Both
    I=Incidental
    P=Permanent

    Default Value: B

    15 TAX_CLASS_NLD Character(1) VARCHAR2(1) NOT NULL Tax Class is used for HR Netherlands to be tracked for Earnings and Deductions.
    1=Wage Tax and Social Security
    2=Wage Tax, No Social Security
    3=No Wage Tax, Social Security
    4=No Wage Tax,No Social Security

    Default Value: 1

    16 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL