MODEL_ONE_TIME

(SQL Table)
Index Back

Payroll Deduction Override

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

  • 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.
    12 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: BEN_PROG_BENPLN

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

    Prompt Table: %RECNAME_EDIT2

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

    Prompt Table: BNPRG_SLSTX_VW

    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

    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