HR_JTR_TREENM_V (SQL View)	Index Back
List of Tree Names by Struct Job Tree Builder

HR_JTR_TREENM_V

(SQL View)

List of Tree Names by Struct

Job Tree Builder

SELECT DISTINCT A.TREE_STRCT_ID , A.TREE_NAME , A.EFFDT , A.EFF_STATUS , A.DESCR , A.VALID_TREE FROM PSTREEDEFN A WHERE A.TREE_STRCT_ID <> 'ACCESS_GROUP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).

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

3 EFFDT Date(10) DATE Effective Date

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

5 DESCR_TREE Character(30) VARCHAR2(30) NOT NULL Tree Description

6 VALID_TREE Character(1) VARCHAR2(1) NOT NULL Valid Tree
N=Draft Tree
Y=Valid Tree

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	EFFDT	Date(10)	DATE	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	DESCR_TREE	Character(30)	VARCHAR2(30) NOT NULL	Tree Description
6	VALID_TREE	Character(1)	VARCHAR2(1) NOT NULL	Valid Tree N=Draft Tree Y=Valid Tree