CAT_TREE_VW3

(SQL View)
 Index Back

Category working scroll view


SELECT DISTINCT a.setid , a.tree_node , a.tree_name , a.tree_node_num , a.effdt , a.parent_node_num , b.category_type , b.effdt , b.descr60 FROM PSTREENODE a , ps_itm_cat_tbl b , pstreedefn c WHERE a.setid = b.setid AND a.tree_node = b.category_cd AND b.eff_status = 'A' AND a.setid = c.setid AND a.setcntrlvalue = c.setcntrlvalue AND a.tree_name = c.tree_name AND a.effdt = c.effdt AND c.effdt = ( SELECT MAX(c1.effdt) FROM pstreedefn c1 WHERE c1.setid = c.setid AND c1.setcntrlvalue = c.setcntrlvalue AND c1.tree_name = c.tree_name AND c1.eff_status = 'A' AND c1.effdt <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number
7 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL Category Type
PSF=User Def
UNS=UN/SPSC
8 EFFDT_USED Date(10) DATE Effective Date
9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description