PAY_TAX_GRSERN

(SQL Table)
 Index Back

U.S. Payroll Tax

This record contains employee paycheck tax information.

  • Parent record: PAY_CHECK

    • # 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

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 STATE Character(6) VARCHAR2(6) NOT NULL State
    9 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    10 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class
    11 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
    12 RES_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
    13 TAX_GRS_COMPNT Character(5) VARCHAR2(5) NOT NULL Taxable gross component ID.
    14 OTHER_RATE_ID Character(4) VARCHAR2(4) NOT NULL This is used as the record key for Other Benefits Rate Data that recategorize rates from parent record Benefit Rate Data.
    SSCH=Children - SS Rate
    SSEE=Employee - SS Rate
    SSSP=Spouse - SS Rate
    15 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    16 TAX_GRS_EFFECT Character(1) VARCHAR2(1) NOT NULL Tax Gross Effect
    A=Adds To
    N=No Effect
    S=Subtracts From
    17 TAX_GRS_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Taxable Gross Adjustment
    18 TAX_GRS_ADJAPL Signed Number(15,2) DECIMAL(13,2) NOT NULL Applied Tax Gross Adjustment