ZZ_DSTNCT_DEPT (SQL View)	Index Back
Department-Level Security 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. CSA Aug 27 : Enhanced for SetId

ZZ_DSTNCT_DEPT

(SQL View)

Department-Level Security

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. CSA Aug 27 : Enhanced for SetId

SELECT SETID, DEPTID, TREE_NODE_NUM, TREE_NODE_NUM_END FROM PS_TRN_DPTSCRTY_VW GROUP BY SETID, DEPTID,TREE_NODE_NUM, TREE_NODE_NUM_END

# 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 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number

4 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	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
4	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number