PAY_TAX_1042

(SQL Table)
 Index Back

U.S. Payroll Tax for 1042

This record contains employee paycheck tax information required for reporting 1042-S taxes and earnings.

  • 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 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    10 INCOME_CD_1042 Character(2) VARCHAR2(2) NOT NULL Income Code (for 1042-S)
    12=Royalties
    15=Scholarship/Fellowship Grants
    16=Independent Personal Services
    17=Dependent Personal Services
    18=Teaching
    19=Studying and Training
    50=Other Income
    11 TAX_RT Signed Number(8,6) DECIMAL(6,6) NOT NULL Tax Rate (after form)
    12 WH_ALLOW_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Withholding Allowance
    13 TXGRS_1042_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Taxable Gross (1042)
    14 TAX_1042_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax (1042)