VC_PLAN_VW_LNG

(SQL View)
 Index Back

VC No Group Plan View

This view is a related language record to VC_PLAN_VW.

SELECT A.VC_PLAN_ID , B.LANGUAGE_CD , B.DESCR50 , B.DESCRSHORT FROM PS_VC_PLAN_TBL A , PS_VC_PLAN_LANG B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PLAN_MEM_CRIT IN ('A', 'E')

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