VC_PLAN_WG_VW

(SQL View)
 Index Back

VC Plans with Groups

View of VC_PLAN_TBL that includes all plans that are NOT of type - Ad Hoc - EE VC Without Groups

SELECT A.VC_PLAN_ID ,A.DESCR50 ,A.DESCRSHORT FROM PS_VC_PLAN_TBL A WHERE A.VC_PLAN_MEM_CRIT NOT IN ('A', 'E')

  • Related Language Record: VC_PLAN_WG_VLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description