RC_SOLN_OPR_VW(SQL View) |
Index Back |
---|---|
Row Added NameOperator 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 | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. | |
2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |