KK_TREE_VW

(SQL View)

SELECT A.SETID ,A.TREE_NAME ,A.EFFDT ,A.TREE_NODE ,B.TREE_LEVEL ,A.TREE_LEVEL_NUM ,A.TREE_NODE_NUM ,A.TREE_NODE_NUM_END ,A.PARENT_NODE_NUM FROM PSTREENODE A , PSTREELEVEL B WHERE A.TREE_LEVEL_NUM=B.TREE_LEVEL_NUM AND A.EFFDT=B.EFFDT AND A.SETID=B.SETID AND A.TREE_NAME=B.TREE_NAME

# 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 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

5 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

6 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

7 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number

8 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number

9 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
5	TREE_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Tree Level Number
6	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
7	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
8	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
9	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number