RB_OPR_BO_VW (SQL View)	Index Back
Operator Identification View This view is used to get the operator's person identifier and busisness object identifier

RB_OPR_BO_VW

(SQL View)

Operator Identification View

This view is used to get the operator's person identifier and busisness object identifier

SELECT a.OPRID ,a.PERSON_ID ,b.BO_ID ,d.OPRDEFNDESC ,n.BO_NAME_DISPLAY FROM PSOPRALIAS a , PS_RD_PERSON b , PS_BO_NAME_PRIM_VW n , PSOPRDEFN d WHERE a.PERSON_ID = b.PERSON_ID AND a.PERSON_ID <> ' ' AND a.OPRALIASTYPE = 'PER' AND b.BO_ID = n.BO_ID AND a.OPRID = d.OPRID

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

4 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
4	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
5	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object