VC_PLAN_WG_VLNG

(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 , A2.LANGUAGE_CD ,A2.DESCR50 ,A2.DESCRSHORT FROM PS_VC_PLAN_TBL A , PS_VC_PLAN_LANG A2 WHERE A.VC_PLAN_MEM_CRIT NOT IN ('A', 'E') AND A.VC_PLAN_ID = A2.VC_PLAN_ID

  • Related Language Record for VC_PAY_WG_SRCH VC_PLAN_WG_VW VC_PLGOAL_WG_VW

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