SCRTY_TBL_GBL

(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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Prompt Table: OPRDEFN_SCRTY

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL