NVS_SCOPENODEVW

(SQL View)
Index Back

XX


SELECT A.SETID ,A.TREE_NAME ,A.TREE_NODE ,A.EFFDT FROM PSTREENODE A ,PSTREEDEFN B WHERE B.SETID = A.SETID AND B.SETCNTRLVALUE = A.SETCNTRLVALUE AND B.TREE_NAME = A.TREE_NAME AND B.EFFDT = A.EFFDT AND ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PSTREENODE A_ED WHERE A.SETID = A_ED.SETID AND A.SETCNTRLVALUE = A_ED.SETCNTRLVALUE AND A.TREE_NAME = A_ED.TREE_NAME AND A_ED.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' )

# 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_NODE Character(20) VARCHAR2(20) NOT NULL Node name
4 EFFDT Date(10) DATE NOT NULL Effective Date