PY_MOD_ONETM_VW

(SQL View)
Index Back

Payroll Deduction Override

This record contains one-time deduction overrides.

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' , 0 , 0 , ' ' , ' ' , ' ' FROM PS_INSTALLATION

  • Parent record: PAY_EARNINGS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

    3 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.
    4 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    5 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: BEN_PROG_BENPLN

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

    Prompt Table: %RECNAME_EDIT2

    7 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: BNPRG_DEDCLS_VW

    8 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

    Prompt Table: BNPRG_SLSTX_VW

    9 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

    10 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

    11 DED_ADDL_AMT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Flat/Addl Amount
    12 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent
    13 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
    14 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    15 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    16 SPCL_PROCESS Character(1) VARCHAR2(1) NOT NULL Special Process
    B=Bond
    G=Garnishment
    U=Union Dues
    17 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
    18 PY_MOD_DESCR_LABEL Character(30) VARCHAR2(30) NOT NULL Earnings Type