RC_PRB_LVL_VW

(SQL View)
 Index Back

Problem View

This view returns the problem code values for creating a work order.

SELECT SETID , PARENT_NODE , TREE_NODE , EFF_STATUS , DESCR80 , DESCR20_MIXED , NODE_LEVEL , PROBLEM_GROUP , PROBLEM_CD_WO FROM PS_WM_PRBTREE_VW WHERE SHOW_IN_SELFSERV = 'Y'

# 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 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node
3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.
6 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL This field is used in the problem tree for work orders in FMS.
7 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
8 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL This field is used to group problems in the problem tree in work managment.
9 PROBLEM_CD_WO Character(15) VARCHAR2(15) NOT NULL This field stores data retrieved from the problem_cd field in FMS.