VC_PRT_PLAN_LNG

(SQL View)
 Index Back

VC - Prorate Period panel

Variable Compensation: This record is used by the Prorate Period panel

SELECT A.VC_PLAN_ID , B.LANGUAGE_CD , B.DESCR50 FROM PS_VC_PLAN_EFFDT A , PS_VC_PLAN_LANG B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_VC_PLAN_EFFDT C WHERE C.VC_PLAN_ID = A.VC_PLAN_ID AND C.EFFDT <= %CurrentDateIn) AND A.VC_PRORATION_IND = 'Y'

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