SCRTY_TBL_BUS (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_BUS

(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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

3 ACCESS_TO_ALL_LOC Character(1) VARCHAR2(1) NOT NULL Access to all Locations
Y/N Table Edit
Default Value: N