RC_SA_RSLN_VW (SQL View)	Index Back
Solution Advisor Resolution Vw Solution Advisor Resolution View.

RC_SA_RSLN_VW

(SQL View)

Solution Advisor Resolution Vw

Solution Advisor Resolution View.

SELECT K.OPRID , K.KEY_CASE_ID , K.KEY_BUSINESS_UNIT , K.RECNAME , K.RC_SCORE , k.RC_TEXT_SCORE , K.BUSINESS_UNIT , K.CASE_ID , K.RSLN_SEQ_NBR , R.RSLN_SUMMARY , R.RSLN_STATE , R.USAGE_COUNT , R.LAST_USAGE_DTTM , %subrec(RB_AUDIT_SBR, R) , R.RSLN_NOTES FROM PS_RC_SA_RSLT_KEYS K , PS_RC_RESOLUTION R WHERE K.RECNAME = 'RC_IT_RSLN_VW' AND K.BUSINESS_UNIT = R.BUSINESS_UNIT AND K.CASE_ID = R.CASE_ID AND K.RSLN_SEQ_NBR = R.RSLN_SEQ_NBR

# 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 KEY_CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID

3 KEY_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

5 RC_SCORE Number(6,2) DECIMAL(5,2) NOT NULL Survey Score

6 RC_TEXT_SCORE Character(4) VARCHAR2(4) NOT NULL Field to display search score as text (in percentage)

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

8 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.

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

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

11 RSLN_STATE Character(1) VARCHAR2(1) NOT NULL Resolution Status for Call Center application.
0=Viewed
1=Successful Resolution
2=Waiting on Customer
3=In Consideration
4=Failed Resolution
5=Withdrawn

12 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'.
Default Value: 0

13 LAST_USAGE_DTTM DateTime(26) TIMESTAMP Used to identify last time the record was marked 'Used' in a Search result

14 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

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

16 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

17 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

18 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

19 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

20 RSLN_NOTES Long Character CLOB Resolution Notes

#	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	KEY_CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID
3	KEY_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	RC_SCORE	Number(6,2)	DECIMAL(5,2) NOT NULL	Survey Score
6	RC_TEXT_SCORE	Character(4)	VARCHAR2(4) NOT NULL	Field to display search score as text (in percentage)
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	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.
9	RSLN_SEQ_NBR	Number(8,0)	INTEGER NOT NULL	Resolution Sequence Number
10	RSLN_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Resolution Summary
11	RSLN_STATE	Character(1)	VARCHAR2(1) NOT NULL	Resolution Status for Call Center application. 0=Viewed 1=Successful Resolution 2=Waiting on Customer 3=In Consideration 4=Failed Resolution 5=Withdrawn
12	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'. Default Value: 0
13	LAST_USAGE_DTTM	DateTime(26)	TIMESTAMP	Used to identify last time the record was marked 'Used' in a Search result
14	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
15	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
16	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
17	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
18	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
19	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
20	RSLN_NOTES	Long Character	CLOB	Resolution Notes