TRN_DPT_DFT2_VW (SQL View)	Index Back
Training Dept Tree Excluded Vw The Operator Security module uses this table to determine which employee data the operator can access. If the operator is granted access to a specified department, then they can access all employees assigned to that department.

TRN_DPT_DFT2_VW

(SQL View)

Training Dept Tree Excluded Vw

The Operator Security module uses this table to determine which employee data the operator can access. If the operator is granted access to a specified department, then they can access all employees assigned to that department.

SELECT B.SETID ,B.DEPTID ,B.DESCR ,C.EFFDT ,A.TREE_NODE_NUM ,A.TREE_NODE_NUM_END FROM PSTREENODE A ,PS_DEPT_TBL B ,PS_SCRTY_TREE_VW C WHERE A.SETID =B.SETID AND A.TREE_NAME = 'DEPT_SECURITY' AND A.SETID = C.SETID AND A.EFFDT = C.EFFDT AND A.TREE_NODE = B.DEPTID

Related Language Record: TRN_DPTDFT2_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

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

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

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

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