SEC_UNITSF_OPR (SQL Table)	Index Back
OprID Access to Business Units 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_UNITSF_OPR

(SQL Table)

OprID Access to Business Units

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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_SF

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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_SF
3	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access Default Value: Y