RC_RSLN_COPY_VW (SQL View)	Index Back
Resolutions Independent Text Resolutions - Which have been copied and used in by other resolutions and a new solution has not been created for this.

RC_RSLN_COPY_VW

(SQL View)

Resolutions

Independent Text Resolutions - Which have been copied and used in by other resolutions and a new solution has not been created for this.

SELECT USAGE_COUNT , BUSINESS_UNIT , CASE_ID , RSLN_SEQ_NBR , RSLN_SUMMARY , RSLN_NOTES FROM PS_RC_RESOLUTION WHERE SOLUTION_ID = 0 AND NEW_SOLUTION_ID = 0 AND USAGE_COUNT <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USAGE_COUNT Number(8,0) INTEGER NOT NULL Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'.

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

4 RSLN_SEQ_NBR Number(8,0) INTEGER NOT NULL Resolution Sequence Number

5 RSLN_SUMMARY Character(80) VARCHAR2(80) NOT NULL Resolution Summary

6 RSLN_NOTES Long Character CLOB Resolution Notes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USAGE_COUNT	Number(8,0)	INTEGER NOT NULL	Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
4	RSLN_SEQ_NBR	Number(8,0)	INTEGER NOT NULL	Resolution Sequence Number
5	RSLN_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Resolution Summary
6	RSLN_NOTES	Long Character	CLOB	Resolution Notes