WM_PROB_LVL_VW

(SQL View)
 Index Back

Problem Level View

Problem level view controls the selection of problems on the service request.

SELECT SETID , PARENT_NODE , TREE_NODE , EFF_STATUS , NODE_LEVEL , DESCR80 , DESCR20_MIXED FROM PS_WM_PROBLEM_TREE WHERE PARENT_NODE <> TREE_NODE

  • Related Language Record: WM_PROB_LVL_LVW

  • Parent record: WM_PROBLEM_TREE

    • # 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 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    3 TREE_NODE_CHILD Character(20) VARCHAR2(20) NOT NULL Tree Node Child
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 NODE_LEVEL Character(1) VARCHAR2(1) NOT NULL Node level
    1=Top
    2=Middle
    3=Bottom
    6 DESCR80 Character(80) VARCHAR2(80) NOT NULL Description
    7 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case