VC_WRD_GRP_LANG

(SQL View)
 Index Back

VC Plan prompt view

Variable Comp: this view return VC Plan (EE-VC w/ group and Tree group plan types)

SELECT A.VC_PLAN_ID , A2.LANGUAGE_CD , A2.DESCR50 FROM PS_VC_PLAN_TBL A , PS_VC_PLAN_LANG A2 , PS_VC_PLAN_EFFDT B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND %EffdtCheck(VC_PLAN_EFFDT, B, %currentdatein) AND B.VC_APPROVAL_IND = 'Y' AND B.EFF_STATUS = 'A' AND A.VC_PLAN_MEM_CRIT IN ('T','G') AND EXISTS ( SELECT 'X' FROM PS_VC_AWARD_VW WHERE VC_PLAN_ID = A.VC_PLAN_ID) AND A.VC_PLAN_ID = A2.VC_PLAN_ID

  • Related Language Record for VC_WRD_GRP_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