VC_PLAN_TYP_LNG

(SQL View)
 Index Back

Prompting VC PLan Types

This view lists all available VC plan types. If Stock Admin is not installed the stock plan types are not available.

SELECT %Substring(X.FIELDVALUE,1,2) , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_VC_PLAN_TYPE_VW P , PSXLATITEMLANG X WHERE P.VC_PLAN_TYPE = X.FIELDVALUE AND X.FIELDNAME = 'VC_PLAN_TYPE'

  • Related Language Record for VC_PLAN_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VC_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL VC Plan Type
    D=Discretionary Bonus
    G=Goal Sharing
    I=Stock - ISO
    K=Stock - NSAR
    N=Non-Monetary
    O=Other
    P=Profit Sharing
    Q=Stock - NQ
    R=Stock - RSA
    S=Stock- ISAR
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description