RC_SOLN_OPR_VW (SQL View)	Index Back
Row Added Name Operator ID name used to log solution.

RC_SOLN_OPR_VW

(SQL View)

Row Added Name

Operator ID name used to log solution.

SELECT DISTINCT A.ROW_ADDED_OPRID , %Substring(E.BO_NAME_DISPLAY, 1, 50) FROM PS_RC_SOLUTION A , PSOPRALIAS C , PS_RD_PERSON_NAME E WHERE A.ROW_ADDED_OPRID = C.OPRID AND C.PERSON_ID = E.PERSON_ID AND E.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name