TREE_BU_LEVN_VW

(SQL View)

SELECT a.setcntrlvalue , a.tree_name , a.tree_level , b.tree_node , a.effdt FROM pstreelevel a , PSTREENODE b WHERE a.setcntrlvalue = b.setcntrlvalue AND a.tree_name = b.tree_name AND a.tree_level_num = b.tree_level_num AND a.effdt = b.effdt AND a.effdt = ( SELECT MAX(c.effdt) FROM PSTREENODE c WHERE c.setcntrlvalue = a.setcntrlvalue AND c.tree_node = b.tree_node)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETCNTRLVALUE_TREE Character(20) VARCHAR2(20) NOT NULL Used in allocation panels

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

3 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

4 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETCNTRLVALUE_TREE	Character(20)	VARCHAR2(20) NOT NULL	Used in allocation panels
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	TREE_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Tree Level Number
4	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date