RC_SOLN_OPR_VW

(SQL View)
Index Back

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