GPUS_W4_LST_VW

(SQL View)
 Index Back

W-4 Exemption Condition List

Used to list exemption conditions in W-4 Tax Information self service page. the SQL was updated for the W-4- 2020 form

SELECT MESSAGE_SET_NBR , MESSAGE_NBR , MESSAGE_TEXT , DESCRLONG FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 17297 AND MESSAGE_NBR IN (215, 216)

  • Related Language Record: GPUS_W4_LST_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    2 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    3 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    4 DESCRLONG Long Character CLOB Long Description