SEC_SETID_CLS (SQL Table)	Index Back
OprID Access to SetIDs SCRTY_TBL_ACAD is used for data security purposes. It identifies the highest academic organization (in the hierarchy of academic organizations within your institution) that can be accessed by a particular operator ID. When you grant user access to a certain academic organization, you are also granting access to all academic organization that report to it, unless an academic organization is specifically excluded.

SEC_SETID_CLS

(SQL Table)

OprID Access to SetIDs

SCRTY_TBL_ACAD is used for data security purposes. It identifies the highest academic organization (in the hierarchy of academic organizations within your institution) that can be accessed by a particular operator ID. When you grant user access to a certain academic organization, you are also granting access to all academic organization that report to it, unless an academic organization 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: OPRCLASS_VW

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class Prompt Table: OPRCLASS_VW
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
3	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access Default Value: Y