RC_SA_SOLN_VW (SQL View)	Index Back
Solution Advisor Solution View Solution Advisor Solution View.

RC_SA_SOLN_VW

(SQL View)

Solution Advisor Solution View

Solution Advisor Solution View.

SELECT K.OPRID , K.KEY_CASE_ID , K.KEY_BUSINESS_UNIT , K.RECNAME , K.RC_SCORE , K.RC_TEXT_SCORE , S.SETID , S.SOLUTION_ID , S.RC_SOLUTION_TYPE , S.RC_SUMMARY , S.SYMPTOM_DESCR , S.SOLUTION_DESCR , S.EXPIRY_IND , S.EXPIRY_DATE , S.EXPIRY_REASON , S.NEW_SOLUTION_ID , S.USAGE_COUNT , S.LAST_USAGE_DTTM , S.RC_SOLVED_COUNT , %subrec(RB_AUDIT_SBR, S) FROM PS_RC_SA_RSLT_KEYS K , PS_RC_SOLUTION S WHERE K.RECNAME = 'RC_SOLUTION' AND K.SETID = S.SETID AND K.SOLUTION_ID = S.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 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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

8 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

9 RC_SOLUTION_TYPE Character(4) VARCHAR2(4) NOT NULL Solution Type
ADHC=Adhoc Solution
CAND=Canned Solution
FILE=File
LINK=Link
S=Standard Solution
W=Workaround Solution

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

11 SYMPTOM_DESCR Character(254) VARCHAR2(254) NOT NULL Symptom Description

12 SOLUTION_DESCR Long Character CLOB Solution Description

13 EXPIRY_IND Character(1) VARCHAR2(1) NOT NULL Expiry Indicator
N=Not Expired
Y=Expired
Default Value: N

14 EXPIRY_DATE Date(10) DATE Expiry Date

15 EXPIRY_REASON Character(80) VARCHAR2(80) NOT NULL Expiry reason

16 NEW_SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Superceding Solution ID
Prompt Table: RC_SOLN_NEW_VW

17 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

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

19 RC_SOLVED_COUNT Number(6,0) INTEGER NOT NULL Solved Count Field in Solution

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

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

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

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

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

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

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
8	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID
9	RC_SOLUTION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Solution Type ADHC=Adhoc Solution CAND=Canned Solution FILE=File LINK=Link S=Standard Solution W=Workaround Solution
10	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
11	SYMPTOM_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Symptom Description
12	SOLUTION_DESCR	Long Character	CLOB	Solution Description
13	EXPIRY_IND	Character(1)	VARCHAR2(1) NOT NULL	Expiry Indicator N=Not Expired Y=Expired Default Value: N
14	EXPIRY_DATE	Date(10)	DATE	Expiry Date
15	EXPIRY_REASON	Character(80)	VARCHAR2(80) NOT NULL	Expiry reason
16	NEW_SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Superceding Solution ID Prompt Table: RC_SOLN_NEW_VW
17	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
18	LAST_USAGE_DTTM	DateTime(26)	TIMESTAMP	Used to identify last time the record was marked 'Used' in a Search result
19	RC_SOLVED_COUNT	Number(6,0)	INTEGER NOT NULL	Solved Count Field in Solution
20	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
21	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
22	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
23	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
24	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.
25	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time