RF_DISPBRD_TMP5(SQL Table) |
Index Back |
---|---|
Dispatch Board Temp TableStores Dispatch Board Setup Information |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RF_NONVW |
2 | SOACTIVITY_STATUS2 | Character(3) | VARCHAR2(3) NOT NULL |
Service Order Activity (line) Status.
OAC=Accepted OER=En Route OHA=Hold Assignment OHC=Hold Customer OHP=Hold Part OOS=On Site OPA=Assigned ORJ=Rejected |
3 | RF_COLORS | Character(2) | VARCHAR2(2) NOT NULL |
Used to represent colors and patterns for the Dispatch Board
01=Purple Block 02=Blue Block 03=Blue-Green Block 04=Yellow-Orange Block 05=Orange Block 06=Yellow-Green Block 07=Green Block 08=Yellow Block 09=Red-Orange Block 21=Gray Stripes 22=Dark Green Stripes 23=Light Blue Stripes 24=Bright Green Stripes 25=Pink Green Stripes 26=Blue Stripes 27=Yellow Pink Stripes 28=Thin Blue Stripes 29=Blue Yellow Stripes 30=Olive Orange Stripes 31=Pink Yellow Stripes 32=Red Yellow Stripes 33=Olive Stripes 34=Red Stripes |
4 | DISPLAY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Display on Chart
Y/N Table Edit |