TAX_CLASS_LANG

(SQL View)
 Index Back

U.S. Payroll Tax

This record contains employee paycheck tax information.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.STATE , A.LOCALITY , B.LANGUAGE_CD , B.XLATSHORTNAME FROM PS_PAY_TAX A , PSXLATITEMLANG B WHERE A.TAX_CLASS = B.FIELDVALUE AND B.FIELDNAME='TAX_CLASS' AND %EffdtCheck(PSXLATITEMLANG, B, %CurrentDateIn)

  • Related Language Record for TAX_CLASS

  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name