EXP_401_LMT_VW

(SQL View)
 Index Back

Limit Extension Types for 401a

View with Exception Limit Extension Types of Adjust Eligible Earns YTD used as prompt for Limit Type 401(a) in Employee Savings Management component.

SELECT A.FIELDVALUE ,A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'LIMIT_EXT_TYPE' AND A.FIELDVALUE IN ('E')

  • Related Language Record: EXP_401_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name