RF_ADD_OPR_VW (SQL View)	Index Back
Operator/Person/Name View Displays the primary name of the person associated with the operator id.

RF_ADD_OPR_VW

(SQL View)

Operator/Person/Name View

Displays the primary name of the person associated with the operator id.

SELECT D.BO_NAME_DISPLAY , A.OPRID , D.LAST_NAME FROM PSOPRDEFN A , PSOPRALIAS B , PS_RD_PERSON C , PS_BO_NAME D WHERE A.OPRID = B.OPRID AND B.PERSON_ID = C.PERSON_ID AND D.BO_ID = C.BO_ID AND B.OPRALIASTYPE ='PER' AND D.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object

2 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_NAME_DISPLAY_1	Character(80)	VARCHAR2(80) NOT NULL	This field represents the Display Name for a business object
2	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name