WM_PRB_TREE_SD

(SQL View)
 Index Back

Work Request Problem Tree

same as WM_PROBLEM_TREE except SETID is not required

SELECT A.SETID , A.TREE_NODE , A.EFF_STATUS , A.PARENT_NODE , A.NODE_LEVEL , A.DESCR80 , A.DESCR40 , A.DESCR20_MIXED , A.SHOW_IN_SELFSERV , A.PROBLEM_GROUP , A.PROBLEM_CD , A.ASSET_FIELD , A.ASSET_REQD , A.CUSTODIAN_JOIN , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MODEL , A.SUBRECNAME , A.PUBLISH_DATA , A.TAG_1 , A.TAG_2 , A.TAG_3 , A.TAG_4 , A.TAG_5 , A.TAG_6 , A.TAG_7 , A.TAG_8 , A.TAG_9 , A.TAG_10 , A.TAG_11 , A.TAG_12 FROM PS_WM_PROBLEM_TREE A

  • Related Language Record: WM_PRB_TREE_LG

    • # 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 ASSET_REQD Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    Default Value: N

    14 CUSTODIAN_JOIN Character(1) VARCHAR2(1) NOT NULL Join with Custodian?

    Y/N Table Edit

    15 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
    16 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: %EDITTABLE

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

    Prompt Table: %EDITTABLE2

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

    Prompt Table: %EDITTABLE3

    19 SUBRECNAME Character(15) VARCHAR2(15) NOT NULL Subrecord (Table) Name

    Prompt Table: WM_SUBREC_VW

    20 PUBLISH_DATA Character(1) VARCHAR2(1) NOT NULL Publish Data to Customer Relationship Management and third parties
    21 TAG_1 Character(1) VARCHAR2(1) NOT NULL Smart Tag Number
    22 TAG_2 Character(1) VARCHAR2(1) NOT NULL Smart Tag 2
    23 TAG_3 Character(1) VARCHAR2(1) NOT NULL Smart Tag 3
    24 TAG_4 Character(1) VARCHAR2(1) NOT NULL Smart Tag 4
    25 TAG_5 Character(1) VARCHAR2(1) NOT NULL Smart Tag 5
    26 TAG_6 Character(1) VARCHAR2(1) NOT NULL Smart Tag 6
    27 TAG_7 Character(1) VARCHAR2(1) NOT NULL Smart Tag 7
    28 TAG_8 Character(1) VARCHAR2(1) NOT NULL Smart Tag 8
    29 TAG_9 Character(1) VARCHAR2(1) NOT NULL Smart Tag 9
    30 TAG_10 Character(1) VARCHAR2(1) NOT NULL Smart Tag 10
    31 TAG_11 Character(1) VARCHAR2(1) NOT NULL Smart Tag 11
    32 TAG_12 Character(1) VARCHAR2(1) NOT NULL Smart Tag 12