SETIDSOLUTION_IDSO_ID0=Viewed
1=Successful Resolution
2=Waiting on Customer
3=In Consideration
4=Failed Resolution
5=Withdrawn
RF_SOLNSO_VW(SQL View) |
Index Back |
|---|---|
Service Order Solutions ViewThis view returns solutions and it's state for service orders. |
| SELECT C.SETID , A.SOLUTION_ID , B.SO_ID , A.RSLN_STATE , B.BUSINESS_UNIT , B.SERVICE_ID FROM PS_RF_RESOLUTION A , PS_RF_SO_HDR B , PS_SET_CNTRL_REC C WHERE A.SO_ID = B.SO_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'RC_SOLUTION' |
| # | 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. |
| 2 | SOLUTION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 3 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 4 | 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 |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | SERVICE_ID | Character(20) | VARCHAR2(20) NOT NULL | Service ID |