RS_AGG_NODE_VW2

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , B.TREE_NAME , B.TREE_NODE , B.PARENT_NODE_NAME , B.TREE_NODE_NUM FROM %Table(RS_AGG_TREE_VW) A , PSTREENODE B , %Table(SET_CNTRL_TREE) C WHERE A.TREE_NAME = B.TREE_NAME AND A.EFFDT = B.EFFDT AND B.SETID = C.SETID AND B.TREE_NAME = C.TREE_NAME AND %Substring(C.SETCNTRLVALUE, 1, 5) = A.BUSINESS_UNIT

# 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_NODE Character(20) VARCHAR2(20) NOT NULL Node name
4 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node
5 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number