VC_ELIG_PLAN_VW

(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.DESCR50 FROM PS_VC_PLAN_EFFDT A , PS_VC_PLAN_TBL 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 B.VC_PLAN_MEM_CRIT <> 'A'

  • Related Language Record: VC_PRT_PLAN_LNG

    • # 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