WM_PRB_LVL2_VW

(SQL View)
 Index Back

Work Request Problem Tree View

Problem Tree view

SELECT SETID , PARENT_NODE , TREE_NODE , DESCR80 , DESCR20_MIXED , NODE_LEVEL , PROBLEM_GROUP , PROBLEM_CD FROM PS_WM_PROBLEM_TREE WHERE SHOW_IN_SELFSERV = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: WM_PROBLEM_TREE

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

Prompt Table: WM_PRB_LVL_VW

4 DESCR80 Character(80) VARCHAR2(80) NOT NULL Description

Prompt Table: WM_PRB_LVL_VW

5 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case
6 NODE_LEVEL Character(1) VARCHAR2(1) NOT NULL Node level
1=Top
2=Middle
3=Bottom
7 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group
8 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code