RF_RSLN_DET_VW(SQL View) |
Index Back |
---|---|
Service Order Resolution ViewThis is the record for the view that will fetch the Solution Summary and Solution Description for the Solution associated with the Service Order |
SELECT A.BUSINESS_UNIT , A.SO_ID , A.RSLN_SEQ_NBR , A.SOLUTION_ID , A.RSLN_STATE , B.RC_SUMMARY , B.SOLUTION_DESCR FROM PS_RF_RESOLUTION A , PS_RC_SOLUTION B WHERE A.SOLUTION_ID = B.SOLUTION_ID AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE= A.BUSINESS_UNIT AND C.RECNAME = 'RC_SOLUTION') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: RF_SO_HDR.BUSINESS_UNIT |
2 | SO_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
3 | RSLN_SEQ_NBR | Number(8,0) | INTEGER NOT NULL |
Resolution Sequence Number
Default Value: 1 |
4 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
5 | 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 |
6 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
7 | SOLUTION_DESCR | Long Character | CLOB | Solution Description |