RF_DISP_BRD_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	START_DT	Date(10)	DATE	Start date field to store start date value.
4	START_TIME	Time(15)	TIMESTAMP	Start of Shift
5	END_DT	Date(10)	DATE	This field stores the end date values.
6	END_TIME	Time(15)	TIMESTAMP	End of Shift
7	EST_START_DT	Date(10)	DATE	Estimated date that a service activity will be started.
8	EST_START_TIME	Time(15)	TIMESTAMP	Estimated time that a service activity will be started.
9	EST_END_DT	Date(10)	DATE	Estimated date that a service activity will be finished.
10	EST_END_TIME	Time(15)	TIMESTAMP	Estimated time that a service activity will be finished.
11	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
12	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number.
13	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
14	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
15	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID
16	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
17	ACTIVITY_CODE	Character(8)	VARCHAR2(8) NOT NULL	Activity Code which identifies the specific Activities which will be performed as part of Service Orders.
18	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
19	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.
20	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
21	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
22	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
23	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name