SCRTY_TBL_DEPT

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.

PeopleSoft Field Name Field Type Column Type Description
ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

Prompt Table: OPRDEFN_SCRTY

SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SET_DEPT_VLD_VW

DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_SCRTY_VW

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

Default: Y

TREE_EFFDT Date(10) DATE Effective date of the Tree
TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19