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 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. | |
3 | Character(15) | VARCHAR2(15) NOT NULL | Person ID | |
4 | Date(10) | DATE | Start date field to store start date value. | |
5 | Time(15) | TIMESTAMP | Start of Shift | |
6 | Character(10) | VARCHAR2(10) NOT NULL | Service Order ID | |
7 | 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. |