PY_MOD_OTDEDLVW

(SQL View)
Index Back

Rel. Lang for PY_MOD_OTDED_VW

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' , C.LANGUAGE_CD , C.DESCR , 'Flat Amount' , ' ' , ' ' FROM PS_MODEL_PAY_DEDS A , PS_PY_MOD_CLS_L_VW C , PS_PY_MOD_DEDXXLVW D WHERE A.DED_CLASS IN ('A','B') AND A.PLAN_TYPE = C.PLAN_TYPE AND A.DEDCD = C.DEDCD AND A.DED_CLASS = C.DED_CLASS AND A.PLAN_TYPE = D.PLAN_TYPE AND A.BENEFIT_PLAN = D.BENEFIT_PLAN AND A.DEDCD = D.DEDCD AND A.DED_CLASS = D.DED_CLASS AND D.PLAN_TYPE = C.PLAN_TYPE AND D.DEDCD = C.DEDCD AND D.DED_CLASS = C.DED_CLASS AND D.LANGUAGE_CD = C.LANGUAGE_CD

  • Related Language Record for PY_MOD_OTDED_VW
  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    18 PY_MOD_DESCR30 Character(40) VARCHAR2(40) NOT NULL Description
    19 PY_MOD_DESCR25 Character(25) VARCHAR2(25) NOT NULL Description
    20 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    21 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2