CONSOL_TREE_VW

(SQL View)
 Index Back

Consolidation Tree in Proc Log


SELECT DISTINCT A.TREE_NAME , B.DESCR FROM PS_CONSOL_PROC_LOG A , PSTREEDEFN B WHERE B.TREE_NAME = A.TREE_NAME AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE TREE_NAME = B.TREE_NAME AND SETID = B.SETID AND EFFDT <= A.AS_OF_DATE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description