PLN_TYPRAVW_LNG

(SQL View)
 Index Back

Vw - Plan Types - ATAX Rollovr

This view is used for editting online entry when adding after-tax rollover plan types.

SELECT %Substring(X.FIELDVALUE, 1, 2) ,X.LANGUAGE_CD ,X.EFFDT , X.XLATLONGNAME FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'PLAN_TYPE'

  • Related Language Record for PLAN_TYPE_RA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PLAN_TYPE_RA Character(2) VARCHAR2(2) NOT NULL Plan Type ATAX Rollover
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description