WM_PRB_TREE_LG (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_PRB_TREE_LG

(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 for WM_PRBTREE_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

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

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

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
5	DESCR40	Character(40)	VARCHAR2(40) NOT NULL	This is a description field that holds 40 characters.
6	DESCR20_MIXED	Character(20)	VARCHAR2(20) NOT NULL	This field is used in the problem tree for work orders in FMS.