SCRTY_TBL_DEPT (SQL Table)	Index Back
OprID Access to Departments SCRTY_TBL_DEPT is used for data security purposes. It identifies the highest department (in the hierarchy of departments within your company) that can be accessed by a particular operator class. When you grant user access to a certain department, you are also granting access to all departments that report to it, unless a department is specifically excluded.

SCRTY_TBL_DEPT

(SQL Table)

OprID Access to Departments

SCRTY_TBL_DEPT is used for data security purposes. It identifies the highest department (in the hierarchy of departments within your company) that can be accessed by a particular operator class. When you grant user access to a certain department, you are also granting access to all departments that report to it, unless a department is specifically excluded.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
Prompt Table: OPRDEFN_SCRTY

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_DEPT_VLD_VW

3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_SCRTY_VW

4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access
Default Value: Y

5 TREE_EFFDT Date(10) DATE Effective date of the Tree

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	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security Prompt Table: OPRDEFN_SCRTY
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_DEPT_VLD_VW
3	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_SCRTY_VW
4	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access Default Value: Y
5	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
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