WM_PROB_LVL_LVW

(SQL View)
Index Back

Problem Level View

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

SELECT A.SETID , A.PARENT_NODE , A.TREE_NODE , B.LANGUAGE_CD , B.DESCR80 , B.DESCR20_MIXED FROM PS_WM_PROBLEM_TREE A , PS_WM_PRB_TREE_LG B WHERE A.PARENT_NODE <> A.TREE_NODE AND B.SETID = A.SETID AND B.TREE_NODE = A.TREE_NODE

  • Related Language Record for WM_PROB_LVL_VW
  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR80 Character(80) VARCHAR2(80) NOT NULL Description
    6 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case