GM_DEPT_SEC_VW (SQL View)	Index Back
Grants Dept Tree Security View This view joins the Department table to the tree table and shows the range of tree nodes which represent all the departments children.

GM_DEPT_SEC_VW

(SQL View)

Grants Dept Tree Security View

This view joins the Department table to the tree table and shows the range of tree nodes which represent all the departments children.

SELECT A.SETID ,A.TREE_NAME ,A.EFFDT ,B.DEPTID ,B.DESCR ,A.TREE_NODE_NUM ,A.TREE_NODE_NUM_END FROM PSTREENODE A , PS_DEPT_TBL B WHERE A.SETID = B.SETID AND A.TREE_NODE = B.DEPTID AND %EffdtCheck(DEPT_TBL X, B, %currentdatein)

# 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

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

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

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

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

7 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range 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
3	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
7	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number