RC_SOLN_SRCH_V2 (SQL View)	Index Back
Solution Search View Solution Search view for Solution Config Search

RC_SOLN_SRCH_V2

(SQL View)

Solution Search View

Solution Search view for Solution Config Search

SELECT A.SETID , A.SOLUTION_ID , A.RC_SUMMARY , A.SOLN_STATUS , A.ROW_ADDED_OPRID , A.RC_SOLUTION_TYPE , A.NEW_SOLUTION_ID , A.RC_SOLN_VISIBILITY , A.SYNCID , A.RC_SOLN_OWNERID , A.START_DATE , A.EXPIRY_DATE FROM PS_RC_SOLUTION A

Related Language Record: RC_SOLN_SRCH_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID
Prompt Table: RC_SOLUTION

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

4 SOLN_STATUS Character(4) VARCHAR2(4) NOT NULL Solution Status
ACTV=4 - Active
DNED=5 - Denied
DRFT=1 - Draft
EXPR=6 - Expired
REVW=3 - In Review
RWRK=8 - Rework
SUBM=2 - Submitted for Review
SUPR=7 - Superseded

5 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
Prompt Table: RC_OPR_NAME_V2

6 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

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

8 RC_SOLN_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Solution Visibility
A=All
I=Internal

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

10 RC_SOLN_OWNERID Character(5) VARCHAR2(5) NOT NULL Solution Content Owner ID field - uppercase denoting an Owner
Prompt Table: RC_SOLN_CTNT_VW

11 START_DATE Date(10) DATE Start Date for Gen Standing PO

12 EXPIRY_DATE Date(10) DATE Expiry Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID Prompt Table: RC_SOLUTION
3	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
4	SOLN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Solution Status ACTV=4 - Active DNED=5 - Denied DRFT=1 - Draft EXPR=6 - Expired REVW=3 - In Review RWRK=8 - Rework SUBM=2 - Submitted for Review SUPR=7 - Superseded
5	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row. Prompt Table: RC_OPR_NAME_V2
6	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
7	NEW_SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Superceding Solution ID Prompt Table: RC_SOLN_NEW2_VW
8	RC_SOLN_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Solution Visibility A=All I=Internal
9	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.
10	RC_SOLN_OWNERID	Character(5)	VARCHAR2(5) NOT NULL	Solution Content Owner ID field - uppercase denoting an Owner Prompt Table: RC_SOLN_CTNT_VW
11	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
12	EXPIRY_DATE	Date(10)	DATE	Expiry Date