VC_ORG_ATN_VW (SQL View)	Index Back
Plans with Org Goals defined This view is used as a base record in the panel VC_ORG_GOAL_ATN.

VC_ORG_ATN_VW

(SQL View)

Plans with Org Goals defined

This view is used as a base record in the panel VC_ORG_GOAL_ATN.

SELECT A.VC_PLAN_ID ,B.DESCR50 ,B.DESCRSHORT FROM PS_VC_ORG_GOAL A ,PS_VC_PLAN_TBL B WHERE 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

#	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