OPRIDSEQ_NBR_4BUSINESS_UNITCASE_IDRSLN_SEQ_NBRPrompt Table: RC_SOLUTION_VW
0=Viewed
1=Successful Resolution
2=Waiting on Customer
3=In Consideration
4=Failed Resolution
5=Withdrawn
Default Value: 3
RC_SA_RSLN2_VW(SQL View) |
Index Back |
|---|---|
Solution Advisor Case RslnsVise used for Solution Advisor Case Resolutions. |
| SELECT K.OPRID , K.SEQ_NBR_4 , K.KEY_BUSINESS_UNIT , K.KEY_CASE_ID , R.RSLN_SEQ_NBR , R.CASE_ID , R.BUSINESS_UNIT , R.SOLUTION_ID , R.RSLN_SUMMARY , R.RSLN_STATE ,R.RSLN_NOTES FROM PS_RC_SA_RSLT_KEYS K , PS_RC_RESOLUTION R WHERE K.RECNAME = 'RC_CASE' AND K.BUSINESS_UNIT = R.BUSINESS_UNIT AND K.CASE_ID = R.CASE_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 | SEQ_NBR_4 |
Number(4,0) | SMALLINT NOT NULL | Sequence Nbr 4 |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | 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. |
| 5 | RSLN_SEQ_NBR |
Number(8,0) | INTEGER NOT NULL | Resolution Sequence Number |
| 6 | KEY_CASE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Case ID |
| 7 | KEY_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Solution ID
Prompt Table: RC_SOLUTION_VW |
| 9 | RSLN_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Resolution Summary |
| 10 | 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 Default Value: 3 |
| 11 | RSLN_NOTES | Long Character | CLOB | Resolution Notes |