TAX_CLASS_BAL

(SQL View)
 Index Back

EE U.S. Tax Balance

This view contains employee Year-to-Date, Quarter-to-Date and Month-to-Date Tax balances.

SELECT A.EMPLID ,A.COMPANY ,A.BALANCE_ID ,A.BALANCE_YEAR ,A.BALANCE_QTR ,A.BALANCE_PERIOD ,A.STATE ,A.LOCALITY ,B.PY_DESCR10 ,A.TAX_CLASS ,A.WORK_PSD_CD ,A.RES_PSD_CD ,A.NLGRS_YTD ,A.NLGRS_QTD ,A.NLGRS_MTD ,A.TXGRS_YTD ,A.TXGRS_QTD ,A.TXGRS_MTD ,A.TAX_YTD ,A.TAX_QTD ,A.TAX_MTD ,A.TIPS_MTD FROM PS_TAX_BALANCE A , PS_PY_TAX_CLASS B WHERE A.TAX_CLASS = B.TAX_CLASS

  • Related Language Record: TAX_CLASS_B_LNG

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    3 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID

    Prompt Table: BALANCE_ID_TBL

    4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

    Prompt Table: BALANCE_YR_VW

    5 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

    6 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period

    Prompt Table: BALANCE_ID_DEF

    7 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TAX_TBL

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

    Prompt Table: LOCAL_TAX_TBL

    9 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    10 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class
    11 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality

    Prompt Table: LOCAL_TAX_TBL

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

    Prompt Table: LOCAL_TAX_TBL

    13 NLGRS_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL No Limit Gross YTD
    14 NLGRS_QTD Signed Number(15,2) DECIMAL(13,2) NOT NULL No Limit Gross QTD
    15 NLGRS_MTD Signed Number(15,2) DECIMAL(13,2) NOT NULL No Limit Gross MTD
    16 TXGRS_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Taxable Gross YTD
    17 TXGRS_QTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Taxable Gross QTD
    18 TXGRS_MTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Taxable Gross MTD
    19 TAX_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Tax YTD
    20 TAX_QTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Tax QTD
    21 TAX_MTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Tax MTD
    22 TIPS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL MTD Taxable Tips