VC_PLAN_EEVC_VW (SQL View)	Index Back
VC Plan Vw - EEVC Only This view is used by Variable Comp as a search record to panels that only are applicable to non-group plans that use Employee Variable Comp.

VC_PLAN_EEVC_VW

(SQL View)

VC Plan Vw - EEVC Only

This view is used by Variable Comp as a search record to panels that only are applicable to non-group plans that use Employee Variable Comp.

SELECT A.VC_PLAN_ID ,A.DESCR50 ,A.DESCRSHORT FROM PS_VC_PLAN_TBL A WHERE A.VC_PLAN_MEM_CRIT ='E'

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

#	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