VC_MTX_ATN_VW

(SQL View)
Index Back

VC Matrix Goal Attainment view

This view is used as a search record by the Matrix Goals Attainment panel group.

SELECT A.VC_PLAN_ID ,A.DESCR50 ,A.DESCRSHORT FROM PS_VC_PLAN_TBL A ,PS_VC_MTX_GOAL_DEF B WHERE A.VC_GOAL_TYPE = 'M' AND A.VC_PLAN_MEM_CRIT IN ('A', 'E') AND A.VC_PLAN_ID = B.VC_PLAN_ID

# 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