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

RF_SOLN_ASS_VW3

(SQL View)

Service Order Assignees

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

SELECT A.BUSINESS_UNIT , A.SO_ID , A.PERSON_ID , B.STORLOC_TYPE , A.PROVIDER_GRP_ID , A.PRIMARY_FLAG , 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_RF_SOLN_ASSIGN A , PS_RB_WORK_STORLOC B WHERE A.PERSON_ID = B.PERSON_ID

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

4 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

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

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

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

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

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

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

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

12 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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RF_GRP_MEM_VW
4	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
5	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RF_PROVIDER_GRP
6	PRIMARY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Primary Y/N Table Edit
7	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BU_FS_NONVW
8	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	This field is used to hold the Storage Area associated with an Inventory item.
9	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 1 associated with an Inventory item.
10	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 2 associated with an Inventory item.
11	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 3 associated with an Inventory item.
12	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 4 associated with an Inventory item.