VC_PAYOUT_SRCH

(SQL View)
 Index Back

VC Payout Search View

This view is used by Variable Comp as a search record to the component Plan Payouts (VC_PAYOUT).

SELECT A.VC_PLAN_ID ,A.DESCR50 ,A.DESCRSHORT FROM PS_VC_PLAN_TBL A WHERE A.VC_PLAN_MEM_CRIT ='E' AND A.VC_GOAL_TYPE <> 'M'

  • Related Language Record: VC_PLAN_EEVCLNG

    • # 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
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description