RF_SO_ASSIGN_VW(SQL View) |
Index Back |
|---|---|
Open SO Assign ViewThis view returns assigned provider groups and group members where the service order is not complete, closed or canceled. |
| SELECT B.BUSINESS_UNIT , B.SO_ID , B.SO_LINE , C.SO_STATUS , C.SO_PRIORITY , B.ACTIVITY_CODE , B.SOACTIVITY_STATUS , B.SOACT_PRIORITY , B.EST_START_DT , B.EST_START_TIME , B.EST_END_DT , B.EST_END_TIME , A.PROVIDER_GRP_ID , A.PERSON_ID , D.SETID FROM PS_RF_SOLN_ASSIGN A , PS_RF_SO_LINE B , PS_RF_SO_HDR C , PS_RF_PROVIDER_GRP D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND A.SO_LINE = B.SO_LINE AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.SO_ID = C.SO_ID AND SOACTIVITY_STATUS NOT IN ('CAN', 'COM', 'CLO') AND A.PROVIDER_GRP_ID = D.PROVIDER_GRP_ID AND D.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = B.BUSINESS_UNIT AND E.RECNAME = 'RF_PROVIDER_GRP') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 3 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Stores the Service Order line number. |
| 4 | SO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to store the Service Order Header Status.
C=Complete D=Closed O=Open X=Canceled |
| 5 | SO_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
The priority of the service order.
H=High L=Low N=Normal U=Urgent |
| 6 | ACTIVITY_CODE | Character(8) | VARCHAR2(8) NOT NULL | Activity Code which identifies the specific Activities which will be performed as part of Service Orders. |
| 7 | SOACTIVITY_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Service Order Activity (line) Status.
CAN=Canceled CLO=Closed COM=Completed OAC=Accepted OER=En Route OHA=Hold Assignment OHC=Hold Customer OHP=Hold Part OOS=On Site OPA=Assigned ORJ=Rejected |
| 8 | SOACT_PRIORITY | Character(3) | VARCHAR2(3) NOT NULL |
The priority of the service order activity (a.k.a. line).
HIH=High LOW=Low NOR=Normal URG=Urgent |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 11 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 12 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 13 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 14 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 15 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |