VC_PLAN_VW

(SQL View)
 Index Back

VC No Group Plan View

This view is used as a prompt for Plan ID for all online and batch transactions for Plans that have not used Groups.

SELECT A.VC_PLAN_ID ,A.DESCR50 ,A.DESCRSHORT FROM PS_VC_PLAN_TBL A WHERE A.VC_PLAN_MEM_CRIT IN ('A', 'E')

# 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