PSIBSECURBC_VW

(SQL View)
Index Back

SELECT DISTINCT A.OPRID , B.BCNAME FROM PSOPRCLS A , PSAUTHBUSCOMP B WHERE A.OPRCLASS = B.CLASSID

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