VC_PLAN_FUND_VW (SQL View)	Index Back
VC Plans w/ Funding This view is used as a prompt for Plan ID for the component Plan Funding. It returns all VC Plans that use funding.

VC_PLAN_FUND_VW

(SQL View)

VC Plans w/ Funding

This view is used as a prompt for Plan ID for the component Plan Funding. It returns all VC Plans that use funding.

SELECT A.VC_PLAN_ID ,A.DESCR50 ,A.DESCRSHORT FROM PS_VC_PLAN_TBL A WHERE A.VC_FUND_IND = 'Y'

# 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