TREE_NODELVL_VW (SQL View)	Index Back
All Tree Nodes at a Level This View is used to prompt the valid values for certain Summary Ledger Chartfield. The values are from tree nodes at certain level of a Chartfield Value tree. The first three keys (TREE_NAME_SETID, TREE_NAME, TREE_LEVEL) and EFFDT are matched with the values on the panel.

TREE_NODELVL_VW

(SQL View)

All Tree Nodes at a Level

This View is used to prompt the valid values for certain Summary Ledger Chartfield. The values are from tree nodes at certain level of a Chartfield Value tree. The first three keys (TREE_NAME_SETID, TREE_NAME, TREE_LEVEL) and EFFDT are matched with the values on the panel.

SELECT L.SETID , L.TREE_NAME , L.TREE_LEVEL , N.TREE_NODE , N.EFFDT , D.DESCR FROM PSTREELEVEL L , PSTREENODE N , PS_TREE_NODE_TBL D WHERE N.TREE_NAME=L.TREE_NAME AND N.SETID=L.SETID AND N.EFFDT=L.EFFDT AND N.TREE_LEVEL_NUM=L.TREE_LEVEL_NUM AND D.TREE_NODE = N.TREE_NODE AND D.SETID = N.SETID AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_TREE_NODE_TBL WHERE SETID = D.SETID AND TREE_NODE = D.TREE_NODE AND EFFDT <= N.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_NAME_SETID Character(5) VARCHAR2(5) NOT NULL TableSet

2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

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

4 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value

5 EFFDT Date(10) DATE Effective Date

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME_SETID	Character(5)	VARCHAR2(5) NOT NULL	TableSet
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	TREE_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Tree Level Number
4	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value
5	EFFDT	Date(10)	DATE	Effective Date
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description