DEPT_TBL_ACCESS (SQL View)	Index Back
DEPTID/OPRCLASS Security Vw DEPT_TBL_ACCESS is a view used for data security purposes. It identifies which operator classes have access to which departments' employee data.

DEPT_TBL_ACCESS

(SQL View)

DEPTID/OPRCLASS Security Vw

DEPT_TBL_ACCESS is a view used for data security purposes. It identifies which operator classes have access to which departments' employee data.

SELECT %Sql(SCRTY_SEL_DEPTKEY, SEC,SEC) ,SEC.DESCR , SEC.DESCRSHORT FROM PS_DEPT_SEC_SRCH SEC

Related Language Record: DEPT_TBLACS_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_DEPT_VLD_VW

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_DEPT_VLD_VW
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description