RC_TOPSOLSRH_VW (SQL View)	Index Back
Top Solution Search View View used as a prompt for Top solutions. Summary is pulled from RC_SOLUTION record.

RC_TOPSOLSRH_VW

(SQL View)

Top Solution Search View

View used as a prompt for Top solutions. Summary is pulled from RC_SOLUTION record.

SELECT B.OPRID , A.SOLUTION_ID , A.RC_SUMMARY FROM PS_RC_SOLUTION A , PS_RC_TOP_OPR_SOLN B WHERE A.SOLUTION_ID = B.SOLUTION_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 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

3 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

#	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	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID
3	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.