ST_VC_PLAN_VW (SQL View)	Index Back
VC Plans for Stock Variable Compensation plans that are Stock plan types.

ST_VC_PLAN_VW

(SQL View)

VC Plans for Stock

Variable Compensation plans that are Stock plan types.

SELECT A.VC_PLAN_ID , A.DESCR50 FROM PS_VC_PLAN_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
Prompt Table: VC_PLAN_TBL

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID Prompt Table: VC_PLAN_TBL
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50