SCRTY_TBL_COMP (SQL Table)	Index Back
OprID Access to Localizations 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_COMP

(SQL Table)

OprID Access to Localizations

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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

#	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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL