RC_PROBSHOP_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
3	LOCATION_SETID	Character(5)	VARCHAR2(5) NOT NULL	This field contains the location setid for an asset in work management.
4	WR_LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field contains the Service Center for a work order in Work Management.
5	SRVC_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	The field contains the service group id used to identify the service location for a work order in FMS.
6	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	This field contains the Work Order Business Unit from Work Order Management.
7	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	This field contains the Shop ID to identify the service location for a work order in FMS.
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
10	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
11	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
12	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
13	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
15	BUILDING	Character(10)	VARCHAR2(10) NOT NULL	Building #
16	FLOOR	Character(10)	VARCHAR2(10) NOT NULL	Floor #
17	SECTOR	Character(10)	VARCHAR2(10) NOT NULL	Sector
18	AGENT_ROLE	Character(30)	VARCHAR2(30) NOT NULL	This field contains the role that the agent has.
19	TECHNICIAN_ROLE	Character(30)	VARCHAR2(30) NOT NULL	This field contains the technician role for a work order in Work Management.
20	WO_TYPE	Character(5)	VARCHAR2(5) NOT NULL	This field contains the Work Order type for a work order in FMS.
21	PRIORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field contains the priority code for a work order in FMS.