RF_DISPBRD_TMP5

(SQL Table)
Index Back

Dispatch Board Temp Table

Stores 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