WM_PRBTREE_VW

(SQL View)
 Index Back

Work Request Problem Tree

The Problem Tree table organizes problem codes by category to drive the self-service Work Request entry and define WO defaults.

SELECT SETID , TREE_NODE , EFF_STATUS , PARENT_NODE , NODE_LEVEL , DESCR80 , DESCR40 , DESCR20_MIXED , SHOW_IN_SELFSERV , PROBLEM_GROUP , PROBLEM_CD , ASSET_FIELD , CUSTODIAN_JOIN , ASSET_TYPE , ASSET_SUBTYPE , MFG_ID , MODEL , SUBRECNAME , PUBLISH_DATA FROM PS_WM_PROBLEM_TREE WHERE PUBLISH_DATA = 'Y'

  • Related Language Record: WM_PRBTREE_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 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: WM_PROBLEM_TREE

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node

    Prompt Table: WM_PRB_TREE_VW

    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 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
    8 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case
    9 SHOW_IN_SELFSERV Character(1) VARCHAR2(1) NOT NULL Show in Self-service

    Y/N Table Edit

    Default Value: Y

    10 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

    Prompt Table: WM_PCR_GROUP

    11 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

    Prompt Table: WM_PCR_PROBLEM

    12 ASSET_FIELD Character(1) VARCHAR2(1) NOT NULL Field to use for Asset lookup on Work Request
    1=Tag Number
    2=Serial ID
    3=Vehicle ID Number
    4=Asset ID
    5=Do not display asset fields
    13 CUSTODIAN_JOIN Character(1) VARCHAR2(1) NOT NULL Join with Custodian?

    Y/N Table Edit

    14 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    15 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: %EDITTABLE

    16 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: %EDITTABLE2

    17 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: %EDITTABLE3

    18 SUBRECNAME Character(15) VARCHAR2(15) NOT NULL Subrecord (Table) Name
    19 PUBLISH_DATA Character(1) VARCHAR2(1) NOT NULL Publish Data to Customer Relationship Management and third parties