TREE2_VW

(SQL View)
Index Back

Organization Chart Tree 2 View

Organization Chart Tree 2 View

SELECT B.SETID , B.TREE_NAME , B.TREE_NODE , B.EFFDT , B.TREE_LEVEL_NUM , B.TREE_NODE_NUM , B.TREE_NODE_NUM_END FROM PSTREEDEFN A , PSTREENODE B WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PSTREEDEFN A1 WHERE A1.SETID = A.SETID AND A1.TREE_NAME = A.TREE_NAME AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.SETID = A.SETID AND B.TREE_NAME = A.TREE_NAME AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PSTREENODE B1 WHERE B1.SETID = B.SETID AND B1.TREE_NAME = B.TREE_NAME AND B1.TREE_NODE = B.TREE_NODE AND B1.EFFDT >= A.EFFDT AND B1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SETID_TBL

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 Effective Date
5 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
6 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
7 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number