RF_DISPBRD_TMP7

#	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	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
16	ACTIVITY_CODE	Character(8)	VARCHAR2(8) NOT NULL	Activity Code which identifies the specific Activities which will be performed as part of Service Orders.
17	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
18	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.
19	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
20	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
21	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name