WM_PRBTREE_SRCH

(SQL View)
 Index Back

Work Request Problem Tree View

Problem Tree view

SELECT SETID , TREE_NODE , DESCR80 , DESCR20_MIXED , NODE_LEVEL , PARENT_NODE FROM PS_WM_PROBLEM_TREE

  • Related Language Record: WM_PRBTR_SRCHLG

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: WM_PROBLEM_TREE