KK_DYN1 (SQL View)	Index Back
Dynamic Dept/Operator Security

KK_DYN1

(SQL View)

Dynamic Dept/Operator Security

SELECT a.deptid , C.OPRID FROM PS_DEPT_TBL A , PS_PERSONAL_DATA B , PSOPRALIAS C WHERE A.MANAGER_NAME = B.NAME AND B.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).