TAX_CLASS_B_LNG

(SQL View)
 Index Back

EE U.S. Tax Balance

This is the related language view for TAX_CLASS_BAL

SELECT A.EMPLID ,A.COMPANY ,A.BALANCE_ID ,A.BALANCE_YEAR ,A.BALANCE_QTR ,A.BALANCE_PERIOD ,A.STATE ,A.LOCALITY ,B.LANGUAGE_CD ,B.XLATSHORTNAME FROM PS_TAX_BALANCE 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_BAL

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