WTREE_LVN_VW2 (SQL View)	Index Back
Winter Tree nodes for a level Winter Tree nodes for a level

WTREE_LVN_VW2

(SQL View)

Winter Tree nodes for a level

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

# 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_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

4 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

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

6 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node

#	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_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Tree Level Number
4	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree
5	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
6	PARENT_NODE_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name of parent node