EXP_LMT_VW_LNG

(SQL View)
 Index Back

Exception Limit Types Lang VW


SELECT %Substring(A.FIELDVALUE,1,3) , A.LANGUAGE_CD ,A.EFFDT ,A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'LIMIT_TYPE' AND A.FIELDVALUE IN ('401','402','457')

  • Related Language Record for EXP_LMT_TYP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LIMIT_TYPE Character(4) VARCHAR2(4) NOT NULL Limit Type
    401=401(a) Limit
    401G=401(a) Limit Grandfather Plan
    402=402(g) Limit
    403=403(b) Limit
    415=415(c) Limit
    415Z=415(c) Limit for 403(b) plans
    457=457 Limit
    CH01=User Defined Per Check Limit 1
    CH02=User Defined Per Check Limit 2
    CH03=User Defined Per Check Limit 3
    CH04=User Defined Per Check Limit 4
    CH05=User Defined Per Check Limit 5
    USER=User Defined Limit
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name