VC_PLGOAL_WG_VW

(SQL View)
 Index Back

VC Plans with Goals and Groups

View of VC_PLAN_TBL that includes all plans that use Goals and that u

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') AND A.VC_GOAL_TYPE <> ' '

  • 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