EXP_LMT_TYP_VW

(SQL View)
 Index Back

Exception Limit Types VW

Exception Limit Types used to prompt valid limit types for Savings Extensions and Overrides.

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

  • Related Language Record: EXP_LMT_VW_LNG

    • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name