RF_DISPBRD_TMP4(SQL Table) |
Index Back |
|---|---|
Dispatch Board Temp TableStores Overlapping Service Orders for a Technician |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROVIDER_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 3 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 4 | START_DT |
Date(10) | DATE | Start date field to store start date value. |
| 5 | START_TIME |
Time(15) | TIMESTAMP | Start of Shift |
| 6 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 7 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Stores the Service Order line number. |
| 8 | 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 |
| 9 | 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 |
| 10 | ACTIVITY_CODE | Character(8) | VARCHAR2(8) NOT NULL | Activity Code which identifies the specific Activities which will be performed as part of Service Orders. |
| 11 | OVERLAP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag on the dispatch board to indicate if there overlapping service orders. |