PV_TREE_RNGE_VW

(SQL View)
 Index Back

SELECT A.SETID , A.TREE_NAME , A.TREE_HAS_RANGES , B.TREE_NODE_NUM , B.TREE_NODE , C.RANGE_FROM , C.RANGE_TO , C.DYNAMIC_RANGE , D.CATEGORY_ID FROM PSTREEDEFN A , PSTREENODE B , PSTREELEAF C , PS_ITM_CAT_TBL D WHERE A.TREE_STRCT_ID = 'ITEMS' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE SETID = A.SETID AND SETCNTRLVALUE = A.SETCNTRLVALUE AND TREE_NAME = A.TREE_NAME AND EFFDT <= %CurrentDateIn ) AND A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = B.EFFDT AND A.SETID = C.SETID AND A.SETCNTRLVALUE = C.SETCNTRLVALUE AND A.TREE_NAME = C.TREE_NAME AND A.EFFDT = C.EFFDT AND B.TREE_NODE_NUM = C.TREE_NODE_NUM AND A.SETID = D.SETID AND B.TREE_NODE = D.CATEGORY_CD AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITM_CAT_TBL WHERE SETID = D.SETID AND CATEGORY_CD = D.CATEGORY_CD AND EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
3 TREE_HAS_RANGES Character(1) VARCHAR2(1) NOT NULL Tree Has Ranges
4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
6 RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values
7 RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values
8 DYNAMIC_RANGE Character(1) VARCHAR2(1) NOT NULL Tree Leaf Dynamic detail range flag
9 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID