RC_SOLN_SRCH_VW(SQL View) |
Index Back |
|---|---|
Solution Search ViewSolution Search View for Call Center application. |
| SELECT A.SETID , A.SOLUTION_ID , A.RC_SUMMARY , %Upper(A.RC_SUMMARY) , A.SOLN_STATUS , A.ROW_ADDED_OPRID , A.ROW_ADDED_DTTM , A.RC_SOLUTION_TYPE , A.NEW_SOLUTION_ID , A.RC_SOLN_VISIBILITY , B.LIBRARY_NAME FROM PS_RC_SOLUTION A LEFT OUTER JOIN PS_RC_SOLN_LIB_TBL B ON (A.SETID = B.SETID AND A.LIBRARY_ID = B.LIBRARY_ID) |
| # | 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
Default Value: 999999999999999 Prompt Table: RC_SOLUTION |
| 3 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 4 | RC_SUMMARY_UPPER | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field (In Upper Case) |
| 5 | 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 |
| 6 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 7 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 8 | 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 |
| 9 | NEW_SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Superceding Solution ID
Prompt Table: RC_SOLN_NEW2_VW |
| 10 | RC_SOLN_VISIBILITY | Character(4) | VARCHAR2(4) NOT NULL |
Solution Visibility
A=All I=Internal |
| 11 | LIBRARY_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Library Name
Prompt Table: RC_SOLNLIB_NM_V |