AV_SESS_OPR_VW (SQL View)	Index Back
Session Operator Id Provides all operator id's for sessions and their corresponding emlid's.

AV_SESS_OPR_VW

(SQL View)

Session Operator Id

Provides all operator id's for sessions and their corresponding emlid's.

SELECT DISTINCT A.OPRID , A.EMPLID , C.NAME FROM PSOPRDEFN A , PS_AV_SESSION_TBL B , PS_HCR_PERSON_NM_I C WHERE A.OPRID=B.OPRID AND C.EMPLID = A.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AV_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AV_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name