RBF_OPR_BO_VW (SQL View)	Index Back
Operators person id and bo_id This view is used to get the operators person id and bo_id

RBF_OPR_BO_VW

(SQL View)

Operators person id and bo_id

This view is used to get the operators person id and bo_id

SELECT a.OPRID ,a.PERSON_ID ,b.BO_ID FROM PSOPRALIAS a , PS_RD_PERSON b WHERE a.PERSON_ID = b.PERSON_ID AND a.PERSON_ID <> ' ' AND a.OPRALIASTYPE = 'PER'

# 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

#	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