VC_TREE_ALND_VW (SQL View)	Index Back
Group Tree View Variable Comp: this view returns all groups for a given tree.

VC_TREE_ALND_VW

(SQL View)

Group Tree View

Variable Comp: this view returns all groups for a given tree.

SELECT DISTINCT TREE_NAME, TREE_EFFDT, GB_CHILD_GROUP_ID FROM PS_VC_TREE_NODE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree
3	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.