VC_TREE_PLAN_VW (SQL View)	Index Back
Variable Comp Tree View This view is used as a prompt for the Tree Name on the Variable Comp Plan table. It selects only valid trees with effective dates less than or equal to the VC Plan date.

VC_TREE_PLAN_VW

(SQL View)

Variable Comp Tree View

This view is used as a prompt for the Tree Name on the Variable Comp Plan table. It selects only valid trees with effective dates less than or equal to the VC Plan date.

SELECT A3.TREE_NAME , A3.DESCR FROM PSTREEDEFN A3 WHERE A3.SETID = ' ' AND A3.SETCNTRLVALUE = ' ' AND A3.EFF_STATUS = 'A' AND A3.VALID_TREE = 'Y' AND A3.TREE_STRCT_ID = 'VC_GROUP_STRUCT' AND A3.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE A3.TREE_NAME = TREE_NAME AND A3.SETID = SETID AND A3.SETCNTRLVALUE = SETCNTRLVALUE)

Related Language Record: VC_TREE_PLANLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description