RF_DISPBRD_ASVW (SQL View)	Index Back
Dispatch Board Assigned Lines This record is used to hold the Assigned Lines information on the grid on the Dispatch Board.

RF_DISPBRD_ASVW

(SQL View)

Dispatch Board Assigned Lines

This record is used to hold the Assigned Lines information on the grid on the Dispatch Board.

SELECT B.BUSINESS_UNIT , B.SO_ID , B.SO_LINE , A.DISPLAY_ORDER , B.PROVIDER_GRP_ID , B.PERSON_ID , A.ACTIVITY_CODE , A.SOACT_PRIORITY , A.SOACTIVITY_STATUS , A.EST_START_DT , A.EST_START_TIME , A.EST_END_DT , A.EST_END_TIME , A.EST_SERVICE_TIME , ' ' FROM PS_RF_SO_LINE A , PS_RF_SOLN_ASSIGN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND A.SO_LINE = B.SO_LINE AND B.PERSON_ID <> ' ' AND (A.SOACTIVITY_STATUS <> 'CAN' AND A.SOACTIVITY_STATUS <> 'CLO' AND A.SOACTIVITY_STATUS <> 'COM' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID

3 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.

4 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style

5 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
Prompt Table: RF_PROVGRP_VW2

6 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RF_GRP_MEM_VW2

7 ACTIVITY_CODE Character(8) VARCHAR2(8) NOT NULL Activity Code which identifies the specific Activities which will be performed as part of Service Orders.

8 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

9 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

10 START_DT Date(10) DATE Start date field to store start date value.

11 START_TIME Time(15) TIMESTAMP Start of Shift

12 END_DT Date(10) DATE This field stores the end date values.

13 END_TIME Time(15) TIMESTAMP End of Shift

14 EST_SERVICE_TIME Number(8,2) DECIMAL(7,2) NOT NULL Estimated time that it will take to perform a service.

15 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number.
4	DISPLAY_ORDER	Number(3,0)	SMALLINT NOT NULL	Display order for ordering items in a list - web style
5	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RF_PROVGRP_VW2
6	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RF_GRP_MEM_VW2
7	ACTIVITY_CODE	Character(8)	VARCHAR2(8) NOT NULL	Activity Code which identifies the specific Activities which will be performed as part of Service Orders.
8	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
9	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
10	START_DT	Date(10)	DATE	Start date field to store start date value.
11	START_TIME	Time(15)	TIMESTAMP	Start of Shift
12	END_DT	Date(10)	DATE	This field stores the end date values.
13	END_TIME	Time(15)	TIMESTAMP	End of Shift
14	EST_SERVICE_TIME	Number(8,2)	DECIMAL(7,2) NOT NULL	Estimated time that it will take to perform a service.
15	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone