VC_PLAN_TYPE_VW

(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.XLATLONGNAME FROM PSXLATITEM X , PS_INSTALLATION I WHERE X.FIELDNAME = 'VC_PLAN_TYPE' AND X.EFF_STATUS ='A' AND (X.FIELDVALUE NOT IN ('I', 'K', 'Q', 'R', 'S') OR I.ST = 'Y')

  • Related Language Record: VC_PLAN_TYP_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description