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 NameField TypeColumn TypeDescription
ROWSECCLASSCharacter(30)VARCHAR2(30) NOT NULLThe class used to determine row level security

Prompt Table: OPRDEFN_SCRTY

SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID

Prompt Table: SET_DEPT_VLD_VW

DEPTIDCharacter(10)VARCHAR2(10) NOT NULLDepartment

Prompt Table: DEPT_SCRTY_VW

ACCESS_CDCharacter(1)VARCHAR2(1) NOT NULLAccess Code
N=No Access
Y=Read/Write Access

Default: Y

TREE_EFFDTDate(10)DATEEffective date of the Tree
TREE_NODE_NUMNumber(10,0)DECIMAL(10) NOT NULLInternal beginning node range number
TREE_NODE_NUM_ENDNumber(10,0)DECIMAL(10) NOT NULLInternal ending node range number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19