VC_PAY_WG_SRCH (SQL View)	Index Back
VC Plan Payouts with Groups This view is used as a search view by the component Plan Payouts with Groups (VC_PAYOUT_WG). It is a view of VC_PLAN_TBL that includes all plans that are NOT of type - Ad Hoc - EE VC Without Groups and that do not use matrix goals.

VC_PAY_WG_SRCH

(SQL View)

VC Plan Payouts with Groups

This view is used as a search view by the component Plan Payouts with Groups (VC_PAYOUT_WG). It is a view of VC_PLAN_TBL that includes all plans that are NOT of type - Ad Hoc - EE VC Without Groups and that do not use matrix goals.

SELECT A.VC_PLAN_ID ,A.DESCR50 ,A.DESCRSHORT FROM PS_VC_PLAN_TBL A WHERE A.VC_PLAN_MEM_CRIT NOT IN ('A', 'E') AND A.VC_GOAL_TYPE <> 'M'

Related Language Record: VC_PLAN_WG_VLNG

# 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