MOD_PAY_TX_OVRD

(SQL Table)
 Index Back

U.S. Payroll Tax Override

This record contains one-time overrides to the empoloyee tax data.

  • 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 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

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

    Y/N Table Edit

    Default Value: Y

    5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    9 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TAX_DATA

    10 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: CO_LOCALTAX_VW

    11 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class

    Prompt Table: PY_TAX_CLASS

    12 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality

    Prompt Table: CO_LOCALPSD_VW

    13 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

    14 RES_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality

    Prompt Table: CO_LOCALPSD_VW

    15 TAX_AMT Number(11,2) DECIMAL(10,2) NOT NULL One-Time Tax Amount
    16 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