TREE_NDLV_SC_VW

(SQL View)
Index Back

Tree Node Level View


SELECT %Substring(A.SETCNTRLVALUE, 1, 5) , A.TREE_NAME , A.TREE_LEVEL , A.EFFDT , B.TREE_NODE 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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_EFFDT Date(10) DATE NOT NULL Effective date of the Tree
5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name