GM_TREENODE_VW (SQL View)	Index Back
Tree Node View PSTREENODE with the addition of PSTREEDEFN.EFF_STATUS, PSTREELEVEL.TREE_LEVEL. Used as prompt table for TREE_NODE in GM_PRJ_BUD_%.

GM_TREENODE_VW

(SQL View)

Tree Node View

PSTREENODE with the addition of PSTREEDEFN.EFF_STATUS, PSTREELEVEL.TREE_LEVEL. Used as prompt table for TREE_NODE in GM_PRJ_BUD_%.

select C.SETID, C.TREE_NAME, B.TREE_LEVEL, C.TREE_NODE, C.EFFDT, A.EFF_STATUS, %Substring(C.TREE_NODE, 1,8), C.TREE_LEVEL_NUM, C.TREE_NODE_NUM, C.TREE_NODE_NUM_END, C.PARENT_NODE_NUM from PSTREEDEFN A, PSTREELEVEL B, PSTREENODE C where C.SETID = A.SETID and C.TREE_NAME = A.TREE_NAME and C.EFFDT = A.EFFDT and C.SETID = B.SETID and C.TREE_NAME = B.TREE_NAME and C.EFFDT = B.EFFDT and C.TREE_LEVEL_NUM = B.TREE_LEVEL_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: TREEDEFN_VW

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

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

5 EFFDT Date(10) DATE NOT NULL Effective Date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

7 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: TREEDEFN_VW
3	TREE_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Tree Level Number
4	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
7	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
8	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
9	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
10	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
11	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number