VC_PLGOAL_VW

(SQL View)
 Index Back

VC Plans w/ Goals

This view is used as a prompt for Plan ID for the component Plan Go

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

# 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