RFM_SOLN_ASS_VW (SQL View)	Index Back
Service Order Assigned Techs This view contains assigned technicians and is used in Manage Material.

RFM_SOLN_ASS_VW

(SQL View)

Service Order Assigned Techs

This view contains assigned technicians and is used in Manage Material.

SELECT ' ' , ' ' , 0 , B.PERSON_ID , B.STORLOC_TYPE , ' ' , ' ' , B.BUSINESS_UNIT_IN , B.STORAGE_AREA , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 FROM PS_RB_WORK_STORLOC B

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RF_GRP_MEM_VW

5 STORLOC_TYPE Character(2) VARCHAR2(2) NOT NULL This field is used to determine the type of Inventory Storage Location that is being associated with a Worker. The valid types are "Good" and "Defective". Typically in the Field Service world, the Good is setup as a Nettable storage location and the Defective would be setup as a Non-Nettable location.
00=Good
01=Defective
Default Value: 00

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

7 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary
Y/N Table Edit

8 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
Prompt Table: SP_BU_FS_NONVW

9 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL This field is used to hold the Storage Area associated with an Inventory item.

10 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 1 associated with an Inventory item.

11 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 2 associated with an Inventory item.

12 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 3 associated with an Inventory item.

13 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 4 associated with an Inventory item.

#	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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RF_GRP_MEM_VW
5	STORLOC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field is used to determine the type of Inventory Storage Location that is being associated with a Worker. The valid types are "Good" and "Defective". Typically in the Field Service world, the Good is setup as a Nettable storage location and the Defective would be setup as a Non-Nettable location. 00=Good 01=Defective Default Value: 00
6	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RF_PROVIDER_GRP
7	PRIMARY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Primary Y/N Table Edit
8	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BU_FS_NONVW
9	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	This field is used to hold the Storage Area associated with an Inventory item.
10	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 1 associated with an Inventory item.
11	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 2 associated with an Inventory item.
12	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 3 associated with an Inventory item.
13	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 4 associated with an Inventory item.