WM_PRB_NODE_VW

(SQL View)
 Index Back

Problem Node View

Problem Node view of bottom level nodes

SELECT SETID , TREE_NODE , PARENT_NODE , NODE_LEVEL , DESCR80 , DESCR20_MIXED FROM PS_WM_PROBLEM_TREE WHERE NODE_LEVEL = '3'

  • Related Language Record: WM_PRB_NODE_LVW

    • # 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 RQST_TYPE Character(20) VARCHAR2(20) NOT NULL Request type equivalent to tree node.
    3 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node

    Prompt Table: WM_PRB_TREE_VW

    4 NODE_LEVEL Character(1) VARCHAR2(1) NOT NULL Node level
    1=Top
    2=Middle
    3=Bottom
    5 DESCR80 Character(80) VARCHAR2(80) NOT NULL Description
    6 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case