PY_MOD_OTDED_VW

(SQL View)
 Index Back

Payroll Deduction Override

This record contains one-time deduction overrides used in paycheck modeling.

SELECT A.PY_MOD_OPRID , A.PY_MOD_EMPLID , A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , 0 , A.SEPCHK , A.PLAN_TYPE , A.BENEFIT_PLAN , A.DEDCD , A.DED_CLASS , A.DED_SLSTX_CLASS , 'O' , 'A' , A.DED_CUR , 0 , 'OT' , A.DED_CUR , C.SPCL_PROCESS , C.DESCR , B.XLATLONGNAME , 'Flat Amount' , 'A' , A.DED_CLASS , ' ' , ' ' , ' ' , 'I' FROM PS_MODEL_PAY_DEDS A , XLATTABLE_VW B , PS_DEDUCTION_TBL C WHERE A.DED_CLASS IN ('A','B') AND B.FIELDNAME = 'DED_CLASS' AND B.FIELDVALUE = A.DED_CLASS AND C.PLAN_TYPE = A.PLAN_TYPE AND C.DEDCD = A.DEDCD AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_DEDUCTION_TBL C_ED WHERE C.PLAN_TYPE = C_ED.PLAN_TYPE AND C.DEDCD = C_ED.DEDCD AND C_ED.EFFDT <= %CurrentDateIn) AND ((A.PLAN_TYPE = '00') OR (A.PLAN_TYPE <> '00' AND EXISTS ( SELECT 'Y' FROM PS_PY_MOD_BENDEDVW D , PS_DEDUCTION_CLASS E WHERE D.PLAN_TYPE = A.PLAN_TYPE AND D.BENEFIT_PLAN = A.BENEFIT_PLAN AND D.DEDCD = A.DEDCD AND E.PLAN_TYPE = D.PLAN_TYPE AND E.DEDCD = D.DEDCD AND E.DED_CLASS = A.DED_CLASS)))

  • Related Language Record: PY_MOD_OTDEDLVW

  • Parent record: PAY_EARNINGS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_MOD_OPRID Character(30) VARCHAR2(30) NOT NULL PayCheck Modeler User Id
    2 PY_MOD_EMPLID Character(11) VARCHAR2(11) NOT NULL PayCheck Modeler Employee ID
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    5 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    Default Value: Y

    7 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    8 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    9 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    10 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    11 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.

    Prompt Table: PY_MOD_SS_PT_VW

    12 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: PY_MOD_SS_BP_VW

    13 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

    Prompt Table: PY_MOD_SS_BD_VW

    14 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
    A=After-Tax
    B=Before-Tax
    L=QC Taxable Benefit
    N=Nontaxable Benefit
    P=Nontaxable Btax Benefit
    T=Taxable Benefit

    Prompt Table: PY_MOD_CLS_VW

    15 DED_SLSTX_CLASS Character(1) VARCHAR2(1) NOT NULL Sales Tax Type
    B=None
    G=Goods and Services Tax
    H=Harmonized Sales Tax
    I=Provincial Sales Tax Insurance
    P=Provincial Sales Tax
    Q=QC Prov Sales Tax Insurance
    S=QC Provincial Sales Tax
    T=Provincial Premium Tax
    U=QC Provincial Premium Tax

    Default Value: B

    16 ONE_TIME_CD Character(1) VARCHAR2(1) NOT NULL Paysheet one-time code.
    A=Addition
    O=Override
    P=Arrears Payback
    R=Refund

    Default Value: O

    17 DED_CALC Character(1) VARCHAR2(1) NOT NULL Deduction Calculation Routine
    A=Flat Amount
    B=Percentage
    C=Calculated by Salary System
    D=Default to Deduction Table
    E=Percent of Special Earnings
    F=Percent of Federal Gross
    G=Percent of Total Gross
    H=Rate x Total Hours
    N=Percent of Net Pay
    P=Rate x Special Hours
    S=Special Deduction Calculation
    W=Rate x Hours Worked

    Default Value: A

    Prompt Table: PY_MOD_SS_DC_VW

    18 DED_ADDL_AMT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Flat/Addl Amount
    19 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent
    20 PU_SOURCE Character(2) VARCHAR2(2) NOT NULL Paysheet update source.
    AM=Absence Management
    ER=Recruiting Interface
    EX=Expense Interface
    IM=SIM Interface
    OT=Other Sources
    PL=Lifetime Balance Payout USF
    RP=Rapid Paysheets
    SP=Stock Admin - ESPP Refunds
    ST=Stock Admin - Options & ESPP
    VC=Variable Compensation
    VF=Bonus from Fusion
    WI=What-If
    21 DEDUCT_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Deducted Amount
    22 SPCL_PROCESS Character(1) VARCHAR2(1) NOT NULL Special Process
    B=Bond
    G=Garnishment
    U=Union Dues
    23 PY_MOD_DESCR_LABEL Character(30) VARCHAR2(30) NOT NULL Earnings Type

    Prompt Table: PY_MOD_DDESC_VW

    24 PY_MOD_DESCR30 Character(40) VARCHAR2(40) NOT NULL Description
    25 PY_MOD_DESCR25 Character(25) VARCHAR2(25) NOT NULL Description
    26 PY_MOD_DED_CALC Character(1) VARCHAR2(1) NOT NULL Flat Amount or Percent of total gross deduction
    A=Amount
    G=Percentage of Gross
    27 PY_MOD_DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
    A=After-Tax
    B=Before-Tax
    28 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    29 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    30 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    31 CHANGE_CODE Character(1) VARCHAR2(1) NOT NULL Whether this record represents an New, Change, Delete or initial load. Used in discounts and perks eligibility file.
    C=Change
    D=Delete
    I=Initial Load
    N=New