EOCM_ENT_USR_VW

(SQL View)
 Index Back

SELECT A.OPRID FROM PSOPRDEFN A , PSOPRALIAS B WHERE A.OPRID=B.OPRID AND B.OPRALIASTYPE <> 'PTN'

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