WM_PRBTREE_VW (SQL Table)	Index Back
Work Request Problem Tree The Problem Tree table organizes problem codes by category to drive the self-service Work Request entry and define WO defaults.

WM_PRBTREE_VW

(SQL Table)

Work Request Problem Tree

The Problem Tree table organizes problem codes by category to drive the self-service Work Request entry and define WO defaults.

Related Language Record: WM_PRB_TREE_LG

Parent Record Of WM_PROBLEM_LOC

# 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.
Prompt Table: SP_SETID_NONVW

2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

4 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node

5 NODE_LEVEL Character(1) VARCHAR2(1) NOT NULL This field is used for processing the problem code for a Work Order in FMS
1=Top
2=Middle
3=Bottom

6 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.

7 DESCR40 Character(40) VARCHAR2(40) NOT NULL This is a description field that holds 40 characters.

8 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL This field is used in the problem tree for work orders in FMS.

9 SHOW_IN_SELFSERV Character(1) VARCHAR2(1) NOT NULL This field is used in the problem tree for a work order in work management.

10 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL This field is used to group problems in the problem tree in work managment.

11 PROBLEM_CD_WO Character(15) VARCHAR2(15) NOT NULL This field stores data retrieved from the problem_cd field in FMS.

12 ASSET_FIELD Character(1) VARCHAR2(1) NOT NULL Field to use for Asset lookup on Work Request
1=Tag Number
2=Serial ID
3=Vehicle ID Number
4=Asset ID
5=Do not display asset fields

13 CUSTODIAN_JOIN Character(1) VARCHAR2(1) NOT NULL This field is used for the problem tree in Work Management in FMS

14 ASSET_TYPE Character(4) VARCHAR2(4) NOT NULL Asset Type
DRIV=Driver
DWEL=Dwelling
VEHI=Vehicle

15 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL This field is used in the problem tree in work management.

16 MFG_ID Character(50) VARCHAR2(50) NOT NULL Key field to represent Manufacturer Identification number

17 MODEL Character(30) VARCHAR2(30) NOT NULL Model

#	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. Prompt Table: SP_SETID_NONVW
2	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	PARENT_NODE	Character(20)	VARCHAR2(20) NOT NULL	Parent Tree Node
5	NODE_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	This field is used for processing the problem code for a Work Order in FMS 1=Top 2=Middle 3=Bottom
6	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
7	DESCR40	Character(40)	VARCHAR2(40) NOT NULL	This is a description field that holds 40 characters.
8	DESCR20_MIXED	Character(20)	VARCHAR2(20) NOT NULL	This field is used in the problem tree for work orders in FMS.
9	SHOW_IN_SELFSERV	Character(1)	VARCHAR2(1) NOT NULL	This field is used in the problem tree for a work order in work management.
10	PROBLEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	This field is used to group problems in the problem tree in work managment.
11	PROBLEM_CD_WO	Character(15)	VARCHAR2(15) NOT NULL	This field stores data retrieved from the problem_cd field in FMS.
12	ASSET_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Field to use for Asset lookup on Work Request 1=Tag Number 2=Serial ID 3=Vehicle ID Number 4=Asset ID 5=Do not display asset fields
13	CUSTODIAN_JOIN	Character(1)	VARCHAR2(1) NOT NULL	This field is used for the problem tree in Work Management in FMS
14	ASSET_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Asset Type DRIV=Driver DWEL=Dwelling VEHI=Vehicle
15	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	This field is used in the problem tree in work management.
16	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Key field to represent Manufacturer Identification number
17	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model